SUMMARY

• 7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2014, 2012, 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, clustering configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in Transact SQL (T - SQL) writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS/ETL, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, contained Databases and, security principals.
• Worked on logical and physical data base modeling with UML and ERwin tools.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server .
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations with WINTEL systems.
• Having Experience on Data center servers and handling more than 1.0 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2. Also created DTS package for data transfer between the two environments.
• Experience in SSIS, SSRS, SSAS and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.

TECHNICAL SKILLS

DBA: Database Administration of MS SQL Server 2014, 2012, 2008, 2005

ETL Tools: SSIS using BIDS, Informatica Power Center

Business Intelligence: MSBI Suite(SSIS, SSRS, SSAS)

Databases: SQL Server 2012/2008/2005 , MySQL, MS Access

Languages: SQL, PL/SQL, .NET(C#), C

Web Technologies: HTML, DHTML, XML, XAML, XSL/XSLT, IIS

Design: ERwin, Visio, Aqua Studio, Enterprise Architect, MySQL workbench, SQL Developer, Data Modeler, SQL Server Diagram Editor, TOAD Data Modeler, Visual Paradigm

Tools: MS Office Suite, TOAD, SQL Plus, SQL Developer, SQL Developer, Data Modeler

Operating Systems: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux, WINTEL Systems

Version Control: Team Foundation Server, Visual Source Safe, SVN

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, GA

SQL Server DBA

Responsibilities:

• Installed and configured of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managed of database objects like Tables, views, stored procedures, indexes etc.
• Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
• Written complex stored procedures and functions according to business requirements.
• Implemented Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Created monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debugT-SQLand slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managed of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000,SQL Profiler, DTS, Crystal Reports, Business Objects,T -SQL, BCP.

Confidential, Jacksonville, FL

Database Administrator

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN Environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Worked and implemented Transact SQL (T-SQL) codes.
• Implemented SQL Cluster Configuration and replication for multiple nodes working and stand by.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Performed transaction log backup, and shrink database log files to free log space and cluster disk space.
• Responsible for database user management.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for Database Problem Management, stand by to support calls on request.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers and WINTEL Systems).

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Wintel Systems, .NET, ERwin, Microsoft Visio, SFTP, SQL Server Integration Services, SSRS and Microsoft Reporting Services.

Confidential, Raleigh, NC

SQL Developer DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using Idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2012/2008/2005 , .Net Framework 3.5/4.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access, Erwin, Visio Professional, TFS

Confidential, Farmington Hills, MI

SQL Server 2012 DBA

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services

Confidential, San Antonio, TX

Database Deployment Engineer

Responsibilities:

• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, ME Change Request, Visio, Enterprise Manager, SQL Query Analyzer, SQL Profiler.