SUMMARY

• A full - fledged Information Technology professional with 12 years of experience in Application and Product development, testing and implementation of web/client-server applications and this includes 9 years with SQL Server DBA to meet a varied range of organizational and user requirements.
• Installation, Configuration of SQL Server 2000/20 R2/2012/2014 and 2016 on Local System and Remote System.
• Experience with Installations, Configuring SSRS and SSIS.
• Experience in performing Migration and Upgrades from and, 2012 and 2014. In-place upgrades process and as well as side-by-side upgrades process.
• Monitoring SQL server performance using profiler, perfmon and tuning adviser to determine the most effective way to increase performance.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in DB and to minimize false alarms as well.
• Expertise in handling huge databases ranging from GB’s to TB’s in size (Maximum 19 TB)
• Successfully implemented High-Availability solutions on MS SQL Server 2000/20 /2014 by using Clusters environment.
• Experience inCassandraDatabase Configurations
• Expertise in DR Solutions using Database cluster/Log shipping/Mirroring/Replication and Always on.
• Managing split teams and coordinating multi-site Support Teams across the globe to work effectively & cohesively and deliver the expected results.
• Good experience in Gathering and Analyzing Business Requirements to deploy database change scripts provided by customers and third party vendors.
• Experience on Always-on with SQL Server 2012 and 2014
• Having knowledge on Azure and AWS.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS)
• Experience in scheduling maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, Tracing long running/deadlock queries, Capacity planning, Monitoring and tuning Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance etc.
• Hands on experience in Installation of SQL Server 2014/2 /2000 Service packs and vulnerability fixes.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Expertise in implementing Database Security Policies and Best Practices, and documenting Standard Operating Procedures, company's database environment.
• Have received appreciation awards from the client and the organization.
• Always ensure to meet the business Recovery Time Objectives (RTO) / Recovery Point Objectives (RPO)
• Involved in all ITIL process like Change management, Incident Management & Problem Management
• Delegating and assigning tasks to the DBA team, both onsite and offshore, while guiding and monitoring them.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2 /2000, Cassandra, Oracle

Operating Systems: Windows NT, Win 2000, Windows 2012/2008/2003 Server.

Languages: TSQL, JAVA, J2EE

Web related: HTML, XML, XSL, JSP, JDBC, Java Script, AJAX, .NET, XAML

Tools: DBSPI, SSMS, MS Office, Eclipse, Edit plus, WSAD 6.0,HPSMRemedy, SQLdiag

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

Lead SQL Server DBA

Responsibilities:

• Providing 24/7 On-Call supports for critical production databases.
• Experience in installing, managing and troubleshooting SQL Server 2014, 2012, 2008R2
• Installed and Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2012 server cluster.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Migrated SQL server 2008 R2 to SQL Server 2012 and SQL server .
• Creating Jobs and Schedule them for execution on Daily, Weekly, and Monthly bases.
• Checking the SQL Error logs for any errors that may have occurred overnight.
• Checking available physical Disk space, Log Space, jobs for failed completion, backups and log sizes
• Setup and Configuration of Always-On Availability Groups (AAG) and HA/DR
• Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards.
• Taking care of the Backups and Restoration Tasks of databases in 16-19 TB’s with multiple files and file groups
• Handled large team as a team lead.
• Supported high available technologies like clustering and Always-on and resolved critical issues.
• Resolving Database Failures, Physical Server Failures and SQL Server Service Failures
• Created linked server from SQL environment to other environments like oracle environment.
• Continuously monitoring and updating Backup and Recovery strategy to recover data based on requirements.
• Configuring, Deploying and Migrating SSRS reports / SSIS.
• Performing the root cause analysis of production issues.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Environment: Windows 2012/2008/2003/2000, VMware, MS-SQL Server 2014/2012/2008 R2/2005.

Confidential

SQL Server DBA

Responsibilities:

• Responsible for handling the Production & Staging Environment.
• Taking care of the Backups and Restoration Tasks of databases in large size with multiple files and file groups
• Preparing documents for disaster Recovery and perform disaster recovery exercise once in a Year.
• Drafting documents for Jobs, Replication, Server Capacity, Database Size, etc.
• Performing the root cause analysis of production issues.
• Performing Weekly Maintenance of SQL Servers
• Database refreshing test environment with the production database backup
• Perform Capacity Planning & utilization
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services(SSIS).
• Preparing the schedule for the maintenance job of various events.
• Configuring and monitoring of Mirroring, Log shipping.
• Assisting the Programmers for optimizing SQL queries.
• Coordinating service pack updates on SQL DB Servers on test and production environments
• Monitoring health of the database server and checking error log or event log for database errors.
• Managing new database objects including tables, indexes, SQL queries, & stored procedures for data manipulation.

Environment: Windows server 2003/2008/2008 R2, MS SQL Server 2008R 2/2008/2005/2000, Cassandra

Confidential

SQL Server DBA

Responsibilities:

• Responsible for handling the Production & Staging Environment.
• Taking care of the Backups and Restoration Tasks of databases in 8-9 TB’s with multiple files and file groups
• Preparing documents for disaster Recovery and perform disaster recovery exercise once in a Year.
• Perform Capacity Planning & utilization
• Preparing the schedule for the maintenance job of various events.
• Ensuring the automation of monitoring MS-SQL Server.
• Assisting the Programmers for optimizing SQL queries.
• Database refreshing test environment with the production database backup
• Coordinating service pack updates on SQL DB Servers on test and production environments
• Monitoring health of the database server and checking error log or event log for database errors.
• Managing new database objects including tables, indexes, SQL queries, & stored procedures for data manipulation.
• Drafting documents for Jobs, Replication, Server Capacity, Database Size, etc.
• Performing the root cause analysis of production issues.
• Performing Weekly Maintenance of SQL Servers

Environment: Windows 2003/2008 server, MS SQL Server 2000/2005/2008, MS Access, T-SQL, MS Excel.

Confidential

Database Administrator

Responsibilities:

• Database Backup’s and consistency checks using DBCC.
• Setting Configuration parameters and Managing Space for Data and Logs.
• Optimization of the server for high performance.
• Monitoring and creating threshold for Disk usage, user connections, Log Backup and Restoration of Data base
• Trouble shooting on user requests.
• Performing the root cause analysis of production issues.
• Performing weekly Maintenance of SQL Servers
• Database refreshing test environment with the production database backup
• Preparing the schedule for the maintenance job of various events.
• Configuration of Standby servers, implementing and Troubleshoot Log Shipping.
• Worked on Creating logins and providing Permissions to user.
• Used DBCC Commands for to improve the performance and integrity of the database.

Environment: SQL Server 2000/2005, T-SQL, Windows Server 2000/2003.

Confidential

Programmer

Responsibilities:

• Develop code complying with coding standards defined by technical management.
• Assist with encoding, testing, debugging, and documenting program modules
• Analysis of the specifications provided by the clients
• Develop new subroutines or expand program to simplify statement, programming or coding of future problems.
• Database maintenance
• Prepare required documents including code-level and user-level documentation.
• Ensuring speedy resolution of queries & grievances to maximize client satisfaction levels.
• Maintaining excellent relations with clients to generate avenues for additional business.

Environment: Java, J2EE, Eclipse, Oracle 8i, Windows XP.

Confidential

Team Member

Responsibilities:

• Assist with encoding, testing, debugging, and documenting program modules and Database maintenance
• Prepare required documents including code-level and user-level documentation.
• Analysis of the specifications provided by the clients
• Ensuring speedy resolution of queries & grievances to maximize client satisfaction levels.
• On time deliverables based on requirements.

Environment: Java, J2EE, Eclipse, Oracle 8i, Windows XP.