Database Engineer - PostgreSQL

Description :

Responsibilities :

Database Design & Development :

- Develop stored procedures, triggers, functions, and views using PL/pgSQL.

- Optimize queries and indexing strategies for performance and scalability.

- Experience with pgModeler for database design.

Deployment & Automation :

- Automate schema migrations and maintain version control with tools like Liquibase or Flyway.

- Integrate database changes into CI/CD pipelines.

Administration & Operations :

- Monitor database health, performance, and resource utilization.

- Implement backup, restore, and disaster recovery strategies.

- Configure replication, clustering, and high availability solutions.

Security & Compliance :

- Ensure compliance with data protection regulations (GDPR, HIPAA, etc.).

Troubleshooting & Complex Scenario Handling :

- Handle large-scale data partitioning, sharding, and advanced indexing.

- Provide support for production incidents and root cause analysis.

Skills & Requirements :

- Strong proficiency in Vector database.

- Experience in schema design, query optimization, and indexing.

- Knowledge of replication, partitioning, sharding, and clustering.

- Proficiency in backup/recovery and disaster recovery planning.

- Familiarity with monitoring tools (pgAdmin, Prometheus, Grafana).

- Familiarity with deployment tools (Jenkin, Bitbucket).

- Understanding of Linux system administration.

- Strong problem-solving and debugging skills.

Nice to Have :

- Familiarity with containerized environments (Docker, Kubernetes).

- Knowledge of PostgreSQL extensions (PostGIS, TimescaleDB, pg_partman).

- Scripting skills (Python, Bash) for automation.

- Exposure to large-scale, high-throughput environments.

- Experience with CI/CD pipelines for database deployments.