PROFESSIONAL SUMMARY

• A database professional with extensive experience as a Sr. SQL Server Production support, Application Support and Team management Consultant managing a team of Oracle&SQL expertise
• Over 10 years of experience solving complex business problems related to database planning, migrations and SQL performance and environment stabilization.
• I am a solid database consultant that uses enterprise best practices in a world - class Windows environment to anchor high transactional, zero downtime data solutions.
• Proactive individual with outstanding record of achievement across career path with diverse companies including IT product & IT services.
• Excellent communicator with perseverance, creativity and reasoning ability to analyze complex cases and effectively handle emerging process problems.
• Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000 in Very Large Databases in OLTP and OLAP environments.
• Working knowledge with Oracle 9i,10g & 11g.
• Expertise and Interest include Administration, Database Design, Performance Analysis, highly transactional servers and Production Support for Large (VLDB) and Complex Databases.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, Transact replication, Log shipping and mirroring.
• Implemented new features in MS SQL Server 2012 like Always on HADR.
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008/R2, Microsoft SQL server 2012on VMware Environment.
• Documented Disaster Recovery (DR) 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 2012 concepts like Data partitioning, Snap shot isolation, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD.
• 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, reorg, horizontal and vertical partitioning.
• Experience working with server side trace.
• Extensive experience working with PowerShell, CMD Shell, Python for remote database administration & automation activities.
• 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.
• Thorough Understanding of different RAID levels implementation.
• Working with database sizes more than 5 TB.
• Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Experience in BI tools likeSQL Server Reporting Services (SSRS),SSIS & SSAS
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Data migrations from SQL to SAP, MS Access
• Experience in using DMV and DMF Of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Having working knowledge in Windows, Network and Active directory.
• Having working knowledge in Symantec Backup exec, Acronis backup systems
• Highly involved in Migrations from physical to Virtual & old versions of databases to Latest
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Worked with Third Party Backup solutions like SQL Lite speed for MS SQL Server and data modeling tools like Erwin. Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Provide 24/7 production support for mission critical systems.

PROFESSIONAL EXPERIENCE

Confidential, New Orleans, LA

Database Support Lead

Responsibilities:

• Manage and Administer SQL Server 2005, 2008, R2, 2012& 2014 versions of database. Installed SQL server2005,2008,2012 and 2014on a test environment to be the future production environment.
• Worked on new features in SQL Server 2012 like Column stored indexes, User-Defined Server roles and Contained Databases.
• Worked on over 200+ database migrations from 2005/2008 to later versions of SQL on both Physical & Virtual environments
• Involved in setting up Always on availability groups over multiple databases that are involved in Database mirroring..
• Setting up Uni-Directional Transactional Replication between SQL Server and Oracle Databases using Golden Gate.
• Setting up Bi-Directional Transactional Replication between SQL servers to SQL Server databases with updatable subscriber.
• Data migrations using BI tools like SSIS
• Monitor and troubleshoot critical issues with Replication.
• Running SQL Server jobs and Maintenance plans in Windows batch files as Scheduled Tasks.
• Troubleshooting queries and stored procedures which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• 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.
• Using and implementing DMV’s, DMF’s for identifying index fragmentation.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statisticsand Reindexing.
• Recovering the databases from backup in disasters, implementing point in time recovery solutions.
• Data migrations from SQL server to SAP
• Database migrations from SQL Server to MS Access
• Daily routine DBA tasks like handling user's permissions and space issues on Highly Transactional Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• 24/7 production and on call support and working on tickets.
• Focusing on information Protection and security for the Control Systems
• Having working knowledge in Windows, Network and Active directory.
• Having working knowledge in Symantec Backup exec, Acronis backup systems

Environment: MS SQL Server 2005/2008/2008R2/2012/2014, TSQL, OLTP,OLAP, Windows 2008, Idera SQL Safe, SSIS, SSRS, Lite Speed, MS Visio, BMC Remedy, PowerShell, CMD Shell, C#SQLCLR, SFTP, FTP etc.

Confidential

Senior DBA (L3 Support)

Responsibilities:

• Manage and administer SQL server 2005\2008\R2\2012 servers.
• Migrations of databases from SQL 2005 to SQL 2012 and SQL 2008 to SQL 2012.
• Deployment of databases, jobs, 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.
• Upgrade 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.
• Implemented Log Shipping Technique for warm backup solutions.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Continuous monitoring server health with Idera.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Worked with PowerShell for performance enhancement and security audits. 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 with in the SLA’s, as a part of operations that support DBA.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration using BI tools (SSIS)
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• 24*7oncall production support.

Environment:MS SQL Server 2005/2008/2012,OLTP,OLAP, Windows 2003/2008/2012, SSRS, SSIS, SSAS, MS Access etc.Bank of Nova Scotia

Confidential

Senior SQL Admin

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 and mirroring.
• Work on 32 bit, 64 bitclustered and standalone server environments.
• Configure the RAID levels for data files, log files and tempdb at server level.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• 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 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.
• Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Work on DTS, Import and Export utility, BCP Utility and replication tool.
• Create and modify Stored Procedures and Functions to generate reports.
• Migrated SQL Server 2000 to 2005, SQL Server 2005 to 2008 R2 and DTS to SSIS (ETL).
• Experience with the third party tools (Erwin, Fog Light, VERITAS )
• Implement and manage the clustering environment like Active/Passive and Active / Active.
• Use log shipping for synchronization of database.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Design and create Power and Temperature Reports based on the management request for customers using SSRS.
• Create parameterized, drill down and aggregation type of reports in SSRS 2005 and Crystal Reports.
• Provide 24x7 Production Database on-call support.

Environment: MS SQL Server 2005,2008,R2,OLTP,OLAP, Windows 2000/2003, SSRS, SSIS, SSAS, PL/SQL, MS Access, Linux, VB, C#, Erwin and SharePoint 2007 etc.FIFA

Confidential

Senior Application DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Evaluated data storage considerations to store databases and transaction logs.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table
• Expression (CTE), Data Partitioning, Snapshot Isolation
• 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.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Reindexing.
• Developed and optimized database structures, stored procedures, Dynamic
• Management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Worked on log shipping for synchronization of database.
• Authenticated logins and validated permissions.
• Writing stored procedures, triggers, and functions and maintained coding standards.
• Involved in database Normalization, logical and physical data modeling using
• Managed VERITAS net backups and Litespeed backups, Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• Design and Development of SSIS Packages to load the Data from various Databases and Files.

Environment: Windows 2003 server, ASP, XML, MS SQL Server 2005/2008,OLAP, T-SQL, MS Access, MS Excel, Oracle etc.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• 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 TuningAdvisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• 24/7 on call support.
• Created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: SQL Server 2008/05/00,Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, LiteSpeed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, FogLite.