DBA

Summary

●** years of IT Programming/DevOps/AWS/Azure Architect/DBA combined experience

●12+ years of MS SQL Server DB Administration/Maintenance–SQL Server 2000-08R2 to 16 &17

●9+ years IT management role, including responsibility for performance reviews and budgeting

●10+ years of system maintenance and administration experience including automations of jobs

●Expert knowledge of Microsoft Technology Programing, Reports Development in Client Server and Web Technologies using Crystal Report & SSRS

●Excellent Server Management skills including code deployment and maintenance using SCOM.

●Excellent in Production, Staging and Development Servers installation and maintenance.

●Web Farm Server setup, Citrix Servers maintenance including production support.

●Excellent troubleshooting and communication skills with Project Execution skills.

●Managed production support and then started rotation methods in it by mentoring the support team. Excellent troubleshooting experience in server issues including network issues.

●4+ years of Microsoft Azure, AWS Cloud Services experience

Certifications

●Microsoft Certified Solution Developer (MCSD) – 2000 & MCAD-2003

●Microsoft Certification – Azure Provisioning SQL Database -2019

Technical Summary

●Languages: Java 1.2, HTML, XML, VB, PERL, C#, VB, Python, Powershell and JavaScript

●Software: SSRS, SSIS, Crystal Reports 8.5/10, CF, Install Shield and BizTalk Server 2000

●Technologies: ASP, XSLT, IIS, ADO, ASP.NET, VB.NET, WPF, WCF, DevOps and J2EE

●OS: Windows 95/98/2000-12/16/XP/7/10, Win NT 4.0/2003/08/12, Linux, UNIX

●Tools: Red Gate, Power BI, Tableau, Cloud Tools, Toad, SVN, Git, SentryOne

Idera, MS Visio, MS VISUAL STUDIO, MS Project, SSRS and Dell Spotlight.

●Databases: SQL Server 2000/05/08 R2/-/17/19, Oracle, PostgreSQL, Cosmos, NoSQL, Mongo

●ETL Tool: ODI, SSIS, Informatica 5.1, Cognos, Oracle Apps.

Work Experience

DBA Migration Lead for VirtualTechGuru’s Clients

Feb 2021- Aug 2022

Project - Platform Migrations

●Platform/Cloud/Version Migration – On premise VM based SQL Server databases were migrated to Cloud Based VMs. SQL Server 2012 to 2017, On-Prem to Cloud, SQL Server to Azure SQL

●Administration and Maintenance databases along with more automation. Azure DB Administration.

DBA Manager in Six Flags Grand Prairie TX

Jul 2019- Dec 2020

Project- Cloud Migration of SQL Servers, DBA

●Cloud/Version Migration – On premise VM based SQL Server databases were migrated to Cloud Based VMs.

●Administration and Maintenance of high number database servers with more automation.

●Amazon Redshift cluster setup & Management with PowerShell based automation.

●On premise VM SQL Servers to AWS SQL Database Migration and Security migrations.

●Replication, Mirroring & Log Shipping support. Started working on migrating few to Always ON.

●Always On and Replication Maintenance. Maintenance of MySQL Databases.

●Team Management and Budgeting. Training to the team, documentations

●Setting up of MongoDB and AWS infrastructure to support MongoDB

SQL Server DBA/Azure Architect in TGIF, Dallas, TX

July 2017 – May 2019

Project: Service Industry DB Administration

●Optimizing database performance through database performance tuning and creating maintenance jobs used PowerShell. Database Administration and Maintenance.

●Analyzing business data requirements and designing database solutions including bug fixing, maintaining Azure Platform, SSRS.

●Azure Administration. Adding VM Servers for SQL usage, Disk size maintenance and adding.

●Power BI reports deployment/maintenance - administration. PBI Gateway Maintenance.

●Performance tuning in Azure, Maintain SQL Monitoring and alerting

●Azure VM SQL Servers to Azure SQL Database (SaaS to PaaS) Migration and Security migrations.

●Replication, Mirroring &Log Shipping support. Started working on migrating few to Always ON.

●Always On and Replication Maintenance. Maintenance of PostgreSQL Databases.

●Budgeting, Reporting to Management and Co-ordination with other teams for DB Server Maintenance.

●Server Patching including Windows update in regular intervals by closely working with Sys. Admins.

SQL Server Consultant in LHP, Plano, TX

February 2017 – July 2017

Project: HealthCare Administration

●Optimizing database performance through database performance tuning.

●Study the system and created maintenance jobs. Streamlined DB Administration and Maintenance.

●PerfMon scripting and adding required Indexes. Helping developers to tune queries.

●Operational DBA activities like monitoring, backup/restore and performance tuning.

●Upgraded SQL Server 2008 R2 databases into SQL Server 2012 and SQL Server 2016 SP1

●Analyzing business data requirements and designing database solutions including bug fixing, writing stored procedure, triggers and functions with SSRS reports development.

Lead Database Administrator/Cloud Migrations & Maintenance

January 2013 – Dec 2016

Project: Fisher Valves – Emerson Process Management

●Database Administration and Maintenance of Database servers including Patching/Upgrades.

●Cloud Migration, Cloud Database Administration – Azure, AWS Cloud & PostgreSQL

●Budget, workload project management, mentoring and participating in Support Rotation.

●Server DB Script promotion, Job scheduling in various DB Servers for FF team.

●Manage, Monitor database growth activities & Troubleshoot Transaction Log & Space Issues

●Operational DBA activities like monitoring, backup/restore and performance tuning.

●Replication, Mirroring &Log Shipping support. Started working on migrating few to Always ON.

●Work with developers and give them support on their issues or DB restoration or Permissions requests. DevOps Tasks including Continuous Integration and Deploy of DB Scripts.

●Helping build new DB Server setup and installation of software/patch management. Setting up SQL Server maintenance jobs – including Index maintenance jobs.

Environment: SQL SERVER 2005/2008 R2/2012/14, MySQL,NoSQL,RedGate, Idera, AWS, Spotlight.

SQL Server DBA Consulting in CED, Irving, TX

December 2012 – December 2013

Project: CED Service Center

●Database Administration and Maintenance of CED’s 570+ profit center Production Database servers.

●Support Developers in Irving Service Center, Maintaining Dev., QA DB servers.

●Client and Server Build Support and installing the build in various DB Servers for QA team.

●Monitor database growth activities & Troubleshoot Transaction Log & Space Issues

●Operational DBA activities like monitoring, backup/restore and performance tuning.

●Supporting Production Server DB restore at the time of hard disk crashes.

●Involving with Development design and support in maintenance of code standards.

●Helping build new DB Server setup and installation of software.

●Schedule Backup Jobs for Various Tape & Disk Backups

Environment: SQL SERVER 2005/2008 R2/2012, SSIS, RedGate, MS Excel, Visual Studio.

SQL Server DBA Consulting in DCSGlobal, Plano, TX

May 2012 – November 2012

Project: Charity-Care Healthcare Project

●Operational DBA activities like monitoring, backup/restore and performance tuning.

●Database migrations to higher versions. Applying SQL patching.

●Optimizing database performance through database performance tuning.

●Creating maintenance jobs. Database Administration and Maintenance.

●Analyzing business data requirements and designing database solutions including writing stored procedure, triggers and functions with SSRS reports development.

SQL Server DBA – Consulting in BlueCross BlueShield TX, Richardson, TX

December 2011 – May 2012

Project: ACA Risk Compare - TIS

●Supporting the business 24*7, maintaining 99.9 uptimes, depending on the application and business SLA requirements.

●Monitor database growth activities & Troubleshoot Transaction Log & Space Issues

●Database Administration and Maintenance.

●Operational DBA activities like monitoring, backup/restore and performance tuning.

Environment: SQL SERVER 2005/2008 R2 SSIS, RedGate, Cognos, TeraData, MS Excel

CSC Covansys, Overland park, KS

SQL Server DBA/ Sr DevOps Engineer / Server Administration/Production Support Roles

October 2005 – December 2011

Project: NFIP Flood Insurance

Responsibilities

●Experience in installation and configuration of MS SQL Server 2005/08 for Flood Insurance Acrosoft.

●Have good experience in Release/Change/Configuration/Service Request/Incident Management with Good documentation

●Experience in Migration from SQL Server 2000 to SQL Server 2005 and 2005 to 2008R2.

●Strong experience in performing database consistency checks, planning and scheduling Backup, Restore and Recovery procedures. Experience in backup and disaster recovery procedures.

●Experience in Query Optimization, Tuning of Stored Procedures, and Performance Tuning.

●Automating manual jobs in DB/ Web Server maintenance & administration of assigned flood system.

●Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.

●Used SQL Profiler, Execution Plan and Performance Monitor.

●Experience in Database Mirroring, Database Snapshot and Isolation Levels.

●Has excellent experience in setting up all types of replication - Snapshot, Merge and Transactional.

●Involved in data modeling for the application and created ER diagram using Erwin.

●Planning and Documenting the current configuration and worked on regaining disk space

●Supporting the business 24*7, maintaining 99.9 uptimes, depending on the application and business SLA requirements.

●Worked on Compression, Index maintenance. Always testing all the activities in Test system before Prod move.

●Monitor database growth activities & Troubleshoot Transaction Log & Space Issues

●Schedule Backup Jobs for Various Tape & Disk Backups

●Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.

●Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.

●Excellent T-SQL Programming skills. Maintaining coding standards across the board in all SQL Server environments. Experience in query optimization & performance tuning.

●Extensively worked and had good knowledge on Integration and Reporting Services and good experience in data migration from Oracle/Access/Excel /Flat Files to SQL Server 2005/2008 R2

●Strong experience in Database authentication modes, creation of users, configuring permissions and assigning roles to users. Having good experience in ETL using DTS, SSIS, SSAS and SSRS Reporting.

●Very good understanding in SDLC (Systems Development Life Cycle) with development in .Net technologies

●Good Experience in SCOM 2007 R2 - Deployment, Configuration and using SCOM for Monitor ASP.NET Application, Monitor Network Devices, Monitoring VMware Servers and Monitoring Non-Windows Devices.

●Using Toad, Writing/Debugging Oracle PL/SQL. Good experienced with Oracle DB Development for Reports.

●Having good experience in ETL using SSIS and SSRS Reporting. Familiarity with SSAS.

●Worked closely with web developers, Architects, Quality Analyst and other stake holders.

●Started rotation methods in production support by mentoring the support team. Excellent troubleshooting experience in server issues including network issues.

Flood Reports System

●Created new Reporting Systems using SQL Server 2005 Reporting Services, Report Viewer controls in VS.Net.

●Modularized and designed a reporting system which can be enhanced and developed independent of the current Flood System.

●Development and Maintenance in existing Crystal Reports using Crystal Report 10.

Production Support

●Web/Web Farm, Batch and Citrix server configuration and maintenance (using SCOM). IIS Management.

●Lead team in Production Batch Supports by automating batches, problem solving (24x7) and mentoring with experience gained all these years in batch support.

Dept. of Labor, Licensing & Regulations by Covansys Corporation Consulting, Baltimore, MD

Senior Consultant – Database Programming and Report Development

April 2005 – October 2005

Responsibilities

●Developed highly complex and customized reports for Federal Govt. by using Crystal Reports/SSRS for Mid-Atlantic Career Consortium Project.

●Involved in SQL Server database administration and maintenance activities along with Database Programming.

●Provides estimates to complete a desired modification; analyze the client’s requirements and suggested and developed the best possible reports keeping in the mind the cost and the feasibility with DLLR’s unique architecture with PDF export facility.

Environment: Crystal Reports 10, Crystal Enterprise Server, SSRS, ASP, XML, XSL, MTS, IIS and .Net Tech using ASP.Net and ADO.Net with SQL Server 2000 Installation, configuration and maintenance of Windows 2000/NT 4.0, FORTE and SQL 6.5 servers

Merrill Lynch - Covansys Corp Consulting, Plainsboro/Hopewell, NJ

Business analyst / Tech Lead

October 2004 – March 2005

Project: MLIM Share Class Conversion

Responsibilities

●Played business analyst, Tech lead roles, collected requirements from business, analysis design including detailed design document preparation with proto type design.

●Supporting offshore teams, functional and system testing by using Rational Robot automated testing tool and delivery of those test scripts. Worked with offshore model and implemented successfully.

●Developed Portfolio Management Reporting reports for MLIM.

Environment: Crystal Reports, MS Project and Rational Robot and SQL Server 2000

Covansys Corporation, Plainsboro, NJ and India

Team and Tech Lead

March 2004 – September 2004

Project: MLIM – LAS Risk Enhancement / Center

Responsibilities

●As a Team Lead: Risk Enhancement project involved enhancements to the existing application with the addition of Risk Module. This included a web based interface for maintaining counterparty and the related data regarding its group, credit rating, and capital and risk information.

●The project also involved implementing a reports module (pdf reports) for current and historic dates. Automatic daily pdf reports are created through batch jobs in UNIX.

●Certain jobs were created in PERL for storing historic prices, exchange rates and loan related information. These run at specified time intervals.

●Full responsibility from requirement analysis to development. Lead a 4 member technical during the development of this application with onsite-offshore model

●Client/Onsite Business Analyst- interaction, process implementation and documentations in various stages of the project with on-time successful quality development.

Covansys Corporation, Hopewell, NJ/India Senior Analyst January 2004 – March 2004

Project: MLIM – AEM Derivatives

●Merrill Lynch Investment Managers (MLIM) has implemented MOSP (Middle Office Strategic Platform) for supporting their middle office business process

●Analysis and Design including Use case preparation and Unit Test Plan preparation with Development.

T. Rowe Price Inc., Baltimore, MD Senior Analyst March 2003 – December 2003

Responsibilities

●Module Lead in Development group in Java Technology Web Programming for TRowePrice.

●Worked for CitiBank Singapore – Java we programming in this period in the same project group

●Project planning and tracking using MS Project 2000 and Reports preparation for CMM

Covansys formerly Complete Business Solutions India Limited, Chennai Senior Analyst / Team Lead

August 2002 – February 2003

DM Data Inc. (Mega soft), Chennai, India System Analyst / Project Lead Aug 2000 – Aug 2002

Uthra Systems, Chennai, India System Analyst / Developer Sep 1998 – Aug 2000

Education

●Master of Business Administration (Systems), March 1998, Annamalai University, Tamil Nadu, India

●Bachelor of Engineer (Electrical & Electronics), April 1996, Annamalai University, Tamil Nadu, India

●Diploma in Production Management

●Post Graduate Diploma in Marketing Management

Contact this candidate