Database Administrator

Responsibilities

Technica Corporation is seeking highly skilled Database Administrator who designs, implements, and maintains 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.Key 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).

The position would be located at a government facility in Washington, D.C. and require work to be performed onsite. Any hybrid work schedule would require customer approval. The go