Database Engineer II

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