SUMMARY

• Over 7 years of experience in IT and 6 plus years in Database Administration and Developer for very large and complex databases in SQL Server 2012, 2008 R2, 2008, 2005 and 2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Worked on SQL Server 2012 Migration from SQL Server 2008R .
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Troubleshoot performance problems, fine - tuning of databases and index Analysis.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Working knowledge in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services (SSAS) and Reporting Services (SSRS).
• Implemented different types of Replication models like Transactional and Snapshot.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types, Cursors and functions.
• 24 X 7 Production Database on Call Support
• Worked on importing data from MySQL to SQL Server.
• Strong experience in mentoring team members and writing documentation.
• Worked on logical and physical data base modeling with UML and ERWIN tools
• Worked on Jira, BMC, RFC, Virtual Ticket & Service Now ticketing system software’s.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005, 2000.SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, Quest Spotlight, RML Utility, MS Visio, SSRS, SSIS, SSASProgramming Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA: database administration of SQL Server 2012, 20082, 2008, 2005, 2000

Operating System: Windows 2008/2003/2000 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL LiteSpeed, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2012/2008R2/2008/2005 Servers in Production, QA and UAT Environments.
• Migrated SQL Server R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Performed Backups and restores on regular basis for Migration and other purposes.
• Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
• Worked with tickets like RFC’s for prod/UAT changes and VT’s for QA/DEV servers.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in using SQL Profiler to identify slow running queries and stored procedures, least and mostly used stored procedures.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and indexing updates.
• Worked in Microsoft Cluster Services (MSCS), including Active/Passive, Active/Active, and Network Load Balancing clusters.
• Database refreshes from prod to stage, test and development environments.
• Provided 24/7 on-call support on rotation basis for production database.
• Creating Logins and Roles with appropriate permissions.
• Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
• Solved issues related to server performance and disk space.
• Rebuilding the indexes at regular intervals for better performance.

Environment: MS SQL Server 2012/2008R 2/ 2008/2005/2000 , Visual Studio 2010/2005, SQL Lite Speed, Microsoft Visio 2003, SFTP and Windows Server 2003/2000.

Confidential, Topeka, KS

SQL Server DBA

Responsibilities:

• Performed migration of servers from SQL Server .
• Monitored replication and configured servers for Publishers, Subscribers, and Distributor for Marge and transactional replication.
• Tuned T-SQL code using optimization techniques to improve query response time.
• Rebuilt indexes at regular intervals for better performance.
• Involved in designing the databases using Erwin.
• Detached database from Sql server 2005 and attached to Sql Server 2008 using SSMS.
• Setting up a QA Environment with SQL Server 2005/2008 Database Server for the complete application testing.
• Involved in configuring Microsoft Cluster Service (MSCS), and review network, security, and considerations for other software that will run on the failover cluster.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Involved in implementing Marge and Transactional Replication.
• Defined constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc), rules and defaults.
• Data migration from Text to SQL Server using BCP command line utility and Bulk insert.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Participated in testing and debugging of SQL queries.
• Created Service Broker Programs to continuously load data from the mirror database to the report database.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Implementation of fail over clustering on warm stand by servers and raid 1 - 5 technologies.
• Created SSIS packages to pull data from Oracle to Flat Files and Excel.
• Generated different reports using MS SQL Reporting Services.
• Analyzed the requirements and selected the appropriate Fact tables/created Fact tables and Dimension tables.

Environment: MS SQL Server 2008/2005/2000 , Windows 2003/2000/NT, SQL Profiler, SQL Server Management Studio SSIS, SSRS, Database Tuning Advisor, Service Broker, Raid, Oracle 9i,BCP Utility, Excel .

Confidential, Overland Park, KS

SQL Server DBA

Responsibilities:

• Replicated SQL servers handling thousands oftransactionsper day with 24/7 uptime to service clients.
• Actively involved in Creation of database, modified tables, triggers, andstore procedures to clean and validate the data to meet the company specifications.
• Independently upgraded all the servers from MS SQL Server 2000 to MS SQL Server 2005.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Used BCP utility to publish table output to text files.
• Implemented Constraints on tables for maintaining Data Integrity.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Participated in testing and debugging of SQL queries.
• Created distributed partitioned tables, partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.
• Implemented day-to-day operations such as database creation, monitoring disk space, monitoring performance using Profiler, implementation, testing, maintenance, and troubleshooting of software applications.
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Environment: T-SQL, MS SQL Server 2005/2000/7.0 , BCP utility, DTS, Windows 2003/2000/NT, Sybase, ERStudio.

Confidential, Dayton, OH

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 and apply service packs, hot fix and clustering installation.
• Database Administrator, Database Programming.
• Installed and managed multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Responsible for writing & Editing Stored Procedures, Triggers, Views, Tables & T-SQL Scripts.
• Deploying new code base release to UAT and Production Environments.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Worked with change management and change control procedure.
• Converting DTS packages into SQL Server 2005 Integration Services
• Solved issues related to server performance and disk space.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Managed the multiple databases (DB) under EMC drives clustered (active/active, active/passive) and also involved in Capacity Planning.
• Support Development team in deploying and testing the application.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks or network latency.

Environment: Microsoft Windows Server 2000/ /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Create Database Objects like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases .
• Rebuilding the indexes at regular intervals for better performance.
• Manage replication and database modifications for replicated objects.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Design, document and implement SSIS packages and stored procedures.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: Windows 2003 Server, SQL server 2005/2000, Event Viewer, SQL Profiler, T-SQL.