Andrew Kolega

**-** **** **. ******* NY *****

Email: ac8rdb@r.postjobfree.com

Phone: 917-***-****

OBJECTIVE

A position as Sr. Oracle Database Administrator

SUMMARY

Over 30 years experience in IT, over 20 years experience as an Oracle database administrator. 4 years experience as a member of a Database Architecture and Engineering team.

Experience:

Jan 2018 – Present JP Morgan Chase

Hired as a Sr, Oracle DBA and joined the Sustained Engineering Database Services team.

Duties included:

Providing DBA support for many critical 11gR2 and 12c

Standalone and RAC databases running on Redhat linux and AIX.

Troubleshoot query and instance level performance issues .

Maintain backup and recovery strategy using rman and zdlra

Maintain BCP strategy using Dataguard

Apply PSU patches and one off patches

Perform ASM disk maintenance.

Perform upgrades.

Jan 2016 – Sep 2017 Deutsche Bank

Hired as a member of a Level 3 Global DBA Exadata Support team.

Duties included:

• Providing DBA support for many critical, very large (20TB) RAC databases version 11.2.0.4 running mostly on exadata x3, x4 and x5 with Oracle Enterprise Linux along with databases running on Solaris zones.

• Troubleshoot performance issues at the instance and sql levels.

• Troubleshoot rman issues for backups and clones to non prod.

• Troubleshoot Dataguard issues.

• Applying CPU, PSU and exadata bundle patches.

• Performing ASM Diskgroup maintenance.

• Performing Cell Server disk maintenance.

Feb 2013 – Oct 2015 Brown Brothers Harriman

Was a member of a DBA team that was responsible for supporting the most high profile and critical databases in the firm.

Duties included:

• Providing 24/7 DBA support for critical, very large (20TB) RAC databases version 11.2.0.3 running on exadata x2, x3 and x4 with Oracle Enterprise Linux.

• Troubleshoot performance issues at the instance and sql levels.

• Implement Database Resource Management and IO Resource Managnment.

• Set up and support backup and recovery strategy using rman, DDBoost and ZFS.

• Install OEM 12c (version 12.1.0.4) and set up monitoring for databases, ASM, Clusters, servers, exadata components and Golden Gate.

• Support Business Continuance Strategy using Oracle Data Guard.

• Refresh non prod database from prod using rman clone and datapump.

• Replicate data using Golden Gate versions 11 and 12.

• Assiste in planning and supported Data Center Migration of critical databases from x2 to x4, x3 to x4.

• Assiste in planning and supported application of quarterly exadata bundle patches.

• Install, implement and administer to Oracle Data Integrator.

• Set up services in Oracle Internet Directory.

Aug 2008 – Dec 2012 TD Ameritrade Jersey City NJ

Sr. DBA Consultant

Provided DBA and engineering support as a member of the Database Architecture and Engineering team to a number of high profile critical projects.

Duties included:

Building 10gR2 and 11gR2 databases on zlinux architecture running SLES10 and SLES 11, x86-64 bit architecture running Red Hat 6.2, Solaris 10 on Sparc and Solaris x86

Providing specifications to build virtual servers for a database migration project from physical Solaris and Red Hat servers to virtual zlinux servers on an IBM Z10 mainframe.

Assist in developing a standard build process for virtual servers on the IBM zlinux platform for Oracle 10g on SLES10 and 11gR2 on SLES 11 and Red Hat 6.

Document process and the plan to covert and migrate the databases from Solaris to zlinux on the IBM Mainframe and from cooked filesystems to ASM.

Plan and perform migrations from Solaris to zlinux with conversions to ASM.

Provide documents for installation, backups, software cloning, database cloning and database standards.

Develop and document migration strategy and for migrating Oracle databases from Red Hat 4 to SLES 10 as part of datacenter migrations.

Plan and provide DBA Support for the datacenter migrations

Documented DBA tasks for implementing data masking using IBM Optim data masking tool.

Configured Oracle Heterogeneous Services and Oracle Gateway 11g to access Sql Server and Cache databases.

Documented DBA tasks to clone non prod databases using storage snap technologies such as IBM XIV.

Develop and document upgrade and cross platform migration strategy and upgrade from 10gR2 to 11gR2 and from single instance to RAC.

Plan and perform upgrades from 10gR2 to 11gR2 with and without simultaneous cross platform migrations

Develop and Document HA and DR strategy which included RAC, Dataguard and Active/Passive HA

Develop and document automated process to implement Active/Passive HA for 11gR2

Implement backup strategy to use incremental backups for lager databases and migrate from rman tape to disk and later to EMC Datadomain

June 1997 – June 2008 Merrill Lynch NYC NY.

Sr. Oracle DBA

Duties included:

Building and supporting 7, 8i, 9i, 10g, 10gR2, 11g databases on Solaris 8,9,10, Red Hat version 3 and 4 and AIX for various financial applications both home grown and 3rd party vendor applications inlcuding Oracle Financials 10 and 11i and Oracle Applications Server Suite 10.2.0.1.2.

Building and supporting 10gR2 RAC databases on Red Hat 3 using ocfs2.

Building and supporting of 10gR2 Portal environment using Oracle Application Server 10.1.2.0.2 with the backend databases on 10gR2 RAC.

Implement 24/7 monitoring strategies.

Develop and implement backup and recovery strategies.

Develop and implement DR strategies using Oracle Standby Database and Data Guard.

Plan and execute database upgades.

Instance and query performance tuning.

Managing a team of 4 - 8 Oracle DBAs that supported Financial System databases. Responsibilities included:

Assigning support for databases to team members.

Setting up on-call rotation for 24/7 support.

Assign tasks for strategic projects to team members and track and report status.

Create and maintain DBA Standards documentation.

Promoted to Assistant Vice President in 2001.

April 1995 – June 1997 Frederick Atkins Inc. NYC NY

DBA

Duties included:

Building and supporting version 7 Oracle databases for various merchandising and financial applications.

Developing and implementing 24/7 monitoring.

Developing and implementing backup and recovery strategies.

Instance performance tuning.

April 1995 – June 1996 Frederick Atkins Inc. NYC NY

Sr. Programmer/Analyst

Duties included:

Designing, coding, implementing and maintaining merchandising applications written in CICS Cobol, RPG II, Oracle Forms, Oracle Reportwriter.

Nov 1994-Apr 1995 Taconic Data Corp Valhalla NY

Sr. Programmer/Analyst

Duties included:

Writing sql loader scripts and stored procedures to load real estate listing data into an Oracle 7 database and extract it in specified formats for distribution to Multiple Listing Service (MLS) organizations.

Jan 1990 – Nov 1994 Frederick Atkins Inc.

Sr. Programmer/Analyst

Duties included:

Designing, coding, implementing and maintaining merchandising applications written in CICS Cobol, RPG II, Oracle Forms, Oracle Reportwriter.

Jan 1989 – Jan 1990 Frederick Atkins Inc.

Computer Operator

Duties included:

Operating an IBM 4381 running under the Power OS

Executing batch jobs

Executing backup jobs.

Sept. 1984 – May 1988 Norstar Back NYC NY

Computer Operator

Duties included:

Operating an IBM 4381 running under the Power OS

Executing batch jobs

Executing backup jobs.

FORMAL EDUCATION: 1976 – 1980 City College of New York

Earned over 100 credits towards a BS in Electrical Engineering.

TECHNICAL EDUCATION:

Oracle 10g and 11g New Features for Adminstrators

Oracle 10g and 11g RAC workshops.

Oracle 10g and 11g Dataguard workshops

Contact this candidate