Database Administrator

Technica Corporation•Washington, DC

23d•$116,000 - $150,000•Onsite

About The Position

Technica Corporation is seeking a highly skilled Database Administrator to design, implement, and maintain moderately complex databases. This role is responsible for maintaining database dictionaries, ensuring the integration of systems through effective database design, and administering and testing computer databases by applying a deep knowledge of database management systems. Additionally, the Database Administrator coordinates changes to computer databases and may plan, coordinate, and implement security measures to safeguard computer databases. The position is located at a government facility in Washington, D.C. and requires onsite work. Any hybrid work schedule would require customer approval. The government has established policies for on-site vs hybrid work which varies across divisions and contracts. Where allowed, remote work must be coordinated with the team lead and/or government POC, ensuring there is zero interruption with the delivery of our services.

Requirements

Active Top-Secret with SCI and CI Poly eligibility
Bachelor’s degree in Information Technology or related field or equivalent education and/or experience.
Minimum 8 years of database administration experience.
Strong knowledge and experience in database management systems.
Ability to design and maintain complex databases.
Experience with database administration and testing.
Knowledge of security measures and techniques to safeguard computer databases.
Excellent coordination and communication skills to manage database changes and integration.

Responsibilities

Design, implement, and maintain moderately complex databases.
Maintain database dictionaries and ensure the integration of various systems through effective database design.
Administer and test computer databases, utilizing knowledge of database management systems.
Coordinate changes to computer databases to ensure data integrity and system efficiency.
Plan, coordinate, and implement security measures to protect computer databases from unauthorized access or data breaches.
Administer and optimize PostgreSQL (v13+) including configuration, performance tuning, patching, and capacity planning.
Implement and validate backup and recovery for PostgreSQL using pg_dump/pg_restore and WAL archiving.
Configure and monitor PostgreSQL replication and high availability (physical/logical replication).
Perform query tuning and indexing for PostgreSQL using EXPLAIN/ANALYZE, partitioning, and pg_stat_statements.
Plan and execute migrations to/from PostgreSQL, including cloud-managed services such as AWS RDS or Aurora PostgreSQL and from Oracle.
Establish monitoring and alerting for PostgreSQL using standard observability tooling (e.g., Prometheus/Grafana or equivalent).