PostgreSQL Database Administrator - CLEARED

Overview Our client is looking for a Database Administrator who will design, administer, maintain, and modernize mission-critical databases while supporting secure data access, database performance, migration efforts, and high-availability operations within a Federal cloud and distributed computing environment. Per our Federal Government Contract, candidates must be U.S. Citizens with an ACTIVE TOP SECRET CLEARANCE. Responsibilities Design, implement, administer, and maintain enterprise database environments. Administer PostgreSQL databases, including installation, configuration, monitoring, performance tuning, backup, recovery, and user management. Evaluate mainframe and distributed data models to support migration into consolidated database environments. Support database modernization efforts, including schema conversion, data migration, data validation, testing, and troubleshooting. Ensure database revisions, architecture changes, and code modifications do not negatively impact existing database access calls or application functionality. Write, troubleshoot, and optimize SQL queries, stored procedures, and database objects. Define users and manage secure, timely access to database resources in accordance with established security requirements. Implement and maintain database backup, recovery, and high-availability solutions. Monitor and optimize database performance to minimize downtime and ensure system availability. Establish, document, and enforce database policies, procedures, standards, and operational practices. Implement database security controls, auditing, encryption, and secure administration practices. Develop and maintain scripts and automation to support database administration and operational efficiency. Perform root cause analysis and troubleshoot database issues in coordination with development, infrastructure, and operations teams. Follow established runbooks, operational procedures, change-management processes, and escalation procedures. Participate in Agile development activities, including sprint planning, backlog refinement, and production support. Work within government-approved software toolsets and established Federal IT processes. Qualifications Active Top Secret (TS) clearance required. U.S. Citizenship required. CompTIA Security+ Certification Required. No flex, candidates without the certification will not be considered. 2+ years of experience administering PostgreSQL, including installation, configuration, monitoring, tuning, backup, recovery, and user management. 2+ years of experience working with relational databases, including PostgreSQL, Oracle, Db2, and SQL. Experience writing and troubleshooting SQL queries, stored procedures, and database objects. 2+ years of experience with database backup and recovery, security, scripting, and automation. Knowledge of database modernization and migration, including schema conversion, data validation, testing,…