We provide IT Staff Augmentation Services!

Lead Oracle Dba Resume

Dover, DE

SUMMARY:

  • Over twenty years of experience, building, planning and maintaining from Oracle 7 to 12c databases
  • Performance Tuning, Database Backup and Recovery. Well versed in the functionality of Oracle 10g and 11g Real Application Cluster (RAC), 10gAS, and PeopleSoft 9.1 and SSO - OID integration with Windows AD.
  • Also has extensive experience of cross platform migration, OEM Grid Control, TOAD, Erwin.
  • Has worked on all configurations of the Oracle Database Server: Parallel Server and Data Guard.
  • Team leader, motivated team member or independent worker with strong problem solving abilities and communication skills, an aptitude for sharing knowledge and quickly adapting to new environments.

TECHNICAL SKILLS:

Software and Languages: Hyperion, Essbase, WebLogic, 10gAS, SSO, PeopleSoft People Tools, J2EEOID, OAM, Web Cache Clustering, RAC, OWB, Data Guard Disaster Recovery, Oracle 8i, 9i, 10g, PL/SQL, Erwin, Veritas DBE/AC, Micro-Strategy. TDE.

Operating Systems: Linux (Red Hat), AIX, HP-UX (9.0.4, 10.10, 10.20. 11i), SOLARIS (2.7, 2.8, 5.910), TRU-64, Windows 2000/3/8/12. Oracle X2/X3/X4 full rack Exadata machine.

PROFESSIONAL SUMMARY:

Confidential

Lead Oracle DBA, Dover, DE

Responsibilities:

  • Responsible for a wide range of databases from 10g to 11gR2, and later 12C on Linux, HP UX and Windows servers.
  • Support of PeopleSoft applications like HR, Financial.
  • Daily support, installation, setup, migration, upgrade of different version of Microsoft SQL server databases.
  • Migrating schemas and objects across databases using either data pump exports or using database links.
  • Schedule RMAN backups, background jobs using cron on UNIX, and using PLSQL procedures on Windows.
  • Day-to-day user requests relating to user access privileges, database availability, Performance analysis/tuning, for slow performing queries, and poorly written SQL scripts.
  • Installed and configured the new Oracle Enterprise Manager Cloud Control (12C), and registered databases as well as Oracle Web Logic and Microsoft SQL Servers databases.
  • Day-to-day user requests relating to user access privileges, database availability, Performance analysis/tuning using various tools like OEM, TOAD etc.
  • Experienced in Oracle Automatic Storage Management (ASM) and Oracle Automatic Storage Management Cluster File System (ACFS).
  • Used Erwin for physical and logical modeling. Forward and reverse engineering to and from the database.
  • Create as requested, new databases, upgrade on Exadata machine to newer versions, quarterly security patch set (CPU or PSU).
  • Configured and administered Oracle databases, Cloning, Backup and recovery of Oracle databases manually, using RMAN, and using data pump export/import utilities. Cross server’s migrations.

Confidential

Oracle dba, Washington, DC

Responsibilities:

  • Converted the Oracle Development, Integration and Production Databases to Automatic Storage Management (ASM).
  • Migrated single instances Development, Integration to 2 nodes RAC and Production database to 2 nodes RAC.
  • Designed and developed Backup (Hot & Cold Backup) & Recovery procedures for Production databases. Set up Operating System level tasks for backup, recovery and housekeeping.

Confidential

Lead Oracle dba, Woodlawn, MD

Responsibilities:

  • Managed a wide range of databases from Oracle 9i to 11g On Sun Solaris.
  • Upgraded databases from version 9.2.0.8 to 11.1.0.7.
  • Setup, and configured Oracle Data Guard.
  • Managed and tuned online transaction processing (OLTP) database by using fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.
  • Cloned several databases using RMAN, with either cold backup or hot backup.
  • Recovered databases from backup files on different servers and file systems, with different database SID.
  • Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing all Oracle databases.
  • Installed and configured ETL tool Informatica on a three tiers environment. Helped the ETL team with the design, tuning and troubleshoot of ETL processes.
  • Experienced OLAP and Data warehouse configurations.
  • Database Performance Tuning and Troubleshooting and Oracle Database Partitioning.
  • Experienced with 11g, 12c Oracle databases and Golden Gate 12.x. and also installed, configured, troubleshooted the Golden Gate replication between different versions of Oracle databases.
  • Used Erwin for physical and logical modeling. Forward and reverse engineering to and from the database.
  • Installed and configured reporting tool Cognos, and later Micro Strategy on a three tiers environment. Assisted the reporting team with the tuning of report processes.
  • Daily Maintenance involving performance monitoring, backup monitoring, upgrading to new releases and patches, manage space, instance/SQL tuning, process scheduler maintenance, perform adhoc SQL for users and review production process logs.

Confidential

Oracle dba, 10g AS DBA, Washington, DC

Responsibilities:

  • Applied different Oracle 9i and 10g patches, quarterly Oracle CPU and security Patch sets to the database server on Sun Solaris and Linux servers.
  • Applied the quarterly Oracle CPU and security Patch sets to the HTTP servers, middle-tier tiers and infrastructures.
  • Performed several database upgrades from 9i to 10g, as well as database migration from different servers using cold backup and cloning.
  • In charge of day-to-day maintenance of five OID, and AD domains.
  • Designed, and implemented the integration of Oracle Internet Directory (OID), Oracle Identity Manager (OIM) and Oracle Access Manager (OAM) with Windows Active Directory (AD).
  • Deployed Oracle Internet Directory (OID) and Single Sign-On (SSO), which is to be integrated with J2EE and E-Business Suite 11i applications within the Unified Desktop framework.
  • Database Performance Tuning and Troubleshooting and Oracle Database Partitioning.
  • Created a wallet and generated a certificate request. Installed the wallet to the HTTP server default location for both SSO servers. Configured SSL for both SSO servers using SSLConfigTool. Integrated Oracle Internet Directory with Windows Active Directory. Configured Oracle Single Sign On for Windows Native Authentication (WNA). Setup Kerberos. Configured Windows Native Authentication. Reconfigured OID Local Accounts.
  • Installed, and deployed homegrown J2EE partner Applications, Oracle Application Express (Apex).
  • Reregistered mod osso on the Partner Application Middle Tiers to enable SSO.
  • Upgraded the Oracle OID, SSO metadata repository from 10.2.0.1 to 10.2.0.3 version, and then applied the quarterly Oracle CPU and security Patch sets to SSO and OID servers.

Confidential

Oracle dba, Gaithersburg, MD

Responsibilities:

  • Using Oracle version 10g, Oracle Fail-safe, and standby databases, I designed and implemented the database servers for two new data centers. This effort included creating, tuning, managing and monitoring of the development and production database instances to support 24x7 e-commerce applications. This effort also included the implementation of backup and recovery, and disaster recovery strategies.
  • Configured Advanced Security Option to encrypt connections between clients and server, and secure the databases, as per DOC requirements.
  • Involved in daily maintenance of databases to ensure the improvement of a high performing SQL statements and database availability at all time.

Confidential

Oracle dba, Milford, CT

Responsibilities:

  • Installed and configured 10g Real Application Cluster (RAC) on Linux 3.0.
  • Created a physical Standby database using Data Guard.
  • Migrated the database to Oracle Automatic Storage Management (ASM).
  • Converted the Single Instance Database to Oracle RAC.
  • Database Performance Tuning and Troubleshooting and Oracle Database Partitioning.
  • Managed and tuned online transaction processing (OLTP) database by using fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.
  • Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing all Oracle databases.

Confidential

Oracle dba, Washington, DC

Responsibilities:

  • Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing databases, application servers and web servers.
  • Designed and planned the layout of the Application Servers universe, including clustering of the Infrastructure, integrated Oracle OID with Microsoft Active directory.
  • Implemented Single Sign-on (SSO) plan for OTR including the integration of Oracle infrastructures, Portal, Business Intelligence Reports.
  • Served as technical lead, and DBA consultant on the Data warehouse project using Oracle 10g RDBMS.
  • Designed a sound backup and recovery strategy on TB database, including crisis scenario, capacity planning.

Confidential

Oracle DBA, Tulsa, OK

Responsibilities:

  • Served as an application server DBA, coordinating and supporting the effort of PL/SQL and web developers, then translating their recurrent changes into database objects.
  • Installed and administered Oracle Warehouse Builder.
  • Designed and implemented a summary management including bitmap indexes, materialized view and Partitions.
  • Installed, setup, configured and administered the Payroll an HR databases (PeopleSoft).

Hire Now