Sr Oracle DBA (Performance expert)

FUNCTIONAL PROFILE

Global Wholesaling Banking Oracle Database Leader

Mobile: 224-***-**** Email: ****.*****@*****.***

Expertise

Oracle Database Leader

Global Database Operations Management

Oracle (11g, 10g, 9i)

Oracle database internals

Oracle database performance tuning and optimization

Oracle RAC (11g, 10g)

OEM Grid Control 12c

Oracle Exadata support

Oracle DataGuard

Goldengate replication, Oracle Streams

Unix (Sun Solaris, Redhat Linux, HP-Unix)

SAN Storage (EMC,Hitachi)

NAS Storage (Netapp)

Change Management (ITSM, Maximo)

Database Automation (IPCenter)

Database Vendor Management

Industry Vertical

Banking

Finance

Healthcare & Pharmaceuticals

Education

BS - Bachelor of Engineering (Electronics & Telecommunications Engineering)

Executive Summary:

Strategic, goal-oriented & influential Oracle database leader with proven track record of success in leading database teams across the globe (follow-the-sun model). 18 years of experience managing complex, Oracle databases and database clusters hosting business critical applications. Intimate knowledge of Oracle database internals, Oracle RAC, Oracle DataGuard, database replication (Oracle Streams, Goldengate), Unix (Sun Solaris, Linux) and SAN Storage. Compelling communicator who inspires confidence in his vision and judgments, and is able to transmute this confidence into buy-in and adoption across the organization.

Selected Accomplishments:

Instrumental in establishing significant stability across the entire business critical Global Wholesale Banking database infrastructure resulting in a 40% reduction in the high severity client impacting database incidents.

Led several stability efforts in collaboration with the Unix and Middleware teams to achieve stability, consistent service times and optimal performance across the critical Payments and Wires applications.

Led the Oracle database operations team across US, India and Mexico for 24x7 database support of Global Wholesale Banking applications.

Implementation of database automation using IPCenter for automation of repetitive tasks.

Streamlining of monitoring of all the critical Oracle production database systems to ensure all facets of Oracle databases were being closely monitored.

Led the Tier2 database operations team across the globe for providing 24x7 production support of all databases across Bank Of America (Oracle, SQL*server, Sybase).

Was nominated for Bank of America “Award Of Excellence” for diligent work related to the complete redesign and optimization of the ACH (Automated Clearing House) system within Global Treasury Services.

CAREER SYNOPSIS

Independent Sr. Oracle Consultant

(2015-July 2017)

Global Wholesale Banking Tier3 Oracle Database Operations Manager,

Bank Of America

(2013-2015)

Lead Oracle DBA managing Global Banking & Markets (Trading) databases (at Bank Of America) consisting of clustered (Oracle 11g RAC) and single instance databases.

Performance expert with an excellent knowledge of Oracle internals,

Unix kernel and a good working knowledge of SAN fabric and SAN

storage (EMC & Hitachi).

Partnered with the application development teams to develop and

implement best practices for application code development for

maximum scalability and concurrency.

Rolled out a standard database performance troubleshooting

methodology across the entire Trading DBA team primarily using

OEM Grid Control 12c supplemented by custom scripts based on

data-dictionary views.

Responsible for streamlining the Disaster Recovery strategy for critical applications based on the RTO (Recovery Time Objective) and RPO (Recovery Point Objective) requirements. Data Guard (physical standby) was implemented as a standard DR strategy and Goldengate replication was implemented in exceptional cases based on business requirements.

Brought on board to engineer a turnaround of extreme instability within the Global Wholesale Banking database infrastructure that was causing frequent disruption and downtime affecting large corporate clients and loss of business and credibility.

Assembled and led a core team of Oracle database experts that interfaced closely with the first level of Oracle database production support (Tier2) to help triage critical business impacting incidents

Led several stability efforts in close collaboration with the Tier3 Unix team to establish stability and reliability within the GWB Oracle database infrastructure.

Partnered closely with the Tier3 Unix team and Tier3 Middleware team to detect and eliminate single points of failure affecting business critical GWB applications.

Led an extensive effort to streamline Oracle production database monitoring (using

Foglight) to ensure that the health of all Oracle database components was being closely monitored.

Instrumental in establishing significant stability across the entire business critical Global Wholesale Banking database infrastructure resulting in a 40% reduction in the high severity client impacting database incidents

Tier2 Database Operations Manager,

Bank Of America

(2010-2013)

Tier2 Database Operations Manager for production databases across the bank (Oracle, SQL*server, Sybase)

Led the massive effort for the establishment of a new production database team providing the first level (Tier2) of 24x7 production database support for all production databases across the bank (Oracle, SQL*server, Sybase)

Led the transition of production database support from the individual business aligned (CTO) database teams to the centralized Tier2 production database support model.

Led the extensive transition of production database monitoring (Foglight) to ensure that all the production database health & welfare alerts were being received, monitored and actioned by the Tier2 database operations team.

Led an effort to reduce the non-actionable Foglight database alerts inundating the Tier2 database operations team to ensure focus on critical 24x7 production database support.

Collaborated closely with the Tier2 Midrange (Unix, Windows), Tier2 Middleware and Tier2 Mainframe teams to establish common standards and procedures for Tier2 production support.

Established a standard engagement mechanism for engaging Design & Build database teams for critical production database incidents.

Established a forum to partner with Design & Build database teams to identify, track and address critical production database incidents that resulted from flaws and gaps in building production database systems.

Partnered with the GMRT (Trading) Design & Build database team to establish new procedures for the production support of the critical Trading production database hosted on Oracle Exadata This was only the 2nd Oracle Exadata system rolled out across the entire bank.

Oracle DBA Manager for CRM Services and Dealer Financial Services,

Bank Of America

(2007-2009)

Oracle DBA Manager (CRM Services & Dealer Financial Services)

Oracle DBA Manager leading the Oracle DBA team supporting databases hosting mission critical CRM Services and Dealer Financial services applications.

Led extensive stability efforts to ensure stability of production Oracle databases hosting business critical Dealer Financial Services applications.

Led a massive upgrade of all Oracle databases (from Oracle 9i to Oracle 10g) hosting CRM Services and multiple long-running efforts to stabilize the post-upgrade performance of critical CRM Services applications.

Established a partially automated process to support frequent database refreshes of non-production CRM Services Oracle databases from production.

Partnered with the CRM Services business infrastructure team to develop standards and procedures for database capacity planning.

Oracle DBA for Trading and Global Treasury Services,

Bank Of America

(2000 – 2006)

Oracle DBA supporting Trading and Global Treasury Services

Lead DBA closely involved with a complete redesign & optimization of the ACH (Automated Clearing House) application within the BA Direct application suite.

Planned, designed and implemented the migration of mission critical Global Treasury Services databases to Hitachi 9980 SAN in conjunction with the Unix and Storage group resulting in 50% performance improvement for the I/O bound business processes.

Worked with the SAN storage team to implement the databases on SAN to conform to the availability requirements i.e. redo log separation and primary/standby database separation by implementing the primary and standby databases on two different data frames of Hitachi 9980.

Coordinated with the Storage and Unix team to thoroughly test the multipathing capabilities of Veritas DMP by forcing a path failover by shutting down one of the McData ports and testing the application response during the failover.

Documented and tested the standby failover strategy including graceful switchover and switchback in coordination with the performance testing team.

Participated in regular disaster exercises for critical applications.

Assisted in implementing a corporate information security baseline for Oracle databases.

Oracle DBA Consultant, Prosoft Technology Group,

(1997 – 2000)

Oracle DBA Consultant

Was involved in Oracle database consulting at client sites in the Chicago area to provide Oracle database support and development primarily geared towards the Health Services & Telecommunication clients.

Contact this candidate