Database Administrator - PostgreSQL (3-6 yrs)

Job Description :

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 :

- Design, build, and configure PostgreSQL databases to meet evolving business requirements.

- 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 :

- Monitor database performance and identify bottlenecks.

- 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 :

- Install, configure, and upgrade PostgreSQL servers.

- 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., replication, clustering).

- Perform database migrations.

- Specializing in Oracle to PostgreSQL migrations.

Data Integration and ETL :

- Develop and implement ETL strategies for integrating data from diverse sources into data warehouses.

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

- Ensure data quality and consistency.

Security and Compliance :

- Implement and maintain database security measures to protect sensitive data.

- Monitor database activity and identify potential security threats.

- Ensure compliance with relevant data privacy regulations.

- Perform regular security audits.

Troubleshooting and Support :

- Provide timely and effective troubleshooting for database-related issues.

- Respond to and resolve production incidents.

- Provide technical support to developers and other stakeholders.

Primary Skills and Requirements :

- 3-6 years of proven experience as a PostgreSQL Database Administrator in a large-scale enterprise environment.

- 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., 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 and1 collaboration skills.

Technical Skills :

- Advanced knowledge of PostgreSQL administration, configuration, and tuning.

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

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

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

- Experience with shell scripting.

- Experience with database monitoring and management tools (e., pgAdmin, Prometheus, Grafana).

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

- Experience with ETL tools.

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

- Knowledge of cloud infrastructure and networking.

Preferred Qualifications and Skills :

- Bachelor's degree in Computer Science, Information Technology, or a related field.

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

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