Must have 5+ years SQL Server DBA working experience with SQL Server.
Must be knowledgeable and experienced in the different versions of SQL Server (2012 - 2016). Knowledge of upgrading to SQL Server 2019 & 2022 and benefits to the migrating to these environments.
Must have skills and experience in Database data management backups, ETL, and archive using native SQL Server backup tools.
Experienced using internal diagnostic and maintenance tools such as DBCC and internal SP functions as well as SQL Diag, SQL Profiler, and third-party diagnostics tools.
Demonstrate Knowledge of Partitioning Architecture.
Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSAS, SSRS, and MS SharePoint.
Management of multiple processing schedules and notification strategies. Strong skills in T-SQL, DOS, PowerShell, tuning, and debugging. Experience with SQL Server Manager, Visual Studio, DTS/SSIS, and other SQL Server tools including but not limited to Profiler & SQL Server Command Line Utilities
Experience with SQL Server database replication and mirroring
Experienced in security/access strategies for a wide pool of user groups and developers with different access requirements.
Ability to maintain a positive attitude while working with high demands and short deadlines
Ability to prioritize heavy workload with minimum supervision
Highly adaptable with the ability to work in a fast-paced demanding environment
Must have excellent communication and interpersonal skills
Ability to work well with development and infrastructure teams in doing database design, changes, and enhancement to new and existing applications.
Strong organizational and analytical skills.
Understanding of High Availability and Disaster Recovery requirements and solutions.
Preferred:
Microsoft Certified Database Administrator (MCDBA) or higher certificates on SQL Server 2012+.
Experience in data modeling and metadata management.
Understanding of or experience supporting .NET applications.
Understanding of or experience with virtual environments.
Experience with Oracle DBA and Oracle support is a strong plus