SUMMARY:

• 6.2 years of IT experience as a Microsoft SQL Server Database Administrator in organizations like Confidential, USA and Confidential Consulting India . Worked in all the major releases starting late SQL 2000 till latest 2016.
• Performed and created runbooks for SQL Server and service pack installation.
• Have experience on Database Mirroring, Log Shipping, Failover Cluster and Always - ON cluster high availabilities.
• Have knowledge on Database security, Backup/Restore & Backup compression.
• Handled Disaster recovery, Query tuning and Performance tuning activities.
• Performed SQL Server upgrade and migration activity from lower to higher version of SQL.
• Have hands on in handling issues regarding reporting services (SSRS) and integration services (SSIS).
• Configured and installed Reporting services (SSRS).
• Prepared memory consumption, database growth, disk & CPU utilization reports for SQL Instances.
• Provided SQL best practice recommendations and requirements to application team.
• Automated daily monitoring of SQL Instances via batch file on SQLcmd.
• Experience to handle TCP/IP port and ODBC connectivity issues.
• Done database resource control with resource governor.
• Done Organizational training in SQL Server 2012 by an experienced external trainer.
• Excellent analytical and problem solving skills, can adapt to new technologies quickly.
• Strong interpersonal and communication skills.
• Valued contributor who performs confidently, team oriented and a quick learner.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005.

SQL Editions: Enterprise, Standard, Evaluation, Express

ETL & REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Database Tools: SQL profiler, SQL Query Analyzer, SQL Server Management Studio, Performance monitor, DTA, SQL activity monitor

Third Party Tools: Foglight database monitoring tool, Veritas Netbackup tool, SM9 (ITSM), System Passport Efecte tool (CMDB), BMC Patrol/SCOM (Monitoring tool).

Languages: T-SQL

Operating Systems: Microsoft Windows 2000, 2003, 2008 R2 Standard & 2010

Automation tool: SQL CMD

PROFESSIONAL EXPERIENCE:

Confidential, DEs plaines, IL

SQL DBA

Responsibilities:

• Setup Backup policies as per Microsoft best practices.
• Suggest and Setup mandatory Maintenance jobs for SQL databases.
• Done SQL standalone and feature installation.
• Configure database mails for getting database status on regular intervals.
• Handling Database Migration activity to configure a clone database server for DR purposes.
• Setup Logshipping High Availability between two DR servers.
• Created Database runbooks for DR activities and Backup/Restore.
• Configure SSIS packages and setup mail task for package success and failure.
• Documented procedural document for handling SQL server slow performance issue.

Confidential

SQL Server DBA| Database Engineer

Responsibilities:

• Contributed in Knowledge transition and go live for this project. Went to Onsite for Knowledge Transition to SA and Helsinki. Supported 45 different clients for SQL administration.
• Did Installation, Upgradation of SQL Instances.
• Setup, Monitoring and troubleshooting of routine maintenance jobs (Backup/Restore, Indexing, Database Consistency Checks, batch jobs) with SQL Server Best Practices
• Worked on incidents, CMT’s and Problem tickets.
• Handled Cluster, Hyper V cluster environment, always on clustered environment
• Worked on backup failure, disk space issues and DR activities.
• Done backup restore, DB refresh activities, security setup.
• Moved Tempdb files to other locations
• Created new database, Login and users.
• Handled install/uninstall, SSRS connectivity and OLEDB connection issues.
• Resolved disk space issues due to tempdb full and mdf size increase.
• Done SSRS installation, configuration, report creation and reports deployment.
• Performed automated daily monitoring checks through powershell scripting and through SQL CMD.
• Prepared capacity, memory and CPU utilization reports for SQL environment servers.

Confidential

SQL Server DBA

Responsibilities:

• Administered around 30 SQL Server cluster instances, logshipping instances with in cluster environment, 4 always on cluster instances and 20 standalone DB’s.
• Did installation and configuration of 2 node and 3 node cluster.
• Performed upgrade/downgrade of SQL instances.
• Setup Logshipping in SQL 2012 environment.
• Did DR activities with application team.
• Provided Consulting for Database Performance Tuning and used tools like Data Tuning Advisor and Profiler.
• Managed Databases using Maintenance Plan, integrity Checks, Backup (Full, Differential, Log)
• Troubleshooted for Locking, Blocking and Deadlocks.
• Performed database restore through netbackup tool.
• Worked on security issues.

Confidential

SQL DBA

Responsibilities:

• Configured Database Mirroring and Logshipping.
• Setup SQL server reporting service.
• Propose and setup Backup strategy via maintenance plans.
• Done Database performance tuning.
• Propose solution to Data transfer to DR site.
• Worked on implementing Disaster Recovery strategy as per the requested SLAs.
• Creating/Maintaining/Troubleshooting SQL agent jobs in Production.
• Created SQL Server Installation runbooks and instruction for DR strategy in HA environment.

Confidential

SQL Server DBA

Responsibilities:

• Performed Backup/restore of SQL Server Databases.
• Created Jobs to perform preschedule SQL activities.
• Created Indexes for optimal performance of SQL Server.
• Rebuilded /reorganized the Indexes.
• Did performance tuning through SQL Profiler.
• Worked on Fragmentation removal under large tables.
• Worked on missing indexes.
• Moved datafiles and logfiles on to the new location.
• Did capacity handling on SQL Server disk drives.
• Maintained SQL Server performance weekly status report.

Confidential

SQL DBA

Responsibilities:

• Implemented a standard model of SQL Server Install process with defined process of keeping standards defined by Microsoft.
• Upgraded servers from SQL 2005 to SQL 2014 and Migrated databases from lower version to upper with all the related server objects (linked servers, logins, dB components smoothly).
• Worked on High Available solution (Logshipping/ Mirroring).
• Planning efficiently to patch servers in complex Always On and Cluster scenarios
• Worked on various performance tuning projects where the reports taking more time to execute. Reviewing execution plans, creating/removing index/stats and instructing developer to change script logic solved ease many situations

Confidential

SQL DBA| Database Engineer

Responsibilities:

• Administered around 250 SQL Server databases ranging upto 120 GB in size.
• Worked on Peregrene ticketing tool that was the part of incident management.
• Managed RFC’s that was the Change management utility.
• Did monitoring through Foglight monitoring tool.
• Performed Installation and Upgradation,
• Performed backup and restore of databases.
• Did other activities likes Monitoring database, checking error logs, checking the log file size and free space in the data drives and connectivity of databases.
• Implemented & troubleshooted High Availability solution (LogShipping and Mirroring) for SQL.
• Maintained Security of databases to restrict access to critical data for common users.
• Did Capacity and Storage planning for future storage requirements.
• Worked on User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Monitored all the Scheduled jobs and solving any issues related to failed jobs.