Internship Postgresql Dba Jobs in Washington, DC

Job Summary:
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. They are seeking a Database Engineer III to manage tasks related to the operation, support, administration, optimization, and maintenance of client-owned databases. The role involves installing and configuring PostgreSQL databases, resolving performance issues, and ensuring database security and integrity.
Responsibilities:
• 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 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.
Qualifications:
Required:
• 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.
Preferred:
• EDB PostgreSQL Certification.
• You have experience with NoSQL databases, such as Couchbase, MongoDB etc.
• Experience with agile software development such as SCRUM and XP.
Company:
Ampcus is a global business, technology consulting and an staff augmentation firm specializing in AI/ML,digital solutions, Cybersecurity & Risk management, Testing, Forensics & Fraud services and human capital management. Founded in 2004, the company is headquartered in Chantilly, USA, with a team of 1001-5000 employees. The company is currently Late Stage.