PostgreSQL Database Administrator - CLEARED

The Squires Group; Washington (District of Columbia); On-site; USD 125,000 - 155,000; Full time

Job summary

The Squires Group, a federal contractor, is seeking a Database Administrator to design, administer, maintain, and modernize mission-critical databases within a Federal cloud and distributed computing environment. Candidates must have an ACTIVE Top Secret clearance and U.S. citizenship.

You will administer PostgreSQL databases, perform migrations, optimize performance, and implement secure access controls while aligning with security requirements and Agile practices.

Qualifications

• 2+ years of PostgreSQL administration including installation, configuration, monitoring, tuning, backup, recovery, and user management.
• Experience with relational databases (PostgreSQL, Oracle, Db2, SQL).
• Strong communication skills and ability to work with cross-functional teams.

Responsibilities

• Design, implement, administer, and maintain enterprise database environments.
• Administer PostgreSQL databases including installation, configuration, monitoring, performance tuning, backup, recovery, and user management.
• Write, troubleshoot, and optimize SQL queries, stored procedures, and database objects.
• Define users and manage secure access to database resources.
• Implement high-availability, backup, and recovery solutions and monitor performance.

Skills

PostgreSQL administration

SQL & stored procedures

Agile

Security compliance

Communication

Tools

Microsoft Word

Excel

Job description

Overview

Our client is looking for aDatabase Administratorwho 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, and troubleshooting.


• Understanding of database security controls, auditing, encryption, and secure administration practices.


• 2+ years of experience working in Agile environments, including sprint planning, backlog refinement, and production support.


• Strong verbal and written communication skills.


• Ability to perform root cause analysis and collaborate effectively with development, infrastructure, and operations teams.


• Ability to follow operational procedures, runbooks, change-management processes, and escalation procedures.


• Proficiency with Microsoft Word and Excel.

Preferred Qualifications

• Experience supporting Federal, Department of Defense (DoD), or other mission-critical government environments.


• Experience supporting database modernization and migration initiatives involving legacy and distributed systems.


• Experience working in secure cloud environments.


• Experience developing database automation and scripting solutions.


• Experience supporting high-availability database architectures and minimizing database downtime.


• Experience working with government-approved software toolsets and Federal security requirements.

4 Reasons to Join The Squires Group, Inc.: 1. Our Commitment to You - We offer competitive pay, multi-year projects, and a list of exciting clients. 2. Work-Life Balance - We work hard; we work smart and have quality time for family and \"life.\" 3. Golden Rule - We treat our consultants the way we want to be treated: with integrity, professionalism, and trust. 4. We Care About You – We help you meet your career goals and continuously support your efforts in the field.

The Squires Group, Inc. is an Equal Opportunity/Affirmative Action Employer.