Back to jobs
New

Database Administrator

Remote

Position Summary 

Effectual DBAs are key members of the Public Sector Program Management team, responsible for delivering mission-aligned solutions with a strong focus on technical excellence, regulatory compliance, and stakeholder satisfaction. The DBA is responsible for managing and maintaining enterprise database ecosystems, including DB2, PostgreSQL, and associated DBMS platforms, within public sector and government domains. This position ensures data is secure, highly available, and optimized to support mission-critical applications, modernization initiatives, and cloud-based deployments. The DBA is a key contributor to database architecture, performance, and compliance, including structured migrations from DB2 to PostgreSQL. As representatives of the Effectual brand, they are expected to stay current with applicable public sector standards, policies, and best practices to consistently deliver high-quality, well-architected solutions that address the diverse needs of government and public sector organizations. 

A Glimpse into the Daily Routine of an Effectual DBA 

A Database Administrator (DBA) actively monitors database performance, system alerts, and capacity utilization to ensure environments operate efficiently and securely. Execute routine maintenance tasks, applying tuning adjustments, and updating configurations to optimize database performance. Work closely with development teams to support query optimization, schema planning, and integration of application requirements. Manage and execute upgrades, patches, backups, and recovery exercises to maintain system reliability and data integrity. When issues arise affecting security, performance, or data availability, the DBA investigates and resolves them promptly. Comprehensive documentation of configurations, standards, and changes is maintained to ensure audit readiness and compliance. Participate in migration activities and engages in cross-team technical discussions to support modernization initiatives and collaborative problem-solving across the organization. Be available during core customer hours, support in-person collaboration which is essential to ensure effective communication and teamwork. Your expertise will be critical in driving both application development and successful cloud migration initiatives. 

Essential Duties and Responsibilities 

  • 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 

Qualifications 

  • 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 

Nice-to-Have Skills and Experience 

  • Active Clearance or Public Trust (DOJ Preferred) 
  • PMI and AWS Certifications (e.g., PMI-ACP, AWS Certified Solutions Architect) 
  • Experience with automation tools such as Ansible, Terraform, or scripting languages for database management 
  • Familiarity with CI/CD pipelines, DevOps workflows, and infrastructure as code supporting cloud database deployments 
  • Knowledge of ETL workflows, data pipelines, and analytical database services 
  • Experience with database hardening, security audits, log analysis, and federal compliance frameworks 
  • Prior exposure to multi-cloud or hybrid cloud DBMS environments 
  • Experience with commercial or open-source monitoring and observability platforms 
  • Familiarity with performance metrics, KPIs, and reporting for executive leadership 
  • Experience in leading Agile transformation initiatives within large, complex organizations 
  • Stay updated with emerging AWS cloud technologies, public sector regulations, industry trends, and best practices related to application migrations  

Physical Demands and Work Environment  

The work is generally performed in an office environment.  Physical demands include sitting, keyboarding, verbal communication, written communication.  Employees are occasionally required to stand; walk; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the functions.

This job description may not be inclusive of all assigned duties, responsibilities, or aspects of the job described, and may be amended anytime at the sole discretion of the Employer. Duties and responsibilities are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. This document does not create an employment contract, implied or otherwise, other than an “at will” relationship. Effectual Inc. is an EEO employer and does not discriminate on the basis of any protected classification in its hiring, promoting, or any other job-related opportunity. 

Create a Job Alert

Interested in building your career at Effectual? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Effectual’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.