PostgreSQL DBA

TEKsystems
$60.00 - $65.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, Michigan, Detroit
Nov 21, 2024
Our client is looking for a PostgreSQL DBA to support day to day tasks within their environment, as well as an upcoming project to upgrade 150 clusters to the most recent version of mySQL. The team is currently made up of 6 other DBA's, so the openness to learn and work with other database technologies outside of PostgreSQL is important for this opportunity. In addition to this, someone that can come in and evaluate their current implementation strategies and suggest solutions for better performance/efficiency would be a big asset to this team. The ideal candidate would have a minimum of 3 years of experience working heavily with PostgreSQL, SQL Server, as well as AWS. Seeking candidates who are passionate about the technology, self-starters, and a quick learner. Skills: Database Administrator, PostgreSQL, SQL, Sql Server, Mysql, Troubleshooting, AWS, Terraform Additional Skills & Qualifications: Experience with production workloads in an AWS ecosystem Experience with PostgreSQL 11 and above Experience with SQL Server 2016 and above Experience with maintaining AWS RDS and Aurora instances In-depth understanding of the database engine and strong performance tuning skills Troubleshooting experience with PostgreSQL and SQL Server high availability solutions Strong experience working with Unix/Linux and Shell Scripting Troubleshoot service outages as they occur, including after hours and weekends. Experience with Infrastructure as a code (IAC) such as terraform, or Cloud-formation is an added advantage Familiarity with database CICD process, concept, and tools Understanding of NoSQL databases is an added advantage. Responsibilities: Work with developers and business analysts to create and modify database structure Monitor the performance of the database servers On-call support on a rotation basis (1 week every 6-7 weeks) Strong understanding and ability to configure and troubleshoot physical and logical replication in PostgreSQL Strong understanding and ability to configure and troubleshoot log shipping and Always-on HA solutions in SQL Server Identify and resolve performance bottlenecks both in on-premises and cloud Familiarity with deploying and managing PostgreSQL, SQL Server in cloud environments (e.g., AWS, Azure, GCP), preferably AWS Perform database maintenance tasks, including backups/restores, updating statistics, rebuilding indexes, etc. Work with data engineers to help map data in our production databases to the data warehouse Maintain system security and data integrity Work with systems engineers to ensure optimal hardware and storage subsystems Develop, manage, and maintain a strong disaster recovery and high availability plan Install, upgrade, and patch the database servers Participate in code and design reviews Participate in production code pushes Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: * Medical, dental & vision * Critical Illness, Accident, and Hospital * 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available * Life Insurance (Voluntary Life & AD&D for the employee and dependents) * Short and long-term disability * Health Spending Account (HSA) * Transportation benefits * Employee Assistance Program * Time Off/Leave (PTO, Vacation or Sick Leave) About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.