SQL DBA

Role: SQL DBA

Location: Redmond, WA (Locals Only)

Duration: 6+ months

Major Responsibilities

• Application Monitoring and Incident Management along with Incident Investigation & Restoration work
• Understanding the root causes of the issues and follow up with internal teams for any gaps
• Make critical operations decisions by prioritizing multiple, simultaneous events
• Coordinate work performed by multiple teams and track resolution.
• Coordinate appropriate escalation notification and High Priority process execution
• Prepare and execute test cases in collaboration with business owners to ensure that the operational integration aspects of all the releases are properly validated and ready for deployment on Production environments
• Execute manual/automated test cases for deployment validation and verification
• Prerequisite data validation/Verification, troubleshooting of all the distributed infrastructure for deployments
• Create manual/automated test scripts for pre & post deployment validations in multiple environments including Production/Non Production
• Troubleshooting, data validation/verification and data set up for various releases and patches
• Preparing the multiple environments and ensuring the distributed infrastructure is up to date with latest patches installed
• Streamline communication between Client services and the IT/Dev teams
• Ensure proper taxonomy used for the creation and closure of tickets
• Ensure all work performed follows procedures listed in the TSG
• Manages resources, coordinates and participates in activities associated with multiple environments including Production/Non Production SQL Servers
• Plan automated backups and fail-over configurations
• Make critical operations decisions by prioritizing multiple, simultaneous events
• Coordinate appropriate escalation notification and High Priority process execution

Preferred DB Skillsets

• SQL 2008/2012 DBA Skills
• Backup and recovery operations
• Replication administration
• Index Tuning
• Query Tuning
• T-SQL and Stored Procedure creation
• Schema management
• DB related file system management
• Clustering administration
• Data archiving
• Database mirroring
• Experience in supporting large database systems with high transactional volume
• SQL Server Clustering