At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
Top Skills' Details
Experience with SQL Server 2016 and above
Experience with PostgreSQL 11 and above
Experience with AWS; able to maintain AWS RDS and Aurora instances
Description:
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.
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
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.