Database Engineer

## About the role 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. ## 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.