Resume

Sign in

Sql Server Data

Location:
Mahwah, New Jersey, 07430, United States
Salary:
120000
Posted:
October 26, 2016

Contact this candidate

Resume:

Xavier Kodavatiganti

609-***-****

acw83d@r.postjobfree.com

SUMMARY OF QUALIFICATION

A Microsoft Certified (MCDBA, MCSE) and Senior SQL DBA with a Master’s Degree and 12+ years of Total IT Experience in Production Support Database Administration in Windows Environments and also Application support experience using Microsoft SQL Server 7.0, 2000, 2005, 2008/2008 R2, 2012, 2014, and 2016.

Worked on SQL Server Upgrades from 2000/2005 to SQL Server 2008 RTM/R2 to SQL Server 2012 and to SQL Server 2014. Both Side-by-Side and in-place upgrades.

Specialist in resolving issues relating to SQL Server Install/Upgrade failures.

Installed/upgraded 800+ SQL Instances of 2005/2008/2008R2/2012/2014 Clustered Servers of Dev/QA/UAT/Production Environments till date.

Installed and Maintained Multi-Node SQL clusters. Max being 12-Node Windows Cluster with 20 SQL Clustered Instances on it.

Deployed SQL on Azure and configured Always-on in Azure and testing.

Handled and maintained the largest database of 9 TB in size.

Extensively worked on Database Backups, Restores, and Disaster Recovery procedures.

Created scripts to automate tasks like Creation of Always-On using Powershell (Type 1, 2, 3, and 4 AO configuration).

Enabled and configured more than 200+ Always-On feature in both same subnet and multisubnets on SQL 2012, SQL 2014, and 2016. Configured Always-On in multi domain SQL Instances.

Dogfooding done using SQL 2016 CTP1 and CTP2 for testing stretch databases with Azure SQL databases

Created and updated KB Articles to help team resolve issues at the L1/L2/L3 level.

Escalation support provided to customers within MSIT.

Tested and worked on DB HealthCheck feature of Always-On and QueryStore in SQL Server 2016.

Worked closely with customers to help them in setting their migration plans.

Experience in implementing different types of Replication modes like Snapshot, Transactional, and Transactional with Subscriber Updates, and merge.

Worked extensively and implemeted Transparent Data Encryption (TDE) on databases as per customer requirements.

Worked extensively on Performance Tuning and Query Optimization of TSQL queries/procedures.

Worked extensively on SSIS Package designs for Import/Export from various data source like flat file and Excel to MS SQL Server and vice versa.

Created Windows Batch Files and automated tasks as per customer requirements.

Worked extensively on SSRS reports, designed and deployed the reports into the Reporting Server and automating the e-mails to the customer.

Backup of SSAS Cube and Restoration of the Cubes, assigning permissions on the cubes.

Installation and configuration of SSIS, SSRS, and SSAS Servers.

Installation and configuration of SSAS PowerPivot and integrating with Sharepoint 2010.

Working knowledge on MongoDB 3.2.

Individual Contributor and good team player, strong interpersonal and Communication skills combined with self motivation, initiative and ability to think outside the box. Quick learner and good team player.

EDUCATIONAL QUALIFICATIONS & CERTIFICATIONS:

Bachelor of Commerce from Osmania University

Masters in Commerce from CDE Osmania University

One year Full-time Advanced Diploma is Software Technologies from VJINFO.

Certifications:

Certification in Microsoft SQL Server 2005 - Implementation and maintenance 70-431. (Microsoft Certification ID : 6648328, Year 2009.)

Please click the below link to verify my Microsoft Transcripts:

https://mcp.microsoft.com/authenticate/validatemcp.aspx

Transcript ID (851182) and the Access Code (xavier17081977)

Microsoft Certified Database Administrator SQL Server 2008 (70-432 - Implementation and maintenance and 70-450 - Designing, optimizing and maintaining a database administrative solution Certified). (Year 2012 Microsoft Certification ID : 8901892.)

https://mcp.microsoft.com/authenticate/validatemcp.aspx

Transcript ID (999038) and the Access Code (srivanixavier)

Certification’s on IT Infrastructure Library (ITIL V3 and ITIL 2011) (ITIL V3 2011 Certificate # 02310279-01-862V and ITIL 2013 Certificate #023*****-**-YHDF).

Certification’s on IT Infrastructure Library (Intermediate SOA Certified & Intermediate PPO Certified). (Intermediate SOA Certificate # GR756015356XK and Intermediate PPO Certificate # GR758015750XK both in Year 2014).

TECHNICAL COMPETENCIES:

Operating Systems : Windows Server 2000/2003/2008R2/2012/2012R2

RDBMS : MSSQL Server 7.0/2000/2005/2008/2008R2/2012/2014

Languages : T-SQL, PowerShell, HTML, DHTML, C and C++

SQL Server Tools : Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS, SSRS SharePoint Powerpivot, Symantec Netbackup, DPM Backup tool, FogLight, SQL Sentry, LightSpeed, BMC Remedy

PROFESSIONAL EXPERIENCE:

Client: United Parcel Service (UPS), Mahwah NJ Oct 2015 – Till Date

Environment : SQL SERVER 2005/2008/2008 R2/2012/2014

Responsibilities:

Handling day-to-day Alert and failures.

Database refresh on a regular basis from Production environment to Dev, QA, and Staging Environments.

SQL Upgrades from SQL 2008 to SQL 2014.

Performance tuning of queries and troubleshooting issues relating to performance.

Setting SQL Standards across SQL Servers in the environment.

Creation of reports on SSRS as per customer requirements.

Creation of packages using SSIS as per customer requirements.

Microsoft Pvt. Ltd.

Senior Escalations Engineer (SQL DBA Services) Oct 2012 – July 2015

Environment : SQL SERVER 2000/2005/2008/2008R2/2012/2014

Responsibilities:

Handling day-to-day Escalations from Customers within Microsoft and from our Vendor Teams.

Working on Azure technologies and testing SQL features on Azure.

Configuring Always-on on Azure and testing failover/failback scenarios.

Collaboration with SQL Engineering team in identifying issues in SQL space.

Defect remediation and setting standards for SQL.

Automated Always-On using Powershell Script to reduce time and efforts.

In regular search for opportunities for Automate and work on Automation Projects to reduce time and human efforts.

Ad-Hoc support to Business Units within Microsoft and help them with planning in migrations/Upgrades/new projects/DR setups.

Providing Training to L1/L2/L3 vendor teams (TechMahindra and Infosys Teams).

Proactive Deep dives to eliminate errors across the BU Platforms relating to SQL Server.

Dogfooding new Versions and Setting up Standards for SQL Server.

Technical Audits to improve quality of L1/L2/L3 support teams.

Specialized in resolving issues relating to SQL Install/Upgrade failures.

NetEnrich Technologies

Lead DBA May 2012 – September 2012

Environment : SQL SERVER 2000/2005/2008/2008 R2, MySQL 5.1/5.5

Responsibilities:

Managing Team and assigning tasks.

Monitoring work quality and timely response to the client.

Client meetings to understand their requirements and helping them.

Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment and providing the results for their perusal.

Configured of Log shipping as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.

Configured of Mirroring (High Performance/High Safety/High Availability) as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.

Handling Onsite and On-call requests.

24/7 support (Weekends On-Call Support).

Database bifurcation tasks.

Working in Clustered Environment active/active, Active/Passive nodes.

Installation and configuration of MySQL on Windows.

Automating backup jobs on MySQL Servers.

Implemented replication in MySQL on Windows Environment.

Creation of Events in MYSQL to automate the job schedules.

Creation of Users and assigning roles for the same in the MySQL.

Backup and Restore task of MySQL.

KantarITP (Now IBM). Hyderabad

Senior SQL DBA July 2010 – May 2012

Environment : SQL SERVER 2000/2005/2008/2008 R2

Responsibilities:

Handling day-to-day Alert and failures.

Copying data from one table of the instance to another.

Database refresh on a regular basis from Production environment to Dev, QA, and Staging Environments.

Implemented Transactional replication with Updatable Subscription between Singapore and Jakarta, UK and US Servers belonging to different domains (cross-domain Implementation).

Installation and configuration of New SQL Servers 2008/2008 R2 both clustered and stand-alone on VM’s.

Installation of SSIS, SSRS, and SSAS.

Deploying of SSIS packages and creating the jobs for the same.

Deploying of .rdl files in SSRS.

Backups and restore of SSAS cubes.

Monitoring data and log files.

Migration of databases from SQL 2000/2005 to SQL 2008/2008R2 Versions.

Upgrading SQL instances using side-by-side or in-place upgrades

Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment and providing the results for their perusal.

Configured of Log shipping as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.

Configured of Mirroring (High Performance/High Safety/High Availability) as per client requirements as a part of DR strategy and implemented alert mechanisms for any failures of the same.

User creation and assigning roles in all Environments.

Handling Tickets and requests.

Handling Onsite and On-call requests.

24/7 support (Weekends On-Call Support).

Database bifurcation tasks.

Working in Clustered Environment active/active, Active/Passive nodes.

Installation and configuration of MySQL on Windows.

Automating backup jobs on MySQL Servers.

Implemented replication in MySQL on Windows Environment.

Creation of Events in MYSQL to automate the job schedules.

Creation of Users and assigning roles for the same in the MySQL.

Backup and Restore task of MySQL.

Patni Computers Pvt. Ltd. (Now IGate), Mumbai

SQL DBA November 2008–April 2010

Environment : SQL SERVER 2000/2005/2008/2008 R2, MySQL 5.1/5.5

Responsibilities:

Automated and Manual FULL backups of databases on a daily basis on different instances.

Copying data from one table of the instance to another.

Checking the data consistency after loading from DB2 to SQL through SSIS packages.

Taking care of log files and disk space.

Log shipping of databases between the instances and restoring the databases in different environments (DEV, QA, UAT).

User creation and assigning roles.

Creation of Reports and deploying them in Reporting Server.Handling Onsite requests.

Extensively worked on Products and Bundles.

Query tuning for EIM tasks.

Worked on DB2 procedures to make them compatible to MSSQL.

Working on Data Migration related issues with DM Team.

Handled Siebel Admin works like Repository Migration, List of Values, Sales Agent, PDQ, System Preferences, Data Administration - Order Type, Personalization Administration, Audit Trail, Data Maps, Business Services, Business Service Simulator, Workflows, Web Services, State Model, Organizations, Divisions, Positions, Access Groups, Responsibilities, Views, Responsibility - View, Employees exported from DEV Environment and Imported into UAT Environment.

Handling Onsite requests regarding Asset Migration and analyzing data for Data Migration.

24/7 support to the Siebel, BizTalk, and DM teams.

Created SSIS packages to load data from flat files, excel spreadsheets, and DB2 Data Source.

Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment.

Handling Tickets and requests.

Handling Onsite and On-call requests.

24/7 support.

Configured Mirroring in Asynchronous High Performance mode and monitoring and handling the issues related to mirroring.

Database bifurcation tasks. Worked in Clustered Environment active/active nodes.

Neon Technologies Pvt. Ltd., Hyderabad

SQL DBA August 2004–November 2008

Environment : SQL SERVER 2000/2005/2008/2008 R2, MySQL 5.1/5.5

Responsibilities:

Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.

Created DTS Packages to upload test data from Text files. Text files use to come from those locations where caller application is not used.

Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Experienced in Creating SSIS packages to integrate the data coming from various data sources.

Maintaining the jobs Scheduled during the night for the Backup of Databases.

Taking care of the replication between the LIVE servers and the Central Server on an hourly basis.

Supported 24 X 7 production environment.



Contact this candidate