PostgreSQL Database Administrator (DBA)Location: Chicago, Illinois (Hybrid)
Duration: 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.
Category Code: JN008