Senior SQL Server DBA - Columbus, OH - Georgia IT Inc.
Columbus, OH, NJ
About the Job
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:
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.
Source : Georgia IT Inc.