Reflexive Concepts
Database Engineer II
Reflexive Concepts - Annapolis, Maryland, United States, 21403
Work at Reflexive Concepts
Overview
- View job
Overview
Reflexive Concepts is seeking a Database Engineer II to join our team!
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.
Required Qualifications: •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.
Preferred Qualifications: •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.
Requirements:
Active TS/SCI FS Poly Five (5) years of DBE or related experience Bachelor's degree in technical discipline
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.
Required Qualifications: •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.
Preferred Qualifications: •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.
Requirements:
Active TS/SCI FS Poly Five (5) years of DBE or related experience Bachelor's degree in technical discipline