Database Administrator

• Design, implement, and maintain moderately complex databases for business and operational needs
• Ensure efficient database configurations and maintain current database dictionaries
• Integrate systems through effective and reliable database designs
• Administer and test computer databases, especially PostgreSQL environments
• Perform database testing to ensure functionality and efficiency
• Plan, coordinate, and implement database security measures
• Administer, monitor, and maintain PostgreSQL version 13+ environments
• Set up, configure, patch, tune performance, and plan capacity
• Implement and validate backup and recovery procedures using pg_dump/pg_restore and WAL archiving
• Configure, monitor, and manage PostgreSQL replication and high availability
• Optimize queries and indexing using EXPLAIN/ANALYZE, partitioning, and pg_stat_statements
• Plan and execute migrations involving PostgreSQL, AWS RDS, Aurora PostgreSQL, and Oracle
• Integrate PostgreSQL with existing IT infrastructures
• Develop, configure, and deploy monitoring and alerting systems using Prometheus, Grafana, or similar tools
• Monitor and troubleshoot database performance to proactively address bottlenecks
• Report to the Program Manager
• Perform other duties as assigned

• Administer Oracle databases supporting a cleared client program
• Support traditional Oracle database administration
• Work with CI/CD and database deployment pipelines
• Use configuration management and infrastructure automation tools
• Manage database changes and deployments
• Report onsite in Washington, DC or Sterling, VA approximately 1 to 2 times per quarter

Database Administrator jobs in District of Columbia

Database Administrator

Oracle Database Administrator – Active Clearance