Database Administrator with Security Clearance

The Database Administrator 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).

Qualifications: 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.