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 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 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 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.g., replication, clustering).
• Perform database migrations.
• Specializing in Oracle to PostgreSQL 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 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 and Support :
• Provide timely and effective troubleshooting for database-related issues.
• Respond to and resolve production incidents.
• Provide technical support to developers and other and Training :
• Mentor and train junior database administrators.
• Share knowledge and best practices with the team.
• Create and maintain technical Skills and Requirements :
• 5-8 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.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 :
• Advanced knowledge of PostgreSQL administration, configuration, and tuning.
• 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, Systems :
• Strong knowledge of Linux / Unix operating systems (e.g., CentOS, Ubuntu, RHEL).
• Experience with shell Tools :
• Experience with database monitoring and management tools (e.g., pgAdmin, Prometheus, Grafana).
• Knowledge of database migration tools (e.g., ora2pg, pgloader).
• Experience with ETL :
• Proficiency in SQL.
• Knowledge of scripting languages (e.g., Python, (Preferred) :
• Experience with cloud-based PostgreSQL services (e.g., AWS RDS for PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL for PostgreSQL).
• Knowledge of cloud infrastructure and Qualifications and Skills :
• Bachelors 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.g., Docker, Kubernetes).
• Knowledge of CI / CD pipelines.
• Experience with infrastructure as code (IaC) tools like Terraform or Ansible.
• Experience with NoSQL databases

(ref : hirist.tech)