Database Engineer

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.

Skills

Database Design, Database Architecture, DBMS, Database Installation, PostgreSQL, Database Schema, Monitoring Tools, PL-SQL