DBA SQL Server

Essential Job Functions:

• Apply All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery.
• Work 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-through, and participation in weekly operations reviews.
• Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
• Proactive database monitoring and issue resolution
• Database and T-SQL optimization including performance tuning, query optimization, and supportability.
• Actively participate and contribute to projects involving enterprise database systems enhancements to meet business requirements. Participate in project design and SQL Server database design decisions.
• Develop and implement Database security policies and procedures, in line with corporate objectives
• Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
• Implementation and ongoing support of high availability architecture standards and technologies.
• Create and maintain appropriate documentation about the database and the data architecture.
• Support data management solutions including ETL processing, data archive, data purge, etc.
• Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
• Work on project sizing processes - including design reviews as necessary to appropriately size new environments, recommend design strategies and deliver associated cost and resource effort estimates.
• Perform other duties as assigned.

Position Requirements:

• 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