Sr.SQL Server with Azure

Senthil Kumar Muthuveeramman Natarajan

914-***-**** ************.**@*****.*** Reston, VA

PROFILE SUMMARY

** ***** ** ********** ** IT Industry that include 13+ years of exp. in SQL Server as DBA / Database Architect in versions ranging from SQL Server 2000 to 2017 by working in Enterprises like Gate Group, Wells Fargo, Virginia Premier, Kroger Company, CSC, Ramco Systems.

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 working with Microsoft Azure (SQL Azure).

2+ Years of experience in DWBI using SSIS, SSRS and SSAS along with Scripting using Powershell.

Proven Experience in handling Upgrades, Migration, Consolidation, Virtualization, Edition Conversion etc.

Experience in handling VLDB with TB sizes along with experience in implementing Database Partitioning (with both Manual and Sliding Window Technique) and experience in implementing Data Purge/Archival processes.

Proposed and Implemented DR Strategy for Critical Databases using Database Mirroring, SAN Replication and using AlwaysON Availability Group based on Recovery Time Objective (RTO) and participated in DR tests.

Proposed and Implemented High Availability using Clustering and AlwaysON. Experience in building and managing SQL Server on Private Cloud with VMware vCloud.

Tuned Server/DB/Application Performance by analyzing various metrics. Optimized various Queries using Execution Plan.

COMPUTER LITERACY

Databases : SQL Server 2000/2005/2008/2012/2014/2016/2017, Oracle 8.0, MS Access.

Cloud & Virtualization : Azure SQL Database, SQL Server on Azure VM, Azure SQL Managed Instance,

Amazon RDS for SQL Server (AWS), VMWare vCloud (ESXi).

Scripting : Azure CLI, Windows Powershell 3.0, T-SQL, PLSQL.

SQL Tools : Idera SQLSafe/Diag.Mgr, Redgate SQLCompare, SQLSentry Plan Explr., MAP

Data Warehousing : Azure Data Factory, SSIS (SQL Server Integration Services), Informatica.

Azure Synapse Analytics, Azure Data Lake.

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

Data Modelling : CA ERWin (Relational & Dimensional Modelling), ERD Concepts 8.

DevOps Tools & Version Control : Microsoft Teams, Azure DevOps with GitHub / TFS, Jira, MS VSS.

Other Tools : BMC Remedy PAC2000, ChangeGear, Tivoli (TDP) / TSM, SCOM 2012,

Jira with Confluence.

ERP : Logistics, HR, Maintenance Management, Airline Catering.

Operating System & GUIs : Windows 2003/2008/2012 and VB 6.0/VB.Net, Foxpro 2.6, Developer 2000.

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

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 DBA

Duration : Aug.2019 – Apr.2020

Client : Gate Gourmet.

Project Site : Reston, VA.

Environment : SQL Server 2012/2016/2017, Azure VM,

Microsoft Teams, Azure DevOps with GitHub, Jira, Confluence.

Job Duties:

Designed and Developed automations for bulk data uploads

Designed and Developed automation for periodical non-prod database refreshes along with user re-configuration & data cleanups.

Automated multiple upload work using SSIS packages since those were ETL tasks being done manually.

Tuned existing ETL packages using various best practices to reduce execution times.

Tuned few stored procedures as per the requirement from development team.

Designed Audit Setup approach using both CDC and Temporal Table mechanisms and Developed POCs for the same and presented to the management.

Designed & Implemented Backup Strategy using Azure Blob Storage and also designed Non-Prod Refresh Strategy along with DB refresh automation on one of the non-prod environments.

Built and Managed SQL Server Instances on SQL Server on Azure VMs model (IaaS)

Role : Database Engineer

Duration : Jul. 2017 - Jun.2019

Client : Wells Fargo.

Project Site : Charlotte, NC.

Environment : SQL Server 2012/2014/2016, Powershell, SSIS,

Remedy Pac2000, Redgate SQLCompare.

Job Duties:

Managed Disaster Recovery setup that are configured with Mirroring, Log Shipping and AlwaysON Availability Group.

Configured Data Protection (Backup) based on Recovery Point Object (RPO).

Implemented High availability, Disaster Recovery and Load Balancing (Read Only) using AlwaysON availability group.

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

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

Took ownership of SQL Server 2008 to 2016 upgrade project that contained around 100 production databases scattered over 5 Production SQL Instances and completed successfully along with new Always ON availability group setup.

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

Developed a tool (automation) called PET (Permissions Extraction Tool) to preserve permissions of a database before any major change happen and re-apply permissions after the change completion.

Wrote PowerShell script (automation) to capture, manage and delete trace data in regular intervals.

Role : Database Architect (Datawarehouse Team)

Duration : Jul. 2016 - Jun. 2017

Client : Virginia Premier Health Plan Inc.,.

Project Site : Richmond, VA.

Environment : Oracle 11g/12c, SQL Server 2008R2/2012/2014, SSIS, SSRS, Azure,

Idera SQLSafe/Diag.Mgr, ChangeGear.

Job Duties (as part of Datawarehouse Team):

Designed Disaster Recovery Strategy and proposed Infrastructure requirement & implemented the same.

Designed Architecture for Azure SQL Database Implementation Model and completed Proof of Concept before making a detailed plan to migrate DBs on to Cloud.

Identified list of databases and instances that are potential for migrating to Azure Cloud IaaS model.

Migrated first set of databases on to Azure cloud against Azure SQL Database Elastic Pool model.

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

Implemented CDC and Change Tracking. Developed Backup SLA report to ensure backups are in place.

Provided recommendations to ETL team on Database design against Dimensional modelling with respect to performance tuning.

Developed SSIS packages as per the business needs.

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

Wrote Powershell scripts for gathering various performance metrics inside and outside SQL Server and for gathering OS, Active Directory level information across servers.

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.

Project Site : Cincinnati, OH.

Environment : SQL Server 2005,2008R2,2012, SSIS, SSRS, SSAS,

IBM Tivoli (TSM), VMWare vCloud (ESXi), Microsoft Visio, Microsoft Project.

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.

Job Duties (as part of Enterprise Database Services Team):

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

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.

Headed SQL Server Database Services team that owned and managed 5000 databases and 250 servers.

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

Handled VLDB (Very Large DB) with TB sizes and implemented Automated Partition extension (using Sliding Window technique).

Wrote 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.

Resolved Blocking/Deadlock issues, Abnormal Log/ 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 Workload 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.

Role : SQL Server Database Administrator (DBA)

Duration : Jul. 2007 - Oct. 2011

Employer : Computer Sciences Corporation (Client: The Kroger Company)

Project Site : Chennai, Tamil Nadu, India.

Environment : SQL Server 2005,2008R2, SSIS, SSRS, SSAS.

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.

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)

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 and Database Mail.

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.

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

Role : SQL Server DBA cum Development Lead

Duration : Sep. 2000 - Jun. 2007

Employer : Ramco Systems Limited.

Project Site : Chennai, Tamil Nadu, India.

Environment : SQL Server 2000/2005, MS Access.

Job Duties:

PRODUCT: ERP OnCloud & Ramco Enterprise Series 4.0 (Module: EAM & HR)

Database Administration:

Installed and Configured Standalone SQL Instances.

Baselined Server Performance Counters. Monitored Server Performance.

Handled Regular/Baselined Backups and Archival Processes, Restoration and Recovery Processes

Handled User/Security Management; Created and Scheduled Application and DB maintenance Jobs; Configured Alerts & Notifications using Database Mail.

Configured Log Shipping as High Availability Solution.

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 on Process Modelling tool features/release details& guided them.

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.

Database Development:

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

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

Payroll Processing, Employee Compensation.

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.

Contact this candidate