Database Engineer PostgreSQL

SCOPE OF WORK include the following:
Install, configure, patch, and upgrade database software PostgreSQL
Produce detailed technical architecture designs for PostgreSQL solutions.
Support of production and non-production PostgreSQL databases
Support of production and non-production databases:
o Correct issues reported in production system
o Support routine and ad-hoc IT DBA requests
o Update documentation, if required as part of correcting production issues
o Implement and monitor daily and nightly database maintenance jobs
o Monitor, diagnose, and respond to system failure and performance issues, taking
appropriate measures to reduce system downtime and eliminate recurrence of the problem
o Work with technical staff, including network engineers and software developers, to
analyze and improve system performance
o Formulate and implement backup and monthly maintenance procedures for PostgreSQL
Production clusters
o Serve as technical support for any database related performance or access issue
Generate ad-hoc and routine reports and define metrics for database health and performance
Administer, maintain, develop and implement policies and procedures for ensuring the security and
integrity of company databases.
Leading the team in providing technical support for any database-related performance or access
issue
Perform or affect the performance of all database installations, patches, and planned upgrades.
Implement data models and database designs, data access and table maintenance codes.
Resolve database performance issues, database capacity issues, replication, and other database
issues.
Perform database related development as dictated by departmental or project demands.
Design and perform data migrations and data transformations as required by application delivery
teams or business customers.
Develop and maintain documentation, diagrams, and procedures and complies with company s
change management control process.
Ensure that all database designs adhere to industry best practices.
Work with application delivery teams during database design.
Possess substantial knowledge about application and database performance profiles of all databases
under their management.
Represent the IT department in terms of database expertise in coordination with other departments.
QUALIFICATION AND EXPERIENCE:
EXPERIENCE: - PostgreSQL Years of Experience
Experience with PostgreSQL database Administration 8+ Years
Production support experience on (PostgreSQL) 8+ Years
Experience with Puppet deployment tool 3+ Years
Good understanding of Monitoring Tools such as PEM and TOAD 4+ Years
Expert level of PostgreSQL knowledge and experience with PostgreSQL 9.5 5+ Years
Experience with database characteristics such as table 7+ Years
design, relationships, data partition, efficient indexes, storage allocation,
Capacity planning, etc.
High Availability Solutions (Master-Master, Master-Slave) and sharing 5+ Years
Experience in performance tuning and load testing of database 7+ Years
Knowledge of NoSQL database security concepts 5+ Years
Experience in supporting PostgreSQL databases in Cloud (Google, AWS, etc.) 3+ Years
Linux/Unix platforms and Linux Shell scripting 5+ Years
Display strong ability in troubleshooting complex issues 5+ Years
Experience in performance tuning and load testing of database 7+ Years
Knowledge of database security concepts 5+Years
Experience with high availability database and application architectures 3+ Years
NOTE: In addition, this is the desired experience.
EDB PostgreSQL Certification
You have experience with NoSQL databases, such as Couchbase, MongoDB etc.
Experience with agile software development such as SCRUM and XP
SPECIAL SKILLS:
Analytical and problem-solving skills
Developing and/or creating new or more effective ideas, approaches, etc.
Developing and executing short-range plans/decisions
Excellent interpersonal and communication skills
Ability to exercise sound judgment across a broad range of circumstances