Database Engineer II
Reflexive Concepts
- Annapolis Junction, MD
- Permanent
- Full-time
Specifically, we're looking for someone who has experience with PostgreSQL and PostGIS.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 monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana).
- Knowledge of scripting languages for automation and tooling.
- Experience with containerized environments (Docker, Kubernetes).
- Familiarity with cloud platforms (AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL).
- 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.
- Active TS/SCI FS Poly
- Five (5) years of DBE or related experience
- Bachelor's degree in technical discipline