Effectual

Database Administrator

Effectual

full-time

Posted on:

Location Type: Hybrid

Location: Washington DC • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AWSCloudPostgres

About the role

  • Design, deploy, configure, and maintain secure cloud-based database environments across DB2, PostgreSQL, and related DBMS platforms
  • Administer and optimize mission-critical databases to ensure high availability, performance, and throughput
  • Plan and execute database modernization initiatives, including migrations from DB2 to PostgreSQL
  • Monitor database performance, diagnose bottlenecks, and optimize queries and configurations
  • Implement and enforce database security controls, including access management, encryption, auditing, and STIG compliance
  • Develop and maintain backup, recovery, and disaster recovery strategies to ensure data integrity and continuity of operations
  • Execute controlled upgrades, schema changes, patching, and routine maintenance activities
  • Provide technical support and troubleshooting for application teams and end-users
  • Maintain operational documentation, including runbooks, configuration records, and as-built guides
  • Support automation initiatives, including database maintenance scripting, IaC integration, and CI/CD workflows
  • Collaborate with engineering, security, and operations teams to ensure database architecture meets enterprise performance, scalability, and resiliency requirements
  • Contribute to project governance and execution within regulated public sector environments

Requirements

  • Minimum Education: Bachelor’s degree in related field AND
  • Minimum Experience: 4 years of experience in specialized cloud technologies OR
  • Substitution/Alternative to Minimum Education and Experience: Must have at least 12 years of on-the-job experience
  • Available during customer working hours, as needed—both for scheduled and impromptu support
  • Be able to work remotely but, be able to go on-site as requested and/or occasionally on-site in Washington DC
  • Must be a US Citizen
  • 4+ years administering large-scale database environments in government or public sector domains
  • Certifications: AWS Database Specialty, PostgreSQL, IBM DB2, CompTIA Security+ and/or equivalent
  • Hands-on experience with DB2, PostgreSQL, and enterprise DBMS administration
  • Proven experience with migrations and modernization activities, specifically DB2 to PostgreSQL transitions
  • Strong understanding of database performance tuning, backup and recovery, monitoring, and troubleshooting
  • Experience supporting secure environments with formalized change control, auditing, and compliance alignment
  • Excellent stakeholder management, communication, and negotiation skills
  • Experience with Agile tools such as Jira, Confluence, and other project tracking systems
  • Familiarity with technical environments, including cloud migration projects (AWS preferred) and enterprise-level software stacks
  • Experience with Agile techniques (User Stories including descriptions, acceptance criteria and story points, ATDD, TDD, Continuous Integration, Continuous Testing, Pairing, Automated Testing)
  • You are able to work with distributed teams and handle multiple workstreams simultaneously
  • Strong organizational, problem-solving, and conflict resolution skills
  • Quick-learner and operating with minimum supervision in a changing environment
  • Experienced in drafting comprehensive documents using Microsoft Office suite
  • Strong analytical and problem-solving abilities to translate requirements into technical specifications
  • Hardworking and self-motivated, with the ability to work in team and individual settings
  • Detail-oriented and able to stand behind the quality of the work
  • Able to properly understand and communicate level of effort, define due dates, and meet deadlines
  • Ability to work Eastern Standard Time Zone schedule

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
DB2PostgreSQLdatabase administrationdatabase performance tuningbackup and recoverydisaster recoverydatabase security controlsdatabase modernizationquery optimizationcloud technologies
Soft skills
stakeholder managementcommunicationnegotiationorganizational skillsproblem-solvingconflict resolutionquick learnerdetail-orientedself-motivatedability to work independently
Certifications
AWS Database SpecialtyPostgreSQLIBM DB2CompTIA Security+