SUMMARY

• Expert in 10g, 11g, 12c Database Administration
• Expert in 11g, 12c Real Application Cluster (RAC) on ASM installation
• Expert in Data Guard Administration
• Expert in RMAN Backup and Recovery
• Expert in Disaster Recovery
• Expert in Database Migration, Upgrade and Patch Application
• Oracle DBA Instructor’s Assistant

TECHNICAL SKILLS

• Relational Databases: Oracle 10g, 11g,12c, 19C,AWS, SQL Server,Azure
• Operating Systems: Microsoft, Windows 2000, 2003 & 2008 Advanced Server, Red Hat (Linux), VMWare
• Networking Topologies / Protocols: Ethernet, TCP/IP, NACL, SSL
• Programming Languages: SQL, PL/SQL, SQL*PLUS
• Software Applications/Tools and Utilities: OEM, RMAN, DATA MIGRATION - EXPORT-IMPORT, PROCEDURES, BACKUP &RECOVERY PERFORMANCE TUNING-SQL-LOADER, REAL APPLICATION CLUSTERS (RAC), DATAGUARD, Amazon Web Services, 12c Container database, SQL-DEVELOPER

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle Database Administrator/ Trainer

Responsibilities:

• Developed course and implemented training materials for IT departments for certification exams
• Used both demonstration and lecture series to teach students and share information in relation to Oracle database technologies
• Trained students all over the world on different IT products to include Oracle 11g, 12c and Amazon Web services
• Created curriculum specific to helping students attain above average level of competency in regards to Oracle DBA jobs
• Helped businesses learn Oracle software applications for database administration
• Consulted for business by providing on-call services for mission critical Oracle 12c database
• Provided technical support to client end users via meta-link and working with dba’s to manage issues .
• Developed and delivered training for domestic and international SME’s virtually and instructor style.
• Trained clients on Oracle Real Application Clusters implementation in their data centers and advised on high availability and fault tolerance strategies.
• Worked with the Department of Labor in implementing curriculum to help students in the Atlanta and DC area attain the necessary training in regards to Oracle 11g/12 and Amazon Web Services.

Confidential, MD

Senior Oracle Database Administrator

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 11g RAC for JPSS block 2.0 and 1.2 program.
• Help facility critical DBA activities and procedures at various sites to include: Riverdale, NSOF, Greentech
• Perform database build/schema upgrades for Real Application Clusters databases. Migrating databases from build K to the current build of build L at various sites and locations.
• Manage, troubleshoot and resolve oracle database, RAC and applications issues.
• Perform database cloning for pluggable database
• Part of team that converted a non container database to a container database.
• Perform creation of Container Pluggable databases
• Part of team that upgraded 11.2.0.2 database to 12c database
• Perform patching of 12c database
• Refresh/Clone Database and applications for development and testing purpose.
• Perform installation, maintenance, and troubleshooting and performance administration of Oracle 11g.
• Perform Online and Offline database backups on schedule.
• Scripting (shell) of automated backup for Cold / Hot backups and also defining and Setting backup and recovery procedures.
• Create trigger to ensure that container pluggable databases auto start.
• Part of team that added a node to the RAC cluster environment.
• Perform daily Archive log file backup and checking Alert Log files.

Confidential, Washington D.C

Oracle Database Administrator

Responsibilities:

• Planed, installed, configured and troubleshot Oracle 10g and 11g databases on Linux Red Hat Operating systems.
• Planed, installed and configured a 3 node Oracle Real Application (RAC) for both a test and production environment.
• Managed RAC databases using CRSCTL, SRVCTL and grid control
• Installed and manage Oracle Enterprise Manager.
• Installed and configure relevant network components to ensure database access as well as database consistency and integrity.
• Troubleshot and resolve various Oracle connectivity problems.
• Provided network troubleshooting and administrative support for the development staff.
• Created numerous virtual machines via virtual manager to test different application performance to include ad hoc patch fixes on Windows server 2008, Win 7, Win XP 32 bit and 64 bit operating systems/machines.
• Analyzed the Tables and Indexes on performance base regularly.
• Monitored Tablespaces and Datafiles utilization and creation
• Tuned various slow running query.
• Monitored the user sessions and take appropriate action to kill the inactive sessions.
• Created and tuned various materialized views.

Confidential, Columbia, MD

Oracle Database Administrator

Responsibilities:

• Maintained a 10g database security using encryption, and Fine Grain Access Control.
• Configured, audited, granted privileges, restricted access, created users, profiles, roles and monitored quota on tablespaces in line with resource planning guide.
• Managed multiple databases and instances using DataGuard, RAC in a real time production, testing, and development environment.
• Used Enterprise Manager DB console to monitor performance, clone databases, tuning and maintaining optimal performance.
• Used Oracle Grid control on UNIX/Linux and Windows to maintain a 500Gb database with a group of DBAs in a 24/7 365 production environment involving technical proficiency.
• Used DataPump for migration, Remapping, SQL*loader, import and export of database/schema/Tablespace.
• Generated Reports and preparing memo to communicate progress and providing early alerts for major updates.
• Served as point-of-contact to coordinate service with DBMS vendor and other related third-party vendors.
• Used a hot and cold backup and recovery using RMAN.
• Used Enterprise Manager to schedule backups.
• Used Data guard to perform both switch over and failover exercises.
• Configured and managed database backups (full and incremental), restores, cataloguing, and migrations on primary servers and across servers within a project.