What are the responsibilities and job description for the Senior SQL DBA position at Techgene Solutions LLC?
Job Description
Role: Senior SQL DBA
Must be willing to be hybrid Ft. Lauderdale, FL, (Could also sit in Dallas or White Plains, NY)
6 month Contract
Position Summary:
Looking for a Senior level SQL Server Database Administrator to join our team! We are a SQL Server heavy shop on our journey to the cloud (AWS Azure) using Aurora and MongoDB databases. The Senior DBA is responsible for providing operational and engineering data support to. This role will also be involved in senior level discussions within the team and outside team and be a representative of the DMT(Data Management team) in architectural discussions.
This is a hybrid (60-40) position based in Fort Lauderdale, FL
Qualifications:
- Bachelor's degree or equivalent work experience.
- Minimum 7 plus years' experience with database administration for MSSQL Server 2014 and up.
- Minimum 3 years of SQL server database architecting experience.
- Very strong scripting and automation skills are expected using TSQL, Power SQL and SQL Agent.
- Good understanding of AWS technology and year plus hands-on knowledge of Aurora MongoDB or some NoSQL databases.
- Experience with administering databases greater than 5 TB.
- Automation experience for day to day tasks is required.
- Experience with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server 2014 and up, including failover clustering, log shipping and MSSQL Always On.
- Experience in troubleshooting and resolving problems (performance issues, database integrity issues, blocking and deadlocking issues).
- Experience in MS SQL Business Intelligence Stack (SSIS, SSAS and SSRS).
- Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience with Microsoft SQL Server backup and recovery scenarios.
- Experience with Microsoft SQL Server replication.
- Excellent communication and documentation skills.
- Experience in implementing operational automation using scripts is desirable.
- Experience with Delphix is highly desirable.
