SQL DBA

Collabera - SQL DBA

Position: SQL DBALocation: Downtown Dallas, TXDuration: 12 Month Contract (Possible Extension/Conversion)Day-to-Day:

• We need a Sr. DBA who can work independently to perform daily support activity, as well as lead automation projects.
• Required experience with SQL Server Replication, AG and automation. Experience with automating DBA tasks, using PowerShell and similar tools.
• Experience with architecting complex solutions for new application and migrations.
• Some details and requirements are subject to change

Must haves:

• 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

C#,Windows,Other,dba,JIRA,Powershell,Scheduling,Azure,Shipping,Testing, Troubleshooting, SQL, embedded Other