Oracle Dba Resume
Des Moines, IA
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: bOracle 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.