SUMMARY

• Around 8 years of Database Administration and Development experience on MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 in Very Large Database environments.
• Expertise and Interest include Administration, Database Design, Performance Analysis, highly transactional servers and Production Support for Large (VLDB) and Complex Databases.
• Experience working with both Hyper - V and VMware virtualization.
• Experience in setting up Always on availability groups in SQL 2012 as a Disaster recovery setup.
• Extensive experience with configuring high availability and Disaster recovery techniques like clustering, set up different topologies in replication, Log shipping and mirroring.
• Implemented Transactional Replication as a part of the Disaster Recovery (DR) solution.
• Experience configuring and working Microsoft SQL server 2005, 2008/R2, 2012 on VMware Environment.
• Documented Disaster Recovery plans and participated in disaster recovery drills.
• Worked extensively on Clustering and server consolidation.
• Troubleshooting production issues and raising high availability.
• Experience in implementing new features of SQL Server 2008 like Policy-Based Management, Resource Governor, Data Collector Sets and Backup Compression Techniques.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD.
• Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas. Working in both MOLAP and HOLAP environments.
• Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
• Expertise in setting up Active/Passive and Active/Active Clusters for High Availability.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, Re-org, horizontal and vertical partitioning.
• Experience working with server-side trace.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of a disaster of a server.
• Thorough Understanding of different RAID levels implementation.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Upgraded databases from MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Implemented Log Shipping Technique for warm backup solutions.
• Hands-on Experience with using Data Modeling Tools such as Erwin and MS Visio.
• Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Overall database design thatinvolvescreating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hotfixes and Unattended Installations.
• Provide 24/7 production support for mission critical systems.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Explicitly used third-party tools like Lite Speed, Fog light and Red gate.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Develop and manage reports on SharePoint Server.
• Monitoring Dashboard Reports for Performance Tuning and finding the bottleneck in the database.
• Worked with Third Party Backup solutions like SQL LightSpeed, TSM for MS SQL Server and data modeling tools like Erwin.
• Flexible, Enthusiastic and project-oriented team player withexcellent communication skills and analytical skills to develop a creative solution for challenging client needs.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/2003/2008/2012/2012 R2/XP/VISTA/7/10

Databases: MS-SQL Server 6.5/7.0/2000/2005/2008/2008 R2/2012,2014 MS Access

ETL Tools: Data Transformation Services, SSIS

Reporting Tools: SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer

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

Third-party Tools: Erwin, Visio, Red gate, Lite Speed, Guardium, Tivoli

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior SQL Server DBA

Responsibilities:

• Manage and administer SQL server 2005\2008\R2\2012\2014\2016 servers.
• Installations and Migrations of databases from SQL 2005 to SQL 2008/2012 and SQL 2008 to SQL 2012/2014/2016.
• Virtualization of the prod and non prod environments.
• Configured and maintain ALWAYS ON setup on Multi Subnet Cluster and Geo-redundant cluster in SQL 2012.
• Configured Windows Failover Clustering and SQL Clustering on Multi Subnet Cluster.
• Set up Change data capture (CDC) on the production databases.
• Deployment of databases, jobs from pre-production to production.
• Troubleshooting performance issues with slow running queries and applications.
• Scheduling Backups/restores and doing point in time restores when needed.
• Configured Snapshot Replication and Transactional replication and troubleshooting issues.
• Build 2012\2014 cluster environments on VMware and Physical servers.
• Upgrades and applying patches and hotfixes.
• 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.
• Work with application vendors for building new application databases.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• 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.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Used the PowerShell scripting to get the most consistent production environment.
• Disaster Recovery Planning, Testing, and Analyzing and continuous update of documentation.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents within the SLA’s, as a part of operations support DBA.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Involved in capacity planning, sizing, and database growth.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• 24*7 on-call production support.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installing, configuring, tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2/2012.
• Built 2 node and multinode SQL Server clustering.
• Set up Always On availability groups.
• Created SSIS package for loading the data coming from various interfaces and used multiple transformations in SSIS to collect data from various sources.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Configured Bi-directional replication and have resolved many of the issues related to replication.
• Created Data Model or the Marketing Information System Team using Erwin.
• Created databases and Schema Objects including tables, indexes, and applied constraints connected various applications to the database and wrote functions, stored procedures, and triggers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Worked extensively on SQL Server Reporting Services (SSRS) to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server 2000 to 2005 and 2008/2008R2.
• Created Database Diagrams using Erwin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving deadlock issues and performance issues.

Environment: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003/2008 Servers, .NET, MS Access, Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB, Reporting Service (SSRS).

Confidential

Sr. SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server 2000\2005\2008\R2\2012 servers.
• Migrations of databases from SQL 2005 to SQL 2008/SQL 2012.
• Deployment of databases, jobs, cubes from pre-production to production.
• Building SQL 2005\2008 cluster environments on VMware or Physical windows.
• Performed installations of SQL 2005\2008\2012 on clustered and standalone servers.
• Upgradations of SQL server versions and applying patches and hotfixes.
• 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.
• Fix the Cluster and Replication issues on SQL 2005/2008/2012 servers within very strong SLA’s.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Migrations from virtual to the physical OS.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Used IDERA SQL Diagnostic Manager for Performance monitoring, analyzing and troubleshooting.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing.
• Performance tuning of databases by windows performance monitor and SQL Profiler.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents within the SLA’s, as a part of operations support DBA.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Involved in capacity planning, sizing, and database growth projects.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and nonproduction changes.
• 24*7 on-call production support.

Environment: MS SQL Server 2000/2005/2008/2012 , Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, Idera, TSM/TDP, SCCOM.

Confidential

SQL Server DBA

Responsibilities:

• Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2005/2008 (R2) on new servers with service packs.
• Support and troubleshoot very large databases (VLDB).
• Extensively worked on Snapshot and Transactional Replication.
• Work on 32 bit, x64 bit and i64 clustered and standalone server environments.
• Configure the RAID levels for data files, log files and tempdb at the server level.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring and make recommendations based on the results.
• Involved in the ETL process under development, testing and production support environments.
• Extensively use SSIS tool to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
• Develop complex mappings and tune mappings for better performance.
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Fix data issues and write various SQL scripts and procedures for the migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Develop all the required stored procedures, user-defined functions, and triggers using T-SQL and PL/SQL.
• Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Work on DTS, Import and Export utility, BCP Utility and replication tool.
• Responsible for transferring packages using SSIS (ETL).
• Create and modify Stored Procedures and Functions to generate reports.
• Monitor and modify performance using execution plans and Index tuning.
• Migrated SQL Server 2000 to 2005, SQL Server 2005 to 2008 R2 and DTS to SSIS (ETL).
• Hands-on experience with the third-party tools (Erwin, Fog Light, VERITAS).
• Implement and manage the clustering environment like Active/Passive and Active / Active.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Maintain the database consistency with DBCC, DMF and DMV’s at regular intervals.
• Troubleshoot and fine-tune databases for performance and concurrency.
• Provide 24x7 Production Database on-call support.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, SSRS, SSIS, SSAS, PL/SQL, MS Access, VB, C#, Erwin and SharePoint 2007.