Today
Top Secret/SCI
Unspecified
Full Scope Polygraph
IT - Database
Fort Meade, MD (On-Site/Office)
Kavaliro is seeking a Database Engineer to support a client in Maryland.
Job Description:
The candidate shall have experience with Sybase ASE and PostgreSQL, with specific experience with database migrations and integrating PostGIS. Demonstrated experience with developing migration strategies, migration tool selection and use, schema conversion, code refactor, performance optimization, test, and validation. Experience with Amazon Web Services (Relational Database Services, Simple Storage Service) also required.
Key Responsibilities:
Job Description:
The candidate shall have experience with Sybase ASE and PostgreSQL, with specific experience with database migrations and integrating PostGIS. Demonstrated experience with developing migration strategies, migration tool selection and use, schema conversion, code refactor, performance optimization, test, and validation. Experience with Amazon Web Services (Relational Database Services, Simple Storage Service) also required.
Key Responsibilities:
- Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability.
- Monitor and tune database performance using native tools and custom scripts.
- Implement and maintain high availability (HA) and replication strategies.
- Collaborate with developers to refine complex queries and stored procedures.
- Automate routine tasks using scripting languages (e.g., Bash, Python).
- Document database architecture, processes, and best practices.
- Strong SQL skills and experience with performance tuning and query optimization.
- Proficiency in Linux/Unix environments and CLI tools like psql.
- Experience with logical and physical replication, partitioning, and backup strategies.
- Familiarity with cloud platforms (AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL).
- Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana).
- Knowledge of scripting languages for automation and tooling.
- Experience with containerized environments (Docker, Kubernetes).
- Understanding of CI/CD pipelines and infrastructure as code (Terraform, Ansible).
- Exposure to other RDBMS (e.g., Oracle, MySQL) or NoSQL systems is a plus.
- Fort Meade, MD
- This position is onsite and there is no remote availability
- Candidates must have an active TS/SCI security clearance with a Full Scope Polygraph.
group id: 10411514