Senior SQL Server DBA - Columbus, OH

Senior SQL Server DBA

Location: Columbus, OH

Duration: 6-12 Months

Need someone to be onsite 2 days per week. US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp.

Knowledge, Skills, & Abilities:

Overall 10+ years of managing SQL Server environments with minimum 5-7 years' experience in SQL server 2014 or later in an administrative role.

Must possess high-level of proficiency in SQL, T-SQL and Powershell.

Must possess 3+ years of experience building, deploying and maintaining ETL packages using SSIS.

Must possess experience installing, configuring, upgrading database software including HADR configurations.

3-5 years' experience creating/updating/optimizing/troubleshooting -- Stored procedures/functions, tables, views, triggers, indexes and constraints. Experience with database object migrations across multiple database environments and keeping various environments in sync.

Must possess experience in troubleshooting and resolving job failures, performance issues, blocking/deadlocking issues, connectivity and security issues.

Proficient in optimizing database workloads using Profiler/Extended Events/DMV's or other database monitoring tools. Experience with Solarwinds DPA is preferable.

Possess good working knowledge of windows server operating systems (2012/2016/2019)

Possess strong knowledge of backups, restores and recovery models.

Possess solid understanding of various Amazon Web Services especially AWS RDS, EC2 and S3.

Familiarity with other SQL/NoSQL databases such as Oracle, MySQL, PostgreSQL, MongoDB, etc. is a Plus

Experience with enterprise information security, user accounts and database security management.

Experience with source control and change control processes and tools.

Ability to work unsupervised, prioritize task lists and be self-responsible and accountable.

Ability to document and communicate effectively with the team regarding technical, progress and critical issues. Possess excellent written and verbal communication skills.