L3 Team Member Resume California - Hire IT People

PROFESSIONAL SUMMARY:

Having 7.5 years of Extensive experience as a SQL Server DBA (Production Support) with basic knowledge on MySQL and MONGO DB.
Experience in Installation, configuration and administration of SQL Server 2000/ 2005/2008/2012 /2014
Expert in Implementing and maintaining High Availability solutions (Always On / Replication / DB Mirroring / Log shipping)
Good knowledge in Database Migration and Up gradation from SQL Server 2000/2005 to SQL Server 2008/2012
SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases
Experience in Disaster Recovery Planning and Security Management operations
Ability to troubleshoot day - to-day problems encountered on production as well as development database environments
Supported over 500 database servers and 1200+ databases and databases with 1TB in size.

PROFESSIONAL EXPERIENCE:

Confidential

L3 Team Member

Environment: SQL Server 2000/ 2005/2008/2012 on Windows Server 2003/2008/2012

Responsibilities:

Managing 500+ database servers across 15 data centers and AWS location
Installing, Configuring and Administering SQL server 2005/2008/2012
Fixing real time issues for production outage resolutions - includes server performance and slow running queries
As a senior member, responsible for ensuring SLA is met for different kind of tickets like Service Requests, Incidents
Handling the Change management and problem management process
Automating the regular DBA tasks
Migrating databases from lower versions (SQL 2000/2005/2008 ) to higher versions (SQL 2008/2012/2014 )
Responsible for guiding junior administrators in trouble shooting non-routine and complex troubleshooting requirements
Performing annual DR test for the critical database and validating disaster recovery plan
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
Performing archival activity on production large databases to reduce the load on server

Confidential

L2 Team Member and Service Build Engineer

Environment: SQL Server 2008/2012 on Windows Server 2008/2012

Responsibilities:

Installing, Configuring and Administering SQL server 2005/2008
Applying the service packs and hot fixes on standalone servers/cluster servers
Supported for Project deployments, Monthly and Quarterly releases on UAT and Prod Servers.
Worked on Octopus Tool to deploy web applications and services
QA Refresh for every quarter to sync the UAT data with Production
Maintained high availability of database using Replication/Mirroring
Worked on Migration and Up gradation from lower version to higher version
Having calls with Clients and Business Analysts (BAs)

Confidential, California

Associate SQL Server DBA

Environment: SQL Server 2005/2008 on Windows Server 2003/2008

Responsibilities:

Installing, Configuring and Administering SQL server 2005/2008
Monitoring and auditing users, backup and recovery strategies, Monitoring and optimizing the performance of the database.
Export and Import the data from QA or Production servers to Development Servers
Establish procedure to migrate databases, logins, and jobs to new environment servers.
Maintained high availability of database using Replication/Mirroring
Configured transactional replication

Confidential

Associate SQL Server DBA

Environment: SQL Server 2008 on Windows Server 2008

Responsibilities:

Installing and Configuring SQL Server 2008, Upgrading Service Packs/hot fixes
Securing SQL Server (Managing Logins, users and object level permissions)
Optimizing and Automating SQL Server Administration (Configuring SQL Mail, Optimizing SQL Server Agent, Managing Operators, Managing all maintenance Jobs)
Setting up the Backup and DB optimization Maintenance Plans through GUI and T-SQL
Database Migration, Up gradation and Full Db Refresh
Optimizing, performance tuning and Troubleshooting SQL Server (Managing and Configuring Databases, Performance Tuning, Optimizing Indexes and Troubleshooting Memory related issues.)
Planning, Implementing and maintaining High Availability solutions (Log shipping/DB Mirroring)