Database Administrator

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., * 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 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., At Technica Corporation, our goal is to provide exceptional professional services and innovative technology solutions that meet or exceed our customer’s expectations. We specialize in a wide range of advanced information technology solutions from Systems Engineering to Cyber Security, and from Software Development to Product Solutions. From our locations across the DC Metro area, Hampton, Virginia, and Huntsville, Alabama, we provide technological subject matter expertise, program management and business process knowledge as a trusted advisor in support of our Department of Defense and other Federal Agency customers.

• 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., Amazon Relational Database Service (RDS), Analysis Skills, Business Process Management, Capacity Management, Change Management, Cloud Computing, Communication Skills, Computer Security, Computer Testing, Data Quality, Data Recovery, Database Administration, Database Design, Database Management Software/Systems (DBMS), Database Technology, Federal Government, Government, Government Policies, High Availability, Information Technology & Information Systems, Information/Data Security (InfoSec), Internet Security, Machine Tool, Microsoft Access Database, Oracle, Organizational Skills, Performance Tuning/Optimization, Policy Development, PostgreSQL, Professional Services, Project/Program Management, Replication and Remote Mirroring, Service Delivery, Software Development, Software Patches, System Integration (SI), System Migration, Systems Administration/Management, Systems Engineering, Team Lead/Manager, Work From Home

The annual base salary range for this position is $116,000 - $150,000. Please note that the salary information is a general guideline only. Technica considers factors such as scope and responsibilities of the position, candidate’’s work experience, education/training, key skills, location, as well as market and business considerations when extending an offer.