Xerxes Jimmy Dorabjee

*** *. ****** ***. #****, Glendale, CA 94115 Cell: +1-415-***-**** Email: addpvv@r.postjobfree.com

SUMMARY

A visionary and results-oriented executive with over 8+ years of experience managing and leading teams in the US and internationally. 15+ years of industry experience in designing, developing, configuring and implementing both client-server and e-business applications across industries. Highly motivated professional focused on leadership of Oracle Applications EBS R11i/12 implementations and administration, 11i migration / upgrades, Oracle database administration, support and customization projects. Experience in 5 full-cycle Oracle Enterprise Business Suite (EBS) implementations for clients in retail, financial, manufacturing, life sciences and semi-conductor manufacturing industries. Strong project management experience working with clients on key projects from defining strategy, project scope, resource allocation, and final delivery.

PROFESSIONAL EXPERIENCE

GUESS? INC., Los Angeles, CA Manager Database Administration Sep 2016 – Current

DBA Manager at an international American trend-forward clothing brand and retailer.

Responsible for budgeting, capacity planning, systems performance and uptime management.

Leading a team of on-site/off-site DBA’s globally.

Performing an escalation manager role for the DBA team.

Actively involved in the change management process.

Establish service level agreements with end-users.

Manage the DBA team to deliver valuable and high-quality database functionality to our customers.

Provide technical leadership and guidance to team members and project peers.

Hiring, training, motivating and coaching DBA team.

Assessing employee performance and providing helpful feedback and training opportunities.

Manage, support and administer business critical databases and database applications 24X7 and providing high availability, fault-tolerance, scalability and security of the DB environments which include Oracle 10gR2/11gR2/12c, Oracle EBS R12.2, Vertica 8.0, Attunity and MS SQL Server databases for retail, stores, financials, data warehouse and business intelligence environments at GUESS?

Lead the implementation and configuration of Attunity / Jenkins to replicate data from Oracle and IBM iSeries databases to Vertica data warehouse databases for reporting, business intelligence and analytics.

Manage the Vertica version upgrades from Vertica7.1 to 7.2 and 7.2 to 8.1 and 9.2

Configure and implement database performance monitoring tools. Automated tasks using CRON.

Configure Oracle Enterprise Manager 12c Grid control / Grafana for monitoring, managing and automating alerts based on thresholds.

Work with cross-functional teams and provide weekly status updates on projects and goals.

Coordinating meetings between the application, development and network teams to provide status updates and notifications on ongoing projects.

Implement all processes required for PCI and SOX compliance and provide relevant documentation for the quarterly and yearly Audit processes at GUESS?

Evaluating Cloud platform providers Google Cloud Platform (GCP), Amazon Web Services (AWS) and Oracle Cloud Platform (PaaS). Also received training on Dockers, Kubernetes.

Bare Escentuals, San Francisco, CA Sr. Database Administrator Nov 2011 – Apr 2016

Provide production DBA support for an internationally reputed manufacturer and distributor of beauty products.

Manage and lead an on-site/offsite team of database administrators.

Lead DBA working with Oracle and third-party vendors for the successful implementation of Oracle Advance Supply Chain Planning (ASCP) suite in a distributed architecture at Bare Escentuals.

Lead DBA working with third party vendors for the successful implementation of Oracle SOA Fusion Middleware12c Suite at Bare Escentuals which will replace the existing IBM WebSphere Application.

Lead DBA for the implementation of Oracle Enterprise Manager OEM12c for monitoring and administering all the Oracle database, E-Business Suite and Microsoft SQL Server database environments at Bare Escentuals.

Administration of Oracle11gR2 databases for BI (OBIEE), Data Warehouse, Red Prairie, Fusion Middleware12c, PeopleSoft, WebSphere, MDM Customer Hub, Micro Strategy and Sterling application environments.

Cloning various R12 instances from RAC to Non RAC (Test, Patch, Dev, QA, UAT and Prod Support).

Implementing & supporting Oracle RAC 10g/11g with Data Guard / SunGard as Oracle Maximum Availability Architecture (MAA).

Strong experience in Perl scripting, Unix shell scripting and PL/SQL programming to resolve business problems of various nature.

Establishing and maintaining sound backup and recovery policies and procedures using RMAN.

Administration of Microsoft SQL Server databases for SharePoint, Mi9, Slingshot, Axiom, BMC Software application environments.

Apply patches/patch analysis and administration, CPU/PSU patches on E-Business (databases, applications, mid-tier), OBIEE, and PeopleSoft databases.

Working on and managing various implementation projects at Bare Escentuals which include:

oiPayment setup using PayPal for Bare Escentuals (UK)

oFriends and Benefits (FAB) project which includes configuring and setup of schemas and interfaces for Sonic, WebSphere, Red Prairie, MDM Customer Hub and Sterling database environments.

oImplement Red Prairie WMS for Bare Escentuals (North America) which was originally using Oracle WMS. Currently Bare Escentuals (UK) is still using Oracle WMS.

oImplement Red Prairie reporting database environment specifically for reporting and archiving of data older than one month from Red Prairie WMS and Parcel schemas.

oImplement Golden Gate on the Red Prairie Oracle 11gR2 RAC database environments for replication of data from production to the reporting instance.

oMonitor the performance of Golden Gate extract, pump and replicate processes and upgrade Golden Gate software as and when requested by Oracle Support.

oApplication of rollouts and patches to Red Prairie application environments.

oPartition high volume Red Prairie tables in the archive and reporting instance to purge data older than 6 months.

oImplement all processes required for PCI compliance and provide relevant documentation for the quarterly and yearly Audit processes at Bare Escentuals.

CISCO, San Jose, CA Sr. Oracle Applications DBA Oct 2009 – Nov 2011

Part of Application Technology Services (ATS) technical operations DBA support group of a large multinational organization that designs and sells consumer electronics, networking and communications technology and services.

Worked on and managed all Cisco Services and Software Delivery (CSSD), ERMO and CA Infrastructure Foundation projects.

Led a team of 4 database administrators onsite and an offshore team of 5 database administrators in India.

Supported quarterly and Go Live Release activities.

Managed the application of patches, performance monitoring, 10g RAC installations and upgrade projects for very large number of database environments where databases were above 200 TB in size.

Provided 10gAS, SSO, OC4J, Oracle Applications R12 and Oracle10g RAC Database support.

Managed the performance of the data loads to development and staging instances. Imported and exported database schemas across instances.

Actively involved in the change management/escalation process followed at CISCO and lead weekly meetings with onsite and offshore DBA teams.

Deloitte Consulting LLP, San Francisco, CA Sr. Specialist Aug 2008 – Feb 2009

BearingPoint Inc, Redwood City, CA Sr. Technology Consultant Aug 2004 – Jul 2008

Solix Technologies Inc., Sunnyvale, CA Sr. Oracle Applications DBA Apr 2002 – Jul 2004

Spider Systems Pvt. Ltd., Pune, India. Oracle Applications DBA Aug 2001 – Mar2002

Mascot Systems, Pune, India. Oracle Applications DBA Dec 1998 – Jul 2001

ABN AMRO Bank NV System Administrator Jun 1997 – Aug 1998

Gulf Computers Pvt. Ltd. Programmer Dec 1996 – Feb 1997

TECHNICAL SKILS

Databases: Oracle 12c, 11gR2/R1 RAC, 10g RAC Rel2/10g / 9i / 8i / 8.x, MS SQL SERVER 7.0 / 2014/2016, Vertica 9.2.x, 8.1.x

Operating System: Solaris 10/9, HP-UX 11/10.x, AIX 5L, Red Hat Enterprise Linux 7.3/5.5/4/3.7, SUSE Linux

Hardware: Sun-Fire-15000, SUN4U Sparc SUNW, Sun-Fire/Ultra v80/v880/v440/E10K/E4500/E450, Dell PowerApp Series, Compaq ProLiant Series, HP Superdome, HP9000 D390, L1000/2000, IBM RS 6000, HP LC III SERIES, IBM NETFINITY 5000/5500, HP NETSERVER LD PRO, HP LH 4, HP BL460c/680, IBM AIX 570/510/630/650

Languages: SQL, PL/SQL, Perl, Python, UNIX Shell Script.

Tools: Spotlight, OEM12c / OEM10g Grid Control, TOAD, RMAN, SQL*Loader, SQL*Plus, JDBC, Discoverer 4i/10g, JDeveloper, Veritas Netbackup, ETL, Legato NetWorker6, Mercury ITG, Loadrunner, XML Publisher, Vertex Quantum, Golden Gate v11.2.1.0.x, MS Project, Visio, MS VSS 6.0, MS PowerPoint, Attunity, Jenkins, Grafana, Zeppelin

ER Applications: Oracle Apps EBS R12.2.x/11i (11.5.10.2/11.5.x/11.0.3), iAS1.0.2.2 Oracle 9iAS/10g, Demantra 7.2.x, Hyperion 7.1, Oracle Workflow 2.6, Oracle ADI 7.0/7.2, IIS 4.0/5.0, OBIEE, VCP 12.1.3.8, OLAP, MOBILE WEB APPLICATIONS (MWA), Red Prairie WMS, Golden Gate 11.2.1, iStore (Chase Paymentech, Paypal), PRISM SUITE ver. 5 SP 26/ver. 6, Weblogic 11g

Cloud Environment: Google Cloud Platform (GCP), Oracle Cloud Platform (PaaS), Amazon Web Services (AWS)

EDUCATION

University of Pune, India

Bachelor of Commerce (BCOM), Cost and Works Accountancy and Business Administration

National Institute of Information Technology, India

Graduate of NIIT (GNX), Software Exports

CERTIFICATIONS

Oracle Database 10g: RAC for Administrators Rel.2 from Oracle University.

Oracle 8i DBA Backup and Recovery and Performance Tuning from SQL * INTERNATIONAL.

Administering Microsoft SQL Server Databases from Learn IT!

Currently preparing for the GCP Data Engineering Professional Certificate

COMMUNITY INVOLVEMENT

Committed to community services. Extensive volunteer history includes involvement in public schools, Habitat for Humanity and United Way.

Contact this candidate