VINCENT M CAMMARATA

** ***** ******* ****** *** York City, NY 10004

Cell 305-***-**** • Home 212-***-**** • acwuos@r.postjobfree.com

Objective

To obtain the position of Database Administrator using my 15+ years of DBA experience to support and manage build/enhance systems in a fast paced environment.

Summary of Accomplishments

SENIOR DATABASE ADMINISTRATOR BACKUP AND RECOVERY SPECIALIST

Solutions-driven IT professional with 15+ years of database administration experience and extensive hands-on background in production support and release management with a keen ability to resolve critical database problems.

Manage the planning, architecture, deployment, capacity planning, policy-scheduling and management of Windows/Unix/EMC Avamar Grid-based infrastructures in conjunction with database administration.

Outstanding relationship builder, skilled at quickly gaining and maintaining the trust and respect of business leaders, staff, strategic partners, and international clientele with a solid record of achievement in building and aligning organizations with strategic business objectives to achieve improved bottom-line results.

Selected by senior management to direct a team of eight offshore and onshore DBAs to ensure the on-time release of critical projects, incident management, and to assist the support of over 200 applications.

KEY QUALIFICATIONS

Database administration

Systems architecture

Operations management

Log shipping

Disaster recovery

Database security

SQL replication

Regulatory & SOX compliance

SSIS & SSAS & SSRS

Strategic planning

SAN Storage

Performance metrics

Resource allocation

Cluster configuration

Data Domain

Avamar Policy

Performance & tuning

Security compliance

Avamar Scripting

Avamar Grid

Team leadership

Always On/Mirroring

Customer Service

Troubleshooting

CAREER HIGHLIGHTS

PCM MALL - EL SEGUNDO CA 2014-PRESENT

Leading hardware & software company in retail. Direct Marketer of products and services to businesses and government.

SENIOR MICROSOFT SQL SERVER DATABASE ADMINISTRATOR

KEY HIGHLIGHTS

Manage and coordinate deployment schedule alongside IT and business groups to ensure that projects are successfully completed.

Monitor and optimize stored procedures and queries to support web site.

Support SQL replication for over 10,000 tables via transactional, snapshot and peer to peer replication for critical systems and disaster recovery.

As lead DBA, design and document processes to ensure compliance with Sarbanes-Oxley/Internal Audit.

Create production support policies and guidelines for all developers and IT professionals.

Supported SSIS SSRS and SSAS services along with legacy DTS

Support a large-scale database system and maintenance in a 24/7 environment.

Implement DR strategy using transactional replication, log shipping and mirroring.

Release of code to production environment that includes extensive work with developers and MKS.

Manage team of four database administrators for production support offshore in Manila.

Implement Microsoft Always On and Mirroring for read only database.

BARNES & NOBLE BOOKSTORE / NOOK – NEW YORK, NY 2011-2014

Leading bookstore, Fortune 500 company in retail sales for content, digital media and educational products

SENIOR MICROSOFT SQL SERVER DATABASE ADMINISTRATOR

KEY HIGHLIGHTS

Plan and create backup and disaster recovery plans for all production, QA and development SQL servers via dump and load, log shipping and mirroring and utilizing EMC Avamar and SQL Backtrack.

Proficient in EMC Avamar Data Domain for SQL Server, TSM and Quest Light Speed.

As lead DBA, design and document processes to ensure compliance with Sarbanes-Oxley/Internal Audit.

Support a large-scale database system and maintenance in a 24/7 environment.

Implement DR strategy using transactional replication, log shipping and mirroring.

Manage Backups via Avamar Grid and custom Avamar Scripts for schedulers (AutoSys/Control-M).

Release of code to production environment that includes extensive work with developers and MKS.

Supported SSIS SSRS and SSAS services

MOODY’S INVESTORS SERVICES – NEW YORK NY 1996-2011

A nationally registered credit ratings agency, assigning debt risk ratings to publically issued bonds.

SENIOR MICROSOFT SQL SERVER / SYBASE DATABASE ADMINISTRATOR OF INFORMATION TECHNOLOGY

KEY HIGHLIGHTS

Managed and executed the deployment of MSSQL 2000, 2005 & 2008 upgrade for over 135 SQL Servers. Deployment included hardware upgrades, replacing server with VM and SAN technologies.

Worked with IT and business groups to coordinate global deployment schedule.

Designed and planned backup and disaster recovery plans for all production, QA and development SQL servers via dump and load, log shipping and mirroring.

Maintained proper compliance practices with Sarbanes-Oxley (SOX) requirements.

Responsible for the operational support of over 700 data servers running MSSQL and Sybase along with SSRS & SSIS.

Tested and integrated the latest versions of service packs and patches.

Proficiency in performance & tuning, SQL replication, SSIS patches & log shipping.

Worked with third party tools such as EMC Avamar, SQL Backtrack, Quest Lightspeed and Network Appliance Snap Manager.

EDUCATION & PROFESSIONAL DEVELOPMENT

BACHELOR OF ARTS, POLITICAL SCIENCE – COMPUTER SCIENCE May 1999

Queens College, City University of New York, Flushing, NY

Certificates of Completion

MICROSOFT SQL SERVER 2000, 2005, 2008 and 2012 ADMINISTRATION/INTERNALS, Learning Tree International, NY, NY

SYBASE 15 INTERNALS

SYBASE Inc., New York, NY

INFORMATION TECHNOLOGY

Operating Systems: Windows 2012, Windows 7, Windows Server 2003, Unix

Languages: SQL JAVA

Software: MSSQL 2000, 2005, 2008, 2012, 2014 SYBASE 12.5, 15, Direct Connect for Sybase & MSSQL, MS Office, MS Access, SSIS & SSAS, EMC Avamar SQL/Workstation Backup, QUEST LIGHTSPEED, SQL BACKTRACK for SQL – SYBASE and TSM

Contact this candidate