Job description

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 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. 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. • 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.   About Technica : 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. EQUAL EMPLOYMENT OPPORTUNITY It is Technica's policy to affirmatively support Equal Employment Opportunity (EEO) for all qualified individuals without regard to color, gender, religion, creed, national origin, age, race, disability, gender identity, genetic information, sexual orientation, marital status, veteran status or any other characteristic protected by law. This policy covers all aspects of the employment relationship including recruiting, hiring, compensation, assignment, promotion, transfer, training, working conditions, employment longevity, retirement, employee benefits and termination. Technica's EEO philosophy promotes equal employment opportunity throughout the organization. Any form of unlawful employee harassment based on the above mentioned characteristics is prohibited. Equal Opportunity Employer Minorities/Women/Vets/Disabled/Gender Identity/Sexual Orientation.

Requirements

Must-haves

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).
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.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aws

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Vision

Pto