SUMMARY

• 8 years of IT experience in SQL Server Database Administration, Design System Analysis, Testing, Development and Support of Microsoft SQL server 2014,2012, 2008R2/2008, 2005 in PRODUCTION, DEVELOPMENT, QA and UAT Environments.
• Experience in database administration and development activities like Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Disaster Recovery, Performance tuning and Query Optimization, Data Transformation Services, Database Security and Patching SQL server.
• Experience in applying latest Service Packs and Rolling Patches and Upgrades for SQL Servers in Clustered (Failover) and Non - Clustered environments.
• Experience in Configuration and Maintenance of Disaster Recovery solutions like Clustering, Database Mirroring, Log Shipping, Transactional & Merge Replication in SQL Server 2014/2012/2008/2005.
• Installed and Configured SQL server 2014 on VMware environment.
• Prepare, document and conduct Disaster Recovery exercises.
• Involved in Implementing of multiple multi-node clustered community environments, which supported multiple instances of SQL Server 2005 and later.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshoot issues with the same. Applied Hotfixes and Service Packs in clustered environments
• Configured Database Mirroring in High Performance and High Availability mode and troubleshoot issues with the same
• Experience in supporting Very Large databases (VLDB) and troubleshooting the associated problems.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Deadlocks and Handling the Isolation Level and Concurrency Effects.
• Verifying and tuning stored procedures created by developers by using Execution Plans, SQL Server Profiler and Database Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Experience in administrative activities comprising Database Health Check, Index Optimization (Rebuild and Reorganizing Indexes with different fill factors), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Security.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008R2, 2008, 2005

Databases: Microsoft SQL Server 2014/2012, 2008, 2005, 2000

Programing Languages: T-SQL, SQL, PL/SQL, PowerShell, HTML, C#, C/C++, XML

Database / ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), DTS, Query Analyzer, SQL Profiler, TOAD

Reporting Tolls: SQL Server Reporting Services (SSRS) and Report Builder

Third Party Tools: SQL Lite speed, IDERA, VMware, TSRM, SQL Sentry, Erwin Data Modeller and SQL Compare, ITSM Ticketing System, Aldon Ticketing System, Orion

PROFESSIONAL EXPERIENCE

Confidential, Savannah, GA

Sr. SQL DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2014 on Test, Development and Production Environments.
• Implemented Always On High Availability in MS SQL Server 2014.
• Migrating SQL server from 2008R2 to 2012 on standalone environment.
• Experience in implementing and configuration of HA solutions like Clustering and DR solutions like Replication, Log shipping on physical and virtual machines.
• Used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Worked SQL Server Security internals for databases/application
• Involved in Major Migration Projects between data centers.
• Implemented and Maintained SQL Server Replication.
• Design and implementing security configurations using best practices and standards
• Implementing and maintaining SOX controls and best practices for database security under SOX compliance.
• Configured Transparent Data Encryption (TDE) and Auditing.
• Working on role based security models along with understanding of Active Directory best practices for databases/applications
• Worked on SSIS security best practices/implementation.
• Created SSIS Packages to get data from other sources to some of the SQL servers and scheduling them as daily and weekly jobs.
• Created Tables, Triggers, Cursors and modifying Stored Procedures with change requests sent from development teams and working closely with Web/Change Management teams.
• Created Linked Servers between different Servers in SQL Server 2014 Environments and also between 32 and 64 bit Servers to access database objects in remote locations.
• Performed database consistency checks using DBCC Utilities and handling data corruption in user databases and identifying the bottlenecks caused by complex queries using Activity Monitor, SQL Profiler and Performance Monitor.
• Experience in Rebuilding/ Reorganizing Indexes based on the Index fragmentation.
• Used Index tuning wizard to redesign and create the indexes for better performance.
• Configured the DB SMTP mail and Alert system for the notification purposes.
• Used native tools like SQL SENTRY Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Designed the Database Recovery Plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Experience in SQL Server Reporting Services (SSRS).
• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2014 and MS SSRS 2012/2014.
• Created a SSIS Replication package from Production to 12 pool servers.
• Planned and co-coordinated database security measures.
• Created Logins and Roles with appropriate Permissions.
• Fixed the failed PRINCIPALS (logins), user permissions and security in Active Directory and at the SQL Server Level.
• Database Backup and restores, and periodical database refreshes, using Red Gate.
• Used IDERA SQL Diagnostic Manager for Performance monitoring, analyzing and troubleshooting.

Environment: Microsoft SQL Server 2014, Microsoft Windows 2014/2012/2008 Servers, IIS 7.5, XML, Red Gate, IDERA, TFS Source Control, JIRA, AGILE, PL/SQL, SSIS, SSRS, MS Visio, MS Office.

Confidential, Jacksonville, FL

Sr. SQL DBA

Responsibilities:

• Upgraded SQL server 2008 R2 to SQL Server 2012 on standalone and clustered environmentsand applied service pack.
• Interacted with application team at the timedatabase migration from SQL Server 2008 R2 to SQL Server 2012.
• Interacted withDevelopers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issuesto ensure data optimization.
• Managing Production SQL Servers onVIRTUAL and PHYSICAL environments
• Installing and ConfiguringSQL Server 2012/2008 R2/2008.
• Supported the business24x7, maintaining 99.999uptimes depending on the application and business SLA requirements.
• Involved indatabase design, database standards, and T-SQL code reviews.
• ConfiguredActive/Active and Active/passive SQL Server Clusters.
• ImplementedMirroring and Log Shipping for Disaster recovery
• Configuredtransactional and snapshot replication.
• Used tools likeSQL Server profiler, Performance Monitor to identify bottlenecks.
• Documented the results fromUpgrade Advisor and resolved all before and after issues migrating from SQL Server 2008 to SQL Server 20012.
• Involved in troubleshooting all the performance issues for different database applications.
• Deployed SSIS packagesto MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Used theExecution Plan to improve the optimization of the T-SQL code.
• Performance tuning ofSQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries.
• Provided 24x7 Production support for the database and application issues.

Environment: Microsoft SQL Server 2012/2008 R2/2008, Windows 2012/2008 Servers, T-SQL, SQL Server Profiler, SSIS, MS Office, Performance Monitor, SQL Server Cluster.

Confidential, Tallahassee, FL

Sr. SQL DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for Backup and Restore Jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modified Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Created Clustered and Non-Clustered Indexes to improve the performance of database access.
• Created and managed databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Logical and Physical Data Modeling Process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error Logs and Log File Viewer for Software and hardware related errors.

Environment: Microsoft SQL Server 2008/2008 R2/2005, Microsoft Windows 2008 Server, MS Visual Source Safe, IIS 7.5/6.0, XML.

Confidential, Atlanta, GA

Sr. SQL DBA

Responsibilities:

• SQL Server bitFailover Cluster Installation on Windows Server bit SQL Server 2008 Installation.
• Writing batch scripts to do automation of database tasks. Writing scripts to manage different servers for auditing purpose .Performance tuning on different Production Servers.
• Used the data warehousing capabilities of Microsoft SQL Server Enterprise to build faster warehouses, manage growing data volumes, and integrate with Microsoft business intelligence products.
• Created and implementedDTS/SSIS Packagesforimportingandexporting datato other data storage.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding indexes with different fill factors and update statistics manually.
• Building Maintenance plans for database maintenance.
• Writing stored procedures as for business requirements.
• Used several SSIS control flow and data flow transformations as part of ETL.
• Created SSIS Packages to export and import data from CSV files, Text files, Excel Spreadsheets and various other sources to manage translations to Regional Sites.
• Shrinking the data files as the space requirements.
• Effectively used PL/SQL advance features like collections, ref cursors, dynamic SQL and bulk loading.
• Managing users and security.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Used Team Foundation Server 2010 for maintaining source control, data collection, reporting, and project tracking
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2005/2008/2008 R2, T-SQL, Windows 2003/2008 Server, Vb.net,Asp.net, Erwin, MS Office, PL/SQL, SSIS, SSRS, Crystal Reports, Oracle.

Confidential, Minneapolis, MN

SQL Server Reports Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Developed, monitored and deployed SSIS packages.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Deployed the created SSIS packages in Development and Testing environments.
• Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Experience in working with Team Foundation Server (TFS).
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports.
• Defined the report layout in SSRS.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports, parameterized reports.
• Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Actively supported business users for change requests.
• Performed code review with other developers and suggested for improvements and alternate strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Involved in creating cubes for the Enterprise Data Warehouse (EDW).

Environment: MS SQL Server Management Studio 2008/2005, Query Analyser, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.