Skill Summary:

• I have 13 years of IT experience with all aspect of Design, implementing Administration of Windows NT/2000/2003/2008/12 SQL Server 2000/2005/2008/2012 databases size ranging from GBs to TBs in Government, Banking and Financial, Brokerage, Pharmaceuticals, Manufacturing Sectors.
• Expert in installing, configuring, managing, monitoring and troubleshooting SQL Server 7/2000/2005/2008/2012.
• Worked on design, migrate and upgrade from SQL Server 2000 to 2005 2000/2005 to 2008 2014
• Solid experience and outstanding knowledge of high availability SQL Server solutions upto 7 Node Clustering, SQL Replication and Log Shipping.
• Installation and Integration of SharePoint Server 2010 with SQL Server 2012.
• Experience in Creating and Maintaining enterprise databases, Backup Recovery, Security.
• Solid experience with creating jobs, alerts, schema management, database reorganization, database maintenance, and optimization.
• Hands on experience in SQL Server Windows Server Hardening.
• Extensively worked on FFIEC Federal Financial Institutions Examination Council Audit Compliance.
• Hands on experience on, Bulk Insert, BCP, DTS packages and Database consistency check using DBCC commands.
• Monitoring databases and tuning SQL Server performance with performance monitor, SQL Profiler and Index Tuning for better performance.
• Installing, upgrading, configuration and patching/Hotfix of SQL Server Windows.
• Configured and Administered Windows 64 bit 2003/08/12 Cluster Servers with Active/Active and Active/Passive nodes/Servers.
• Worked Extensively on Pro-Active Monitoring of SQL Servers using Diagnostic Manager, GFI Disk keeper, NETIQ, MOM 2005, Foglight for Databases and Servers.
• Hands on Change Control / Incident Management / Release processes.
• Extensively worked on T-SQL Scripts - Stored Procedures, Functions, Triggers and Automation of Jobs.
• Worked on Database mirroring and Reporting Services in SQL Server 2005/08/14.
• Experience with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments.
• Experience working in Production 24/7 Oncall and also in Development Environment.
• Good interpersonal communication and problem solving skills.
• Level 5 FEDERAL SECURITY Clearance Public Trust.
• NACI-1 Clearance.

Technical Skills:

Network Operating Systems Windows NT/00/03/08/12

Databases SQL Server 7.0/00/05/08/14, Oracle 9i, 10g

Server Management VM Servers, Cluster Administration, DNS, DHCP.

Backup Veritas Netbackup, LiteSpeed for SQL Server

Reports SQL Server Reporting Service

Database Language T-SQL, PL/SQL

Tools Idera Diagnostic Manager, SQL IO Stress Test, HP-SIM, IBM-Director, GFI Disk keeper, NETIQ, Scom 2012, MOM 2005, Foglight, Litespeed

Work Summary

Confidential

Position: Lead Server Database Administrator

Responsibilities Include:

• Migration of Servers from Windows 2003 to Windows 2012.
• Active Directory and Domain Controller Migration from Windows 2003 to Windows 2012.
• Configured and maintaining SQL Server multi-node SQL Clustering
• Configured and maintaining Always On for High Availability.
• SQL Server migration form SQL Server 2008 to SQL Server 2014.
• 24X7 Monitoring of Production Server
• Patching and upgrading Database Servers
• Maintaining, performance tuning, Backups for SQL Server Database Servers
• Supporting the Windows, SQL Database Servers.
• Virtualization of SQL Servers from P2V.
• Performance tuning of Databases
• Support Test, Dev, Staging and Production Environments

Confidential

Position: Database Consultant

Responsibilities Include:

• Responsible for monitoring and making recommendations/implementation for performance improvement in hosted HA databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• SQL Server DBA Production Support, Version Upgrade Architect Setup, Capacity Planning, Load Balancing Scaling out SQL Server
• Install, manage troubleshoot multi node multisite QL Server clusters Active Active Active Passive.
• Installed SharePoint 2010 and Configured Maintained SQL Server integration with SharePoint and fine tuned Database for best performance.
• Used SQL IO Stress test tools to diagnose the SAN storage for I/O and RW.
• Used SQL Diagnostic manager for Database monitoring for performance issues.
• SQL Server Virtualization Consolidation
• Leverage Change Control processes for all SQL Server changes made in Production environment
• Plan, Design and Scheduled Database Maintenance Administrative Tasks
• Performance Tuning Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Implemented Administered SQL Server High Availability and Disaster Recovery strategies.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in Disaster Recovery Planning and Security Management operations. Game Plan Planning, Execution whenever required and doing Drill twice a year.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Implemented on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Extensively worked on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• 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.
• Strong experience in mentoring team members and writing documentation.
• Installed and administered upto Seven-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment across locations.
• 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.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .

Confidential

Position: Lead DBA

Responsibilities Include:

• Experience in supporting Very Large Database VLDB more than 10 TB and troubleshooting problems
• Perform business analysis, technical analysis, systems design, application software programming.
• Having Experience on Data center servers and handling upto 10 TB's of Databases and 100s of SQL Server Instances.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating subscriber servers.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• 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.
• 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.
• 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.
• Deploying new code base release to UAT and Production Environments.
• Working with customers on Application rollouts and server migrations.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Designed and implemented comprehensive Backup plans.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Expertise in designing databases and capacity planning.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Automated messaging services on server failures, for task completion and success.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Table partitioning to improve I/O access.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Migration from SQL server 2005 to 2008 by using In-Place upgrade process and as well as side-by-side upgrade process, And documented the Upgrade Process.
• Experience in supporting Very Large Database VLDB more than 10 TB and troubleshooting problems
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Longrunning queries. And also good experience in data table partitioning.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV's and DMF's, Re-indexing, Updating Statistics and online indexing.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Worked in Active-Passive, Active-Active Cluster and DB Replication environment as a High availability solution.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Automated Checking Database Health by using DBCC Commands and DMVS

Confidential

Position: Sr. Database Administrator

Responsibilities Include:

• Hands on Experience in installing, configuring, monitoring and troubleshooting Administration of SQL Server 2005, 2008 Windows 2003 2008.
• Worked as a Production and Development support DBA, provided 24 7 Production Support
• Experienced in building, configuring and maintaining 4 environments Production, Pilot, Client-Pilot Development.
• Implemented administered clustering on SQL Server 2005, 2008 Enterprise and Standard Edition on Windows 64 Bit Enterprise edition both Active-Active Active-Passive with 2 and 3 nodes.
• Hands on Experience in building and administration of SQL Servers on Physical VM's and have used in Production, Pilot and Client Pilot environment.
• Extensively working on Query Optimization, Indexing, and Troubleshooting SQL Server related issues.
• Hands on experience in SQL Server Windows Server Hardening.
• Extensively worked on FFIEC Federal Financial Institutions Examination Council Audit Compliance.
• Experienced in working with Data Transformation SSIS.
• Extensively working on 64 Bit Windows Enterprise Server and SQL Servers Enterprise Standard.
• Experienced in SQL Server tuning techniques to optimize the SQL queries and stored procedures.
• Wrote stored procedures for Automation of Jobs and Administrative purposes.
• Performance Analysis and Tuning of Databases and used SQL Profiler for performance Analysis
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Capacity planning for Database and Backups for EMC and projecting the Database growth.
• Hands on Experience on automation and monitoring: SQL server agent, maintenance plans, SQLCMD, databases mail, SQL profiler.
• Defining SQL Server standards for HA and securing the Databases from intrusion by SQL hardening.
• Created the backup and restore strategy for production, and development environments.
• Extensively worked on SQL Server Replication Snapshot Transactional across Datacenters and client locations.
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery
• Experience in installing and configuring transactional replication for 2 environments.
• Bi-weekly and monthly Capacity Planning management reports including databases growth rates, contingency planning, various statistic as well as application tuning statistics.
• Implemented Mount Volumes Mount Points in clustered SQL Server environment and have used Diskkeeper to monitor the MV's MP's.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
• DR planning, coordination and implementation
• Working on Migrating SQL Server Databases from 2000/2005 to 2008.