PostgreSQL Database Administrator - TS Clearance (Federal)

The Squires Group, Inc.; Washington (District of Columbia); On-site; USD 120,000 - 170,000; Full time

Job summary

The Squires Group, Inc. is seeking a Database Administrator to design, administer, maintain, and modernize mission-critical databases within a Federal cloud environment. Candidates must be U.S. Citizens with an ACTIVE TOP SECRET CLEARANCE and 2+ years of PostgreSQL experience.

Responsibilities include PostgreSQL administration, data migration, security controls, and high-availability implementations, with collaboration across development and operations teams in an Agile setting.

Qualifications

• Active Top Secret (TS) clearance required.
• U.S. Citizenship required.
• 2+ years of experience administering PostgreSQL, including installation, configuration, monitoring, tuning, backup, recovery, and user management.
• 2+ years of experience with relational databases (PostgreSQL, Oracle, Db2, 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 in Agile environments, including sprint planning, backlog refinement, and production support.

Responsibilities

• Design, implement, administer, and maintain enterprise database environments.
• Administer PostgreSQL databases: installation, configuration, monitoring, performance tuning, backup, recovery, and user management.
• Evaluate data models to support migration into consolidated database environments.
• Support database modernization: schema conversion, data migration, validation, testing, troubleshooting.
• Ensure revisions and changes do not disrupt database access or functionality.
• Write, troubleshoot, and optimize SQL queries and database objects.
• Define users and manage secure access to resources per security requirements.
• Implement and maintain backup, recovery, and high-availability solutions.
• Monitor and optimize performance to minimize downtime and ensure availability.
• Establish, document, and enforce database policies and operational practices.
• Implement security controls, auditing, encryption, and secure administration practices.
• Develop scripts and automation for administration and efficiency.
• Perform root cause analysis with development, infrastructure, and operations teams.
• Follow runbooks, change-management, and escalation procedures.
• Participate in Agile development activities and production support.
• Use government-approved software toolsets and Federal IT processes.

Skills

Strong communication

Root-cause analysis

Team collaboration

Agile experience

Job description

The Squires Group, Inc. is seeking a Database Administrator to design, administer, maintain, and modernize mission-critical databases within a Federal cloud environment. Candidates must be U.S. Citizens with an ACTIVE TOP SECRET CLEARANCE and 2+ years of PostgreSQL experience.

Responsibilities include PostgreSQL administration, data migration, security controls, and high-availability implementations, with collaboration across development and operations teams in an Agile setting.