SUMMARY:

• Oracle Database Administrator with Seven (7) years of experience in administering all aspects of Oracle 12C, 11G/10G within a RAC, Dataguard, Golden gate, Oracle Cloud Infrastructure(OCI) and Amazon web services (AWS) environments.
• Experienced in installing, upgrading, migrating, patching, refreshing databases and cloning oracle homes
• Upgraded GRID Infrastructure, RAC - Dataguard setups for 11gR2 and 12c
• Enforced database security strategies by creating database users, user roles, profiles, audit trails, audit banners and transparent data encryption
• Experienced in database Backups RMAN ((Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces
• Experienced with Oracle RAC, Oracle Enterprise Manager Grid Control, Data Guard including Active DG and Flashback.
• Performed PL/SQL development, Shell scripting and Performance tuning, OS utilities AWR/ADDM.
• Installed and configured Oracle 11g RAC dataguard physical standby and dataguard broker.
• Used OEM, SQL Developer and TOAD to administer database.
• Experience with My Oracle Support (MOS)/Meta link for Oracle SR, patch download Experience and TFA reporting
• Determined problem-solver with success in aligning the business and industry’s best practices and technical vision in order to initiate, implement, and improve innovative business technology solutions
• Experienced with HP service Manager’s service desk and on-call tools for problem/incident management and on-call support.
• Excellent communication, inter-personal and organizational skills.

TECHNICAL SKILLS:

Database Development Tools: OUI, DBCA, DBUA, Oracle Net Manager, SQL, SQL*Plus, SQL*Loader, TOAD, OEM, PL/SQL, Enterprise Manager, RMAN, Data Dump and Export/Import Utility.

Technical Environment: UNIX (Linux, Solaris, HPUX, AIX), Windows, Oracle 10g, 11g, OEM 11g/12c, RAC, ASM, DATA GUARD

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Oracle Database Administrator

Responsibilities:

• Oracle RAC/dataguard Installation and upgraded from 11.2.0.1 CRS/ASM to 11.2.0.4 GRID Infrastructure and from 11204 to 12101
• Upgraded several databases from 11201 to 11204
• Manages several databases on AWS RDS and EC2
• Oracle secure backups to the cloud
• Installed and Configured Oracle Database Vault
• Applied quarterly PSU Patches to RAC/Non-RAC databases.
• General administration and routine operations including ASM diskgroup management, applying database tuning improvements, managing users and database security, troubleshooting and performance tuning.
• Upgraded several databases from 11201 to 11204
• Upgraded GRID Infrastructure, RAC-Dataguard setups from 11204 to 12102
• Export and import of tables and schemas as per development/Application team requirements using Data pump
• Generated scripts for daily maintenance routine activities, growth rate monitoring and optimizing database performance
• Routine Golden gate administration
• Provide planned maintenance for the implementation of new releases and Database migrations
• Provide support after normal business hours (i.e., nights, weekends, and holidays) and participate in a 24 x 7 on-call rotation.

Confidential, Fort worth, TX

Oracle Database Administrator

Responsibilities:

• Supported The Boeing Company production/UTA/test/Dev database systems in a large complex LINUX, HP-UX, AIX and Windows environment
• Delivered 24/7 database administration support to more than 600 servers and 2500 databases, which include oversight of DBA on-call rotations.
• Proactively provided support to RAC, ASM, and Data Guard physical standby databases throughout daily production operations.
• Resolved archivelog gaps and other related problems. Effected switch over manually and using DMGDRL
• Used AutoSys, windows task scheduler and Crontab to schedule weekly backup and file clean jobs
• Closely tracked and administered the production environment, which includes database alert logs, file system disk space, tablespace monitoring, system shut downs, and database restarts for maintenance purposes.
• Performed refresh of schemas from production to test environment using the DATAPUMP utility (expdp/impdp).
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control, OraTools and TOAD
• Successfully run complete, incremental, and archive backups with Recovery Manager (RMAN).
• Upgraded multiple databases from 11.2.0.3 to 11.2.0.4.
• Configure OID and LDAP Oracle service names and alias registration.

Confidential, Adrian, MI

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 10g/11g software on Linux.
• Refreshed databases and configured them to meet developer and user requirements
• Applied Oracle Critical PSU on our databases on quarterly basis.
• Managed backups and recoveries using RMAN, data-pump export/import utilities Managed tablespace, control file and online redo logs.
• Conducted regular status checks, monitoring the Alert log, trace files of databases.
• Monitor databases which include basic health checks, growth of objects, and performance of databases.
• Monitored database activity and file usage by removing old or obsolete files to ensure necessary resources are released to enhance database performance.
• Checked database and servers for disk contention, monitored resource usage, system events, to maximize performance.