PostgreSQL Database Administrator

We have an exciting opportunity for a PostgreSQL Database Administrator. This role serves as a PostgreSQL subject matter expert within a team that manages PostgreSQL, Progress OpenEdge, Oracle, and SQL Server databases, with the primary focus on administering PostgreSQL while also developing the skills to support at least one of the other platforms through training and mentoring as required.

This role can be based in the UK/Ireland or Germany on a remote basis but with the expectation of travel internationally when required by the business. 

About The Role

• Administrate, configure, and monitor a range of PostgreSQL databases as an integral part of the DP World DBA team. Ensure optimal performance, availability, and reliability of the managed PostgreSQL systems. Implement industry best practices for PostgreSQL database administration, including database tuning, resource management, and data integrity maintenance
• Proactively monitor PostgreSQL database performance, identifying and resolving performance bottlenecks to enhance system responsiveness. Collaborate with the DBA team and IT stakeholders to troubleshoot and resolve complex PostgreSQL database-related issues.
• Implement and maintain effective backup and recovery strategies for PostgreSQL databases, ensuring data integrity and uninterrupted business operations. Actively contribute to disaster recovery planning and testing to ensure data and system availability during emergencies.
• Plan and execute PostgreSQL database upgrades and migrations both on-prem and in the cloud, adhering to best practices and minimizing downtime.
• Collaborate closely with Infrastructure, Application, and Development teams to comprehend PostgreSQL database requirements and offer essential support during projects and deployments. Assist in code management and deployments, guaranteeing the stability and performance of PostgreSQL database environments.
• Maintain comprehensive documentation of PostgreSQL database configurations, procedures, and troubleshooting steps. Foster a culture of continuous learning and improvement by sharing your expertise and knowledge within the DBA team.
• Ensure timely application of PostgreSQL database patches, updates, and bug fixes to maintain up-to-date and secure systems.
• Engage in training and educational opportunities to enhance your PostgreSQL database administration skills. Stay informed about the latest features, best practices, and trends in PostgreSQL technologies.
• Participate in an out-of-hours on-call rota (1 weeek in 4 maximum)

Your Key Skills:

• Bachelor's degree in computer science, mathematics or related field, however relevant technical experience would also be considered
• At least eight years of related database administration experience required with at least 3-4 specifically dealing with PostgreSQL
• Strong technical background with proven analytical and problem-solving skills.
• Experience in managing EDB Postgres Advanced Server and PostgreSQL environments in Linux-based deployments.
• Experience with Oracle, SQL Server, or Progress OpenEdge is a bonus.
• Experience with performance tuning and optimization, using native monitoring and troubleshooting tools such as EDB Postgres Enterprise Manager and pgAdmin.
• Experience with backups, restores, and recovery models for PostgreSQL/EDB.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for PostgreSQL/EDB, including replication and clustering.
• Proficiency in PostgreSQL/EDB performance tuning and optimization techniques.
• Experience working in environments that include Red Hat Linux, Windows Server, Azure, and other cloud technologies.
• Strong knowledge and experience of working with database management tools such as pgAdmin, EDB tools, and command-line utilities.
• Experience with scripting languages (e.g., Bash, Python, PowerShell) for automating tasks and processes related to PostgreSQL/EDB administration.
• Familiarity with change management, change control processes, and problem management specific to PostgreSQL/EDB environments.
• Comprehensive understanding of PostgreSQL/EDB database architecture, file structures, and design principles.
• Organised and adept at working within deadlines. Capable of managing multiple project requests concurrently, engaging team members at a technical level, and effectively communicating complex technical concepts to non-technical individuals.
• Demonstrated ability to exercise sound judgment and manage risk for critical PostgreSQL/EDB systems.
• Proven track record of providing timely technical support to both internal stakeholders and external customers.
• Strong documentation skills with experience in establishing and improving processes and procedures related to PostgreSQL/EDB administration.

Compensation

DP World offers exciting and challenging roles within a growing international organization. We strive to hire and develop the right people, locally and globally, stimulating personal growth and self-development within an informal atmosphere. We offer a market competitive compensation package.

About Dp World

Trade is the lifeblood of the global economy, creating opportunities and improving the quality of life for people around the world. DP World exists to make the world’s trade flow better, changing what’s possible for the customers and communities we serve globally.

With a dedicated, diverse and professional team of more than 103,000 employees spanning 75 countries on six continents, DP World is pushing trade further and faster towards a seamless supply chain that’s fit for the future.

We’re rapidly transforming and integrating our businesses -- Ports and Terminals, Marine Services, Logistics and Technology – and uniting our global infrastructure with local expertise to create stronger, more efficient end-to-end supply chain solutions that can change the way the world trades. The DP World family comprises of syncreon, Imperial and P&O.

What's more, we're reshaping the future by investing in innovation. From intelligent delivery systems to automated warehouse stacking, we’re at the cutting edge of disruptive technology, pushing the sector towards better ways to trade, minimising disruptions from the factory floor to the customer’s door.

We Make Trade Flow

To Change What's Possible For Everyone

DP World is committed to the principles of Equal Employment Opportunity (EEO). We strongly believe that employing a diverse workforce is central to our success and we make recruiting decisions based on your experience and skills. We believe that employees are happiest when they’re empowered to be their true, authentic selves. So, please come as you are. We can’t wait to meet you.

By submitting your resume and application information, you authorize DP World to transmit and store your information in the world-wide recruitment database, and to circulate that information as necessary for the purpose of evaluating your qualifications for this or other job vacancies

#Li-Do1