Chaitanya Dadi

Email : acr2ok@r.postjobfree.com

Phone : 972-***-****

_

OBJECTIVE:

Seeking an exigent position as a SQL Administrator that best utilizes my skills in Database

servers

_

PROFESSIONAL SUMMARY

Over 8+ years of focused IT experience in SQL Server Database Administration and

Development experience on very large and complex databases in SQL Server

2000/2005/2008/2008R2/2012/2014.

Expertise includes Administration, Database Design, Performance Analysis and

Production Support for Large Databases up to 5 TB.

Extensive experience with configuring high availability and Disaster recovery scenarios

like SQL Always-On, Clustering, Replication, Log shipping and mirroring.

Experience configuring all types of Replication (Transactional, Snapshot and Merge)

Implemented new feature of MS SQL Server 2012 Always-On with synchronous and

Asynchronous secondary.

Expertise in configuring two node and multi node clustering (Active-Active / Active-

Passive) on multi subnets.

Experience in implementing new features of SQL Server 2008 like Policy Based

Management, Resource Governor, Data Collector sets and Backup Compression

Techniques.

Good experience in resolving SQL Server blocking and Dead Lock Issues.

Expertise on Powershell scripts for automating tasks and process for end to end

automation using different embedded technologies like .net, WMI, different Adaptors etc.

Expert in Performance Tuning using windows Performance counters, data collector sets,

DMVs and Profiler.

Experience working with server side trace.

Expertise in reading and understanding execution plan and fixing queries to improve

performance.

Worked in integrating TFS with Visual Studio 2005 & 2008

Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery,

Backup and Restore Procedures.

Experience in creating SQL maintenance plans and configuring SQL Mail for alerts .

Worked extensively on Clustering and server consolidation.

Experience in installations and instance patching.

Experience doing Point In Time restores and recovering system databases.

Experience using SQL Server 2008 new features like Policy Based Management, Data

Compression, Resource Governor, Performance Data Collector and Transparent Data

Encryption (TDE)

Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot

isolation, database snapshot, DDL triggers, try-cache blocks, online indexing,

DMVs, DMFs, Mail Setup, Jobs, and Alerts, SQLCMD.

Creating and managing of multiple Linked Servers between SQL Server 2008 R2 &

Oracle 9i and 10g with all required accessibility for Data pull through SQL Jobs.

Proficiency and expertise in migrating Databases from SQL Server one SQL version to

another using various process like Backup/Restore; Detach/Attach, import/export.

Experience in Data Modeling (Logical and Physical Design of Databases),

Normalization of Databases and building Referential Integrity Constraints.

Experience in using SQL DMVs for finding the resource bottlenecks.

Creation and maintenance of Databases, creating Roles and managing user permissions.

Experience in SQL Server Reporting Services (SSRS).

Experience in creating cubes using MS SQL Analysis Services. Developed star and

snowflake schemas.

Experience migrating DTS to DTSX SSIS packages and also creating packages for data

load in to data warehouse environments.

Worked with Third Party tools like SQL Lite speed, Erwin, Lite Speed, Fog light and

Red

Experience on disaster recovery planning and implementing Security Management

operations

Experience with Storage Area Networks (SAN) and utilizing SanDisk space in a

Windows Environment.

Experience working on physical and virtual windows environment ( Hyper-V and

VMWare)

Thorough Understanding of different RAID levels implementation.

Documented Disaster Recovery plans and participated in disaster recovery drills.

Provide 24/7 production support for mission critical systems

TECHNICAL SKILLS:

Operating System: Windows 2000/2003/2008/2012 Server, Linux, Solaris, Unix

Databases: MS SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, Oracle 8i, 9i,

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio

2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor,

SSIS, SSRS, SSAS, Microsoft Clustering Services (MSCS), Visio

Programming: T-SQL, PL-SQL, C, C++, Perl

Third Party Tools: Lite speed, Redgate, Tivoli, Idera, Foglight, Avamar, Guardium, CommVault,

Service-Now, KA Lite.

EDUCATION:

Bachelor of Technology in JNTU, India.

PROFESSIONAL EXPERIENCE:

Informa, New York, NY Apr 2013 Till Date

Sr. SQL Server DBA

Description: Currently working as a Sr. SQL Server DBA, for Informa, on multiple SOA based

projects which provide Drugs & Trial information to the subscribers. A total of four web-based

applications called Sitetrove, TrialTrove, PharmaProjects & TrialPredict, collectively provide

this information, which is entered by hundreds of editorial team members through a window-

based back-end tool called Jedi. All these applications have been build using the latest .NET

technologies & SQL Server 2012.

Reference: https://citeline.com

Responsibilities:

Installation, managing and troubleshooting SQL Server 2014, 2012, 2008R2, 2008, 2005

instances.

Configuring ALWAYS-ON HADR setup between on Multi Subnet Cluster, in which 2 nodes

sitting in New York and 3rd DR node sitting at Houston.

Setup SQL 2012 with Always-On availability group for my databases in sync and secondary

readable mode. I completed failover tests with sync mode and it is functioning as expected.

Configuring and Managing Transact replication and Database Mirroring.

Extensively using DMVs to fix the performance issues on production systems.

Migrating 2005 SQL servers to 2012 and also 2008 R2 SQL servers to 2012 with minimal

downtime.

RAID level suggestions for storage team to improve database performance.

Configure multimode clustering (Active-Active and Active-Passive) on physical and virtual

machines.

Migrating SQL instances on VMWare to Physical boxes for performance improvement.

Creating Jobs and Schedule them for execution on Daily, Weekly, and Monthly bases.

Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO

and RTO solutions based on requirements.

Responsible for monitoring and making recommendations for performance improvement in

hosted databases.

Capacity planning all the databases beforehand.

Periodically checking the health of the servers and providing recommendations.

Performance tuning and monitoring of databases, data archiving and purging, troubleshooting

and management of production databases and disk space management.

Export or Import data from other data sources like flat files using Import/Export through SSIS.

Analyzing long running/slow queries and tune the same to optimize application and system

performance.

Upgrading of SQL server software 2005/2008/2008 R2 to 2012

Designing and creating backups & recovery strategy.

Implement and manage SQL Azure database for cloud server

Working with customers on Application rollouts and server migrations.

Perform SQL Server service pack and Windows Service pack upgrades.

Designed and implemented comprehensive Backup plan using Lite Speed.

24*7 Production support

Georgia Dept. of Transportation, Atlanta, GA Oct 2011 - Mar

2013

Sr. SQL Server DBA

Description: Under the leadership of Commissioner, the Georgia Department of Transportation

(Georgia DOT) plans, constructs, maintains and improves the state's roads and bridges; provides

planning and financial support for other modes of transportation such as rail transit, airports and

air safety planning.

Responsibilities:

Manage and administer SQL server 2005\2008\R2\2012 servers.

Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.

Deployment of databases, jobs, cubes from pre-production to production.

Imported Oracle data bases ODBC into SQL through linked servers.

Monitored Oracle DBAs along with the SQL DBAs in a team.

Building SQL 2008\R2 cluster environments on VMware or Physical windows

Performed installations of SQL 2008\R2\2012 on clustered and standalone servers

Up gradations of SQL server versions and applying patches and hot fixes.

Adding nodes to already existing clustered servers as a part of data load\High availability

Configured Transactional Replication and Log Shipping with SQL Server

Management

Implementation of SQL server logins, Roles and Authentication modes as a part of

security policies.

Use of Idera tools for Performance monitoring and Backup/Restores.

Work on weekly Issues reports which are generated as a part of infrastructure setup.

Continuous monitoring server health using Idera tool

Creating and scheduling maintenance plans for updating statistics, checking

fragmentation, checking database integrity and backup plans

Configured Database mail, linked servers, Transparent Data Encryption (TDE) and

Auditing.

Extensive hands-on experience with MSSQL Server upgrades/migrations and VMWare

environments.

Performance tuning of databases by windows performance monitor and SQL Profiler

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Documenting the standard procedures on regular basis.

Working on tickets\incidents with in the SLAs, as a part of operations support DBA

Conducted various meetings and conferences with application teams to meet corporate

milestones for database consolidation and data migration

Resource planning and coordination for application migrations with project managers,

application and web app teams

Involved in capacity planning, sizing and database growth projections. Worked with

Data warehousing team in VLDB environment for archiving the old data

Worked in an environment with Change management process (Service-now tool) in place

for all kind of production and nonproduction changes

24*7 on call production support.

Pacific Life Insurance Co, Newport Beach, CA May 2010 - Sep 2011

SQL Server DBA

Description: Pacific Life Insurance Company is an insurance company providing life

insurance products, annuities, and mutual funds, and offers a variety of investment products and

services to individuals, businesses, and pension plans

Responsibilities:

Install and configure SQL Server 2005/2008R2.

Hands on experience in Performance issues and troubleshooting database issues.

Designed and implemented comprehensive Backup plan and disaster recovery

strategies.

Migrated DTS packages from Legacy system to SQL SERVER 2005.

Created and Maintained jobs, alerts and Maintenance plans.

Upgrade 2000, 2005 SQL instances to SQL 2008 R2 and document the issues

Configure SQL 2008 R2 Active-Active and Active-Passive clustering

Setup Transactional Replication and troubleshoot issues encountered.

Implementation of SQL server logins, Roles and Authentication modes as a part of

security policies.

Created Database Maintenance Plans for the Performance of SQL Server which covers

Database Integrity Checks, Update Database Statistics and Re-indexing.

Extensively worked to implement Database mirroring, configured Principal, witness

and mirror using the SQL SERVER 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services

(SSRS).

Performance Tuning, Analysis and optimizing for SQL Server Application by using

performance monitor.

Assist the SQL Developers in SQL tuning.

Involved in writing T-SQL Programming for implement Stored Procedures and

Functions for different tasks.

Documenting all the issues encountered.

24*7 on call production support.

SunTrust bank, Atlanta, GA Nov 2009 - Apr

2010

SQL Server DBA

Description: SunTrust Banks, Inc. is an American bank holding company. The largest subsidiary

is SunTrust Bank. It had US$175 billion in assets as of December 31, 2013

Responsibilities:

Managed and Administrated the SQL Server 2008/2005/2000 production and Non-

production servers.

Involved in the migration of SQL Server 2000 databases to SQL Server 2005.

Responsible for monitoring and making recommendations for performance improvement

in hosted databases.

Evaluated data storage considerations to store databases and transaction logs.

Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning,

Error handling through TRY-CATCH statement, Common Table

Expression (CTE), Data Partitioning, Snapshot Isolation.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like

SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and

Database Engine Tuning Advisor.

Created Database Maintenance Plans for the performance of SQL Server, which

covers Database Integrity checks, update database Statistics and Re-indexing.

Developed and optimized database structures, stored procedures, Dynamic

Management views, DDL triggers and user-defined functions.

Identified, tested and resolved database performance issues (monitoring and tuning) to

ensure data optimization.

Involved in trouble shooting and fine-tuning of databases for its performance and

concurrency.

Managed trouble shooting of Client connections, viewing error log and applications.

Developed automated backup and DBCC scripts for databases and transaction logs.

Maintaining the database consistency with DBCC utility at regular intervals.

Worked on log shipping for synchronization of database.

Authenticated logins and validated permissions.

Writing stored procedures, triggers, and functions and maintained coding standards.

Involved in database Normalization, logical and physical data modeling

Transferred data (ETL) to Data warehouse Environment using SSIS.

Design and Development of SSIS Packages to load the Data from various Databases

and Files.

Karvy Consultants, Hyderabad, India Sep 2007 to July 2009

SQL Server Developer/DBA

Description: The Karvy group was formed in 1983 at Hyderabad, India. Karvy ranks

among the top player in almost all the fields it operates. KarvyComputershare Limited is

Indias largest Registrar and Transfer Agent with a client base of nearly 500 blue chip

corporates. The other fields are Karvy Stock Brokers Limited, Karvy insurance Brokers,

Karvy realty services and Karvy Global.

Responsibilities:

Involved in installation and configuration of SQL Server 2000/2005.

Maintained the nonproduction Database Environment.

Created Security, Roles and Permissions to users.

SQL Server optimization, DBCCs, debugging scripts and automating DBA tasks.

Managed the Data Migration from SQL Server 7.0 to SQL Server 2000.

Analyzed data requirements and participated in design reviews.

Mentoring and knowledge sharing on database activities.

Documented business rules and logic.

Automated administrative tasks knowledge transfer of database.

Involved in creating cubes using Analysis Manager.

Migrated all the test environment objects into Production database and maintained high

availability of the database.

Involved in Performance Tuning and Query Optimization.

Monitored the event logs and server error logs for troubleshooting.

Identified the bottlenecks and troubleshooting them for optimal performance.

Contact this candidate