Syam Dondapati

SQL DBA

1-862-***-****

addvg6@r.postjobfree.com

Summary

Over 15+ years of IT experience of which around 12+ years as SQL Server Database Administrator and Developer (Education: Master’s in Computer Applications (MCA))

Administration, Maintenance (24x7) of environment of SQL Server instances (100+) into Production, QA, UAT, DEV

Installation, Upgrade and Migration of SQL Server 2016, 2014,2012 2008 R2, 2008 & 2005

Setup of SQL Server High Availability - Windows Fail Over Cluster Active/Active & Active/Passive on vivid versions of SQL and windows

Setup of SQL Server High Availability/DR using Mirroring, Log shipping and Replication

As a Developer coded stored procedures, functions and views using SQL/TSQL and PL/SQL, SSIS packages

Have strong command over development and connection Oracle databases include linked servers

Performance Tuning and Optimization – Memory, CPU, IO using various methods like extended events, Database Engine Tuning Advisor, perfmon, database Design analysis and query analysis etc.

Installation and Maintenance of SSIS, SSRS and SSAS (SQL Integration, Reporting and Analysis Services)

Installed various patches and done application verification for windows and security patches.

Involved in Change management and Incident handling as per ITIL standard.

Migrated databases to cloud AWS RDS / SQL server on Amazon EC2 also involved in coding terraform scripts as part of automating the procedure.

Migrate, administration and support on databases in AZURE cloud

Have participated various triage calls involving Microsoft, network, storage, server admins and gained good knowledge of the eco system around the SQL Server

Have automated many tasks and user requirements using PowerShell scripting and python

Have utilized various enterprise monitoring tools like Quest – Fog light & SCOM

Certifications:

Microsoft Certified Technology Specialist in Microsoft-SQL Server (70-431)

Implementation & Maintenance. CANDIDATE ID: sr9060471

ITIL V. 3 Foundation

ITIL Service operation

PMI PMP ( PMI ID 1328460 )

DB2 DBA Z/os (Exam Series 730 Candiate id : SR7018991)&

DB2 DBA Linux, UNIX and Windows (Exam Series 731, Candidate id : SR7018991)

Professional Experience

American International Group March 2016- Till date

American Insurance Group known as AIG is one of major market player in insurance domain

Database Administrator and Integrations Services Developer

Administration, Maintenance of SQL Server instances (100+) into Production, QA, UAT, DEV regions

Installation, Upgrade, Migration of SQL Server databases on 2016, 2014,2012 2008 R2, 2008 & 2005

Setup of SQL Server High Availability failover Cluster Active/Active & Active/Passive on WSFC on various versions of SQL Server 2008, 2012,2014 and 2016

Setup and support of SQL Server High Availability/DR using Mirroring, Log shipping and Replication

Support 3 major risk applications which have high visibility and huge complex environment databases

Performance Tuning of SQL Server using various tools and methods like Index tuning, profiler, PerfMon, DTA and DMVs

Migrated databases to cloud AWS RDS / SQL server on Amazon EC2 also involved in coding terraform scripts as part of automating the procedure.

Migrate, administration and support on databases in AZURE cloud

Setup log shipping in AZURE cloud

Installed various patches and done application verification for windows and security patches.

Installation and Maintenance of SSIS, SSRS and SSAS (SQL Integration, Reporting and Analysis Services)

Set up, maintenance and support of Database Snapshot Replication for SQL Server 2012 and 2014 mainly used to propagate the daily files received from external vendors like Moody’s, JP Morgon to various teams from Investments, Risk portfolio

Worked with Dev Ops team to migrate SQL databases from on-premise to AWS EC2/RDS and AZURE Database and ensured that we have the best choice of RDS instances in terms of license cost, CPU etc. and tailored the sizes of instance.

Automated the migration to cloud using terraform scripts

coded stored procedures, functions and views using SQL/TSQL and PL/SQL, SSIS ( ETL ) packages

Performance Tuning and Optimization – Memory, CPU, IO using various methods like extended events, Database Engine Tuning Advisor, perfmon, database Design analysis and query analysis etc.

Automate maintenance and operational tasks through SQL through powershell/python

Utilize Monitoring tool for monitoring and trouble though SQL Alerts, foglight and fog light SQL Optimizer for SQL Server and SCOM

[Tech. Environment: SQL Server 2012,SQL Server 2014, 2016,SQL Server 2008/ R2/2005, SSMS, SSIS, Windows 2008, 2012,2016]

Atos formerly Xerox Corporation July 2011 to Feb 2016

All the Allscripts (Major healthcare IT provide) SCM applications use Microsoft as platform form, so as the back end - Sql Server 2005/2008 (R2 )/2012/2014 servers are used. Our team supports hosting of 500 + servers and manages all the database related requests like user access, reports, manage their production, training, development & Testing environments

Systems development senior Specialist

Administration and maintenance of SQL Server Instances into PROD-QA-DEV-DR and MSBI environments

Installation, Upgrade, Migration of SQL Server2014, 2012 2008 R2,

Setup of Active / Passive Failover Cluster with SQL Server 2012 and Windows Server 2012

Setup of log shipping, Mirroring, Replication, AlwaysOn, Disaster Recovery planning and procedures

Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs

SQL Server upgrade and migration from version 2005 to SQL Server 2008 and SQL Server 2012

Using scripting (power shell) for automating tasks, reports and monitoring scripts through centralized management server

Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore)

Database consistency checks using DBCC

Implemented organizational naming conventions through policy based management

Identifying and tuning TQL queries and stored procedures that heavily using CPU and IO resources.

Performance Tuning and Optimization – Memory, CPU, IO using various methods like extended events, Database Engine Tuning Advisor, perfmon, database Design analysis and query analysis etc.

worked on EMC Time finder

Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs.

Development and deployment SSIS packages in BIDS and Visual Studio

Database refreshes from production backup to non-production servers.

Participated in Sev1/ Bridge calls

Working with resources around the globe (USA, Canada, Mexico & India

[Tech. Environment: SQL Server 2012, SQL Server 2008/ R2/2005, SSMS, SSIS, Windows 2008, Windows 2012]

All scripts (Formerly Eclipsys), April 2008 to July 2011

Senior Database Administrator

Allscripts is a leading provider of advanced integrated clinical, revenue cycle, and access management

software, clinical content and professional services that help healthcare organizations improve clinical,

financial, and operational and client satisfaction outcomes.

Administration and maintenance of 500+ SQL Server Instances into PROD-QA-DEV-DR environments

Discovery, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes

SQL Server upgrade and migration from version 2005 to SQL Server 2008 and SQL Server 2008 R2

Managing user creation and providing permission as per user’s requirements.

Troubleshooting performance issues using Blocker Scripts, SQL Trace, Error Logs and Event Logs

Performance and Tuning, Query Optimization using SQL profiler, DTA, PefrMon, DMVs, DBCC and SSMS

SQL Server and database upgrade from version 2005 to SQL Server 2008 platform

Setup of jobs and alerts for Backup Restore, re-indexing, integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes

Used database maintenance plans for checking database consistency

Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs

Extensively worked on Active-Active and Active-Passive Clustering.

Implemented In-place and Side by Side Migration of MS SQL SERVER 2000/2005 to and 2008.

Install and configure Master Data Services

Expertise in diagnosing and tuning the server optimal performance using SQL Server Dynamic Management Views (DMV).

Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.

Use Data Collector to collect different sets of data with integration to SQL Agent and SSIS

Query optimization using Show Execution Plan, SQL profiler, System Monitor and Query analyzer

Setup, monitoring and maintenance of SQL Server data Replication

[Tech. Environment: SQL Server 2008/2005/2000, SSMS, Windows 2008/2003]

Tech Mahindra Pvt Ltd, India Sept 2005 to September 2007

Technical Associate

M204 to CICS-Db2 Migration for AT&T, USA . This project basically deals with conversion of M204 based application to CICS-DB2 based system. This conversion includes

Logical and physical database design

Conversion of Java code to COBOL code.

Binding of CICS COBO DB2 code

Conversion of M204 Database to DB2 database

Conversion of M204 & IMS Screens to CICS Maps

Participated in weekly IT status update meetings.

[Tech. Environment: TSO, ISPF, JCL, CLISTs, FileAid, z/OS utilities]

Education Qualification

Master of computer applications, “Sri Krishna Devaraya University”,Anantapur, AP India 2004

Bachelor of sciences (Mathematics, Physics Chemistry), “Acharya Nagarjuna University”, Guntur, AP, India 2000

Contact this candidate