Mary Mcwilliams

Oracle Database Administrator at NYU School of Professional Studies
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
New York, New York, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Joe Farhi

I have worked with Mary for 10 years and I found her to be detail-oriented, hard working individual who is easy to get along with and would be a great asset to any team. She has assist me many times in setting up and troubleshooting Oracle databases and is always willing to go the extra the mile to get the job correctly and on time.

LinkedIn User

Mary is an exceptionally talented DBA who is client focused and ensures her assigned tasks are completed on-time and in-full. She was a member of my team for several large projects requiring complex database tasks. I was always able to count on her support and technical knowledge to have all my DBA tasks completed as per the requirements. Mary will be an asset on any database team.

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

Credentials

  • Fundamentals of AWS
    Cloud Academy, Inc.
    Jan, 2021
    - Oct, 2024
  • Oracle Database 12c Administrator Certified Professional
    Oracle
    Jun, 2015
    - Oct, 2024
  • Oracle Database 11g Administrator Certified Professional
    Oracle
    Apr, 2015
    - Oct, 2024
  • Licensed Professional Engineer
    New York State Society of Professional Engineers

Experience

    • United States
    • Higher Education
    • 200 - 300 Employee
    • Oracle Database Administrator
      • Jul 2015 - Present

      Support Enterprise Manager and standby database environment for the school registration and websites. Support Enterprise Manager and standby database environment for the school registration and websites.

    • United States
    • Financial Services
    • 700 & Above Employee
    • Database Administrator
      • Jan 2015 - May 2015

      Supported OLAP Exadata environment. Worked on EHCC project. Supported OLAP Exadata environment. Worked on EHCC project.

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Sr. DBA
      • Jul 2010 - Dec 2014

      Supported rac and standalone databases in development and production, primarily on Solaris and Linux. Monitored production databases using adhoc queries and KSH scripts. Created DML scripts using Accurev for production releases. Examined database bottlenecks and evaluated sql statements. Automated partition maintenance. Implemented database backups. Performed character set conversions. Upgraded and patched databases. Implemented scripts for SOX compliance. Supported rac and standalone databases in development and production, primarily on Solaris and Linux. Monitored production databases using adhoc queries and KSH scripts. Created DML scripts using Accurev for production releases. Examined database bottlenecks and evaluated sql statements. Automated partition maintenance. Implemented database backups. Performed character set conversions. Upgraded and patched databases. Implemented scripts for SOX compliance.

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Database Administrator
      • 2008 - May 2010

    • Sr. Database Administrator
      • May 2008 - Apr 2010

      Supported project to merge US and Canada databases in a timely manner. This project required running hundreds of DDL schema changes and comparing the production and development databases. The project required refreshes of the development environment using an Oracle RMAN hot backup from production. Working on migrating Oracle SAP surround databases from data center in the UK; 20 TB of database will move. Working on SAP Business Warehouse upgrade project to oracle 11g. Supported database developers with schema changes, performance tuning and daily issues. Used Toad, Schema Manager, OEM, SQL, PL/SQL, TKProf, Statspack, and korn shell scripts. Use OEM to run ADDM and AWR reports. Show less

    • United Kingdom
    • Manufacturing
    • 700 & Above Employee
    • Senior Database Administrator
      • 1994 - Jun 2008

    • Sr. Database Administrator / Developer
      • Jan 1994 - May 2008

      Migrated in house databases to Oracle 10g and implemented new features. Installed and upgraded oracle and sql server software. Provided production support for Oracle Data Guard databases. Implemented changes that resolved Data Guard Performance problems. Create table partitions for historical tables. Used Toad and other products to compare databases and generate DDL.Supported Disaster Recovery testing of Oracle Data Guard Databases and Oracle RMAN backup databases.Supported SAP Business Warehouse, Hyperion, Peoplesoft and other commercial applications on an Oracle platform.Supported dozens of Peoplesoft development databases. Refreshed development databases using rman, installed and upgraded software. Provided Unix support on AIX by creating volume groups, file systems and users. Wrote unix scripts to support applications. Used BMC's Patrol, Nmon, vmstat and other tools to diagnose database and operating system performance issues.Supported warehouse application written in Pro*C, Report Writer, SQL Forms running on VAX/VMS Cluster (Oracle 6). Upgraded from Oracle 6 to 7.Provided third level support for production databases using Peregrine's Service Center.Created SQL*Server 2005 databases, installed and patched software. Use Remedy to create RFCs and maintain the configuration management database.Expert in Legato's Networker module and Maestro scheduling software. Resolved Oracle Data Guard (9i and 10g) and rman hot and cold problems. Show less

    • Sr. Systems Analyst
      • Jan 1987 - Jan 1994

      VAX/VMS systems manager. Installed the operating system, ran a training class for new users, supported applications and software. Installed and supported oracle 5 and 6. Developed Oracle applications using SQL*Forms, Pro*C. Used Erwin to develop data models. VAX/VMS systems manager. Installed the operating system, ran a training class for new users, supported applications and software. Installed and supported oracle 5 and 6. Developed Oracle applications using SQL*Forms, Pro*C. Used Erwin to develop data models.

    • Civil Engineering
    • 700 & Above Employee
    • Systems Analyst
      • 1985 - 1988

Education

  • Columbia University
    BS, Mechanical Engineering
    1974 - 1978
  • Stevens Institute of Technology
    M.S, Computer Science

Community

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