SUMMARY:

• 7+ years of experience in Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server 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 T - SQL writing stored procedures, triggers and functions.
• Experienced in Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experienced in implementing the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Experienced in working on logical and physical data base modeling with UML and ERWIN tools.
• Experienced in using DMV and dynamic management functions for finding out long running queries.
• Experienced in working on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experienced 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.
• Experienced in working 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.
• Experienced in Troubleshooting performance problems, fine-tuning of databases and index Analysis.
• Experienced in working on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Experienced on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Experienced in implementing Always-ON (AAG) on SQL Server 2012 SP2 CU5.
• Experienced in maintaining individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experienced on Data center servers and handling 1.4 TB databases.
• Experienced in handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Experienced in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experienced in creating Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Experienced in working with Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.
• Experienced in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strongly experienced in mentoring team members and writing documentation.
• Experienced in 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012, 2008, 2005, Oracle, DB2

Programming: C, C#, Java, Java Script, VB Script, Shell Script

Operating System: Windows Server 2003/2008/2012, IBM AIX, Oracle Solaris

Monitoring Software: HP Sitescope, Microsoft SCOM, Red Gate, Precise

Tools: TOAD, Visio, ARIN

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

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

SQL Server 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).
• Involved in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Involved in Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Involved in 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.
• Involved in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Implemented 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, Austin, TX

MS SQL Server DBA

Responsibilities:

• Performed business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Involved in Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferred the data (ETL) to Data warehouse (Informatica) by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Installed, authored, and managed reports using SQL Server Reporting Services.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Monitored 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 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.
• Involved in Re-engineering Customer Cognos and People Soft modules into SQL Server Integration Services.
• Prepared the project management and technical documentation.
• Involved in Unit Testing the SSIS packages with respect to its flow and performance issues.
• Involved in Solving the Bugs Reflected by the Testing team.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Involved in Managing the VERITAS net backups.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Completed documentation about the database. Recovering the databases from backup in disasters.
• Involved in exporting or importing data from other data sources like flat files using Import/Export through DTS, SSIS.
• Involved in analyzing long running slow queries and tuning the same to optimize application and system performance.
• Set up SQL Server configuration settings for better server management.
• Involved in 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, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential, Reston, VA

SQL DBA

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Involved in 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.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Involved in Deploying new code base release to UAT and Production Environments.
• Performed SQL Server service pack and Windows Service pack upgrades.
• Worked with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Involved in Troubleshooting 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 2008 Integration Services.
• Migrating SQL Server 2005 data bases into SQL Server 2008.
• Involved in recovering the databases from backup in disasters.

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