Database Administrator

Responsibilities:

• Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.
• Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting.
• Deploy and maintain database infrastructure on both on-premises servers and AWS cloud platforms, utilizing best practices for scalability, reliability, and cost-efficiency.
• Collaborate with cross-functional teams to design, implement, and optimize database architectures to meet business requirements and performance goals.
• Implement and maintain disaster recovery solutions, including backup strategies, replication, and failover procedures, for both on-premises and AWS deployments.
• Automate routine DBA tasks and workflows using scripting languages.
• Ensure compliance with security policies, regulatory requirements, and industry best practices for database operations and data protection.
• Monitor and response to DB alerts from monitoring tools and command center team.
• Monitor database performance and capacity utilization, proactively identifying and resolving issues to maintain optimal performance and scalability.
• Provide trend analysis to executive management to help them taking informed decisions regarding resource management.
• Lead, monitor and provide guidance to junior DBA.
• Collaborate with cross-functional teams to ensure smooth integration of databases with other systems and applications.
• Perform database capacity planning and trend analysis.
• Apply changes to the database following strict procedures of Change management policies and protocol.

Must Have:

• Experience with PostgreSQL database, Enterprise Failover Manager (EFM), Postgres Enterprise Manager (PEM) and PGBACKREST on Linux servers.
• Proficiency in end-to-end architecture of PostgreSQL database, including database design, development, administrate of large-scale database, OLTP and analytical data structures (logical and physical design)
• Experience managing PostgreSQL databases in AWS RDS and/or EC2 environments.
• Proficiency in PostgreSQL troubleshooting, performance tuning, SQL Tuning, access management and security setup, health monitoring and maintenance, PL/PGSQL (triggers, functions, ….)
• Experience in designing, implementing, and monitoring disaster recovery (DR) solutions for PostgreSQL databases including Backup and restore, Point-in-Time-Recovery (PITR), on-site/offsite replication.
• Experience managing Amazon RDS implementation of PostgreSQL.
• Experience in database and data migration from on-premises to cloud.
• Experience in creating Linux shell scripts.

‌

Nice To Have:

• Experience with Connection Management using options such as LDAP, Kerberos in PostgreSQL.
• Familiarity with managing version control and deployment processes, specifically within Amazon RDS and on-premises server environments.
• Experience with database automation and orchestration tools such as Jenkins and Ansible.
• Solid understanding of database security best practices and compliance standards.
• Provision, manage, deploy, monitor and benchmarking statistics in OpenShift environment.
• Experience with latest PG community contribution modules/projects.
• Experience with other database technologies (e.g., MySQL, Oracle, MongoDB).
• Familiarity with containerization technologies such as Docker and Kubernetes.
• Knowledge of DevOps practices and principles.

‌

Preferred Qualification:

• Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
• Proven experience as a PostgreSQL Database Administrator, with at least 5-7 years of hands-on experience.
• Ability to work effectively in a fast-paced environment and manage multiple priorities.
• Excellent communication and collaboration skills, with a strong customer service orientation.
• PostgreSQL certification (e.g., Certified PostgreSQL Associate/Professional) is a plus.

If you're a skilled PostgreSQL DBA looking for an exciting opportunity to work with cutting-edge technologies and contribute to the success of a dynamic team, we'd love to hear from you. Apply now and join us on our journey to innovate and transform the world of technology