Application DBA

Position: SQL DBA - Dev DBA , SNOWFLAKE Must Haves - Experience with creating tools for DBA daily tasks, using PowerShell - Always On Experience - 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 - Respond to inquiries from business partners related to performance, application errors, storage capacity, etc. - SQL query optimization skills - 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 Skills: Sql Server 2012, Always On, Sql Server, Powershell Experience: 0.00-0.00 Years