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, TerraformAdditional Skills & Qualifications:Experience with production workloads in an AWS ecosystemExperience with PostgreSQL 11 and aboveExperience with SQL Server 2016 and aboveExperience with maintaining AWS RDS and Aurora instancesIn-depth understanding of the database engine and strong performance tuning skillsTroubleshooting experience with PostgreSQL and SQL Server high availability solutionsStrong experience working with Unix/Linux and Shell ScriptingTroubleshoot 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 advantageFamiliarity with database CICD process, concept, and toolsUnderstanding of NoSQL databases is an added advantage. Responsibilities:Work with developers and business analysts to create and modify database structureMonitor the performance of the database serversOn-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 PostgreSQLStrong understanding and ability to configure and troubleshoot log shipping and Always-on HA solutions in SQL ServerIdentify and resolve performance bottlenecks both in on-premises and cloudFamiliarity with deploying and managing PostgreSQL, SQL Server in cloud environments (e.g., AWS, Azure, GCP), preferably AWSPerform 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 warehouseMaintain system security and data integrityWork with systems engineers to ensure optimal hardware and storage subsystemsDevelop, manage, and maintain a strong disaster recovery and high availability planInstall, upgrade, and patch the database serversParticipate in code and design reviewsParticipate in production code pushesEligibility 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 & visionCritical Illness, Accident, and Hospital401(k) Retirement Plan – Pre-tax and Roth post-tax contributions availableLife Insurance (Voluntary Life & AD&D for the employee and dependents)Short and long-term disabilityHealth Spending Account (HSA)Transportation benefitsEmployee Assistance ProgramTime 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.