PostgreSQL DBA - TEKsystems

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.