SUMMARY:

• A fulfilled Oracle Database Administrator with a track record of implementing database services geared at optimizing RDBMS functionality and productivity in heterogeneous environments. I hold over six years in improving and optimizing the performances of Oracle 10g, 11g and 12c databases. Have demonstrated high skills in accomplishing various oracle environment expectations; database installations and upgrades, troubleshooting, advance backup and recovery operations, performance tuning, enforcing database security procedures, and performing other related database services. DBA skills include:
• Experienced in database administration on Oracle databases (10g, 11g, and 12c) as well as Oracle Virtual Machine(OVM)
• Extensive and advance knowledge on RMAN backup/recovery operations, architecture, and procedures.
• Knowledgeable on data pump expdp and impdp utilities.
• Ability to establish and maintain sound backup and recovery policies and procedures
• Experienced in database and application proactive and level tuning.
• High abilities in troubleshooting and resolving oracle environment issues and providing timely interventions: slow running queries
• Great at installing oracle software 10g, 11g and 12c and creating, configuring, and managing oracle databases.
• Experience with Grid/ASM, RAC, Data Guard and high availability techniques.
• Extensive knowledge of Automatic Storage Management environment (ASM) on single instances and on RAC configurations
• Skilled in building DR (disaster recovery): - standby databases (physical and logical) on unix, linux, and Window platforms
• Solid understanding of database High Availability. Emphasis on minimal or zero down time.
• A skilled communicator; able to maintain cultural sensitivity, establish rapport with members of diverse groups, and promote team cohesiveness.
• Highly organized and independent; able to effectively coordinate tasks to accomplish projects with timeliness and creativity.
• An organized, detail-oriented, and conscientious self-starter, able to strategize and prioritize effectively to accomplish multiple tasks and stay calm under pressure.
• Flexible and analytical with a keen eye for details; skilled at synthesizing and editing information to achieve overall objectives.
• An effective leader, skilled in enlisting the support of all team members in aligning with project and organizational goals.
• High-energy, confident professional with an infectious enthusiasm for technology.
• Decisive, efficient team approach; outstanding communication skills.
• Strong meeting planning and facilitation skills; able to communicate effectively with all organizational levels, build relationships of trust and enlist the participation of team members.
• Highly organized and efficient in fast-paced multitasking environments; able to prioritize effectively to accomplish objectives with creativity, enthusiasm and humor.
• Creative, resourceful, and flexible, able to adapt to changing priorities and maintain a positive attitude and strong work ethic.

TECHNICAL SKILLS:

Databases: OLTP, DSS and WAREHOUSE databases

Tools: Oracle Enterprise Manager (OEM)/Grid Control, Oracle Expert RMAN, SQL Loader, SQL*Plus

3rd Party Tools: SQL Developer, Toad, BMC Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MO

Oracle DBA

• Troubleshooting and resolving day to day database issues (incident and problem management)
• Perform database health check remediation as per ISeC requirement
• Transparent Data Encryption
• Schedule and perform various forms of Rman backup on Cron or via the OEM Grid control
• Manage RAC/ASM configurations; managing disk groups, and investigating performance issues
• Apply various quarterly database patches and also support System Admins for OS patching.
• Work on DATAGUARD operations; archive gap resolution and rebuilds
• Perform installs, configurations, and upgrades to 12c; both RAC and single instance environments with/without dataguard.
• Controlling and monitoring user access to the database.
• Work with members across other teams to support agency application changes deployment.
• Participate in weekly on-call rotations as well as team meetings
• Allocating storage, maintaining tablespaces, and maintaining system security compliance.

Confidential, New Orleans, Louisiana

Oracle DBA

• A member of a nine-man team that supported several production and development databases on different platforms (Unix, Windows)
• Actively performed different forms of advanced RMAN recovery activities; point in time, recovery on a different host, and other flashback Import activities.
• Performed performance tuning tasks using all known performance tuning tools (tracing, TKPROF, tuning advisors, etc.
• Schema refreshes and other forms of data movement.
• Created database objects as needed conforming to best practices recommended by oracle
• Managed RAC/ASM configurations
• Automated DATAGUARD log archive apply monitoring via the OEM Grid control
• Installed binaries: 11g and 12c, and created database instances for testing, development, or other operations as out of place restore
• Collaborated with developers, application experts, and others on or offside team or cross-team members to investigate and solve performance problems
• Monitor and proactively tune Oracle databases via the OEM grid control (10g) and RAC platforms (11g) or using the Advisors (SQL Access Advisor, SQL Tuning advisor, and SQL Repair Advisor)
• Apply various patches (interim patches, patch sets, CPU, and PSU)
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Implemented and maintained database security (create and maintain users, roles and assign privileges)
• Monitored system resource availability and responded to system memory and data issues.

Confidential, Baton Rouge, Louisiana

Oracle DBA

• Created and configured Oracle Databases using both the DBCA and manually using database creation scripts.
• Assisted with creation of primary database storage structures (tablespaces) and objects (tables, views, indexes etc.).
• Scheduled and performed various modes of backups using RMAN
• Monitored and proactively tuned Oracle databases via the OEM grid control (10g) and RAC platforms (11g) or using the Advisors (SQL Access Advisor, SQL Tuning advisor, and SQL Repair Advisor) or using scripts.
• Enhanced existing database designs for improved longevity, reduced maintenance, and improved performance.
• Created and managed ASM - a high availability file management solution.
• Assisted with the development and implementation of database architectures for new projects.
• Performed database migrations, conversions and upgrades
• Designed, built, tested, and deployed new/changed databases
• Maintained and administered databases and supporting automation (e.g. database objects, security roles, capacity, performance tuning, import/export, alert rules)
• Worked on High Availability, Backup and Recovery options and helped to implement solutions
• Designed, implemented, and maintained database security procedures
• Automated routine database support tasks
• Applied various patches (interim patches, patch sets, CPU, and PSU)
• Monitored and optimized the performance of the database, also advised development staff of opportunities to improve
• Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables.

Confidential, Atlanta, Georgia

Oracle DBA

• Installation and upgrade of Oracle DBMS instances
• Allocated system storage and planning for future storage requirements for the database and related functions.
• Created primary database storage structures and objects once application developers have designed an application.
• Modified database structure as necessary per directions given by the application developers.
• Designed, implemented, and maintained database security procedures. Also ensured compliance with Oracle License agreement.
• Controlled and monitored user access to the database.
• Planned and executed backup and recovery activities (Control Files, Redo Logs, Rollback Segments, System Data Files, etc.) to ensure timely and complete recoverability. Maintained archived data on disk or other media as defined. Backup and restore the database (Online and Complete) to assure restoral capability.
• Monitored the production Oracle alert logs for database errors.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory, and Operating System kernel parameters.