PostgreSQL Database Administrator - CLEARED

The Squires Group
  • Washington, Washington, DC
  • Remote
    10 days ago

    Job Description

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

     

    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.

     

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

    #LI-JT1

    #LI-Remote

    Numbers & Facts

    LocationWashington, Washington, DC (
    Remote
    )

    Skills

    • Agile Programming Methodologiesunmatched
    • Backlog Prioritizationunmatched
    • Business Operationsunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Computer Securityunmatched
    • Computer Systemsunmatched
    • Cryptographyunmatched
    • Data Migrationunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Recoveryunmatched
    • Database Administrationunmatched
    • Database Architectureunmatched
    • Database Backupunmatched
    • Database Optimizationunmatched
    • Database Programmingunmatched
    • Database Recoveryunmatched
    • Distributed Computingunmatched
    • Federal Contractsunmatched
    • Federal Governmentunmatched
    • Governmentunmatched
    • Government Contractsunmatched
    • High Availabilityunmatched
    • IBM DB2unmatched
    • Identify Issuesunmatched
    • Information/Data Security (InfoSec)unmatched
    • Mainframe Computerunmatched
    • Microsoft Access Databaseunmatched
    • Microsoft Excelunmatched
    • Microsoft Wordunmatched
    • Operations Processesunmatched
    • Oracle Databaseunmatched
    • Performance Analysisunmatched
    • Performance Tuning/Optimizationunmatched
    • PostgreSQLunmatched
    • Presentation/Verbal Skillsunmatched
    • Production Supportunmatched
    • Query Optimizationunmatched
    • Relational Databases (RDBMS)unmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Scripting (Scripting Languages)unmatched
    • Security Auditingunmatched
    • Sprint Planningunmatched
    • Stored Proceduresunmatched
    • Testingunmatched
    • Time Managementunmatched
    • Top Secret Clearanceunmatched
    • United States Citizenunmatched
    • United States Department of Defense (DoD)unmatched
    • Validation Testingunmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder