PostgreSQL Database Administrator - CLEARED at The Squires Group, Inc. in US-DC-Washington

Job description

• 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.

Requirements

• 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 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.
• Security+ certification preferred and/or required by project guidance.
• 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.

Skills

Required

• PostgreSQL administration
• SQL query writing and troubleshooting
• Stored procedures and database objects
• Database backup and recovery
• Database security
• Scripting and automation
• Agile methodologies
• Root cause analysis
• Microsoft Word and Excel
• Active Top Secret clearance
• U.S. Citizenship

Preferred

• Security+ certification
• Federal/DoD experience
• Database modernization and migration
• Secure cloud environments
• Database automation and scripting
• High-availability architectures
• Government-approved software toolsets

Benefits

• 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.
• Check out our Referral Program!
• The Squires Group will pay you for every qualified professional that you refer and we place. If you see a position posted by The Squires Group and know the perfect person for the job, please send us your referral. For more information, go to https://bit.ly/squiresreferral .