JOB DESCRIPTION:
Senior SQL Server Database Administrator
As a Senior SQL Server Database Administrator, you will support a large SQL Server environment with infrastructure both in on-prem data centers and AWS. This role is proficient at SQL Server Database Administration, T-SQL, DevOps concepts, Scripting and automated deployment, monitoring, and support. Be a hands-on engineer to drive detailed and evolutionary designs while working across the organization interfacing with the Application Development and Reporting Teams. Will execute day to day tasks related to operational or project work and contribute to 24x7x365 days of on-call staff coverage.
Responsibilities:
Configure and manage Always On Availability Groups and Failover Clustering.
Accurately complete change ticket requests for database deployments on a timely basis.
Provide SQL Server/T-SQL performance tuning including but not limited to configuration settings, storage optimization (on AWS), query tuning and indexing.
Ensure successful database backups in a way to meet the business RPO's and RTO's
Define improvements to increase system reliability, security, and performance.
Recommend and implement emerging database technologies.
Identify and automate repeating database tasks.
Ensures proper instrumentation of Infrastructure to align with Production Assurance processes (Event, Incident, Change, Release and Problem management).
Assist with database upgrades including planning, preparation & execution of upgrades.
Diagnose and troubleshoot database related issues and errors.
Incident, Change, Release and Problem management).
Contribute to 24x7x365 days of on-call staff coverage.
Required skills:
3 years minimum experience as a SQL Server Database Administrator
Strong verbal and written communication skills.
PowerShell scripting experience
Knowledge of AWS including RDS, EC2, EBS, Cloud Watch, and S3
