SQL Server DBA with Clustering Job in Atlanta, Georgia Us
Title: SQL Server DBA with Clustering
Location: Atlanta, GA
Mode of Hire: Full Time
Experience Level: 6+ Years
Desired Competencies (Technical/Behavioral Competency)
Must-Have:
· Good Communication
· Strong DBA Experience in SQL Server 2000, 2005, 2008 R1/R2
· Configuring, Managing Troubleshooting SSAS SSES Services
· Strong Clustering experience with SQL Server 2005 2008
· Strong SQL Server Performance Tuning Experience
· Sql server 2005/2008 database migration and upgrades
· Database backup and restores
· Analyze and tune application performance by optimizing SQL, stored procedures and triggers
· Troubleshoot and provide technical solutions to database issues
· Participate in the design, implementation and testing of enterprise wide backup/recovery and disaster recovery
· Good knowledge of Change Management process and Configuration Management is required
· 24x7 Production Support experience and willingness to provide 24x7 support preferred
Good-to-Have:
· Worked in 24X7 production support
· Database monitoring tools
· Relevant SQL Server Certification is preferred
· ITIL awareness
· Windows Scripting
Responsibilities:
· Troubleshooting for day to day issues in SQL Server production/non-prod environment
· Installation and patching for SQL Server Databases
· Taking backup and recovery/cloning of database
· Creation of new databases
· Doing performance tuning for the databases
· Security management at database level.
· Space management for databases
· Monitoring of database health and remediating it ontime.
· Patch management for SQL Server database
· 24X7 production support (oncall / shifts – as required)
· Working in onsite-offshore team structure
· Client interaction and Coordination with offshore team