Senior SQL Server DBALocation: Columbus, OHDuration: 6-12 MonthsNeed 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 PlusExperience 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.