Sql Server Microsoft Office

PASUMARTHY RAVI KUMAR

603-***-**** **************@*****.***

PROFESSIONAL SUMMARY

Almost Nine year of experience performing various jobs as a SQL Server database administrator. Have an extensive and exhaustive experience in providing day-to-day support which included issue resolution, backup and restoration, high availability techniques, user management, monitoring, performance tuning and documentation.

Extensive experience in working on both OLTP and OLAP environments.

Worked on multiple editions of Microsoft SQL Server including 2005, 2008, 2008 R2,2012, 2014 and 2016.

Hands-on experience in planning, installation and configuring of the above-mentioned editions with service packs and security patches.

Installation included planning and engendering collation, editions, licensing and service accounts.

Extensive experience on Always-On High Availability groups on SQL Server 2012 and 2014.

Experience in installing and managing virtual environments on VMWare running on ESX servers and interfaced using PowerCLI.

Also, performed migrations (both In-Place and Side-by-Side) from MS SQL Server 2005 to 2008, 2008 R2 to 2012, 2008 to 2012 and 2012 to 2014 respectively.

Also, performed installation of third party application from vendors like Red Gate, SQL Sentry, Idera, SQL Lite and several Microsoft native applications such as Log Parser, (Replay Markup Language) RML Utilities and Performance Dashboard Reports.

Also, designed database schemas, databases, normalized, established data types in an assistive capacity.

Used T-SQL extensively in my day-to-day operations to create views, stored procedures, functions, rules, constraints, tables, indexes, and to write simple and complex queries.

Experienced in managing 125 (VLDB) Very Large Databases with multiple instances spread across multiple locations. A few of these databases exceeded 1 terabyte of data.

Hands-on experience in creating backup and recovery plans, implementing them and periodically testing them.

Vast experience in taking backups on a regular basis Adept in all three types of backups, restorations and database transfer processes as per the maintenance plans.

Experience in installing and managing many High-Availability options such as Log Shipping, Database Mirroring, Replication, Clustering and Always-On.

Performed database Log-Shipping, Database Mirroring, Clustering and Always-On installation, maintenance and monitoring on various instances and databases on several machines.

Have extensive experience in authenticating, authorizing and auditing security tasks as per the security model of the organization. Authenticating involved setting user accounts, user group and roles. Authorization involved delegating ownership with roles and permissions to various securable objects. And Auditing involved ensuring compliance to laws and regulations. Security also involved data encryption at various levels and row-level security.

Proficient in many tools, including Management Studio, Enterprise Manager, Query Analyzer, SQL Server Agent, SQL Server Profiler, SSRS and SSIS.

Have vast experience is query and issue resolution and troubleshooting on a daily basis using both ticketing tool like Peregrine, mail and via issue escalation.

Have been actively doing performance monitoring and tuning using both native applications and third party applications. Adept at optimizing instance and database and tracking Memory pressure, Disk space and CPU usage. Monitoring windows events and transaction logs. Manage and maintain indexes, Databases I/O information. Monitoring Execution plan for current running queries. Locking, blocking, estimated execution plan, Actual execution plan and troubleshoot performance issue.

Acquainted with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and Agile methodologies including SCRUM and Sprints.

Hands on experience in creating various reports including drill through and drill down, Charts, Sub Reports and, Matrix reports on SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Have also worked handsomely on Bulk Copy Program utility, PowerShell, SQL and SQL command line utility.

Experienced in identifying memory bottlenecks and I/O, blocks and deadlocks caused by very complex queries using SQL Server Activity monitor and profiler, Dynamic Management Views (DMVs) and handling them by improving Query Execution plans.

Worked in a team-oriented, collaborative environment. Demonstrated ability to successfully manage, lead, and inspire a team of technical professionals.

Exhaustive experience in providing 24X7 on call support and troubleshooting in both stage and production environments.

EDUCATION

Masters in Information Technology

Southern New Hampshire University – Manchester, NH 2016

Bachelor in Computer Science 1997

Osmania University - Hyderabad, India

Databases:

Microsoft SQL Server 2005, 2008, 2012, 2014 and 2016, MS Access.

Programming:

SQL PowerShell, C#, HTML

Operating System

Windows 95, NT, 7, 8, 10, 2003, 2008 and 2012.

Database Tools:

SQL Server 2005 Best Practice Analyzer, Data Transformation Service, SQL profiler, SQL Query Analyzer, Index Analyzer and Tuning Wizard, Performance Monitor, SQL Server, Management Studio, Data Protection Manager and SSDT, Volume Shadow Copy.

Applications:

Microsoft Office Suite (all applications) including Excel, Visio and Project.

Third party tools:

Red Gate, SQL Sentry, IDERA, LiteSpeed SQL Compare and Net backup.

WORK EXPERIENCE

Georgia State Dept. of Transportation, Atlanta, GA October, 2016 March 15, 2017

Senior Database Administrator

Responsibilities:

Provided primary database administrator 24X7 support in both stage and production environments.

Installed and configured MS SQL Server 2008 R2/2012/2014/2016 on new production and test servers.

Practical experience in Microsoft SQL Server Clustering. Experience in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server. Managed and maintained three node Active passive cluster.

Configured and Maintained Always-ON in 2012 on Virtual machine.

Also, updated with the latest security updates including service packs and security patches.

Monitored database for size and disk space in production, staging & development environments.

Performed database optimization and tuning to increase query and database performance.

Used execution plans to tune stored procedures.

Created, modified tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database maintenance environment:

Improved database performance issues by creating the missing indexes including ColumnStore indexes, updating statistics, identifying fragmentation and rebuilding and reorganizing indexes.

Responsible for the management of the database’s performance, backup, replication, capacity and security.

Installed and maintained SQL Server Reporting Services (SSRS) that supports Analytics application and reporting applications.

Used extended events, server side traces and Profiler for monitoring the events in Microsoft SQL Server Instances.

Created packages and Jobs for sending alerts using SQL mail, database, backup, Recovery and Disaster Recovery procedures. Planned and implemented the complete Backup of various Databases for Disaster recovery scenarios

Involved in migration and documentation of MySQL from SQL Server 2012 to SQL Server 2016.

Created the Backend validations using Insert/Update and Delete triggers. Created various views for generating reports

Developed, monitored and deployed SSIS packages.

Proficient in optimization of T- SQL procedures, removing the deadlocks and Client/Server. Connectivity and finding and solving locks and deadlocks by using DMV's and DBCC commands.

Created and used Tables, Views, Indexes, Stored Procedure and Triggers.

Generated every quarter reports and deployed them on to server.

Using Reporting Services built effective queries for high-performance reporting and rendered them in various formats such as HTML, XML, PDF and Excel formats.

Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).

Performed manual backup as needed and restored database from backup file server. Troubleshot backup jobs failed issues.

Used DBCC and DMV to check database health/resource.

ENVIRONMENT: MS SQL Server 2008/2012/2014/2016 (Standard, Enterprise Editions), MS SQL Server Reporting Services 2008, Data Quality Services, Windows 2008 R2 Server, Windows Power shell, WinSCP, MS Visual Studio 2010, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Database Maintenance Plan Wizard, Reporting Services Configuration Services.

SUN Life Insurance, Hyderabad, India 08/2012 08/2015

Senior Database Administrator

Responsibilities:

With a team of 5 developers installed, deployed and supported over 800 SQL Servers, some of which were on VMWare with over 300 of those servers being mission critical databases across multiple geographic areas.

The VMWare was installed on ESX server and managed using PowerCLI from PowerShell.

Successfully tested and deployed SQL Servers 2012with availability group with three replicas as part of Always-On solution. The High-Availability solution was installed on one active node and two passive node clusters on 2008 2012 Servers.

Well versed in concepts of HA/DR setup and configurations. Identified flaws with DR Strategies and offered suggestions of improvement

Performed Database Backup, Recovery, and Transfer operations.

Used Quest’s Litespeed 6.1.0 for backup and compression.

Used SSIS to extract, transform and consolidate data from different sources into Data Warehouse.

Monitored Connections, Locks and Performance of SQL Server.

Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Used Shell and Perl scripts to transfer data from Sybase to text files for reporting.

Worked with popular monitoring solution like Quest Foglight, SQL Sentry to tune SQL Server Databases.

Hands on experience in troubleshooting and fine-tuning of databases for its performance and concurrency.

Also, performed log shipping as a warm backup solution on a few nodes

Performed Quality Assurance on new installations and updates

Troubleshot performance issue as and when they arose using ticketing system using BMC Remedy application for creating and tracking ticket and on floor Tech Support team for resolution.

Coordinated with the support of DBA’s from different locations and provided support 24X7 and coordinated disaster recover drill on a regular basis.

Using automation tool monitored alerts, notifications and jobs to ensure all jobs ran successfully.

Responsible for monitoring and performance improvement in hosted databases. This role involved index maintenance (creation, removal and modification), file group modifications, adding scheduled jobs to re-index and update statistics in databases.

Managed users which included creating/alteration grant of system/database roles and permission on various database objects.

Defined, developed, and implemented automated batch process according customer requirements. Monitored Notifications, Jobs and Alerts to make sure all jobs run successfully.

Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and Stored Procedures.

Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Experienced in using SQL Server Profiler, Windows Performance Monitor for Performance Tuning and Query Optimization, database consistency checks using DBCC utilities and DMVs.

Prepared the reports for the day-to-day as well as weekly/monthly purposes.

ENVIRONMENT: MS SQL server 2016/2014/2012/2008 R2/2005, Windows 2012/2008/2003 Enterprise edition, Active Directory service, Beyond Compare 3, PowerShell, Winscp, Windows job schedule (Robocopy), Windows Batch file

GE Money Services –Hyderabad, India 08/2007 07/2012

Database Administrator

Responsibilities:

Installed and configured 2012 SQL Server Enterprise and Standard Editions in cluster environment.

Migrated the entire production database from SQL Server 2008 to SQL Server 2012.

Was part of data modeling team and reengineering team and assisted in making databases more compliant to SLA and make them forward and backward compatible using SQL Server Data Diagram.

Managed schema objects including tables, indexes, views, procedures and triggers to enforce referential integrity as per the SLA

Was also part of analysis and development of backup and disaster recovery plans.

Performed scheduled backups (both transactional and log) as per the database maintenance plan in live production environments regularly.

As part of the High-Availability solution, configured database mirroring, replication and log-shopping for disaster recovery scenarios.

As an administrator, created, dropped and revoked user logins within the appropriate roles, created workgroups, monitored user accounts and managed privileges to groups and users.

Also, automated various jobs including taking backups and verifying them, monitoring database’s health by following various counters and parameters and disk space and notification mechanisms in case of exceptions or errors.

Automated daily monitoring and administrative tasks which included tracking rogue transactions, space management and utilization, database status checks, logs, filegroups, extents, checkpoints, locks and deadlocks.

Also, religiously followed system monitor to look for hardware bottlenecks factors such as CPU counters, Input/Output, memory counters various logs including error logs and job history logs.

Relied heavily on Database Tuning Advisor, SQL Profiler and Execution Plans for this.

To improve performance also undertook various performance tuning measures such as creating, monitoring, modifying, rebuilding and reorganizing Indexes (both Clustered and Non-Clustered), Views, Constraints (both Unique and Check) etc.

Assisted in ETL processes to export and import data from multiple sources as well.

ENVIRONMENT: Microsoft Office Suite, MS SQL Server 2008 and 2012, PL/SQL, SSIS, SSRS, Windows 2008, Database Tuning Advisor, SQL Profiler, Red Gate and IDERA.

Global Information Systems – Hyderabad, India 01/2007 07/2007

Junior Database Administrator

Responsibilities:

Initial responsibilities included assisting with installation of SQL Server 2005 with the service packs, logical modeling and physical designing and creating databases in assistive capacity.

Maintained databases, including indexes and perform index analysis, re-indexing and updating statistics.

Implemented and maintained database security, roles, users, logins and permissions at object level.

Performed performance tuning, query optimization using Perfmon profiler on objects in assistive capacity as well.

Monitored event log files, transaction log backups and alerts from previous and current day for any warnings and errors.

Monitored SQL Server agent jobs, alerts, triggers, security policy for violations and system resources for any imminent risks and act accordingly.

Compared performance levels of system against the baselines, performed audits and assist in plans and projections. This task primarily involved checking disk space regularly, capacity planning, monitoring activity, data verification, organizing storage and executing stored procedures, functions and DMO’s.

If any errors were found inform senior database administrator and take immediate action.

Took full database backups regularly, once a week. Take cold/hot backups on ad-hoc basis.

Performed data migration from Microsoft Access to SQL Server database.

Attended the user calls and provided solutions to their problems.

Maintained Log Activity Report and reported everything to Senior Database Administrator.

Worked on SQL Server 2005, Log Parser and SQL Spy among others in assistive capacity.

Did database documentation which included data definition of all data including metadata, data procedure and standards.

ENVIRONMENT: Microsoft Office Suite, MS SQL Server 2005, PL/SQL SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS), Visual FoxPro and dBase.

Contact this candidate