Occupation:Database Administrator |
Location:Alpharetta, GA |
Education Level:Bachelor |
Will Relocate:YES |
Description
EXPERIENCE SUMMARY Having 14+ years of SQL Server database administration & development experience with DBA duties. * Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, SQL Server 2005, SQL Server 2008/R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. * Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations * Developing the successful backup strategies based on recovery models * Implementation of database maintenance plans and backup automation * Implementation of SQL logins, roles and authentication modes as a part of security * Experience in Upgradation/Migration from lower to higher versions * Experience in providing Production support for Database and Applications. * Experience in Tuning SQL Queries & improving the performance of the Database and Applications. * Experience in Creating Jobs and automating the reports. * Extensive experience with Monitor, tune and analyze database performance and allocate server resources to achieve optimum database performance. * Maintaining and troubleshooting Log-Shipping * Experience in implementing different types of Replication models * Successfully planned and implemented Database Mirroring * Configuration and implementation of Always-On High Availability. * Good experience in resolving blocking/locking and dead lock Issues * Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks PROFESSIONAL SUMMARY