SUMMARY:

• 5+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005 in OLTP and OLAP environments.
• Microsoft Certified Database Administrator (MCDBA) and Microsoft Certified Systems Engineer.
• Experience installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014, updating with hot fix and service packs.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non - prod environments.
• Handful experience and knowledge on High availability (HA) &Disaster recovery solutions (DR) - Log Shipping, Mirroring (High safety, High performance & High availability), Replication (Snapshot, Merge, Transactional & Peer -to- Peer), Clustering (Active-Passive &Active - Active) and Always ON (One Primary and 2 secondary replicas).
• Implemented in place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012, 2012 to 2014.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Knowledge of PowerShell scripting.
• Experience in using the DMVS, DMFS, SP PROC’s, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization.
• Setup and maintain High-Availability and Disaster Recovery solutions in MSSQL using Log shipping, Mirroring, Replication.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Design indexing, referential integrity, constraints, data types, database objects like tables, views, indexes, stored procedures, triggers.
• Worked in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
• ITIL Process implementation (Incident/Problem/Change/Release Management).
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Work with application teams to define database object referential integrity.
• Handling Memory configurations for SQL Server 2012, 2008 and 2005 on Windows 2003 Server.
• Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, and Updating Statistics.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Worked on Repositories like Team Foundation Server (TFS).
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Diagnose and resolve performance issues, connectivity/security issues and database corruptions in a critical production environment.
• Experience in using DMV and DBCC commands for various performance issues.
• Used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transactions, login and database action and removing orphan users.
• Experience with MySQL.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Perform MSSQL database setup, database upgrades, space management, backup & recovery.
• Experience in creating SQL Server Reports using SSRS 2005 and 2008, 2012.
• Experience working with Change control process/Change management.
• Experience with working in Data Ware house.
• Strong experience working with team members, documentation and 24/7 on call production support. 24*7 Production support experience.

TECHNICAL SKILLS:

Languages: Java 1.2-1.6, J2EE, XML

App. Servers: Web Sphere and JBoss

Java Technologies: Core Java, J2EE (JSP, Servlets), JDBC, Struts, Spring Framework

Data Base: Sybase, Oracle, and MySQL

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script, Shell, Sybase

Operating Systems: Windows 95/2000/2003/2008/2008 r2/2012/2012r2/XP/VISTA/7, Sun Solaris 9, VMware

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 10g/11g, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer, Toad 8.0 version

Application Software: Visual Studio 2005/2008/2012 , Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin

Other Tools: Lite Speed, Red gate, Toad, Remedy, Jira Board.

PROFESSIONAL EXPERIENCE:

Confidential, Perrysburg, Ohio

SQL Server DBA

Responsibilities:

• Manage and administer SQL server 2012/2014 servers.
• Worked on production, and test server.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Using 3rd party tool Red Gate.
• Performance optimization Update statistics
• Worked on Agile Methodology.
• Exposure to always on.
• Created Backup strategies and scheduling them as a part of database maintenance plans.
• Scheduling and maintaining back up jobs
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Monitoring SQL server performance using profiler to find performance and deadlocks.

Environment: MS SQL Server 2012/2014, Windows 2003/2008R2/2012, SSIS, MS Access, Red Gate.

Confidential, NC

SQL Server DBA

Responsibilities:

• Manage and administer SQL server 2000\2005\2008\R2\2012\2014 servers.
• Maintaining SQL agent jobs.
• Experience in writing DDL, DML statements, Indexes, Partitioning.
• Provided RAID level suggestion for data files, log files and temp dB drives.
• Used Index tuning wizard for optimal query performance.
• Worked on both production and development environment.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Experience in creating SQL Server Reports using SSRS 2005 and 2008, 2012.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Worked on different type of backups like full backup, differential and transactional.
• Worked with T-SQL development and performance tuning in T-SQL code.
• Participated in Performance Tuning of Code using execution plan and SQL profiler.
• Added Indexes to improve performance on tables.
• Used multiple join statements to retrieve data from multiple tables.
• Experience with Data Migrations using SSIS, BCP.
• Configuring and implementing SQL Server contained database.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• 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.
• 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.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Deployment of databases, jobs, cubes from pre-production to production.
• Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers.
• Upgradations 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
• Worked with LDAP.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Continuous monitoring server health with Idera monitoring tool.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Configured Database mail, linked servers.
• Extensively worked on Transparent Data Encryption (TDE) and Auditing.
• Performance tuning of databases by windows performance monitor and SQL Profiler.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Working on the Performance of the Stored Procedures.
• Working on JIRA as project management tool.
• Mentoring junior team members and creating documents on daily basis.
• 24* 7 on-call production support.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, JIRA, PUMA

Confidential

SQL Server DBA

Responsibilities:

• Installation and configuration of MS SQL Server 2008/2008R2.
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler to find the resource bottlenecks.
• Resolve locking and blocking issues.
• Refresh non-prod environments with production data on regular basis.
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
• Used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Used log shipping for synchronization of database.
• Experience in writing DDL, DML statements, Indexes, Partitioning.
• Provided RAID level suggestion for data files, log files and temp dB drives.
• Used Index tuning wizard for optimal query performance.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2008 for faster execution and developed database structures.

Environment: MS SQL Server 2008/2005, T-SQL, MySQL, Windows NT/2000/2003