Database Engineer III – PostgreSQL

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Database Engineer III PostgreSQL.
Location: Washington DC.


The Overall Purpose of Position:

• The purpose of this position is to perform and manage tasks related to the operation support administration optimization and maintenance of client owned databases and database tools.

• 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:
  • Correct issues reported in production system.
  • Support routine and ad-hoc IT DBA requests.
  • Update documentation if required as part of correcting production issues.
• Implement and monitor daily and nightly database maintenance jobs.
• Monitor diagnose and respond to system failure and performance issues taking appropriate measures to reduce system downtime and eliminate recurrence of the problem.
• Work with technical staff including network engineers and software developers to analyze and improve system performance.
• Formulate and implement backup and monthly maintenance procedures for PostgreSQL Production clusters.
• 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 comply with companys 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.

• Experience with PostgreSQL database Administration 8 Years required.
• Production support experience on (PostgreSQL) 8 Years required.
• Experience with Puppet deployment tool 3 Years required.
• Good understanding of Monitoring Tools such as PEM and TOAD 4 Years required.
• Expert level of PostgreSQL knowledge and experience with PostgreSQL 9.5 5 Years required.
• Experience with database characteristics such as table design relationships data partition efficient indexes storage allocation Capacity planning etc. 7 Years required.
• High Availability Solutions (Master-Master Master-Slave) and sharing 5 Years required.
• Experience in performance tuning and load testing of databases 7 Years required.
• Knowledge of NoSQL database security concepts 5 Years required.
• Experience in supporting PostgreSQL databases in Cloud (Google AWS etc.) 3 Years required.
• Linux/Unix platforms and Linux Shell scripting 5 Years required.
• Display strong ability in troubleshooting complex issues 5 Years required.
• Experience with high availability database and application architectures 3 Years required.

• EDB PostgreSQL Certification.
• You have experience with NoSQL databases such as Couchbase MongoDB etc.
• Experience with agile software development such as SCRUM and XP.

• 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.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin age protected veterans or individuals with disabilities.