Nagaraju Immadi

Mobile: 407-***-**** Email: acq8t9@r.postjobfree.com

SQL Server DBA with 6+ years of experience in Database Administration, Design, Development, Security and Support of MS SQL Server 2012/2008,2005,2000 and in Production, Testing, Development, Replication & Cluster Server Environments

SUMMARY:

•Experience in Installation, Configuration, Backup and Recovery process of MS SQL Server and databases per environment requirements.

•Experience in setting up Monitoring and troubleshooting of Database Mirroring, Log Shipping, Replication.

•Experience in Setting up Failover clustering (active/passive) and Monitoring and troubleshooting the clusters in Production and Preproduction Environments .Knowledge of Web store for maintain the clusters.

•Experience in Performance Tuning, Disaster Recovery, troubleshooting, backup, restore procedures.

•Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.

•Tuning SQL queries and analysis of indexes for improving the performance and optimization of the Databases

•Experience in administering SSAS instances, backup of olap databases and troubleshooting

•SSIS package design, deployment and administration

•SSRSdesign, deployment and administration

•Creation and maintenance of Databases, Roles and managing user permissions for database integrity

•Experience in tuning, monitoring, maintaining & scheduling SQL Server Jobs, alerts and automating them.

•Monitoring and troubleshooting with help of Event viewer, SQL Error logs and Log File Viewer for resolving the production incidents to keep the system up and running.

•Experience in handling CPU usage issues, log space issue and space projection scenarios of databases on MS SQL servers

•Experience in creating DR site for existing production environment using log shipping and mirroring and transactional replication

•Experience in Installation, Configuring, Deploying, Troubleshooting and maintenance of Web Applications in IIS 6.0/7.0 using Windows Server 2000/2003/2008/2012.

•Experience in configuring multiple App pools, and scheduling App pools recycling for greater performance of web applications

•Experience in managing and troubleshooting DNS, WINS, TCP/IP and DHCP Servers

•Knowledge of PowerShell scripts to automate daily administrative tasks

•Experience using data modeling tools like SQL Diagrams, Microsoft Visio, and Erwin.

•Worked on Windows 2012/2008/2003/2000 servers laying the latest Win OS through imaging servers for setting up as new servers and repurposing

•Involved in upgrading the environment to the latest patch levels for better performance and taking advantage of latest features of Windows and SQL Server

•Worked on SCOM 2012 by installing Management packs, SCOM Agents. Monitored daily alerts related to Server availability, Disk Space utilization, Service availability

•Ability to handle situations under stressful conditions gave support 24/7 on call for resolved production incidents and priority issues

Technical Skills:

Operating Systems

Windows*, Unix, Linux.

Databases

SQLSERVER *, MS Access, ORACLE 10g

Database Tools

Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, BIDS, Oracle 10g

ETL Tools

SSIS, SSAS, SSRS

Languages/Utilities

TSQL, SQL, PL/SQL, Db2, C, C++, Perl

Data Modeling

Erwin 3.5/4.0,Silver light

Architecture

Relational DBMS, Client-Server Architecture, Clustering, Replication, OLTP

EXPERIENCE:

Client: MasterCard, NY

Position: SQL Server DBA Duration: Feb’13- Present

Responsibilities:

•Working on the SQL Server 2012/2008/2005 instances in production and pre-production servers

•Working on day-to-day tactical break/fix and troubleshooting issues related to SQL Server production

Production systems

•Maintaining backups (including tape library) and backup strategy

•Performance troubleshooting and tuning (SQL Server, web services, etc.)stored procedures and SQL queries

•Upgrading SQL Server systems to latest service packs. Worked on upgrading the systems to SQL 2012, SP1 and CU2.

•Break/Fix tasks, restoring service to systems within SLA, communicating to customers if SLA is at risk

•Involved in Setting up of disaster Recovery Site in a datacenter and migration of databases from one datacenter to another.

•Granting access to internal tools and databases and managing the Security by creating Security groups adding users to them appropriately

•Monitoring production databases to investigate and resolve alerts related to server availability, performance, capacity, etc.) And if required escalated them by creating bug to the development teams.

•Analysis and implementation of OS Patch upgrades, Service packs upgrades, etc. every month to keep the servers up-to-date on the patch level for better performance

•Extensively worked on setting up Mirroring, Log shipping and Replication and Always on in Prod and Non-prod Servers

•Involved in Data center migration

•Created, scheduled database maintenance plan using SSIS Maintenance plan task.

•Configured and deployed and supported SSIS Packages and migrating from preproduction to Production Environments.

•Created,deployed and managed reports usingSQL Server ReportingServices(SSRS)

•Migrating database objects from preproduction to production environment.

•Extensively worked on Profiler, Net Mon Perfmon, DMVs, and DTA for troubleshooting and tuning the databases

•Experience in planning and implementing Disaster Recovery solutions, Backup/Recovery strategies, Performance Analysis etc.

•Worked on SCOM 2012 by installing Management packs, SCOM Agents. Monitored daily alerts related to Server availability, Disk Space utilization, Service availability, URL availability on Site scope and SCOM Servers.

•Used DMVs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes etc. for query/stored proc tuning. Extensively involved in Index tuning.

•Used Backup Compression and Data compression in SQL Server 2008 on clustered environment.

•Involved in Database Refresh and patching security updates on SQL server 2008/2012.

•Created and scheduled Database Maintenance plans for Database Consistency checks, Index Rebuild/Reorg/Update Statistics etc.

•Worked with Monitoring and Management Team setting up server monitoring and alerting for the production and pre-production servers.

Client: Nvidia, CA Duration: 08/2010 to Feb/2013

Title: SQL Server DBA

Responsibilities:

•Installation of SQL Server 2008 Enterprise Edition with Service Pack1 and configured and maintained MS SQL Server 2005 Enterprise Edition (64 Bit) with Service Pack3.

•Efficiently handled production environments with more than 60 servers, Databases ranging 15GB –1.5TB.

•Created new logical and physicaldatabase design to fit new business requirements and implemented it to the SQL Server 2008.

•Implemented Database mirroring in SQL 2008/2005.

•Monitored growth of data and managed space allocation accordingly, Installed and configured Log Shipping for production servers.

•Created Database Maintenance Plans for Re-indexing, Database Integrity Checks, Shrink Database.

•Developed Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications.

•Performed Resource Governor In SQL 2008.

•Implemented table partition on very large table.

•Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction

•Implemented and Monitored 2-Node Active\Passive SQL Clustering to provide High Availability for production and non-production systems

•Implemented ReplicationTransactional type for the use of reporting server.

•Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing using DBCC commands.

•Ensured integrity of data maintained through security, documentation, and change management.

•Created and managed schema objects tables, views, clustered indexes, procedures, and triggers and maintained Referential Integrity of the databases.

•Run daily analysis reports including branch sales reports, productivity reports, and transportation reports.

•Created jobs and alerts for monthly and weekly maintenance.

•Tuning the Production server to get performance improvement by using SQL Profiler and index tuning wizard also by reviewing disk configuration and storage allocation.

•Creation and maintenance of Databases, creating roles and managing user permissions, resolving Blocking and deadlocks.

•Monitoring the status of scheduled jobs for Backup and Restore.

•Monitored SQL server and Application logs for resolving the alerts in production and preproduction servers.

•Created operators and alerts in getting notifications and assigned permissions to the Users in appropriate Roles.

•Used power shell scripts to automate server administration

•WroteSSIS Packages to migrate users, logins, stored procedures, and tables

•DeployedSSIS Package to MSDB as well as File System depending on requirement.

•Created and Deployed reports using Microsoft Reporting Services (SSRS).

•Migrated DTS packages from SQL Server 2000 to SQL Server 2008/2005 as SSIS packages.

•Experience in connecting to remote SQL Servers as Linked Servers and troubleshooting related.

Client: Pfizer, NY Duration:07/2008to07/2010

Title: SQL Server DBA

Responsibilities:

•Installation, configuration and Setup of SQL Server 2005/2000 on Windows 2003/2000

•Involved in complete life cycle of database, which includes designing of database, Populating lookup data, Creating Stored Procedures as per front end developer’s requirement and commercial transitions, writing Triggers, creating user defined functions and created Views to simplify the complexity of the data structure.

•Upgraded databases and objects from 2000 to 2005.

•De-normalized some tables that used lots of computations and joins

•Maintained integrity constraint to facilitate consistent data entry into the database by creating check constraint, triggers

•Imported / Exported data to SQL Server using DTS.

•Worked with SQL Profiler for tracing, auditing and PerformanceTuning and routine DBA/DEVELOPER activities like Query Optimization& effective SQL Serverconfiguration for better performance and cost reduction.

•Identified the performance bottlenecks like CPU, Memory, I/O and tuned and improved the overall performance of the server by 40- 70%.

•Imported data from many different platforms to SQL Server using Data Transformation Services (DTS) and SSIS.

•Checked Database Consistency using DBCC Utilities commands

•Created, maintained and executed and scheduled SQL server jobs

•Implemented all the ServicePack changes to the system service pack levels

•Successfully implemented backup procedures and scheduled maintenances for the databases.

•Designed recovery strategies and test planed for transactional database replication.

•Configured Log shipping for databases to keep a warm stand by server ready

•Worked in a 24x7 productionsupport DBA/DEVELOPER on weekly rotations.

Education:

B.Tech from JNT University, A.P, India.

Contact this candidate