SUMMARY

• I am an IT professional with over 20 years of Oracle DBA expertise with experience in software application development, data modeling, systems analysis and design, Database Engineering and administration.
• I am Expert in Oracle Database, SQL Server, MySQL, UNIX, and Windows.
• My experiences in Database Engineering, Administration, and software application development combine to form a unique expertise in advanced Database Software engineering and application development.

TECHNICAL SKILLS

• Relational Database Analysis and Design
• Physical and Logical Database Design
• Database Design for Readiness Decision Support System (RDSS)
• Oracle Database Administration
• MySQL Database Administration
• Database Duplication/Cloning and Standby (Data Guard)
• Database Replication including Golden Gate
• Reporting Systems
• Database Migration from Oracle to MySQL 8.0
• Database Migration from MySQL 8 to Oracle.
• Data Warehousing (OWB, ODI)
• PL/SQL, Packages, Stored Procedures, Functions, and Triggers
• Business Intelligence
• Disaster Recovery Planning and Management
• Oracle Service Oriented Architecture (SOA)
• Oracle Application Server (OAS), SSO, OID, OVD, LDAP, ASO, Kerberos, Database authentication, Roles, and Privileges
• Oracle Real Application Clusters (RAC) 9i, 10g, and 12c
• Automatic Storage Management (ASM)
• RMAN Recovery Manager
• UNIX/Linux Systems Administration (Kernel - configuration, package installations, etc)
• Oracle RAC 12c Engineering, Installation and Administration
• Oracle Golden Gate 12c active/active bi-directional Replication between a 2-node RAC cluster and a single remote node.
• Oracle Archive log method replication from a production database to a remote server.
• MySQL 8 one-way replication from a Source MySQL database to a Target MySQL database
• Oracle Data Integrator (ODI)
• Oracle Data Warehouse Builder (OWB)
• Oracle DBA (8, 8i, 9i, 10g, 10g AS, 11g, 12c, and 12c RAC)
• MySQL Database Administration
• ETL: Shell, SQL-Loader, Oracle Data Warehouse builder, ODI, etc.
• ERWIN data modeling tool
• Oracle SQL, DDL, DML
• PL/SQL (Stored Procedures, Functions, Packages, Etc.)
• Oracle 10g Portal and Discoverer
• Pro*C/ESQL (Embedded SQL)
• C programming
• Share-Plex
• RMAN backup and restore
• Oracle Forms & Reports 4.5 and 10g
• UNIX: Solaris, HP-UX, AIX, and Linux
• UNIX/Linux Shell Scripting
• Windows Server 2003, Windows XP, NT, and Vista
• SQL: Oracle, SQL Server, All-Base, and DB-Vista

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle,MySQL DBA/Oracle Developer

Responsibilities:

• Performed 7X24 Production and Development Database administration on OLTP databases.
• Installed and configured Oracle 10g, 11g, and 12c databases including 12c RAC in-house and 12c on the Amazon AWS on Linux.
• Installed and configured MySQL 8 on Linux x86-64 servers. *Applied Oracle patches.
• Performed databases and servers upgrade and migration form Oracle 10g to 11g, and 11g to 12c. Performed MySQL database upgrades from MySQL 8.0.11 to 8.0.19. Tuned and Optimized SQL and Databases. Performed monitoring.
• Created PL/SQL procedures for Vehicle Logistics tracking and other tasks. Created and maintained standby databases for disaster recovery purposes.
• Performed complete and incremental RMAN backups (Weekly and daily). Performed MySQL 8 backups including testing of restore. Performed all DBA duties.
• Setup active/active bi-directional replication from 2-node RAC cluster to a single node server using Golden Gate 12c.
• Setup archive log replication from a production database to a remote server.
• Setup one-way replication from a MySQL Linux server to another MySQL Linux server.
• Setup and created MySQL databases.
• Setup and created Postgres databases. Set up periodic jobs to download data from AWS JIRA to refresh the local Postgres JIRA database.
• Migrated Oracle databases, some with data to MySQL. Migrated MySQL database data to Oracle.

Confidential

Sr. Oracle DBA/Oracle Developer

Responsibilities:

• Architected and designed, coded, and implemented software packages to perform data conversion and convergence from heterogeneous systems of the Los Angeles County Department of Public Social Services (DPSS) to the consolidated Exadata Leaders Replacement System (LRS). The various environments comprised of seventeen programs of the Los Angeles County including the LEADER (Los Angeles Eligibility, Automated Determination, Evaluation and Reporting), GEARS (GAIN (Greater Avenues for Independence) Employment Activity and Reporting System)), General Relief Opportunity for Work (GROW), and Department of Children and Family Services’ (DCFS).
• Performed 7X24 Production and Development DBA duties on OLTP databases. Installed and configured Oracle 10g, 11g, and 12c databases. *Applied Oracle patches. Performed databases and servers upgrade and migration form Oracle 10g to 11g, and 11g to 12c. Tuned and Optimized SQL and Databases. Performed 7/24 monitoring.
• Wrote PL/SQL procedure for archival of data and other tasks. Created and maintained a standby database for disaster recovery purposes.
• Trained the operations team on the use and maintenance of the data conversion and consolidation system.
• Performed RMAN backups (Weekly and daily). Performed schema exports/imports. Performed all DBA duties.

Confidential

Sr. Oracle DBA/Oracle Developer consultant

Responsibilities:

• Architecture, engineering, installation, configuration, and 7X24 administrations of Oracle 10g and 11g OLTP Databases on single node as well as RAC clusters.
• Performed DBA duties including RMAN backups, database and SQL tuning, and trouble shooting any database issues. *Performed upgrade of an Oracle OLTP database, Oracle Internet Directory (OID), Oracle Virtual Directory (OVD), Oracle ASO, and Portals.
• The upgrade included creation and administration of users, roles, and access privileges including authentication using OID and SSO.
• The test instance’s Oracle Internet Directory (OID)/Identity management were first upgraded from Database version 10.1 to latest 10.2 and portals from 10.2.0.2 to the latest 10g application release, and the database itself to the latest 10g release.
• Then the production platforms were similarly upgraded.
• Also, integrated and synchronized the Oracle Internet Directory with Microsoft Active directory with authentication from Active directory through OID.
• The platform cluster comprised of Sun Solaris 10, Oracle Linux 5, and Windows 2003 server.
• Created plan to migrate an Oracle database from single instance to a three node RAC cluster including installation and configuration.
• Created plan to install and configure Automatic Storage Management (ASM) including disk groups and failure groups.
• Created plan to install Oracle financials R12 including installation and integration with Demantra.
• The plan included installation and configuration of Linux for Oracle, Automatic Storage Management (ASM), Real Application Cluster (RAC), and Oracle Grid with management, provisioning, and management packs for E-business.
• Created user and technical documentation.

Confidential

Sr. Oracle Developer Lead/Data Engineer

Responsibilities:

• Managed and administered OLTP Oracle database servers and data dictionaries enterprise wide in development and production environments for the Data governance project.
• Performed DBA duties, including database and SQL optimization, RMAN backups, user and roles management, etc.
• Provided troubleshooting, system and data management, and system programming to maximize the capabilities of databases while ensuring high levels of reliability, availability and system functionality.
• Performed configuration, database security, resource monitoring and reporting. *Provided development and development support.
• Worked with development teams and operations to resolve software related issues and provided insight and recommendations regarding emerging technologies and their incorporation into the enterprise environment.
• Worked as part of an effort to establish infrastructure, technical processes, procedure and metric-based system to measure, audit and monitor the data quality.
• Implemented software development life cycle (SDLC) by Reviewing functional specification for the data governance measurement, audit, monitoring and reporting followed by development and testing of PL/SQL procedures.
• Documented technical specifications.
• Designed physical data model schema for data governance and data quality metrics database.
• Assisted in setting up system and database environments.
• Developed and installed the PL/SQL data quality/data governance package tool which includes data profiling, business rules and source integration auditing scripts (SDLC).
• Tested and implemented measurement and monitoring programs. *Performed tuning. Developed statistical reports: Established Baseline Data Quality Threshold.
• Facilitated receipt of the source data for accuracy test.
• Conducted all baseline tests for full database volume.
• Prepared reports. Refined programs based on the outcome of the baseline test.
• Developed scripts to automate the execution of the programs. *Compared source to target data for anomalies.
• Used Trillium Software Discovery to profile some of the data.

Confidential

Sr. Oracle DBA/Oracle Developer Lead

Responsibilities:

• Designed, architected, installed, configured, and administered (7X24) Oracle 10g OLTP database server and Oracle 10g Application Server, including infrastructure, Single sign-on (SSO), Oracle Virtual Directory (OVD), Oracle Internet directory (OID), Business Intelligence, Portal, and Discoverer.
• Performed database configuration and setup of users, table spaces, tuning, optimization, backup and recovery.
• Also, performed configuration and setup of the various components of the application server such as infrastructure, business intelligence, portal, and web cache.
• Created and administered users, roles, and access privileges including authentication using OID, OVD, ASO (Oracle Advanced Security), and SSO.
• Implemented software development life cycle (SDLC) to design and create user applications including application specifications, design and technical documents, followed by implementation.
• The applications utilize Oracle technology for their deployments.
• Created End User Layers (EUL).
• Developed Discoverer worksheets using Discoverer Plus.
• Created a web portal for the company website which includes discoverer Portlets for users to analyze underlying database data.
• The discoverer portals included option to add and modify existing database data. Created forms and reports 10g for data entry and reports generation.
• Installed and configured Oracle SOA (Service Oriented Architecture) Suite 10.1.3.3.0 and applied the relevant patch.
• Installed and configured the Oracle Business Intelligence Enterprise Edition (Oracle BI EE/EBS) 10.1.3.3.2 including BPEL.
• Created BI Delivers proactive intelligence alerts using emailing and dashboards. Built Physical data model and Business Model and Mapping, and Presentation layers, ran consistency checks, and tested the repository using Oracle BI Answers.
• Created BI Answers different views, including charts, pivot tables, and narratives.
• Used selector views to add interactivity and navigability to requests.
• Built, and performed lay out of Interactive Dashboards. Used dashboard prompts to filter dashboard data and populate Presentation variables.
• Configured Oracle Business Intelligence Scheduler tables. Created Requests and published them to the Interactive Dashboard. Created iBots.
• Created Java code to use with TopLink.
• Configured and scheduled RMAN backup and recovery tool to backup the Oracle database.
• Integrated Oracle Internet directory with Microsoft active directory in a one-way replication.