Tagcor

MS SQL databases

Database Support

5+ year experience with creating tools for DBA daily tasks, using PowerShell
Thorough understanding of SQL Server internals for troubleshooting performance issues
Provide primary support for critical, complex production MS SQL databases
Troubleshoot, investigate and drive resolution of incidents.
Work closely with internal technical teams during incident resolution and root cause analysis
Coordinate interaction with vendors, creating service requests and escalating as needed to ensure timely resolution.
Provide problem management and resolution for repeat issues
Make recommendations and contribute to the design and development of long-term solutions
Respond to inquiries from business partners related to performance, application errors, storage capacity, etc.
Review and execute medium to low risk changes including DDL, database configuration changes, patching, and upgrades
Participate in new system builds; create databases, schemas and deploy standard jobs and monitoring
Through review and solid handoffs, ensure system supportability prior to production utilization
Adhere to documented change and incident management policies
Develop technical documentation for use in future incident resolution
Provide support outside of normal office hours only on rare occasions (emergency and infrequent pre-planned occurrences)
Experience with SQL Server 2012, 2014, 2016 & 2017
Experience with SQL Server Replication & AG
Experience with PowerShell and automation projects