We provide IT Staff Augmentation Services!

Technical Architect/oracle Apps Dba Resume

0/5 (Submit Your Rating)

Richardson, TX

SUMMARY:

  • He earned his Doctorate degree from Louisiana State University, Baton Rouge, LA. He did his MBA with an emphasis on Computer Science and Finance at University of Colorado, Colorado Springs. He worked for Confidential for 17 years. At Oracle, he served in various roles such as a Developer, Consultant, Field, Phone, Web Support Specialist, and Database Administrator. He worked for Discoverer Support for many years and rose to Team Lead position. He served Oracle Business Intelligence Systems (BIS) Support and E - Business Suite System Administrator Support. He was part of Grid Control /
  • Enterprise Manager Support team. He worked as a Principal Database Administrator for Oracle Managed Cloud Services: OHSREFRESH and Disaster and Recovery (DR) teams for nine years. Experienced in Database administration and lead refresh of customer instances on Linux/Unix environments. Managed creation and maintenance of DR environments. He supported various Oracle products: tools, applications, and database. He was working for Confidential as a Technical Architect responsible for a successful PeopleSoft Upgrade from 11g to 12c oracle database and Migration from AIX to Linux
  • Established an effective backup, restore and recovery process using rman and ddboost or actifio. In addition to his computer skills and experience, he brings about an additional 6 years of work experience in academics and Life Sciences industries (Pioneer-DuPont and Bioseed). He is a self-starter with a proven track record of successful project life cycle development. He is experienced in handling customer escalations, delivering support, and quality assurance. He has published many articles in peer reviewed scientific journals and WebIV. He has excellent written, oral, presentation, and inter-personal skills. He describes himself as a resource with experience in array of Oracle products with Applications DBA and core DBA skills. He is an US Citizen. He obtained security clearance through Oracle to work on Federal customer databases.

TECHNICAL SKILLS:

Oracle Products: Oracle RDBMS, 12C, 11g, 10g (dbconsole, grid control, RAC), 12C, 11g, 10g, 9i (OEM), Oracle Data Guard, Oracle GoldenGate, SQL*Plus, PL/SQL, Developer 2000 (Forms 6i, Reports 6i, ), Designer 6i, Discoverer ( 4.x), Discoverer Viewer and Plus (4i, 10g, 11g ), Balance Score Card, Warehouse Builder, Portal, Business Intelligence Systems (BIS), Embedded Data Warehouse (EDW), Oracle applications E-Business Suite (10.7; 11.0;11i; 12), SQL*Net, Oracle Utilities (Import, Export, SQL*Loader), Server Manager, Oracle Applications Server, Internet Application Server (9iAS, 10g), Recovery Manager, and Oracle Express Server, and Exadata.

Operating Systems: Windows NT 4.0, Windows XP, Linux, UNIX platforms (Sun Solaris, HP-UX)

Life Cycle Expertise: Complete life cycle development (definition, requirement analysis, functional and technical specifications, programming, unit and system testing, implementation, user, maintenance and enhancement).

Applications: Oracle HRMS (Human Resources and Pay Roll), PeopleSoft V 9.0 (PeopleToolsPeopleCode), SQR, Human Resource Management System and Financial applications. Systems and Computer Technology (SCT), Banner applications (Property Tax, Courts, Alumni, HR, and Finance).

Specialty Skills: Database design, System Administration, application development, development of functional and technical specifications, Project Management, SQL*PLUS, Pro*C, PL/SQL, SAS, Java, Capacity Planning, Database Administration and Performance Tuning. Trouble shoot, resolve and provide friendly support. Know how on latest Bigdata and Hadoop.

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Technical Architect/Oracle Apps DBA

Responsibilities:

  • Responsible for successful upgrade of PeopleSoft on Oracle 11g database to 12c.
  • Responsible for successful migration PeopleSoft on Oracle 12c database from AIX to LINUX.
  • Provided Technical specifications for build of Linux servers for upgrade of PeopleSoft on 12c Oracle database(s).
  • Key member of DBA team on upgrade of Oracle Applications EBS from 11g to R12.2.x
  • EBS DBA: Addressed Refresh, Patching, Data Migration, Concurrent requests, Workflow, and Performance of Oracle E-business Suite (11i thru 12.2.6).
  • Responsible for establishing an effective process of database backup, restore and recovery on ASM file systems on v-block using RMAN, DDBOOST, and ACTIFIO software.
  • Performed LOGICAL BACKUPS for Database migration from AIX to Linux using Data Pump, Export/Import of whole database.
  • Integrated automated schedule of database backups on Cloud Control 13c.
  • Responsible for PeopleSoft refreshes.
  • Actively participated in project meetings involving upgrade and migration of PeopleSoft, Linux infra structure meetings, and coordinated team efforts on coming up with an optimal solution for database backup, restore and recovery and establishing guidelines for backup and retention.
  • Responsible for weekend production support calls on rotation. Did performance tuning of Oracle Database.
  • Installed Grid Infrastructure Software on new Linux Servers to configure ASM file system. Installed 12c databases on ASM files systems on Linux.
  • Experienced in Oracle Golden Gate installation, configuration, troubleshooting replication issues involving Golden Gate.
  • Experienced in Installing OEM agent and hooking up to the grid.
  • Experienced monitoring server and database performance using tools such as Ganglia, NMON, SAR, Fog Light, TOAD, DPA, and OEM.
  • Registering Databases to Oracle 13c Cloud control
  • Creation of RMAN catalog database and registering Databases to RMAN Catalog db.
  • Providing production DBA and On-Call DBA support on Oracle E-Business Suite, BAAN, and PeopleSoft applications.

Confidential, Frisco, TX

Principal Database Administrator

Responsibilities:

  • Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control 11g Installation.
  • Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.
  • Implemented Physical standby for disaster recovery using Data Guard on Oracle 11g.
  • Extensive use of Oracle Dataguard for protection of critical production data & provide data / disaster recovery.
  • Used Oracle GoldenGate to replicate data and sync primary and secondary databases in disaster recovery.
  • Monitored GoldenGate via web client to manage performance.
  • Worked in troubleshooting RAC and implemented ASM features.
  • Providing fixes for Standby database defects.
  • Provisioning, creation of new standby Oracle databases and Oracle applications on Linux.
  • Lead and performed customer facing DR tests for Oracle Hosted Customers.
  • Mentor new or junior team members about DR process and know-how.

Confidential, Colorado Springs, CO

Principal Applications/Database Administrator

Responsibilities:

  • Installed, configured the Oracle 9i and 10g, Oracle 11i apps tech stacks and R12 tech stacks
  • Performed Refresh of several On Demand customer instances for e.g., Prod to Dev, Prod to Test, Prod to Stage, and in all possible combinations. The refreshes involved from single node, multiple nodes to RAC clusters and configuring DMZ and PCP. The skill set required to perform the job is both apps and core dba.
  • Responsible for online and offline backups and recoveries of the oracle database.
  • Create new database users as required. Plans and implements backup and recovery of the Oracle database.
  • Performed refreshes for Federal On Demand customers (Oracle applied security clearance for me) from end to end involving code and data copies, db recovery, application refresh, performing customer specific post refresh steps, and quality health checks. The refresh process included use of automated and manual steps in Linux/Unix environment.
  • Involved in QA process to ensure high quality refresh of instance(s) prior release to Customer.
  • Took leadership role addressing customer escalations and providing root cause analysis.

Confidential, Colorado Springs, CO

Principal Support Administrator, Enterprise Manager Grid Control

Responsibilities:

  • Supporting customers on Enterprise Monitoring using 10g Grid Control, Dbconsole and 9i OEM software.
  • Installed and configured oracle 10g/11g RAC for high availability.
  • Supporting production database system 24*7.
  • Participated in designing and building OEM environments.
  • Provided support to OTO customers working for Oracle On Demand
  • Selected by Management to support Oracle Hosted Service (OHS) customers on Business Intelligence Systems (BIS), Embedded Data Warehousing (EDW), AOL System Administration issues.
  • Wrote a document 'OHS-BIS Pilot Implementation Recommendations’ to avoid known problems by providing useful recommendations to a new Oracle Hosted Services customer on implementation of BIS in general and Financial Intelligence in particular.
  • Consulted by OHSDBA and AMS analysts on various issues related to installation and configuration of Discoverer and BIS/EDW products.
  • Strived for success of OHS by resolving SRs faster, providing quality service, and providing suggestions to streamline OHS processes.
  • Provided support on Discoverer administration and user edition, Discoverer web products (Viewer and Plus), 9iAS, Balance Score Card.
  • Resolved thousands of tars. Documented bugs and worked with Development to resolve bugs.
  • Created many articles and published in Metalink / WebIV.
  • Served as Discoverer Escalation Specialist for the team to address sev.1 and highly escalated tars.
  • Earned reputation for being a competent Discoverer analyst.
  • Served as a key resource in resolving complex Discoverer issues.
  • Developed good rapport with Oracle Development, Consulting and Outsourcing teams.

Confidential, NY

Oracle support Services Administrator

Responsibilities:

  • Worked as an Onsite Oracle Developer/DBA, performing data base administration tasks, not limited to, installation and upgrade of client and server software (Developer 2000, Designer 2000, Oracle 8, and 8i), creation of databases, backup and recovery, and trouble shooting.
  • Took lead role in determining future enhancements for the software/hardware requirements.
  • Reviewed and provided recommendations on two custom developed applications (Fire System and Airport system).
  • Custom developed a Parks Contract Management System application with forms and reports. (Oracle 8.0, Forms 5.0, Reports 3.0).
  • Developed reports (Developer 2000, Reports 2.5, 3.0) for two vendor based applications, SYSCON, Probation and Jail Systems.
  • Assisted in moving applications from individual Developers’ computers to a central location where they can be accessed through a network based on user privileges.
  • Worked on custom development of a module THREEB, right from scratch, using Oracle Development tools, that will integrate with an vendor (SYSCON) developed application, helping client managing Probation Systems.

Confidential

Oracle Consulting, Senior Principal Consultant

Responsibilities:

  • Helped in generation of drill down reports. Six reports were generated from Designer 2.1 repository.
  • Customized forms and reports. Enabled the application on to web using Oracle web server. Confidential DBA on 8.0 Databases on NT.
  • Part of DBA team on this project (Backup, Recovery, and Production support).
  • Helped in adding new features into existing forms and reports. All forms and reports were generated from Designer 2.1 repository. Added new features to post-generated forms and reports in Developer 2000.
  • Developed a ‘Copy All’ functionality that fully duplicates a parent record and all its dependent (child) records.
  • Reverse engineered the changes made in Developer by adding the code and documenting in Designer 2000.
  • Created a Report in Developer that displays all Daily Reports that are specific to items in detail tables.
  • Created a new template for creating a new report with default administration parameters.
  • Converted five more Designer generated reports into reports with better look and more user friendly using Reports Wizard.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Enhanced the navigation of forms to be more users friendly and intuitive by providing graphical icons in place of buttons, toolbar object group that contains the new horizontal and vertical toolbars, and a navigational frame.
  • Reduced number of redundant triggers. Changed the coordinate system to REAL and resized the windows and canvases. Changed visual attributes and added many new property classes.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Designer 2000 v 2.1 was used in the system analysis and database design. Validation and Query forms were generated using the information stored in the repository.
  • Complex application forms and reports were developed using Developer 2000 (Forms 5.0. Reports 3.0).
  • Responsible for development of forms and reports. Discoverer 2000 was extensively used to build the queries and to develop reports.
  • Performed ad hoc queries using Discoverer 2000 for management.

Confidential

Consulting, Senior Programmer Analyst

Responsibilities:

  • Involved in whole life cycle development of the application.
  • Responsible for development of new forms, enhancement of existing forms for base line Banner Property Tax System.
  • Created many tables, views, and applied integrity constraints. Wrote form, block, and item level triggers, stored procedures, and scripts for querying data.
  • Transferred data from legacy systems to current systems.
  • Created test data and performed both unit as well as system testing.
  • Maintained the application by fixing errors. Custom tailored the application according to needs of customers, who purchased and implemented the application.
  • Contributed to both functional as well as technical improvement of the application.

Confidential

Responsibilities:

  • Worked as a Corn Breeder in a Corn Breeding Research Program. Responsible for running a comprehensive yellow corn breeding program to serve farmers.
  • Updated conditioned seed stocks in storage, grower payments, seed quality, and distribution information.
  • Identified valuable inbreds and hybrid combinations.
  • Responsible for experimental design, statistical analysis, data interpretation, and presentation.

Confidential

Laboratory Analysis

Responsibilities:

  • Analysis of soil and water samples to identify any contaminants such as herbicides, pesticides, and toxic chemicals.

Confidential

Responsibilities:

  • Developed Sorghum Restriction Fragment Length Polymorphism (RFLP) map.
  • Published a comprehensive RFLP map on Sorghum in Genome.

We'd love your feedback!