Managing Oracle Dba Resume
5.00/5 (Submit Your Rating)
NJ
SUMMARY:
- 100% hands - on Oracle DBA and manager with various Oracle projects accomplished over last
- 15 years, using Oracle database 12c, 11g, 10g, 9i, Exadata X5/X4/X3, E-Business Suite (EBS) and Applications r12, 11i, Real Application Cluster (RAC), Fusion Middleware on Solaris, HPAIX, Linux/RedHat, Oracle Virtualized Platform (OVP), Oracle Enterprise Linux(OEL), MS
- SQL Server 2005/2008/2012 and Windows 2003/2008 R2 Platforms, as well as using Oracle
- Business Accelerators (OBA), Applications implementation Methodology (AIM), Oracle
- Database Appliance (ODA), Maximum Availability Architecture (MAA) and Service Oriented Architecture (SOA)
- Efficient manager for full - cycle Oracle project implementation including contract biddingPre-sale presentation and hiring, Oracle architecture and design, project budgeting and planning, project tracking, team workload allocation, team coaching, appraisal and timesheetvendor liaisons, policy and standard-making, hands-on installs, and handling of problems at all levels of OS, network, database, applications and end business community
- Sharp problem fixer and powerful performance tuner from end-user/client, network, mid-tiersapplication tiers up to database backend, hosting servers to SQL statements, using Oracle performance tuning technologies like ADDM, AWR, ADR, SQL Tuning Advisor (STA), SQL
- Access Advisor (SAA), Statspack Report, Grid Control, Cloud Control and Enterprise Manager Express (EME)
- Oracle certified expert on implementing Oracle database (12c, 11g, 10g, 9i and 8i), RAC, Data Guard, MAA Disaster Recovery (DR), Oracle Fusion Middleware, Grid Control, EBS/Apps r12 & 11i, TimesTen In-Memory database, Oracle Portal, Oracle Internet Directory (OID)Beehive/Collaboration suite, GoldenGate Replication, EBS/Apps Identity Management like Single Sign-On (SSO), Oracle Secure Backup, Apps Shared Apps Top, GRC and ADRCI
- Lead DBA role for object data modeling, database design, EBS/Apps system configurationsinit parameters tuning, install checklist and standard procedure, backup and recovery using Recovery Manager (RMAN), Flash Recovery Area (FRA), Oracle secure backup, Oracle DB
- Vault, advanced upgrade and migration tools, EBS/Apps patching and cloning, EBS/Apps data Security like Transparent Data Encryption (TDE), API customizations, CPU & PSU PatchingDR synchronization, Oracle Support/TAR management, SOX auditing, and SOA security
- Over 15 years of solid Oracle architecture experience in successfully managing and consulting for numerous Oracle projects on various architectures, including n-tier OLTP, OLAP, Data Warehouse (DW), data mart, data store, data replication, MAA DR design like Active Data Guard, EBS/Apps/SOA system under RAC and non-RAC environments, 10g/11g/12c Fusion Apps/Middleware/Weblogic Servers, OBIEE, Cloud Control vs. Database Control, and cross- platform design, architecture, data conversion, customization, backup, recovery, and cloning
- Lead new implementations to deploy Oracle EBS/Apps/Fusion/Weblogic/12c and 11gR2 RAC on Linux and Windows 2008 R2 systems from testing, QA to production go-live with banking, pharmaceutical and healthcare clients
- Lead upgrade, migration and optimization of Confidential learning and training system from Oracle RAC 10gR2 to 11gR2/12c under Solaris and Container 10
- Led upgrades and migrations for major telecom, retail and financial clients from EBS/Apps/SOA 11i to R12, Oracle RAC DB from 9i /10g R2/ 11gR2/12c, MAA/RAC/ Data Guard using AIX GPFS/virtualization, Solaris, Oracle Linux and MS SQL Server 2005/2008/2012
- Led major HR, Financials, Supply Chain (SC), Manufacturing upgrades, patchingperformance tuning for global EBS/Apps/SOA systems, including migration from Apps 11.5.x to 11.5.10/9i to 10g to 11g and 12c using Oracle 10g/11g RAC and data guard
- Led EBS/Apps r12 auditing and security set-up using Oracle Advanced Security/Vault and Oracle data encryption for a Financials & HR membership system - including row and table level encryptions, and others include:
- N-tier Oracle Apps/Financials set-up using RedHat, RAC, Oracle 10g database and Apps server for a global subscription and catalog system
- Go-live of a Transactional Analysis and Reporting System (STARS) using Oracle Financials, Order, Inventory, Manufacturing and self-service modules
- Design and build-up of Defense Medical HR Internet System (DMHRSi) using Oracle Financials, HR and RAC
- Performance tuning of Defense Medical Financial and Third-Party Billing System (TPOCS) in NT and Win 2K environment
- Development and production support for a national securities and investment management system using Oracle data warehouse/data marts
- Architecture and setup of a global Financials and HR management systems using Oracle Apps 11i
- Production support for large-scale and high-volume OLTP production databases, WebDBs, data warehouses and Oracle Financials system for a leading online retailer
- Led development of other medium-to-large, mission-critical Oracle 7.x/8.x databases/applications, including online stock trading, IT job banks, inventory tracking and transaction data warehouse for overseas clients
- Oracle Database 12c, 11g, 10g, 9i, 8i, 8, 7 Administrator
- Oracle E-Business Suite | Applications r12 | 11i Administrator
PROFESSIONAL EXPERIENCE:
Managing Oracle DBA
Confidential, NJ
Responsibilities:
- As an owner and managing Oracle DBA for Confidential I have been partnerships with Big Four over past 8 years, and managing high-profile projects using Oracle latest EBS/Apps/SOA and database technologies
- Full DBA consulting capacity and capability for full-cycle production new install, design, architecture, setup roll-out, configurations, upgrade and migration; also ad hoc consultancy for production performance tuning, troubleshooting, proof-of-concept and set up latest Oracle technologies like TimesTen (IMDB), GoldenGate (GGSCI), 11gR2 Grid Control, Fusion Middleware 11g/12c, Weblogic 11g/12c, Apps Big Tablespace conversion, extended Single Sign-On setup, extended AWR analysis and ADDM reporting, ADR, ASM conversion and Oracle storage optimization
- Best practices for major Oracle new database and EBS/Apps/SOA technologies. Document major Oracle DBA procedures, including the CPUs, SOX auditing and reports, Oracle backup and recovery, new feature installs, DBA runbook. Present new Oracle technologies and feature to clients
Lead Senior Consultant
Confidential, NYC/NJ
Responsibilities:
- Leading in implementing major Oracle Applications including design, system integration, upgrade, migration, and performance optimization from 11.5.x to 12 using Oracle 10g/11g, RAC and MAA;
- Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence, ETL, ASM on AIX, Solaris and Linux servers;
- Handling severity # 1 TARs and critical patches; Troubleshooting and performance tuning; Cloning Apps instances and refresh/replicate schema data via Database Control and Grip Control; Fine-tune workflow mailing; Maintain RAC operations, DR and RMAN-based recovery;
- Promoting new features of Oracle Apps 12, Fusion and Oracle 10g/11g; Checklist and roadmap the upgrade and migration from Apps 11i to 12; Design and document each Apps-specific build; Provide the Apps DBA runbook; Transfer knowledge to onsite and offshore data centers
Managing Principal Consultant
Confidential, CA
Responsibilities:
- Lead in applying major Apps installs, upgrade and migrations including recent upgrade from 11.5.x to 11.5.10 using Oracle 10g and RAC; Manage patching such as HR K and Financials G, as well as various critical security patches and the year-begin/end Payroll patches
- Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence
- Handled severity # 1 TARs; Performance tuning; Cloned Apps instances and refresh/replicate schema data; Set up self-service Apps like iExpense and iProcurement; Fine-tune workflow mails; Maintain RAC operations
- Introduce new features of Oracle Apps 12, Fusion and Oracle 10g; Roadmap the upgrade and migration from Apps 11i to 12; Provide pre-sale and post-sale supports with onsite demo/presentation
Lead Oracle DBA Consultant
Confidential, NYC
Responsibilities:
- Manage major Oracle Apps tasks including advanced security setup, site and row-level auditing, performance tuning, system architecture, patching, TAR, backup and restore policies, vendor communications, demos of Oracle new features, migration and upgrade
- Development and production support for 15 productions and 20 QA/testing databases; Administration of both OLTP, data warehouse and Apps servers using Oracle replication, home-made refresh, Oracle Financials and 9iAS
- Deploy of RAC on RedHat as mid-tier using Oracle 10g and Apps 11.5.9; Troubleshoot and fix various issues of Apps database and systems using Oracle TAR, MetaLink, Apps OEM and other diagnostics tools
- Migration of the core Financials/membership Apps system from 11.5.7 to 11.5.9; Management of user account, apps security, concurrent processing, batch jobs, patching and profiles as System Administrator
- Back up and restore of all production and QA systems using EBU, RMAN, logical and physical standby, and cloning; Data access and usage securities and auditing
Lead Oracle DBA Consultant
Confidential, NJ
Responsibilities:
- Support all pro-go-live testing and go-live Apps administration of Subaru Transactional Analysis and Reporting System (STARS) using Oracle Financials, Order, Inventory and Manufacturing and other self-service modules
- Set up the standards and best practices for both DBA and development projects; Apply patches, automate the DB and system monitoring and reporting
- Trouble-shoot and fixed problems of OEM, workflow, ADI, portal, discoverer, concurrent/batch processing with Oracle Support; Set up logical standby and Data Guard; Customize Apps interfaces with functional team
- Frequently clone the QA/testing databases from production/gold copy; Tune end-user, Apps, database and OS performance; Implement Fine Grained Auditing (FGA) and database auditing using Log Miner
Lead Oracle DBA Consultant
Confidential, VA
Responsibilities:
- Install, configure and administrate the Defense Medical HR Internet System (DMHRSi) using Oracle Parallel Server (OPS) and Real Applications Cluster (RAC) on Sun cluster server
- Provide a full range of database and applications supports to the Defense Medical Financial and Third-Party Billing System (TPOCS) using Oracle Financials
- Troubleshoot and fix various issues of Apps database and systems using tools like StatsPack and Apps OEM
- Back up, refresh, recover and restore the systems through home-made cold and hot backups, RMAN, Veritas NetBackup and cloning; Set up the standards and best practices for database administration and code implementation