Patricia Pezzi

Lead Database Engineer at Benjamin Moore & Co.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Flanders, New Jersey, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Manufacturing
    • 200 - 300 Employee
    • Lead Database Engineer
      • Feb 2015 - Present

      •Manage Outsource for Database Administration – SQL Server and Oracle Databases.•Creation, Test and Document of all Procedures that are requested by change request to the Outsource.•Setup and creation of PowerShell scripts to produce reports on Database Servers to keep better control of the environment.•Diagnosed and resolved all issues on Manufacturing Servers.•Migration of Database Servers from Flanders, New Jersey to Arlington, Texas.•Monitor Manufacturing Sites for better performance.

    • United States
    • Entertainment Providers
    • 700 & Above Employee
    • Prinicpal DBA
      • Jun 2014 - Sep 2014

      My responsibilities include:•Coordination of Data Center Migration from Brooklyn to New Jersey Data Center. Migration of 159 SQL Servers, 52 Oracle and 6 Sybase Database servers. •SOX Database Reporting, Analysis and Consultation with Auditors.•Database Sizing Report provided to Finance for bill back to the Business Units.•SQL Server Enterprise Agreement True Up with Microsoft utilizing Maptool.•Coordination of Data Center Migration from Brooklyn to New Jersey Data Center. Migration of 159 SQL Servers, 52 Oracle and 6 Sybase Database servers. •SOX Database Reporting, Analysis and Consultation with Auditors.•Database Sizing Report provided to Finance for bill back to the Business Units.•SQL Server Enterprise Agreement True Up with Microsoft utilizing Maptool.

    • Principal DBA
      • Mar 2000 - Sep 2014

    • Senior Manager Database Administraion
      • Apr 2012 - Jun 2014

      • Responsible for Oracle 9i, 10g, 11g, E-Business Suite 11.5.1, 12.1.3, SQL Server 2000, 2005, 2008, 2008R2, 2012 and Sybase 12.0, 12.5.1, 15.0.2 and Sybase IQ 12.7• Management of 5 Oracle DBAs, 4 SQL Server DBAs and 2 Sybase DBAs• Management of approximately 500 Servers utilizing 100 terabytes of data storage• On Call 24x7x365 Rotation Schedule• Coordination and implementation of project plans• Management of Resources – on call, vacation, resource allocation for projects, classes• Geo-Diverse High Availability • Disaster Recovery • Good understanding of the business, incorporate the ITIL process and adhere to customer’s SLA’s.• Maintain relationships with our application owners.• Database Sizes Metrics• SOX Quarterly Reporting on designated SOX servers. Define SOX Governance Procedures, Creation of reports, quarterly process and analysis. • Management of Change Requests and Service Now Tickets• Employee Performance Evaluations• Consultants and other resources: manages tasks, workloads, tracks hours and overtime.• Manage off-hour support requirements (i.e. patching, maintenances, emergencies, etc.).• Experience managing technology professionals in a multi-facility environment.• Provided Customer Relationship Management across Business Units throughout the Enterprise.• Managed Vendor License Agreements.• Created and Coordinated Evaluation Plans for Vendor Product Proof of Concept.My responsibilities include:

    • Manager Database Administration
      • Mar 2000 - Apr 2012

      My responsibilities include:•Built the team from 0 to 5 Oracle DBAs, 3 SQL Server DBAs, 1 Sybase DBA •Management of servers grew to approximately 400 Servers utilizing 75 terabytes of data storage from approximately 150 servers utilizing 10 terabytes of storage in 2007.•Provide Business Case and Power Points for Budget Approvals.•Disaster Recovery – 1 time per year for designated applications.•Management of Resources to cover On Call and Projects.•On Call 24x7x365 Schedule•Database Sizing Metrics•Oracle E-Business, Sybase IQ (12.7) in addition to Oracle, Sybase (12.0, 12.5.1, 15.0.2) and SQL Server (7, 2000, 2005, 2008, 2008R2)•Management of Service Now tickets to insure they are being resolved in a timely manner.•Manage the workload and priorities of the DBA team which is responsible of supporting Back office database systems 24x7 basis that are running Oracle, SQL Server, Sybase, Sybase IQ databases and applications. •Understand customer needs and priorities and coordinate Database Operations deliverables with them.•Conduct 6-month goal review and Annual Employee Performance evaluations.•Demonstrates excellent communication, organizational and follow up skills.•Strong people skills, including the ability to interact with customers, IS&T personnel, and management conveying technical information in an understandable manner to nontechnical personnel.•Results oriented team player, who leads by example, holds self-accountable for performance, takes absolute ownership, and champions all aspects of customer and product initiatives.•Manage the hiring process for employees or consultants.•Multiple Data Center Migrations on both the east and west coasts.•Ability to learn new technologies and adapt to a dynamic environment.

Community

You need to have a working account to view this content. Click here to join now