PostgreSQL Database Administrator - CLEARED

Accountabilities: Design, implement, administer, and maintain enterprise database environments supporting mission-critical federal systems. Install, configure, monitor, and optimize PostgreSQL databases, including performance tuning, backup and recovery, user management, and ongoing maintenance. Evaluate legacy mainframe and distributed data models to support migration into consolidated and modernized database environments. Execute database modernization activities, including schema conversion, data migration, data validation, testing, troubleshooting, and implementation support. Assess database architecture changes, revisions, and code modifications to prevent disruptions to existing database access calls and application functionality. Develop, troubleshoot, and optimize SQL queries, stored procedures, and database objects to improve performance, reliability, and operational efficiency. Manage database users and permissions, ensuring secure and timely access to database resources in accordance with established security requirements. Implement and maintain database backup, recovery, and high-availability solutions to minimize downtime and protect data integrity. Apply database security controls, auditing, encryption, and secure administration practices to safeguard sensitive information and maintain compliance with federal requirements. Establish, document, and enforce database policies, procedures, technical standards, and operational best practices. Develop and maintain scripts and automation tools to streamline database administration, reduce manual effort, and improve operational consistency. Conduct root cause analysis, investigate database incidents, and coordinate issue resolution with development, infrastructure, and operations teams. Follow established runbooks, operational procedures, change-management requirements, and escalation processes to maintain stable and controlled database operations. Participate in Agile delivery activities, including sprint planning, backlog refinement, and production support, while working within government-approved software toolsets and federal IT processes. Requirements U.S. citizenship is mandatory. An active Top Secret (TS) security clearance is required. A valid CompTIA Security+ certification is mandatory; candidates without this certification will not be considered. At least 2 years of hands-on experience administering PostgreSQL databases, including installation, configuration, monitoring, performance tuning, backup and recovery, and user management. At least 2 years of experience working with relational database technologies, including PostgreSQL, Oracle, Db2, and SQL. Demonstrated experience writing, troubleshooting, and optimizing SQL queries, stored procedures, and database objects. At least 2 years of experience with database backup and recovery, security administration, scripting, and automation. Knowledge of database modernization and migration practices, including schema conversion, data validation, testing, troubleshooting, and legacy system integration. Understanding of database security controls, auditing, encryption, access management, and secure administration practices. At least 2 years of experience working in Agile environments, including sprint planning, backlog refinement, and production support. Strong analytical and troubleshooting skills, with the ability to perform root cause analysis and develop effective solutions to complex database issues. Excellent written and verbal communication skills, with the ability to collaborate across technical teams and document procedures clearly. Ability to follow established runbooks, operational standards, change-management processes, and escalation procedures in a structured environment. Proficiency in Microsoft Word and Excel. Experience supporting federal government, Department of Defense (DoD), or other mission-critical government environments is preferred. Experience with legacy and distributed system modernization, secure cloud environments, database automation, and high-availability architectures is an advantage. Familiarity with government-approved software tools and federal security requirements is highly desirable. Benefits Competitive compensation: Pay aligned with your technical expertise, experience, and the requirements of the engagement. Long-term project opportunities: Potential access to multi-year engagements supporting complex and mission-critical technology initiatives. Remote work flexibility: A fully remote position, subject to applicable contract, security, and operational requirements. Professional development: Opportunities to deepen your expertise in PostgreSQL administration, database modernization, secure cloud infrastructure, and enterprise data management. Meaningful technical impact: Contribute to critical government systems where database security, reliability, performance, and data integrity are essential. Collaborative work environment: Work alongside development, infrastructure, and operations professionals to solve complex technical challenges. Career support: Access to professional guidance and ongoing support to help you achieve your consulting and career objectives. Professional culture: An environment focused on integrity, trust, respectful relationships, and consultant well-being. Referral program: Potential referral rewards for recommending qualified professionals who are successfully placed in eligible positions.