SENTHIL KUMAR
**********@*****.***
PROFILE SUMMARY
15+ years of experience in IT Industry that include 10+ 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).
1+ Years of experience in Business Intelligence using SSIS and SSAS.
Extensive experience in Database Design and Implementation using Transact SQL with SQL Server (writing Stored Procs. & Functions etc.) and Data Modelling with ERWin.
Good experience in Project Management with Microsoft Project 2000, Objects Management with Microsoft Visual SourceSafe 6.0, Change Management Processes, ERP Functional Areas like Logistics, HR, Maintenance Management etc., ERP Product Development Methodology
COMPUTER LITERACY
Operating System : Windows NT/2000/XP/2003/2008/2012.
Databases : Sql Server 2000/2005/2008/2012/2014, Oracle 8.0, MS Access
Scripting : Windows Powershell 3.0
Business Intelligence : SSIS, SSAS, SSRS, Informatica.
GUIs and Tools : ERWin, MS Project, MS Visual SourceSafe, MS Office 2007/2013. Visual Basic 6.0, Foxpro 2.6, Developer 2000.
PROJECT PROFILE
Role : Lead SQL Server Database Administrator (DBA) Nov.2011 - Till Date
Client : The Kroger Company, USA .
Project Site : Cincinnati, OH, USA.
Job Duties:
Implemented Disaster Recovery using Database Mirroring and also by using AlwaysON Availability Group mechanism based on Recovery Time Objective (RTO)
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.
Implemented Column Store Index (the in-Memory solution) for one of the Critical Application on SQL Server 2014
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.
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 by Centralizing 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. Licence Cost Savings using Virtualization & Private SQL Cloud. This road map drives as the scope for future projects.
Role : SQL Server Database Administrator (DBA) Jul.2007 - Oct.2011
Client : The Kroger Company, USA.
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 Apr.2007 - Jun.2007
Product : ERP OnDemand – Analytics Module
Location : Chennai, Tamil Nadu, India.
ERP OnDemand 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 Equipement 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 Jan.2005 - Mar.2007
Product : ERP OnDemand (recently name changed as ERP on Cloud)
Location : Chennai, Tamil Nadu, India.
ERP OnDemand Product Details: refer above..
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 Dec.2002 - Dec.2004
Product : Ramco Enterprise Series 4.0 (Module: EAM)
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 equipement 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 Sep.2000 - Nov.2002
Product : Ramco Enterprise Series 4.0 (Module: HR)
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.