SUMMARY

• I have extensive experience in database administration, design and development in RDBMS technologies for a number of clients at Wells Fargo Securities and other institutions. I have been involved in all phases of the database development lifecycle and as a Senior SQL Server DBA
• I have 15 years of exhaustive experience with performance tuning, replication, deploying SSIS and SSRS, configuring and administering backup strategies, clustering, log shipping, database optimization, capacity planning and database programming.
• My strength also lies in developing physical and logical models for database design and development and have past experience as an Oracle database developer with excellent understanding of RDBMS concepts. I gathered my DBA experience working for Financial, Insurance and Pharmaceutical companies. In addition to my experience, I am a team player with good communication, written and team organizing skills and have excellent rapport with my customers.
• Total database administration on SQL Server versions 2012/2008/2005/2000/7: 14 years
• Supported mission critical production databases with real time troubleshooting of production problems.
• Installed and Configured replication, clustering, database mirroring and log shipping.
• Deployed SSIS packages and SSRS reports for fixed income applications
• Capacity planning for new database systems
• Automation of manual jobs across multiple applications to mitigate risk and improve efficiency
• Performance tuning, Backup/recovery, Query Optimization and Security.
• Well versed with monitoring tools such as Idera, I3, BMC patrol and compression tools like Lightspeed in addition to others like Tivoli stored manager.
• Attended SQL PASS 2013.

TECHNICAL SKILLS

• Level
• DBA
• SQL Server
• Expert
• Oracle8i/9i Developer
• Access
• Modeling Tools
• Visio
• Performance Monitoring
• BMC Patrol
• Advanced
• Advanced
• 4 years
• Advanced
• Storage Manager
• Tivoli
• Advanced
• NetApp backup
• Advanced
• Programming Languages, etc.
• T - SQL / PLSQL / OSQL / ISQL
• Advanced
• Powershell
• Shell scripting
• Visual Basic
• Operating Systems
• Windows 2008 R2, 2008, 2003

PROFESSIONAL EXPERIENCE

Senior DBA

Confidential, Charlott, NC

Responsibilities:

• Handled Administration of SQL Server 2012, 2008 R2, 2008, 2005 and 2000.
• Implemented MS SQL cluster (Active/Passive & Active/Active), Multi Node Clusters
• Supported and maintained mission critical servers and clients spread across multiple domestic locations.
• Handled multiple database migrations from 2000 to 2005, 2005 to 2008/2008 R2.
• Worked closely as a team with system administrators, SAN, TDM planners and other infrastructure teams to build multiple new environments, troubleshoot issues and remediate gaps.
• Engaged various third party vendors and worked closely to research and remediate issues.
• Planned and executed SQL Server service packs, hot fixes, new version upgrades etc..
• Tuned databases systems for improved performance and scalability.
• Deployed SSIS packages and troubleshoot issues side by side with the application team.
• Planned and executed deployment of SSRS reports.
• Developed adhoc scripts, utilities and jobs for database maintenance.
• Implemented and managed database clustering, failover and load balancing.
• Participated in discussions with application and infrastructure teams as a database lead for capacity planning.
• Developed, tested, implemented and maintained robust database backup and recovery strategies.
• Handled database replications and mirroring.
• Involved with various BCP tests involving SAN Replications and database mirroring
• Triaged live production issues and conducted root cause analysis for database incidents and problems.
• Routine monitoring of database statistics like database health, logs, space utilization, extents, locks and long running transactions.
• Closely worked with application teams to research and recommend improvements in application code, queries and SQL objects for better overall performance and throughput.
• Adhered to change control and release procedures using Wells Fargo enterprise tools.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate leaders as needed.
• Recommended and implemented tactical solutions as stop gap measures per request from the application team.
• Researched, reviewed and recommended best practices for preventive maintenance.
• Provided & managed support to Environment of more than 400 database servers.
• Set up security, access profiles and procedures for database system administrators.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.
• Interfaced with database vendors & client technical support teams to isolate & resolve database related problems
• Proven ability to handle database of 700GB in size.
• Set up and administered log shipping.
• Supported application development and testing in lower lane environments.
• Developed & implemented table partitioning.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Handled data Migration from legacy systems as well other RDBMS.
• Implemented automate database refresh in lower environments using Powershell.

Senior DBA

Confidential, Wall St., NY

Responsibilities:

• Provided 24 X 7 support for 70 mission critical production databases in addition to other application databases in the development and test environments.
• Developed and implemented backup and restore strategies in the production environment.
• Numerous maintenance plans were designed and implemented.
• Single handedly managed monthly maintenance of the mission critical databases. Maintenance activities included rebooting servers, applying hot fixes in stand alone and cluster environments and failing over the nodes in the cluster environment.
• Involved in capacity planning and disaster recovery planning.
• Implemented Tivoli to monitor various aspects of the database server.
• Application database maintenance involved working with Citrix servers.
• Created Data Transformation service (DTS) packages for transferring data from heterogeneous data sources like oracle and DB2 databases.
• Worked closely with developers in fine-tuning queries in diverse applications using index tuning wizard and SQL server execution plan.
• Installed and configured Active/Passive Cluster for High availability applications.
• Involved with documenting SQL server and database policies and procedures.
• Performed daily monitoring of SQL Server activity, error logs, NT event logs, space usage, and security.
• Configured different types of replications like transactional and snapshot replications
• Monitored Server Level Blocks/deadlock’s for maximum database availability and reliability.

Senior DBA

Confidential, NJ

Responsibilities:

• Production and development support DBA.
• Provided 24 X 7 dedicated support for 123 MS SQL Servers out of which 82 Production, servers and remaining development and test servers.
• Troubleshooted and resolved real time production problems.
• Installed SQL Server 2000 on Windows 2000 and 2003 servers with all service packs and security fixes.
• Installed, configured and maintained Microsoft fail over cluster environment in 3 projects.
• Implemented transactional, snapshot and merge type of replications.
• Configured log shipping environments to create stand by servers for production servers.
• Upgraded databases from SQL Server 7.0 to SQL 2000.
• Created and implemented backup and restore strategies for production and development environment.
• Developed logical and physical data models using Erwin tool.
• Involved in managing database security including granting permissions on various database objects.
• Involved in SQL Sever Performance Monitoring, Server and Database optimization and Query tuning.
• Worked hand in hand with SQL developers to optimize SQL queries and stored procedures.
• Involved in defining change management control procedures to implement the changes to the production servers.
• Installed and maintained SQL Analysis services, extracted data from Oracle and access databases to load cubes.
• Involved in design and setup of Disaster recovery operations.
• Worked with DTS, BCP and BULK INSERT for various import and export operations involving other databases and text files.
• Involved with Capacity Planning for databases.
• Created optimization and integrity check maintenance plans to keep database running in an optimized condition.
• Developed check list for installation of SQL Server and SQL Clusters, service packs and security fixes.
• Monitored Server Level Blocks/deadlock’s for maximum database availability and reliability.
• & Investigate and resolve Any Database Related issues /performance related issues with Minimal Downtime & Maximum Reliability
• Used DBCC commands to check the consistency of the databases.
• Extensively worked with Command-Line Utilities like BCP, ISQL/OSQL, DTSRUN, DTSWIZ, ITWIZ, REBUILDM

Senior DBA

Confidential, NJ

Responsibilities:

• Act as a Sr.SQL Server DBA, responsible for production and development support for 120 SQL Servers including production, test and development servers.
• Installed MS SQL Server 2000, Service pack and hot fix for different environments.
• Configured and maintained the log shipping to create a backup server environment for production servers.
• Configured and maintained transactional and merge replication for production servers.
• Involved in upgrading from SQL Server 7.0 to SQL Server 2000 and worked with the application team to test the successful upgrade.
• Experienced with designing logical and physical database design for development projects.
• Involved in data refresh between different environments.
• Created the DTS packages for import and export operations, extracted the data from oracle, SQL Server and access databases and application related packages.
• Experienced in improving SQL Server database performance by using execution plans, index tuning wizards and profilers.
• Installed, configured and maintained SQL Server 2000 fail over cluster servers for production servers.
• Involved in creating the backup strategy for production, test and development servers, implemented them.
• Experienced with Disaster recovery procedures to recover production databases.
• Experienced with 24 *7 on call production support and on call rotation schedule.

Senior DBA

Confidential, NJ

Responsibilities:

• 24*7 critical production support for 72 servers.
• Involved in administering 40 servers in Development/QA and UAT domains.
• Installed and configured SQL Server 2000, applied service packs and hot fixes for SQL Server.
• Worked on database analysis, creation and review of physical and logical data modeling for the enterprise using Erwin.
• Installed and configured Active/Passive Cluster for High availability applications.
• Involved in upgrading databases from SQL Server 7.0 to 2000.
• Configured different types of replications like transactional and merge replications.
• Experienced with Server Configuration, database configuration and data and log files management.
• Involved in improving database server performance using Performance monitor tool to find bottlenecks in CPU, disk and memory devices.
• Created Data Transformation service (DTS) package for transferring data from heterogeneous data sources like DB2 and oracle databases to SQL Server.
• Worked on FDA compliance requirements.
• Resolved database corruption related problems in SQL Server.
• Involved in Capacity planning for large databases.
• Involved in restore operations for mission critical production databases.
• Worked with SQL Developers to tune stored procedures and Queries to run for better performance.
• Involved with documenting SQL server and database policies and procedures.
• Formulated measures on a weekly basis to ensure that system meets overall service level requirements.
• Monitored job schedules using NetIQ
• Analyzed and created indexes to optimize application performance.
• Analyzed SQL Server long-term performance trends.
• Scheduled and managed jobs (tasks) on SQL Server. Monitored performance of jobs to access impact on normal operations and developed scheduled task scripts.
• Responsible for creating Database, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Involved in Linked Server setup, which allows access to the distributed, heterogeneous queries against OLE DB data sources for EXCEL, MS ACCESS, Text files.

DBA

Confidential

Responsibilities:

• Installed and configured SQL Server 7.0 on Windows NT.
• Involved in setting up SQL Server and database configuration parameters.
• Configured SQL Server clients.
• Involved in database design, normalization of tables, database preparation and user maintenance
• Assisted in setting up Transactional Replication and maintain the servers.
• Involved in restoring databases using SOP defined for SQL Server disaster recovery.
• Identified and resolved SQL Server performance related problems.
• Involved in database optimization to improve performance
• Developed and tuned queries using index tuning wizard and SQL server execution plan.
• Involved in creating tables, indexes, stored procedures and triggers.
• Reverse engineered existing databases to build replacement databases for better and faster databases performance.
• Worked extensively on data import/export from heterogeneous data sources like flat files, Excel files and Sybase databases to MS SQL Server.
• Involved in scheduling and monitoring routine jobs in SQL Server
• Assisted in developing and implementing a DBA maintenance plan for SQL Server (backups, DBCC, updating index statistics, monitoring database and disk space, security, and scheduled tasks).
• Performed daily monitoring of SQL Server activity, error logs, NT event logs, space usage, and security.
• Assisted in setting up regular backups of databases and transaction logs.
• Implemented, tested and maintained a backup and disaster recovery plan.
• Responsible for Logical & Physical Database Design and maintain Data model using Erwin.
• Responsible for User administration and granting permission to the SQL Developers and application users.
• Review / test / apply all database changes to all environments including TeamQA, Model Office, SIT, and Production, Training & Monitor SQL Error Logs /Scheduled Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.

DBA/Database Developer

Confidential

Responsibilities:

• Creation of New NT Logins and Granting privileges to users/Groups and objects
• Backups and recovery of Master, MSDB and Application databases
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Involved in SQL Server installation and Upgrade in Test, Development, QA, Model office & Production servers.
• Created tables, Indexes, Stored Procedures, Triggers and Views.
• Installed, configured SQL Server 6.5 on Windows NT platforms.