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 by working in Enterprises like Kroger Co., CSC, Ramco Systems etc.
• MCSA (70 - 462) on Administering Microsoft SQL Server 2012 Databases (certified by Microsoft) part of MCDBA.
• 4+ years Onsite experience working at Richmond, VA, USA and worked at Cincinnati, OH, USA on H1B Visa.
• 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.
• Proven Experience in handling various types of Upgrades and Migration Projects and also headed SQL Server Database Services team that owned and managed 5000 databases on 250 servers.
• Experience in handling VLDB with TB sizes along with experience in implementing Database Partitioning (with Sliding Window Technique).
• Proposed and Implemented DR Strategy for Critical Databases using Database Mirroring, Log Shipping and using AlwaysON Availability Group based on Recovery Time Objective (RTO).
• Proposed and Implemented High Availability using Clustering and AlwaysON.
• Tuned Server/DB/Application Performance by analyzing various metrics gathered using PerfMon, Data Collector, Who-Is-Active and also by implementing industry best practices. Optimized various Queries using ExecutionPlan.

TECHNICAL SKILLS:

Databases: SQL Server 2008 R 2/2012/2014/2016, Oracle 8.0, MS Access.

Cloud & Virtualization: SQL Azure, Amazon RDS for SQL Server (AWS), VMWare vCloud (ESXi).

Scripting: Windows Powershell 3.0

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

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

Data Analytics: SSAS (SQL Server Analysis Services).

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

SQL Tools: SQL Sentry Plan Explorer, RML Utils, MAP, Idera SQLSafe, Idera Diag.Mgr.

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

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

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

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.

Other Concepts: Data Profiling, Data Quality, Data Cleansing, NoSQL/Big Data, Agile, MPP.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior SQL Server Database Administrator DBA

Responsibilities:

Datawarehouse Team

• 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.
• Provided recommendations to ETL team on Database design against Dimensional modelling with respect to performance tuning.
• 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.

Lead SQL Server Database Administrator (DBA)

Responsibilities:

Enterprise Database Services Team

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

SQL Server Database Administrator (DBA)

Responsibilities:

• 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)
• 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.

SQL Server DBA cum BI Developer

Responsibilities:

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.

SQL Server DBA cum Technical Coordinator

Responsibilities:

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

SQL Server Developer cum Data Modeler

Responsibilities:

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