SENTHIL KUMAR M N

acy9z7@r.postjobfree.com

914-***-****

INTRODUCTION & OBJECTIVE

I am currently working as a Senior SQL Server DBA. I have 11+ years’ experience in Database Administration along with strong experience in areas like T-SQL Programming, Data Modelling (ERWin), Data warehousing & Business Intelligence (SSIS/SSRS). I am looking for new opportunity to work on similar tools and techniques and it may also include Data Quality, Data Analytics, Cloud (AWS/Azure) and NoSQL areas to explore/learn and implement.

PROFILE SUMMARY

16+ years of experience in IT Industry that include 11+ years of experience as SQL Server DBA in versions ranging from SQL Server 2000 to 2014.

MCSA (70-462) on Administering Microsoft SQL Server 2012 Databases (certified by Microsoft) part of MCDBA.

Extensive experience (5+ years) in Database Development (Design and Implementation) using Transact SQL.

Extensive experience (3+ years) in Data Modelling with ERWin.

2+ Years of experience in Data Warehousing and Business Intelligence using SSIS, SSRS and SSAS along with Scripting using Powershell.

1+ Years of experience in building and managing SQL Server on Private Cloud with VMware vCloud,

4+ years Onsite experience worked at Cincinnati, OH, USA.

Holding H1-B Visa valid till August 2017 and currently residing in Richmond, VA, USA.

COMPUTER LITERACY

Databases : Sql Server 2008 R2/2012/2014/2016, Oracle 8.0, MS Access.

Cloud Technologies : Public Cloud with SQL Azure, Amazon RDS for SQL Server (AWS).

Scripting : Windows Powershell 3.0

Data Warehousing : SSIS (SQL Server Integration Services), Informatica, & ETL Concepts.

Business Intelligence : SSRS (SQL Server Reporting Services), Cognos, Business Objects.

Data Analytics : SSAS (SQL Server Analysis Services).

Data Modelling : CA ERWin, Relational & Dimensional Modelling Concepts.

SQL Tools : SQL Sentry Plan Explorer, Atlantis schema inspector, RML Utilities, MAP,

Idera SQLSafe, Idera Diagnostics Manager.

Change Mgmt./Incident Mgmt : Infra/VMWare Service Manager, ChangeGear.

Version Control : Microsoft Visual SourceSafe, Microsoft Team Foundation Server (TFS)

Virtualization : VMWare ESXi.

ERP : Logistics, HR, Maintenance Mgmt. Functionalities & ERP Dev.Framework.

Operating System : Windows NT/2000/XP/2003/2008/2012.

GUIs : Visual Basic 6.0, VB.Net, Foxpro 2.6, Developer 2000.

Office Tools : Microsoft Office 2007/2013, Microsoft Visio 2013, Microsoft Project.

Concepts : Data Profiling, Data Quality, Data Cleansing, NoSQL/Big Data,

Agile Methodology (&Scrum), Massively Parallel Processing (MPP).

EDUCATION

MCA (Master of Computer Applications), Bharathidasan University, Trichy, India.

ADPM (Advanced Diploma in Project Management), Alagappa University, Karaikudi, India.

PROJECT PROFILE

Role : Senior SQL Server Database Administrator (DBA)

Duration : Oct. 2016 - Till Date

Client : Virginia Premier Health Plan Inc., USA.

Project Site : Richmond, VA, USA.

Job Duties:

Recommended Disaster Recovery approach and derived DR strategy. Also, tested the same.

Performed detailed analysis of data warehouse environment infrastructure and ETL packages and provided detailed recommendations for Infrastructure tuning and ETL packages tuning.

Developed Backup SLA report to ensure backups are in place.

Implemented custom update statistics based on level of modification and also implemented Index maintenance automation.

Developed Security Audit SLA report generation mechanism and implemented the same. Proposed new approach for security architecture of the organization based on industry best practices.

Optimized various Queries by implementing indexes using Execution Plan Analysis.

Tuned Server/DB/Application Performance by analyzing various metrics gathered using Performance Monitor, Data Collector, Who-Is-Active table data and by implementing industry best practices.

Role : Lead SQL Server Database Administrator (DBA)

Duration : Nov. 2011 - Apr. 2016

Client : The Kroger Company, USA.

Employer : Computer Sciences Corporation (CSC).

Project Site : Cincinnati, OH, USA.

Job Duties:

Implemented Disaster Recovery using Database Mirroring, Log Shipping based on Recovery Time Objective (RTO) and managed AlwaysON Availability Group setup.

Configured Data Protection (Backup) onto Tape based on Recovery Point Object (RPO). Occasionally base lined backups were required during code deployments or during application version releases.

Implemented High availability by building SQL Server Failover Cluster.

Performed In-depth analysis using various metrics and provided Capacity Planning proposals.

Provided various Architecture Recommendations with its Pros & Cons against each new database Infrastructure requirement.

Used Powershell scripts while developing SLA reports to automate database monitoring

Optimized various Queries by implementing indexes using Execution Plan Analysis.

Tuned Server/DB/Application Performance by analyzing various metrics gathered using Performance Monitor, Data Collector, Who-Is-Active table data.

Implemented Database Encryption and Data Encryption for multiple Sarbanes Oxley (SOX) / PCI / HIPAA compliance applications.

Resolved Blocking / Deadlock issues, Abnormal Log growth Issues, Abnormal TempDB growth issues multiple times on emergency basis.

Resolved critical performance issues on emergency basis.

Reviewed Steps/Runbook that was prepared by offshore members against any major task.

Conducted weekly meetings and KT sessions with offshore members

Reported Work Load Forecasting & Project Status Details periodically to Client IT Manager(s) with proper documentation as the contract falls under Fixed Bid Outsourcing Model.

Implemented and managed Snapshot and Transactional Replication.

Accomplishments:

Achieved Significant recurring Cost Savings against SQL Server Consolidation & Edition Upgrades / Downgrades Project.

Decommissioned 40 Servers as part of Server Consolidation that brought significant Server Infrastructure Cost Savings.

Provided significant contribution to the DCR (DataCenter Re-Alignment) Project that used newly built Private Cloud with VMware vCloud technologies and features by Centralizing & Virtualizing approximately 3000 application databases that saved huge License cost and also saved significant Database Maintenance Labor cost.

Got “Mercury Dart” award against the contributions to Mercury Project.

Provided Road-Map to the Senior Management with Phases 1. Improved manageability using Host & DB Consolidation along with Standardization. 2. License Cost Savings using Virtualization & Private SQL Cloud. This road map drives as the scope for future projects.

Role : SQL Server Database Administrator (DBA)

Duration : Jul. 2007 - Oct. 2011

Client : The Kroger Company, USA.

Employer : Computer Sciences Corporation (CSC).

Project Site : Chennai, Tamil Nadu, India.

Job Duties:

Installed SQL Server 2005/2008/2012 on Windows 2003/2008/2012 on both cluster and on standalone servers.

Deployed vendor scripts/application team scripts; Deployed SSIS Packages; Supported Application Upgrades

Configured Security using various best practices.

Base lined Server Performance using Periodical Metrics Gathering

Provided contributions on fixing various production issues during on-call periods and also during scheduled activities like releases/migrations.

Configuring and managing Database Mirroring and Clustering for various applications.

Implemented Database Encryption, Data Encryption based on business needs.

Implemented Backup compression and Data compression wherever required.

Implemented Database Partitioning (with manual partition extension or with Automated Partition extension (using Sliding Window technique).

Optimized various Queries by implementing indexes using Execution Plan Analysis.

Tuned Server/DB/Application Performance by analyzing various metrics gathered using Performance Monitor, Data Collector, Who-Is-Active table data.

Created & Schedule jobs by utilizing the features like Alerts, Operators, Proxies, Database Mail etc.

Accomplishments:

Developed multiple SLA reports to simplify/automate Database Monitoring work that saved minimum 500 labor man hours per year.

Developed SQL Server Build Automation to build VM SQL Environments automatically after VM clone completion.

Developed other automations like Database Permissions Extraction and Database/Server Permissions Listing.

Prepared Important Templates like SQL Server Projects Questionnaire Template, Operation Readiness Test (ORT) Template and documents like SQL Server KT Document, On-Call Best Practices Document, SQL Server Reference Architecture Document.

Got “Wall of Fame” award against the contributions to Various Projects at Kroger.

Role : SQL Server DBA / BI Developer

Duration : Apr. 2007 - Jun. 2007

Product : ERP OnCloud – Analytics Module

Employer/Product Owner: Ramco Systems Limited.

Location : Chennai, Tamil Nadu, India.

ERP OnCloud Product Details:

It is a subscription Service Model designed for small to mid sized businesses looking for a low initial investment and reduced overhead and maintenance. Being delivered in two forms as a managed service on Customer Equipment on Customer Premises or through a Web Browser entirely through the internet. Functional Areas include Financials, Logistics, Manufacturing, CRM etc.

Job Duties:

Database Administration:

Installed and Configured Standalone SQL Instances.

Base-lined Server Performance Counters

Created Alerts for Server Performance Bottlenecks using MOM

Handled Regular, Base-lined Backups and Archival Processes

Handled Restoration and Recovery Processes

Handled User Management and Security Processes

Configured Log Shipping as High Availability Solution

Created and Scheduled Application and DB maintenance Jobs. Also configured Alerts & Notifications using Database Mail.

BI Development:

Installed and Configured SQL Server Integration Services and Analysis Services.

Developed SSIS Packages and Cubes and deployed them on QA and Production Environment.

Role : SQL Server DBA / Technical Coordinator

Duration : Jan. 2005 - Mar. 2007

Product : ERP OnCloud.

Employer/Product Owner: Ramco Systems Limited.

Location : Chennai, Tamil Nadu, India.

Job Duties:

Database Administration:

Installed and Configured Standalone SQL Instances.

Baselined Server Performance Counters

Created Alerts for Server Performance Bottlenecks using MOM

Handled Regular, Baselined Backups and Archival Processes

Handled Restoration and Recovery Processes

Handled User Management and Security Processes

Configured Log Shipping as High Availability Solution

Created and Scheduled Application and DB maintenance Jobs. Also configured Alerts & Notifications using Database Mail.

Technical Coordination:

Was primary representative to interact with R & D team for correcting Process Modelling Tool related issues, User Defined Screens Development and Integration related issues, Drill Down Views Development related issues, Workflow Integration Related Issues.

Provided training to Developers & Designers about Process Modelling tool features/release details and guided them.

Role : SQL Server Developer & Data Modeler

Duration : Dec. 2002 - Dec. 2004

Product : Ramco Enterprise Series 4.0 (Module: EAM)

Employer/Product Owner: Ramco Systems Limited.

Location : Chennai, Tamil Nadu, India.

Details about “Ramco Enterprise Series 4.0 – EAM Module”

EAM meant for Enterprise Asset Management which is part of the ERP product Ramco Enterprise Series 4.0. It is a fully integrated solution for the maintenance of infrastructure/plant, equipment and tool with predictive and preventive types to streamline operations, to reduce equipment downtime, to avoid outages, to increase product quality, to facilitate compliance.

Job Duties:

Took complete ownership to Develop below sub modules of EAM that is part of ERP product.

Forecast Inspection Jobs (using Daemon Process)

Formula Management.

Predictive Maintenance.

Inspection Order

Modeled data using Erwin to design Conceptual, Logical and Physical Model using Business Rules Document and by coordinative with Requirement Engineers.

Took care Process Design using the Development Framework (Ramco VirtualWorksTM), Code Generation, Front End Code deployment, Frequent Interactions with Business Analysts.

Created/Modified tables & views, Wrote Stored Procedures and Functions etc.

Reviewed Test Cases and testing the application.

Tuned Queries, Stored Procedures and Implemented new Indexes to improve performance,

Role : SQL Server Developer & Design Engineer

Duration : Sep. 2000 - Nov. 2002

Product : Ramco Enterprise Series 4.0 (Module: HR)

Employer/Product Owner: Ramco Systems Limited.

Location : Chennai, Tamil Nadu, India.

Details about “Ramco Enterprise Series 4.0 – HR Module”

HR module is part of the ERP product Ramco Enterprise Series 4.0. It comprises of four broad sections mainly Recruitment, Attendance, Performance and Expense management.

Job Duties:

Designed and Developed below sub modules of HR module that is part of ERP product.

Payroll Processing.

Employee Compensation.

Took care Process Design using the Development Framework (Ramco VirtualWorksTM ), Code Generation, Front End Code deployment, Frequent Interactions with Business Analysts.

Created/Modified tables & views, Wrote Stored Procedures and Functions etc.

Created Unit Test Cases and tested the application components.

Tuned Queries, Stored Procedures and Implemented new Indexes to improve performance.

Contact this candidate