SUMMARY:

• Over 25 years of SQL Server experience as both Administrative and Development DBA
• Knowledgeable with SQL Server 6.5 through 2016
• Knowledgeable with SSIS, SSRS, and SSAS
• Ability to write, debug and tune stored procedures, functions as well as database design.
• Worked with databases as small as several MB to over 8 TB and in shops with as few as 5 production instances to over 3000.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Senior Database Administrator

Responsibilities:

• Supporting SQL Server in both physical and virtual environments. Supported and implemented several clustered physical servers using SQL Server 2012 and 2014.. Implemented transactional replication and database mirroring in several virtual servers.
• Enforcing HIPPA compliance of database servers by monitoring and auditing security access to production databases and cleansing of data in lower environments.
• Development of and maintenance of several data warehouses for Confidential and Confidential clients.
• Working with development team on the development, tuning, and debugging of stored procedures, functions, and SSIS packages. Deploying and debugging these changes in UAT and Production.
• Implementing database best practices standards with regards to backups, maintenance jobs, and security using Ola Hallengren procedures and using Data Domain as our primary backup server.
• Writing PowerShell scripts to handle some simple DBA daily tasks such as scripting out production SQL Agent jobs for DR purposes and clean up of older database backup files.
• Working within a team of 3 DBA’s providing support for SQL Server in Development, UAT, and Production environments with on - call rotation.

Confidential, Parsippany, NJ

Database Administrator/Senior Associate

Responsibilities:

• Supported SQL Server on both physical and virtual environments. Also supported and implemented several clustered physical servers using SQL Server 2012. Implemented transactional replication and database mirroring in several virtual servers.
• Implementing database best practices standards with regards to backups, maintenance jobs, and security using Ola Hallengren procedures and using Data Domain as our primary backup server.
• Working within a team of 4 DBA’s providing support for both Oracle and SQL Server in Development, UAT, and Production environments with on-call rotation.
• Working with DBA teams throughout the company on developing consistent standards for all SQL Server databases in our Insurance, and Direct Sales divisions.
• Working with System admins to upgrade and virtualize older systems off of end of life servers and performing SQL upgrades from R2 and 2012.
• Worked to implement the new Solarwinds monitoring solution and develop proper alerts and monitoring of our SQL Server inventory. Also, used to assist in performance monitoring and tuning.
• Implemented a shared SSRS environment in development and production.
• Heavily involved in the migration of systems and database from the Annuity business into the Investments data center.
• Involved in budget planning and projects for the FY 2015.
• Involved in the planning and execution of yearly disaster recovery tests of all systems in Parsippany to the Clinton data center.
• Involved in the migration of the Parsippany Data Center to Clinton.

Confidential, Parsippany, NJ

Database Administrator

Responsibilities:

• SQL Development role on new MEEVO cloud based application. Duties included database development, tuning, SSIS development, and implementing source control and controlled deployment of all database changes from Dev through to Prod. Also, implementing coding and naming standards for all new development.
• Sole Database Administrator responsible for providing 24x7 support for all SQL Server databases in the company (SQL Server 2005, 2008 and 2012).
• Implementing database best practices standards with regards to backups, maintenance jobs, and security.
• Implemented various daily SSRS reports to advise of general database health.
• Implemented use of SQL Sentry for real time and historical database monitoring to assist in database performance tuning.

Confidential, Lakeland, FL

Senior Database Administrator

Responsibilities:

• Senior Database administrator responsible for maintaining SQL Server 2000, 2005, 2008 and 2012 databases in development, testing, UAT, and production environments.
• Responsible for providing support to the application developers for the development and testing environments and assisting them with production rollouts.
• Developed numerous daily reports in Reporting Services to assist the DBA team in monitoring the many servers, databases, and jobs.
• Developed automated procedure and supported upgrade of Confidential retail environment (2100+ servers) from SQL Server .
• Provided Primary database support for BizTalk 2010.
• Provided 24x7 production on-call support of production systems as well as off-hours support for major tasks (server moves, upgrades, etc.)
• Reviewed current Corporate production environment and implemented updated procedures for daily and weekly maintenance.
• Provided additional guidance for enhanced SQL Server standards throughout the organization.
• Implemented first production database mirroring project at Confidential
• Implemented first SQL Server 2012 database instance on a Windows 2012 Server platform.
• Development and implementation of data warehouse of sales data for Corporate office.
• Lead DBA on several large scale projects, leading teams of 2-3 junior DBAs. Lead for major project of upgrading all store SQL servers to SQL 2008. Coordinated with business and other technical areas to implement upgrade of 2000 servers.
• Enforcing HIPPA compliance of database servers by monitoring and auditing security access to production databases and cleansing of data in lower environments.

Confidential, Tampa, FL

Database Administrator

Responsibilities:

• Sole Database administrator responsible for maintaining approximately 60 instances of SQL Server 2000, 2005, and 2008 databases in development, testing and production environments. Sizes of databases ranged from 3 GB to over 7 TB.
• Lead team of 4-6 people from AppDev group. Was responsible for leading and coordinating upgrades of SQL Server along with conversion from physical to VM servers.
• Designed and implemented a SSRS solution for monitoring database backups and processes. Also designed and implemented a SSRS solution for several canned business defined reports.
• Responsible for converting existing DTS packages to SSIS as well as developing new over 70 new SSIS packages to help automate business processes. Current library consists of over 90 SSIS packages agency wide.
• Responsible for providing support to the application development team for development and testing environments and assisting with production rollouts. Also, provided assistance to other groups (Infrastructure, Special Projects) for setting up and maintaining database instances for vendor applications.
• Use of RedGate SQL Toolbelt products for source control (using Team Foundation Server), data and schema comparison and backups.
• Instrumental in the planning and executing the upgrade of all SQL Server databases from first and then to 2008 as well as moving the SQL Server instances off physical servers and into the new VM environment.
• Responsible for recommending and building a new SQL Server VM Farm that is dedicated to only running SQL Server instances in our DR and Production sites.
• Instituted best practices policies for database related enhancements and use.
• Provided 24x7 production on-call support of production systems as well as off-hours support for major tasks (server moves, upgrades, etc.)

Confidential, Lakeland, FL

Senior Database Administrator

Responsibilities:

• Senior Database administrator responsible for maintaining SQL Server 2000 and 2005 databases in development, testing, UAT, and production environments.
• Responsible for providing support to the application developers for the development and testing environments and assisting them with production rollouts.
• Assisted in the reorganization of the SQL Server databases to new 64-bit clusters. This reorganization involved moving over 100 databases to new silos that were broken down by business groups. Once this was completed in the staging environment, the production environment was then done.
• Worked heavily with both the SAN team to determine disk space needs and also with the NetBackup team on developing tape backup strategies.
• Provided Primary database support for BizTalk 2006.
• Developed numerous daily reports in Reporting Services to assist the DBA team in monitoring the many servers, databases, and jobs.
• Provided 24x7 production on-call support of production systems as well as off-hours support for major tasks (server moves, upgrades, etc.)
• Enforcing HIPPA compliance of database servers by monitoring and auditing security access to production databases and cleansing of data in lower environments.

Confidential, Tampa, FL

Senior Database Administrator

Responsibilities:

• Senior Database administrator responsible for maintaining databases in both SQL Server (2000 and 2005) and Oracle (8i, 9i, and 10g).
• Responsible for providing support to the application developers for the development and testing environments and assisting them with production rollouts.
• Enforcing HIPPA compliance of database servers by monitoring and auditing security access to production databases and cleansing of data in lower environments.

Confidential, Tampa, FL

Senior Database Administrator

Responsibilities:

• Senior Database administrator responsible for maintaining SQL Server databases using SQL Server 7.0, 2000 and 2005 in development, UAT, and production environments (approximately 25 servers and 2 clusters).
• Responsible for maintaining replication between SQL Server, DB2, and Oracle using the DataMirror Transformation Server product.

Confidential, Tampa, FL

Senior Database Administrator

Responsibilities:

• Senior SQL Server DBA responsible for 51 SQL Server databases on 15 different servers covering Development, UAT, and Production environments located in Tampa, FL and Crawley, UK data centers.
• Responsible for all bi-directional replication for SQL Server, Oracle, and DB2 AS/400 instances using a combination of native replication, such as DTS and Materialized Views, as well as DataMirror Transformation Server technologies.
• Responsible for managing and delegating assignments to Montreal and Crawley DBAs, as well as offshore DBAs located in Mumbai, India.
• Designed, coded, and implemented the Oracle logical model for the legacy AS/400 replacement system.
• Data Architect for the Oracle and DataMirror implementation for the ECommerce application.
• Responsible for SQL Server, Oracle, and DataMirror installations and upgrades.

Confidential, St. Petersburg, FL

Database Administrator/Systems Analyst

Responsibilities:

• Database administrator and Systems Analyst responsible for applications within the Fixed Income Division of Confidential . Systems were web-based using VB Script on ASP pages. Coding was also done with Visual Basic 6.0 and Microsoft SQL Server 6.5 and 7.0 via stored procedures.
• Responsible for implementing and maintaining MSMQ to handle time delayed or email requests for reports.

Confidential, Parsippany, NJ

Senior Systems Analyst/Database Administrator

Responsibilities:

• Senior Systems Analyst and Database Administrator responsible for all systems supporting the Tax department and the Auditing Department of Nabisco and RJ Reynolds. This included maintaining both off-the-shelf software as well as designing, coding, testing, and implementing new systems. These systems were written using Visual Basic 5.0 using Microsoft SQL Server 6.5 as the database using stored procedures, triggers, and functions.

Confidential, Florham Park, NJ

Associate Systems Manager/Database Administrator

Responsibilities:

• Responsible for numerous different financial systems during my tenure at Prudential. Systems. These systems were both mainframe and client/server based systems. Mainframe systems were run on an IBM-370 mainframe system using COBOL as the primary language. Data storage used included VSAM and QSAM for flat file processing. Databases used included IDMS and DB2. Front-end design used ADS/O and CICS.
• Responsible for Client/server systems that were developed in Access and Visual Basic 4.0.
• Responsible for database systems that were used, which included Sybase System 10 and Microsoft SQL Server 6.0 and 6.5. This included writing and maintaining TSQL code for stored procedures and ad hoc queries against the database.