Database Engineer

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.