SUMMARY

• Over 7 years of experience in Database Administration and support of MS SQL Server 2008,2008R2,2012, and 2012R2 with strict adherence to ITIL Concepts.
• Extensive knowledge in Installing, Configuration, Upgradation and Maintenance of MS SQL Servers 2005, 2008, 2008R2 in Standalone and Clustered Mode.
• Extensive experience in Installation and Configuration of SQL Server 2008R2/2012/2014 service packs and hot fixes. Proficient in using SQL Server Configuration Manager and SQL Server Surface Area Configuration.
• Extensive Knowledge in Configuring, Installing, and Upgrading Windows Server 2003 R2, 2008,2008R2, 2012 and 2012 R2
• Good Experience in Troubleshooting and Monitoring Windows Server issues on Windows 2003R2, 2008, 2008R2, 2012, 2012R2 Servers
• Good Experience in Configuring Roles like DHCP, DNS, DC and File Server on Windows Servers 2003 R2, 2008,2008R2, 2012 and 2012 R2
• Strong expertise in performing administrative activities like creating User logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups
• Good experience with creating alerts, schema management, database reorganization, data loading, database maintenance and optimization
• Good Knowledge on installation of monthly patches and enhancing the servers security
• Good knowledge in automation of administrative tasks like creating SQL Server Agent jobs, schedules using SQL Server agent and monitoring and troubleshooting these jobs
• Experience in implementing Data Warehousing by merging data from multiple sources and implementing Database recovery strategies
• Expert in configuration and installing disaster recovery high availability solutions like Mirroring, Replication, Fail Over Clustering and Log Shipping
• Master in performing administrative tasks: Database files management, Backup/Restore, Security Management, Data Integration and Synchronization
• Strong expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies
• Expert in Handling of major incident calls which involves engaging multiple teams and carried out the root cause analysis
• Expertise in using DBCC trace flags, handling blocking and deadlock situations
• Excellent documentation skill of standards, routine procedures, issues and resolutions of regular SQL Server activities
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle) agile model as per ITIL Standards
• A well - organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills

TECHNICAL SKILLS

DATABASES: MS SQL Servers- 2008,2008R2,2012 and 2012R2

SERVERS: Windows Servers- 2003R2,2008,2008R2, 2012,2012R2

DATA BASE TOOLS: SQL Server Management Studio, SQL Profiler, SQL Query Analyzer, execution plans, SQL Agents, SQL Alerts, SQL Jobs, Backup Server, Replication server, OLAP Services, Replication Tools.

ETL TOOLS: SQL Server Integration Services (SSIS)

PROGRAMMING LANGUAGES: C,C++, SQL,T-SQL,XML

CERTIFICATIONS: ITIL VERSION 3.0, EXIN

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

Sr. SQL DBA

Responsibilities:

• Installed and Configured SQL Server 2008
• Identified and resolved the query performance using SQL Profiler and Index Tuning wizard.
• Monitored of database size, disk space in all (Production, Model & Development) environments.
• Worked with responsible applications personnel, coordinate testing new releases and upgrades from applications perspective.
• Worked on Log Shipping, Replication to restore Database backup and setting up email alerts on the database for the log file growth and drive space.
• Configured and maintained transactional replication for flow of data from QA and Developer's servers to the replica servers.
• Working with the developers to optimize code if required to minimize the duration and look if the indexes are used appropriately. Also modified database structures as directed by developers for test/develop environments and assisted in coding, design and performance tuning.
• Involved in entire life cycle including database Design, Development, Testing, Optimization, deploying on development and production servers.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Maintained the database with consistency with DBCC Confidential regular intervals and monitoring SQL Server performance using profiler to find performance and deadlocks.
• Creating and managing schema objects such as Tables, Views, Indexes, Procedures, Clusters, Triggers and maintaining
• Created views and stored procedures and optimized them as required by front-end developers for easier implementation on web pages.
• Provided On-Call support on rotation.

ENVIRONMENT: SQL Server 2008 R2, T-SQL, SQL, SQL Profiler, Database tuning Advisor.

Confidential, Houston, Texas

SQL DBA

Responsibilities:

• Database Administration of MS SQL 2005, 2008, 2008R2 and providing support in a 24X7 production environment
• Ensuring that the Daily, Weekly and Monthly jobs are running in the SQL Servers and also troubleshooting the failed jobs in a timely manner
• Configuring Backups and setting up a recovery point as a part of disaster recovery
• Performing Daily checks and troubleshooting the issues which causes performance issues for the databases
• Disk Monitoring and ensuring that there is adequate space for backups
• Creating Database Snapshots for the purpose of creating Management Reports
• Migration of SQL Servers from SQL 20 R2
• Experience in Dimensional Modeling (DM), ER Modeling, Star Schema/Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS)
• Create detailed functional and technical design documentation and develop, document and validate complex business rules vital for data transformation.
• Create Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Involve in writing T-SQL programming for implanting stored procedures and functions for different tasks.
• Using profiler to find badly performing queries and deadlocks.
• Working on Client/Server tools like SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server 2005.
• Designing standards for the database table, column, procedure and views.
• Working 7x24x365 Coverage Production/QA/Development environment on SQL Server 2005, 2008, 2008R2 & proactively monitor and tune Databases and applications for optimal performance.

ENVIRONMENT: MS SQL Server 2005, 2008, 2008 R2, MS EXCEL, T-SQL, SSMS, MS WORD, SQL Job Activity Monitor

Confidential, Alpharetta, GA

SQL DBA

Responsibilities:

• Database Administration tasks for MS SQL Server 2008, 2008R2 and 2012 on a single and clustered mode in production environment
• Upgraded SQL Servers from 2005/2008/2008 R2 to 2012
• Configured Always on Availability groups in SQL Server 2012 for high availability and disaster recovery.
• Configuring Backups using automated scheduled jobs in Job Activity Monitor and troubleshooting incase of any job failures
• Involved in Migrating Data from Oracle to SQL Server using SSIS.
• Involved in Performance Tuning using SQL Server Profiler and some T-SQL Commands.
• Designed, developed and deployed the Packages using Deployment utility using SSIS.
• Handle and Trace the Error using Error Handler.
• Run the package to development or Staging for Starters, and compare the data against the Production data which will run in parallel and made sure the data matches.
• Configure the package using XML and Environmental variables.
• Designed and created the Store procedure, Trigger and Function.
• Designed Cubes using SSAS and deploying on the Production Server.
• Modified and Created Joins to improve the database and execution speed.
• Testing of the Database before deploying the data into the Production server.

ENVIRONMENT: SQL Server 2008/2008R2, 2012, TSQL, SSIS, SSAS, XML, Visual Studio, Windows 7/VISTA/XP

Confidential

SQL DBA

Responsibilities:

• Upgraded SQL Server 2008 to SQL Server 2012 for high volume processing databases on a clustered environment.
• Configured, tuned and optimized SQL Server 2012 and installed necessary Service Packs for SQL 2012.
• Administrated tasks like managing users, roles and permissions.
• Involved in complete database design including conceptual, logical and physical models.
• Loaded stored procedures and user defined functions implemented by the developer teams into the database and tested its performance.
• Traced long running queries and deadlocks using SQL Profiler.
• Involved in Database Backup and recovery and Implemented high availability on the various servers using replication/mirroring.
• Managed security on Production and Development environments.
• Created various SSIS packages based upon the requirements.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Responsible for fine tuning of the database, troubleshooting, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Implemented and tested the point in time recovery of the production databases.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.

ENVIRONMENT: SQL Server 2012/2008 R2, T-SQL, SQL Server Integration Services, Server Reporting Services

Confidential

SQL DBA

Responsibilities:

• Installing and Configuring MS SQL Servers 2008, 2008 R2,2012 and Windows Servers 2008,2008 R2 and 2012
• Troubleshooting of SQL Job alerts and Windows Server Alerts triggered from SCOM Monitoring tool
• Installing and Configuring Windows Server Features like Domain Controller, DNS Server and DHCP Server
• Installing, Configuring and Maintaining SQL High Availability solutions like Mirroring, Replication and Fail Over Clustering
• Installing monthly patches released by Microsoft on all Production Servers
• Maintaining nearly 150 critical Databases to the client and ensuring that the Databases are Backed Up and a valid Recovery Point is set as a part of disaster recovery measures
• Configuring SQL Jobs using SQL Job activity monitor by the use of stored procedures
• Monitored the performance of the SQL Server and the system to identify the hardware bottlenecks, operating system performance, index performance and queries with poor performance using SQL Profiler, Activity Monitor.
• Troubleshooting of ETL jobs and engaging multiple teams for the resolution of the issue and for Root Cause Analysis
• Upgrading the servers from 2008, 2008 R2 to 2012 without effecting the availability
• Managing Permissions and Group Policies using Active Directory Domain Services
• Responsible for updating users for any outages through RM planner tool
• Expert in Handling of major incident calls which involves engaging multiple teams and ensuring that the issue is resolved and the root cause analysis is done
• Providing Data to users by running SQL Queries on the databases
• Mentored seven new members of the Team and ensured that they are familiarized with the project as a part of Knowledge Transfer

ENVIRONMENT: MS SQL SERVER 2008, 2008R2, 2012, Windows: 2008, 2008R2, 2012, 2012R2, T-SQL, SQL Job Activity Monitor, SSMS, SSIS, MS EXCEL, MS WORD