Database Administrator - PostgreSQL

We are seeking a highly skilled and experienced PostgreSQL Database Administrator to join our dynamic team.

In this role, you will be responsible for the design, implementation, and maintenance of our large-scale PostgreSQL database infrastructure.

You will play a critical role in ensuring the performance, security, and availability of our mission-critical data.

The ideal candidate will possess a deep understanding of PostgreSQL internals, strong problem-solving skills, and a proven track record of managing complex database environments.

Responsibilities :

Database Design and Implementation :

- Develop and maintain database schemas, tables, indexes, views, and stored procedures.

- Implement and enforce database standards and best practices.

- Participate in capacity planning and performance forecasting.

Performance Tuning and Optimization:

- Perform query optimization, indexing, and normalization to improve database efficiency.

- Analyze and tune database configurations for optimal performance.

- Conduct performance testing and benchmarking.

Database Administration and Maintenance :

- Manage user accounts and permissions.

- Implement and maintain backup and recovery strategies.

- Perform disaster recovery planning and testing.

- Monitor database health and proactively address issues.

- Implement and maintain high availability solutions (e.g., replication, clustering).

- Perform database migrations.

- Specializing in Oracle to PostgreSQL migrations.

Data Integration and ETL :

- Design and develop data pipelines using appropriate tools and technologies.

- Ensure data quality and consistency.

Security and Compliance :

- Monitor database activity and identify potential security threats.

- Ensure compliance with relevant data privacy regulations.

- Perform regular security audits.

Troubleshooting and Support :

- Respond to and resolve production incidents.

- Provide technical support to developers and other stakeholders.

Mentoring and Training :

- Share knowledge and best practices with the team.

- Create and maintain technical documentation.

Primary Skills and Requirements :

- Strong understanding of PostgreSQL architecture and internals.

- Expertise in database performance tuning, query optimization, indexing, and normalization.

- Experience with database backup and recovery procedures, including disaster recovery planning.

- Proficiency in SQL and database scripting (e.g., PL/pgSQL).

- Experience with database security and access control.

- Knowledge of ETL concepts and tools.

- Experience with database monitoring and alerting tools.

- Ability to work under pressure and meet deadlines.

- Excellent problem-solving and analytical skills.

- Strong communication and collaboration skills.

Technical Skills :

PostgreSQL :

- Experience with PostgreSQL replication, clustering, and high availability solutions (e.g., streaming replication, Patroni).

- Proficiency in PL/pgSQL for stored procedures, functions, and triggers.

- Experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB).

Operating Systems :

- Experience with shell scripting.

Database Tools :

- Knowledge of database migration tools (e.g., ora2pg, pgloader).

- Experience with ETL tools.

Scripting/Programming :

- Knowledge of scripting languages (e.g., Python, Bash).

Cloud (Preferred) :

- Knowledge of cloud infrastructure and networking.

Preferred Qualifications and Skills :

- Hands-on experience with database migration, particularly from Oracle to PostgreSQL.

- Experience with containerization technologies (e.g., Docker, Kubernetes).

- Knowledge of CI/CD pipelines.

- Experience with infrastructure as code (IaC) tools like Terraform or Ansible.

- Experience with NoSQL databases