Database Engineer - PostgreSQL

Description :

Responsibilities :

Database Design & Development :

• Architect and implement efficient schemas, tables, and relationships.
• 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 :

• Manage database deployments across dev, staging, and production environments.
• Automate schema migrations and maintain version control with tools like Liquibase or Flyway.
• Integrate database changes into CI/CD pipelines.

Administration & Operations :

• Install, configure, and upgrade PostgreSQL instances.
• Monitor database health, performance, and resource utilization.
• Implement backup, restore, and disaster recovery strategies.
• Configure replication, clustering, and high availability solutions.

Security & Compliance :

• Enforce role-based access control, encryption, and auditing.
• Ensure compliance with data protection regulations (GDPR, HIPAA, etc.).

Troubleshooting & Complex Scenario Handling :

• Diagnose and resolve deadlocks, replication issues, and performance bottlenecks.
• Handle large-scale data partitioning, sharding, and advanced indexing.
• Provide support for production incidents and root cause analysis.

Skills & Requirements :

• Strong expertise in PostgreSQL (SQL, PL/pgSQL).
• 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 :

• Experience with cloud-hosted PostgreSQL (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL).
• 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.