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