Suresh acza7o@r.postjobfree.com

SQL SERVER DBA 510-***-****

CAREER SUMMARY

6+ Years of experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development, Staging, Data Warehouse environments.

Hands-on experience with Installation/Configuration, Managing and Troubleshooting of MS SQL Server 2016/2014/2012/2008 R2/2008/2005 on Windows Server 2012 R2/2008/2003.

Hand-On experience of multiple Nodes on Cluster Environments.

Setting up and monitored Disaster Recovery environments like Database Mirroring with in the Primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.

Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Created Database Snapshots on Mirror Databases for generating the reports for business crew members and worked with Linked Servers.

Data Migration between different environments and third party databases.

Configured and monitored Replication for Reporting purpose.

Troubleshooting Mirroring, Log shipping and replication synchronization issues.

Troubleshooting Application and Backup jobs.

Hands-On Upgrade of SSIS Packages.

Working knowledge in Reporting Services (SSRS).

Good knowledge in using DMVs and DMFs in resolving Performance Issues.

Experience in providing Logging by using Event Handler for SSIS Packages.

Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, analyzing the Execution Plan and Index Management for better Query Optimization.

Experienced working on SQL Servers Virtual Environments.

Experience in scheduling Backups and Restore and Maintenance plans using Native & Third-party tools.

Experience in T-SQL Development skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Queries.

Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster Recovery Procedures in Database Management Prod Guide.

Daily routine DBA tasks like handling user’s permissions and space issues on production and semi production Server’s and handling maintenance jobs.

TECHNICAL SKILLS

Databases : MS-SQL Server 2016/2014/2012/2008/2005.

Languages : T-SQL.

SQL Server Tools : Index Tuning Wizard, Database Tuning Wizard, Export & Import.

Backup Tools : SQL Native, CommVault.

Performance Tools : Perfmon, SQL Profiler.

Operating systems : Windows Server 2012R2/2008/2003/2000, UNIX.

Software Packages : MS Office 2003, 2007, Visio.

Monitoring Tools : SQL Sentry, Red Gate

Education

Bachelor of Technology from JNTU University, India

70-462: Certified Administering Microsoft SQL Server 2012/2014 Databases

PROFESSIONAL EXPERIENCE

Envestnet Yodlee, Redwood City, CA July 16 - Present

Sr. SQL DBA

Responsibilities:

Working as a support lead by managing off-shore team.

Installed and administered SQL Server 2016/2014/2012.

Migration SQL 2008R2 to 2016.

Involved in Capacity Management and Analysis at hardware of the SQL Server including CPU, Memory and Storage.

Implemented High Availability strategies like AlwaysOn, Database Mirroring, Clustering Replication and Log Shipping.

Managed Cluster environment in both Active/Active and Active/Passive.

Performed routine maintenance activity, performance tuning.

Migrating SQL Database to Azure.

Implemented Secure Operation like Backup Policy, Strong Passwords, cross database ownership changing, disabling XP_CMDSHELL etc.

Backup and restoring databases from production to Development for testing.

Involved in performance tuning with stored procedure and T-SQL having high response time.

Designed and implemented comprehensive Backup plans and disaster recovery strategies.

Applying patched and hot fixes.

Written Scripts using DMV, Views in SQL Server for troubleshooting indexes, performance tuning and instance health check activities.

Documenting the standard procedure on regular basis.

Responsible for query optimization using SQL tools such as SSMS, SQL Profiler and index tuning wizard.

Maintaining the database consistency with DBCC at regular intervals.

Monitoring DB Servers, Instances and Clusters with custom scripts\ jobs.

Responsible for securing SQL Server, user management, and taking care of permissions and roles

Automated operational metrics processes using SQL Server jobs.

Work with installation, configuration and creation of SSRS.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2008, T-SQL, SSIS, SSRS, Power Shell, SQL Agent, SQL Profiler, Azure, Red Gate, Windows 2012 R2/2008/2003 server, Visual Studio 2008/2012, MS Visual Studio 2012, SQL Sentry.

Tufts Health Plan, Watertown, MA Jan 14 to June 16

Sr. SQL Server DBA\Developer

Responsibilities:

Build new SQL Servers and updated with latest service packs and cumulative patches (hot fixes) for SQL Server 2016/2014/2012/2008.

Building new SQL Servers in multi node cluster environments VMware/ Physical environments.

Troubleshooting the Disk failures in a Cluster Environment.

Configured and Managing AlwaysOn High Availability on 3 node cluster environment.

Migrated SQL Server 2008R2 databases to SQL server 2014 by using Backup-Restore and Management Studio Wizards and custom scripts.

Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment.

Upgrade/Migration SQL SERVERS 2008R2 to 2016.

Prepared Documentation for the Disaster Recovery plan.

Managing Databases spread across multiple servers in Production, Development, staging & testing environments.

Created complex stored Procedures, Triggers, Tables using T-SQL.

Troubleshoot Performance issues causing Application slow.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source Excel Spreadsheet to SQL Server.

Created SSIS jobs and scheduled Packages using SQL Server Management Studio.

Hands-On monitoring SQL Servers using SQL Sentry.

Monitor Database consistency and health using DBCC Commands and DMVS.

Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).

Created Linked servers for distributed queries.

Hands-On Replication set-up and troubleshooting.

Created and deployed reports using SQL Server Reporting Services (SSRS).

Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, T-SQL, SSIS, SSRS, Power Shell, SQL Agent, MS Azure, SQL Profiler, Red Gate, Windows 2012 R2/2008/2003 server, Visual Studio 2008/2012, MS Visual Studio 2012, SQL Sentry.

Keltron, Kerala, India Dec 10 – Dec 13

SQL Server DBA

Responsibilities:

Troubleshooting member firms issues related to Audit application.

Responsible for supporting over 150 SQL instances which include SQL 2012/2008/2005.

Migrated Databases from SQL Server 2005 to Server 2012 in Production and test Environments.

Performing the BCP tests of SQL servers as a backup plan strategy as per the requirement.

Performing the Server QA on SQL Server and configuring the SQL Server as per the standards.

Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).

Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.

Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.

Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

Expertise in enhancing and deploying the SSIS Packages from development server to production server.

Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics

Backup and Recovery of Production Databases and Tuning them for better Performance.

Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.

Used SQL Sentry to check the blockings, TOP SQL, and memory issues and DISK I/O issues.

Worked on high availability SQL Server solutions using Mirroring and Log shipping.

Upgrade databases from SQL Server 2005/2008R2.

Created Linked servers for distributed queries.

Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.

Configured database mail to inform corresponding DBA basis on each Job Status.

Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, and Performance Analysis.

Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.

Performed Backup and recovery & Automation of Backups using maintenance plans.

Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.

Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.

Environment: MS SQL Server 2012/2008 R2/2008/2005/2000, T-SQL, SSIS, SQL Agent, SQL Profiler, Sentry, Windows 2008/2003/2000 server, Visual Studio 2008/2012, Red Gate, MS Visual Studio 2012.

Contact this candidate