SUMMARY:

• Over 18 years of IT industry experience.
• Functioned as Senior MSSQL Server DBA for the last 12 Years.
• Highly Proficient in all DBA functions - including server installation, configuration, security issues, storage management, backup & restore policy & procedures, and data manipulation across multiple servers - also has excellent knowledge of Database Architecture, Triggers & Stored procedures, Distributed Transactions and Replication.
• Expert in Data Modeling Logical & Physical Database Design, Schema Optimization, and SQL Queries.
• Well versed in Performance Optimization, large-Scale Production Environments and Troubleshooting.
• Installation, configuring, deployment and trouble shooting of issues on SQL Server 2014, SQL Server 2012, 2008, 2008 R2 /2005 /2000 versions
• Database Backup, Recovery, and SQL Jobs, ETL Integration Process, DTS / SSIS / SSAS / SSRS creation and troubleshooting.
• Excellent experience in full life cycle development.
• Production Support Experience, willing to work in shifts.
• Team handling and management experience.
• Handling and troubleshooting production outages.
• Knowledge on Third Party tools like SQL Litespeed, Hyperback, SQL Sentry, DBArtisan, Erwin, ETL tools.
• Experience in working with vendors like Microsoft.
• Good team player with excellent communication Skills with Financial domain experience.

TECHNICAL SKILLS:

Database Architecture: Database Architect using Erwin Software and Informatica ETL, Micro strategy 7, with Business Intelligence and Data Ware housing. Database diagrams include Logical and Physical Models.

Administrative tasks: MS SQL Server 2014, 2012, 2008, 2008R2 /2005/ 2000 versions, DB2, SYBASE, ORACLE.

Gateways: MDI Database gateways and Sybase DIRECT CONNECT.

Operating Systems: Windows 2003 and Windows 2008 Advanced Servers, Clustered environment, UNIX.

Management tools: Knowledge of system management tools e.g. - BMC Patrol, Tivoli, Remedy, VMware, DBArtisan, Erwin, ETL tools, client interfaces to database such as ODBC, JDBC, Perl DBD, Perl Scripting, shell scripting.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior SQL Server DBA

Responsibilities:

• Installed and Configured MS SQL Server 2014, 2012, 2008 R2 converted databases from versions 2005/2K to 2012 to 2014, 2008 R2 and set up new security applied new DDL, and backup/restore databases, performance tune SQL and heavy analysis of current database usage.
• Installation of new SQL Servers 2012 and 2014 clusters
• Design and install and delivers applications, jobs, stored procedures, triggers etc... For DBA owned business critical functionality, 24/7 responsibility for all Production servers and processes.
• As a Production support DBA, responsible for installation, configuration, monitoring and support of production and QA servers in production environment.
• Installation, configuring, deployment and troubleshooting of issues on SQL 2000/2005/2008/ 2012 versions
• Performed 24x7 support, resolve production incidents on time and troubleshoot issues on production systems
• Hands on experience on high availability such as multi-node cluster implementation Clustering, Log Shipping and Replication, and SQL 2012 Always On
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues.
• Hands on deployment experience on production servers
• Handling and troubleshooting production outages
• Proactive DB monitoring using Net cool, Service now.
• SQL server tools like Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system sprocs
• Production Support Experience, willing to work in shifts
• Team handling and management experience
• Good communication skills with financial domain experience.

Confidential, NJ

Senior SQL Server DBA

Responsibilities:

• Installation of new SQL Servers 2012 and clusters.
• Design and install and delivers applications, jobs, stored procedures, triggers etc... For DBA owned business critical functionality, 24/7 responsibility for all Production servers and processes.
• As a Production support DBA, responsible for installation, configuration, monitoring and support of production and QA servers in production environment.
• Software Integration, DTS, BCP, SQL transfer manger and replication management
• Installation, configuring, deployment and trouble shooting of issues on SQL 2000/2005/2008/ 2012 versions
• Successfully led a team for converting 200 SQL Server databases from Ver 2K to SQL 2005 and SQL Server 2008 to SQL 2012.
• Database Backup, Recovery, and SQL Jobs, DTS / SSIS/SSAS/SSRS creation and troubleshooting.
• Upgraded and reengineered over 300 DTS to SSIS packages, using ETL Integration Processes, business requirements and designing end-to-end ETL solutions that best meet business needs.
• Hands on experience on high availability - Clustering, Log Shipping and Replication
• Performance Tuning, Security, Space Management, Blocking, Deadlocking
• Hands on deployment experience on production servers
• Database development/ modeling experience
• Handling and troubleshooting production outages
• Experience in working with vendors like Microsoft required
• Working knowledge on Oracle and Sybase
• Production Support Experience, willing to work in shifts
• Team handling and management experience
• Good communication skills with Financial domain experience.

Confidential, NJ

Senior SQL Server DBA

Responsibilities:

• Responsible for common DBA tasks in WIN 2000 and Win 2003 multi-server multi-instance SQL Server Enterprise Edition
• Provided Systems DBA support for large Enterprise with over 250 Servers and 1000+ databases.
• Designed and implemented multi-master replication environment across 4 world-wide sites.
• Designed, Coded and Implemented advanced performance monitoring system utilizing shell scripts and TSQL.
• Created upgrade feasibility environment for SQL 2008. Developed procedures and performed upgrades from Sybase to SQL Server 2008.
• Developed and implemented Table Partitioning for large tables (10000 million rows 50-100GB).
• Designed and implemented backup strategies according to business needs.
• Designed and implemented Custom application reporting packages Using SSIS according to business needs.
• Bureau reporting (ISO and Statutory Financial Reporting), to the mgmt during auditing.
• Performed Disaster Recovery on both the Production and QA environments.
• Responsible for enrolling & controlling user access, user creation, roles creation, grants roles & privileges, security system, backup and recovery, etc.Worked as a Tech lead with the Met’s insurance, HR, Individual business and Institutional Business sales support, Broker Dealer Departments.

Confidential

SQL Server DBA

Responsibilities:

• Performed project management for R&D development teams. Responsible for DBA aspect of R&D IT project management including sizing work efforts and handling staffing needs.
• Successfully led a team for converting 200 SQL Server databases from Ver 7.O to SQL Server 2000
• Develop SLA's with customers and ensure compliance.
• Evaluated new technologies including SAN storage, clustered hardware and VLDB’s assisting customers in there purchasing decisions.
• Created SOPs for common database management tasks. Standardizing complete lifecycle of database management.
• Assisted project teams with budget forecasting including obsolescence reviews and capacity planning.

Confidential, Horsham, PA

SQL Server DBA

Responsibilities:

• Responsible for common DBA tasks in WIN 2000 and Win 2003 multi-server multi-instance SQL Server Enterprise Edition
• Provided Systems DBA support for large Enterprise with over 50 Servers and 100+ databases.
• Designed and implemented multi-master replication environment across 4 world-wide sites.
• Designed, Coded and Implemented advanced performance monitoring system utilizing shell scripts and TSQL.
• Created upgrade feasibility environment for SQL Server 6.5 to 7.0 and to SQL 2000. Developed procedures and performed upgrades from SQL Server 6.5 to 7.0 and to SQL 2000.
• Responsible for GxP documentation on Discovery databases according to FDA standards.
• Provided troubleshooting for database and applications issues. Installed and tested SQL Service packs and Latest Hotfixes meaning patches.
• Designed and implemented backup strategies according to business needs.
• Performed Disaster Recovery for both Production and Development environments.
• Responsible for enrolling & controlling user access, user creation, roles creation, grants roles & privileges, security system, backup and recovery, etc.

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Managed Database Servers using SQL Server 7.0 on Win NT.
• Responsible for Replication of Servers across different locations.
• Security, system startup/shutdown and installation of software upgrades.
• Configure SQL Server, Optimize the Server, Create Scheduled tasks and transfer all the data, users, passwords, applications and files.
• Reviewing all the applications for performance tuning and converting access data to SQL Server.
• Programmed extensively in Transact-SQL (triggers, stored procedures, SQL Executive database task automation, and views).
• Responsible for documenting all the efforts for easy transition.

Environment: MSSQL Server 7.0 (Thirty WinNT SERVERS, and Client Workstations Winnt 4.0 Sap R/3, Applications and Informatics ver 6.0).

Confidential, Kenilworth, NJ

MS SQL Server DBA

Responsibilities:

• Worked as a MSSQL DBA and Participated in the development and Y2K testing of the project, experience includes database enterprise architecture design (conceptual & physical), database administration and performance tuning.
• Hands on experience in MS-SQL Server and have a good Knowledge in data base objects such as stored Procedures, triggers and views. Also, downloading the data from DB2 to MSSQL Server via MDI gateways ad Sybase DIRECT CONNECT.
• Transferred the total Database objects and Data from Production Sybase version to MSSQL Server version 6.5

Environment: Windows NT Servers, Backend MSSQL Servers, DB2 on MVS platform, WIN 95 Clients, Power builder 5.0.4, Key file servers

Confidential, MA

MS SQL Server Application DBA

Responsibilities:

• Worked as a MS/SQL DBA and Windows NT SA and participated in the development and Beta testing of the Project.
• Experience includes database enterprise architecture design (Conceptual& physical), database administration and performance tuning.
• Hands on experience in MS SQL Server and have a good Knowledge in database objects such as stored procedures, triggers and views.
• Security Administration: Software Design, Development, Implementation and Ongoing Maintenance, Software Integration, DTS, BCP SQL Transfer Manger and Replication Management. Operations (backups, Device and database management).

Environment:MSSQL ver 6.5 (Four Server Visual Basic ver 5.0 with MDAC 1.5 with ADO and RDS and). CRYSTAL reports ver 6.0 15 Pentium PC with Windows NT ver 4.0

Confidential . NJ

SQL Server Application DBA

Responsibilities:

• Understanding the source code and depending on that preparing Data Flow Diagrams, Entity Relationship Diagrams, Data Flow Diagram Dictionary, Data Dictionary, Screen Detail Design, Report Detail Design, Screen Layouts, and Flowcharts.
• Involved in maintaining the applications on the Production Servers. The maintenance activities include Backup/Restore, Performance Monitoring and Database consistency checks, monitoring and debugging error logs and Scheduling tasks for the various activities to be carried out on the database.

Environment: SQL Server ver 6.5 as backend, Visual C++ ver 5.0 with MFC ver 4.21 as Front end, Pentium PC with Windows NT ver 4.0.