We provide IT Staff Augmentation Services!

Oracle Dba Resume

Des Moines, IA

PROFESSIONAL SUMMARY:

  • Over 10+ years of professional experience in Oracle Database Administration
  • Experience with Building RAC, Data Guard, ASM, Flashback and RMAN
  • Implemented 11g/12c RAC with ASM file system using Oracle clusterware.
  • Expert in areas of Oracle 12c/11g/10g PL/SQL, SQL, SQL*Plus, SQL*Loader.
  • Implemented Data guard (Physical Standby) and Active Data Guard for RAC databases.
  • Expertise in implementing Oracle Golden Gate with high Availability.
  • Migrated Non ASM databases to ASM.
  • Experience with High Availability features ( RAC/ DG/ ASM / Flashback / RMAN)
  • Upgraded Oracle 11g databases to Oracle 12c.
  • Experience in upgrading and migrating databases from non - Exadata to Exadata and applying patches.
  • Experienced in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
  • Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
  • Refresh and Cloning using Datapump and RMAN with Commvault, VERITAS Net Backup & TSM.
  • Expertise in Maintenance, Patching, Cloning and troubleshooting.
  • Excellent knowledge in User Managed / RMAN backups and Recovery.
  • Experienced in Database Point in Time Recovery and Tablespace Point in Time recovery.
  • Enforcing security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.
  • Good understanding of Normalization Techniques.
  • Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages.
  • Experience in Working with Oracle Support to resolve issues and open SR's.
  • Enforcing data integrity using integrity constraints & database triggers.
  • Expertise in setup the replication between the databases using streams and Golden Gate.
  • Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP (Enterprise Data warehouse Databases), Logical and Physical Database Design, Backup and Recovery procedures.
  • Experience in Various Flavors of UNIX - Linux, Sun Solaris, HP-Unix and IBM-AIX.
  • Excellent Analytical, Communication and Presentation skills.
  • Provided 24x7 support during on-call schedules.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting

Database: Oracle 12c, 11g RAC/10g RAC/9i

Operating System: UNIX, Solaris, AIX, HP-Unix, Linux, Windows 2005/2003/XP/2000/NT

Tools: Golden Gate, SQL*PLUS, SQL Developer, TOAD, SQL Navigator, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp and Data pump, Humming Bird Connectivity, Cygwin-XOther Technologies: ODBC, Crystal Reports, MS Office, Erwin, Database Design.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Oracle DBA

Environment: Oracle 11g, 12c multitenant, RAC, Exadata, GoldenGate, SQL, PL/SQL, EXPDP/IMPDP, OEM13c, TOAD, RMAN, Sun Solaris, Red Hat Linux, Windows, Data guard, Autosys, BMC Remedy

Responsibilities:

  • Provided 24x7 support for Production, Development, and Test databases.
  • Production database administration and support.
  • Installed and configured Oracle GoldenGate with high availability for Replication.
  • Troubleshooting Golden Gate Replication issues.
  • Worked on Patching GoldenGate Homes, Migrating GoldenGate to hub servers.
  • Supported databases on Exadata.
  • Migrated several database from Oracle 11G to 12c pluggable database on Exadata.
  • Implementation of High Availability solutions with Oracle 11g/12c RAC Standby Database.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Configured and maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Supported Oracle databases with Edition Based R edefinition (EBR) ,Transparent Data Encryption(TDE), Database Vault, Oracle Virtual Directory(OVD).
  • Worked on Production releases to support database and GoldenGate activities.
  • Worked on Performance Tuning of Databases, Oracle instances, SQL’s using tools AWR, ASH and applying baselines using tuning advisory.
  • Monitoring oracle databases using OEM 13c cloud control and creating Metric Extensions to monitor GoldenGate processes and reports.
  • Worked on writing shell scripts to Monitor GoldenGate, Database reports.
  • Worked with database Functions, Procedure, triggers, synonyms, views, sequences and profiles.
  • Created users, roles and granted privileges according to the business requirements.
  • Works with management, peers and vendors to design and implement hardware/software configurations.
  • Provided support for Production, Development, and test Databases.

Confidential, Moline, IL

Oracle DBA

Environment: Oracle 9i,10g,11g, 12c RAC,SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM12c, TOAD 12, RMAN, Sun Solaris, Red Hat Linux, Windows, Data guard, Sun clusters, Oracle Database Appliance, Patrol.

Responsibilities:

  • Provided 24x7 support for Production, Development, and Test databases.
  • Production database administration and support.
  • Supported databases on Exadata databases.
  • Migrated several databases to Exadata machine.
  • Installed and configured Oracle Golden Gate for Replication.
  • Troubleshooting Golden Gate Replication issues
  • Installation, Configuration and Administration of 11g /12c RAC on Exadata.
  • Implementation of High Availability solutions with Oracle 11g RAC Standby Database.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Configured and maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Worked on Performance Tuning of Databases, Oracle instances, SQL’s using tools AWR, ASH, SQL Trace and Explain plan.
  • Implemented backup and recovery procedures.
  • Monitoring oracle databases using OEM 13c cloud control
  • Installed and Configure OEM 13c, Configure grid control agents and Troubleshooting connectivity with Agents.
  • Created different process documents for day to day DBA activities and make sure Databases are Audit compliance.
  • Worked with database Functions, Procedure, triggers, synonyms, views, sequences and profiles.
  • Created users, roles and granted privileges according to the business requirements.
  • Works with management, peers and vendors to design and implement hardware/software configurations.
  • Provided support for Production, Development, and test Databases.

Confidential, Groton, CT

Oracle DBA

Environment: Oracle 9i/10g RAC/11g RAC, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, HP-UX, IBM-AIX, Sun Solaris, Red Hat Linux, Windows, Data guard, ERWIN

Responsibilities:

  • 24 X 7 Production database administration, support for both OLTP and OLAP (EDWD) databases.
  • Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Migration of all Oracle 9i/10g databases/clients to 11g.
  • Migrated NON ASM databases to ASM databases.
  • Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
  • Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
  • Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Worked on Instance Tuning, Memory Tuning and SQL Tuning.
  • Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
  • Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
  • Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
  • Oracle data cloning between oracle 10g and 11g databases using Golden Gate.
  • Written Shell scripts to monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
  • Partitioning of large tables for better performance and manageability.
  • Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
  • Logical & Physical Database Design
  • Capacity Planning and Benchmarking
  • Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR and ADDM.
  • Applying Quarterly patches and Version change patch bundles.
  • Created users, roles and granted privileges according to the business requirements.
  • Worked with Application Teams to resolve issues in data warehouse databases.

Confidential

Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, Toad 9.0, RMAN, DBCA, ErwinLinux, Windows.

Responsibilities:

  • Provided 24x7 support for Production, Development, and test databases.
  • Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases for high availability and disaster recovery.
  • Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
  • Upgrade and Migration of Database’s from 10.2.0.4 to 11.1.0.6 and applying patches whenever required.
  • Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
  • Recovering the database from any kind of crash with the minimum data loss.
  • Database Recovery (both complete and incomplete) from different types of failure.
  • Used RMAN for backup and recovery. Performed backup validations using RMAN.
  • Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space.
  • Performed Database Point in Time Recovery and Table Space Point in Time Recovery with the use of Transportable Table space.
  • Applying patches quarterly (PSU, CPU, ONE-OFF) for security and to fix the bugs.
  • Responsible for supporting the Oracle databases and ensuring their Performance, Availability and Security.
  • Planning the size of the Database, Creation of Database and location of initial data files, redo log files and multiplexing them, editing database initialization parameter file whenever required.
  • Implementation and release of Database changes as submitted by the development team.
  • Create Production Support databases for testing every Week for developers using Data pump Impdp from Production Backups.
  • Maintaining all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
  • Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, ADDM, AWR, EXPLAINPLAN, SQLTRACE and TKPROF.
  • Maintaining Erwin for all the new database changes Implemented during each release.
  • Responsible for the Database Builds on Test, Development databases and Monitor Production database during builds .
  • Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
  • Written Shell scripts to Monitor activates like availability of Database & Listeners, Space utilization, Gathering statistic for the cost base optimizer, Index rebuilding .
  • Good exposure to oracle technologies like AWR, ASM, Flashback and Data Pump Import/Export.
  • Worked on External tables for Loading Flat files into Database and also created flat files of existing tables for loading into different environment.

Hire Now