Oracle Dba, Oracle Application Dba Resume
Springfield, IL
SUMMARY:
Oracle Database Administrator and Application Professional with over ten years of diverse experiences in modeling data, designing, migrating, implementing, developing and maintaining database applications. As a detail - oriented person, my greatest strength is business awareness and team orientation.
FUNCTIONAL SKILLS:
- Database Design, Development, Implementation and Maintenance
- Database Performance tuning and Migration
- Oracle Total Recall, Label Security, Oracle TEXT Search
- Application Software Design, Programming and Integration
- Systems Analysis and Troubleshooting
- Systems Installation and Maintenance
- Technical Writing and Editing
TECHNICAL EXPERTISE:
Databases: Oracle database 12C/11G/10G/9i/8i, ASM, Data Guard, GoldenGate, RAC, RMAN
Platforms: Oracle Cloud, Linux Server, VMWare, IBM, Sun, Windows . SAN, Data Domain
Operating Systems: SUSE Linux, Oracle Linux, AIX, Windows
Programming: Shell programming, SQL*Plus, PL/SQL, Oracle Application Suite, XML, Oracle SQL Developer and Toad, Korn Shell, C Shell, Enterprise Manager Command Line Interface (EMCLI), Oracle Tuning tools
WORK EXPERIENCE:
Oracle DBA, Oracle Application DBA
Confidential, Springfield, IL
Responsibilities:
- Mentor one junior Oracle DBA and one junior Oracle Application DBA
- Design and manage database structures, storage allocation, constraints, database access, roles
- Conduct database and application performance tuning
- Prepare capacity planning, install, administrate, upgrade and patch Oracle database 12C and 11G in Data Domain
- Install, upgrade and administrate Oracle OEM, Grid Control, and Cloud Control
- Install, configure and setup Oracle Enterprise Manager (OEM) agent to monitor for the server/database targets for entire application environment
- Setup and implement database security and auditing
- Prepare and perform database backup and disaster recovery using Rman
- Conduct stress test and evaluate performance impact using Oracle Real Application Testing
- Tune Oracle database and internet application for high volume transactions OLTP and OLAP
- Perform shell scripting
- Install, configure and maintain Oracle Grid infrastructure, ASM and Data Guard
- Synchronize data between Oracle database and DB2 database
- Synchronize data with statewide data warehouse system Teradata
- Install, configure and monitor Oracle Golden Gate replication utility
- Create, configure, patch and maintain Oracle database system and Linux server in Oracle Cloud
- Work closely with developers and provide technical support
- Work with OS and hardware infrastructure technicians to improve overall system performance
- Work as the only contractor in the project for almost 15 years to bring the internet application from scratch to top star in the nation
Oracle DBA, Database Migration and Application developer
Confidential, Springfield, IL
Responsibilities:
- Analyze and map DB2 database structure to Oracle Database
- Perform ETL to migrate DB2 database to Oracle Database
- Enhance forecasting algorithm after the initial Oracle web application migration from DB2
- Design and implement Oracle Label Security to protect over thirteen million sensitive patient information in over 10,000 clinics
- Design database physical and logical layout
- Install, administrate, upgrade and migrate Oracle database in 10G and 9i at IBM AIX
- Install, upgrade and administrate Oracle Enterprise Manager in Linux
- Setup monitor system for entire application environment
- Audit and maintain high volume historical sensitive data
- Tune Oracle database and internet application for high volume transactions OLTP and OLAP
- Refresh development environment from production periodically
- Work with storage team to configure SAN for database storage and backup
- Work closely with developers and provide technical support
- Work with OS and hardware infrastructure technicians to improve overall system performance
