SUMMARY

• Having around 12 Years of IT experience 10 Years in PRODUCTION DBA (SQL Server).
• Involved in troubleshooting the service tickets (ServiceNow/Virtual Tech) and issues come through BMC.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2014/2012/2008/2005/2000.
• Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, SQL Server Profiler, SQL Server Agent, DTA and Business intelligent Studio.
• Involved in Server Building, configuring and Decommissioning procedures.
• Regular DATABASE BACKUP monitoring and reporting. Recovering the databases from backups in disaster.
• Expertise in Database Administration on Production Server with server configuration, patch, upgrade, maintain and migrate databases and Monitored appropriate disk storage requirements for the databases.
• Expertise and proficiency in SQL Server Replication with Disaster Recovery Planning and Security Management operations.
• Using Robocopy utility to move DB files to file server.
• Experience with Failover Clustering for high availability in Active/Active, Active/Passive.
• Experience in configuring, administering and maintaining Replication.
• Experience in supporting Very Large Database (VLDB) more than 9TB and troubleshooting problems
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Configuring, Monitoring and Troubleshooting LOG SHIPPING and DB MIRRORING, Always ON.
• Having basic knowledge on PowerShell Scripting.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Hands - on working experience with Analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Monitoring SQL Server performance using DMV’s and SQL PROFILER to find deadlocks and blocking. Utilizing the traces for tuning the performance (advisor).
• Updating Statistics and Rebuilding Indexes as a part of maintenance activities by checking the DB consistency.
• Maintaining the database consistency with DBCC at regular intervals.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility and efficiency.
• Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users.
• Troubleshoot system issues, monitored scheduled jobs and setting up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
• Works closely and effectively with all levels of management to satisfy projects/productivity requirements. Demonstrates commitment to leadership/teamwork through positive contributions in streamlining systems and providing superior customer service.
• Experience in Capacity planning, Maintenance planning, Performance Tuning, Disaster Recovery.
• Resolve database related incidents and requests within SLA’s.
• Experience in Offshore Team management
• Updating and Sanitizing DB weekly in DEV and QA environment and Implemented SQL DEV/QA environment on VMware.
• Generating weekly and Monthly reports as customer needed.
• Providing after hours and 24/7 database maintenance and production support.
• Adhere strictly to compliance and operational risk controls in accordance with client’s regulatory standards, policies and procedures.
• Flexibility and Adaptability in regards to new Technologies and environments and work on any project.

TECHNICAL SKILLS

Database: SQL Server (2000/2005/2008- R2/) and SQL Server 2012.

Tools: and Utilities: LiteSpeed, UMRDB, BMC Patrol, BMC Remedy, IBM Tivoli, Maestro, Virtual Tech, Service Now.

Operating Systems: Windows XP, Windows server 2000, 2003, 2008 R2.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SR. MSSQL Database Administrator

Environment: Window 2003/2008 Server, SQL 2005/2008/2008 R2/2012.

Responsibilities:

• Installation, Administration and Maintenance of SQL Server Instances SQL server 2005/2008/R2/2012.
• Coordinating with the Systems Administration team, install and maintain application software and systems that integrate with database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Worked in Active Active, Active Passive Cluster environment as a High availability solution.
• Configuring, Monitoring and Troubleshooting LOG SHIPPING and DB MIRRORING, Always ON.
• Supporting around 3000 Servers including PROD and Non-PROD servers, maximum database size is of 9 TB.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Working with development and systems teams to perform application and database tuning.
• Conducting every six months/yearly Cob tests to make sure the DR is running in sync with PROD.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Setup Test, Dev, Staging and Production Environments.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Migrating application code and objects from development/test environments to production.
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, etc.
• Design database Backup and Restoration Strategy.
• Once created the database Backups, monitor those backups are being performed regularly.
• From time to time recover the databases to a specific point of time, as per the requests.
• Setup High-Availability as part Disaster Recovery Strategy for the Databases.
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Monitoring and Performance Tuning; Physical Server Level, Database.
• Documenting major changes to the SQL Servers.

Confidential

SR. SQL Database Administrator

Responsibilities:

• Database Migration from SQL Server 2000 to 2005.
• Preparing documentation on Database Migration.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Maintain Backup/Restore policies
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Setting up and Monitored Log Shipping, Transactional replication, Database mirroring on Production and QA servers..
• Responsible routine DBA jobs like Backups and Restores.
• Conducting DR Test.
• Checking Database Health by using DBCC Commands and DMVS
• Resolving Space Issue of Production, QA, Development and DR Server.
• Managing Logins and Security.
• Monitored and modified Performance using execution plans and Index tuning.
• Daily Health Check of all production servers (300+).
• Database Backup and Restoration.( Lite-Speed & Native Backup)
• Importing, Exporting Data, Shrinking Database.
• Transfer Login, users between Database Servers.
• Implementing Log-Shipping between Primary Server and DR Server.
• Generate Script for Different Objects of the Database.
• Monitoring Replication using Replication Monitor.

Confidential

SQL DBA

Responsibilities:

• Log Shipping configuration.
• Conducting DR Test.
• Resolving Space Issue of Production, QA, Development and DR Server.
• Monitoring Daily, weekly and monthly Production, QA, Development and DR Server jobs.
• Managing Logins and Security.
• Daily Health Check of all production servers (120+).
• Database Backup and Restoration.( Lite-Speed & Native Backup)
• Importing, Exporting Data, Shrinking Database.
• Transfer Login, users between Database Servers.
• Implementing Log-Shipping between Primary Server and DR Server.
• Generate Script for Different Objects of the Database.
• Maintain database consistency check using DBCC commands.
• Preparing documentation on Database Growth
• Monitoring Replication using Replication Monitor.