PostgreSQL Database Administrator (DBA)

Location: Chicago, Illinois (Hybrid)
Duration: +11 months, contract
Pay: $70+/hr

JOB DESCRIPTION
Our Retail client with over $80B in annual revenue has over 2,000 stores, across 21 US states, with over 400,000 employees. This company is a leader in sustainable retailing with a passion for delivering excellence. By driving omni channel growth, efficiency in the shopping experience and continuing to develop with new technologies; this company is growing and developing continuing success. The leadership team strives for work-life balance for all its employees, with options for overtime if desired.

We are seeking a highly skilled PostgreSQL Database Administrator (DBA) to join our team and ensure the optimal performance, integrity, and security of our database systems.
RESPONSIBILITIES

• Manage and maintain PostgreSQL databases on Azure Flexible Server.
• Ensure database performance, integrity, and security.
• Design and implement disaster recovery strategies.
• Perform performance tuning and optimization of database systems.
• Manage database migrations and version control using Flyway.
• Collaborate with development and operations teams to deploy resources using code.
• Develop and maintain ARM templates and Azure DevOps pipelines.
• Monitor and optimize database performance metrics.
• Implement and manage backup and recovery processes.
• Troubleshoot and resolve database issues.
• Maintain database documentation and standards.
• Stay updated with the latest database technologies and trends.

QUALIFICATIONS

• Proven experience as a PostgreSQL DBA.
• Strong understanding of database architecture and design.
• Experience with Azure Flexible Server and other Azure services.
• Proficiency in disaster recovery planning and implementation.
• Expertise in performance tuning and database optimization.
• Experience with Flyway for database migrations.
• Familiarity with ARM templates and Azure DevOps pipelines.
• Proficiency in SQL and database scripting.
• Working knowledge of other databases such as SQL Server, Cosmos DB, and Informix.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.
  Preferred Skills:
• Experience with database automation and scripting.
• Knowledge of data protection regulations and compliance.
• Ability to work under pressure and meet deadlines.