We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

West Des Moines, IA

SUMMARY:

  • Around 9 years of experience as Oracle Database Administrator in various domains and on a variety of UNIX and Windows platforms with Oracle (12c/11g/10g/9i/8i) . Highly competent in Administration, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery.
  • Proficient experience as an IT professional along with extensive experience as an Oracle Analyst
  • Proficient in Oracle 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x
  • Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing
  • Oracle Database Administration experience in variety of different environments like HP - UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
  • Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g/11g/12c RAC environment.
  • Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
  • Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
  • Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
  • Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA) .
  • Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
  • Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicat.
  • Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicat rebuild and abend.
  • Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
  • Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
  • Laid hands on tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
  • Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
  • Performed backups and crash recoveries using conventional hot/cold backups and RMAN
  • Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
  • Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
  • Implemented Dataguard in the production environment.
  • Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
  • Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.
  • Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database.
  • Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.
  • Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.
  • Managed Materialized Views for data replication purpose.
  • Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
  • Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
  • Solved many Network related problems in a database using Oracle Net Configuration Assistant (NETCA), Oracle Net Manager, Net stat and ping utility, providing Oracle Networking Solutions (tnsnames.ora, sqlnet.ora).
  • Experienced with installing, configuring and administering SQL server 2000/2005/2008 databases including migration from MS SQL server to oracle.
  • Good experience in MSSQL Server 2000/2005/2008, T- SQL with knowledge of Server Clustering, SQL Profiler, Execution plan, Log Shipping, and Database Mirroring .
  • Transferring compressed files on FTP servers, on UNIX platform.
  • Experience in Installing and configuration of IBM Optim on servers, using Informatica ILM and Optima tools for data archiving and data purging
  • Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs, Scheduled Tasks (Windows).
  • Supported a large number of Development Databases, mainly in tuning the SQL code to improve Performance

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5, Windows 2003, Windows 2000/NT, Windows XP.

Databases: Oracle 12c,11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Utlbstat,Utlestat,Statspack, AWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA

Scripting: Shell Scripting Korn & Bourne, C Shell

Monitoring Tools: Quest Fog light, VERITAS Net Backup, Legato backup, Cisco Tidal, Performance and Web Portals, BMC Remedy, HP Quality Center.

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, Putty, SQL*PLUS, iSQL*Plus, ERWIN 4.14, SQL- Navigator, ERWIN, LogMiner and Flashback data Archive, Macromedia Flash, Dream-weaver, MS Office, Joomla.

Languages: SQL, PL/SQL for Oracle, C, Java, Php, XSLT.

PROFESSIONAL EXPERIENCE:

Confidential,West Des Moines, IA

Sr. Oracle DBA

Environment: Oracle Exadata,Red Hat Linux RHEL 5.x and 6.x,Windows 2007/2010,Oracle 11g/12c, SQL, PL/SQL, UNIX Shell Scripting, EXPLAIN PLAN, STATSPACK,AWR,ADDM, EMC,DAN Q,Sql Developer, RMAN, OEM, SQL* Loader,expdp, impdp, TOAD 12.6

Responsibilities:

  • Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
  • Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
  • Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch.
  • Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c. as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
  • Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
  • Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.
  • Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
  • Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
  • Worked and implemented Database Wallet for Oracle 11g also called as keystore from 12c and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption, also used TDE for Goldengate replication too.
  • Also tested disaster recovery with database failover and switchover also tested Goldengate replication after that using DBFS filesystem and ACFS.
  • Implemented Oracle Goldengate (both Classic and integrated capture) and Shareplex for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for archival purposes.
  • Worked on setting up of Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to Downstream systems. And on Non-EXADATA servers we used separate mining database Goldengate replication and on EXADATA source databases is used as mining database too.
  • Installed Goldengate version 11 and version 12 with latest patches applied on DBFS filesystem and ACFS filesystem, also working testing new OGG 12.2 new features available.
  • Implemented Goldengate integrated replicat and co-ordinated replicat(available from OGG 12c) to improve the performance of data replication to targets .
  • Used JAGENT at server level and GG plugin at OEM grid level for Goldengate monitoring and also used cron scripts.
  • Implemented archive and Purge strategy for archiving the inactive data in the historical database and purging the archived data from the primary database as a part of performance improvisation using Goldengate and exp/imp using partitions.
  • Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g, and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and Standalone databases.
  • Refresh the test and development databases from the source production databases on a regular basis using export/import utility
  • Creating and Maintaining the user accounts and providing required privileges for database access based on the user requests with proper approvals.
  • Created and troubleshoot DB Link issues in Oracle for communicating with external databases.
  • Used Utilities like Explain Plan, SQL*Trace, TKPROF and Statspack for SQL Tuning Purpose.
  • Worked on Re-Organizing the tables to convert from non-partitioned to partitioned tables using Online Re-definition (with minimal impact to live system ), CTAS(create table as select ), exp/imp and creating the table with new DDL and direct insert sql.
  • Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.

Confidential,Hopkins,MN

Sr. Oracle DBA

Environment: Oracle Exadata, IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0, Oracle 12c GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Toad 8.6, Oracle Applications 11.5.8, Oracle Application server 10g, AD utilities, APEX 2.0/2.2,Sybase, SQL server

Responsibilities:
  • Extensively worked on goldengate implementations in peer to peer topology.
  • Worked on upgrading of oracle databases from 11g to 12c.
  • Worked on building and rolling out new 12c databases for test/dev/qa environments.
  • Migrated Oracle database from Non Exadata machine to Exadata using datapump and goldengate.
  • Implemented oracle 12c active standby database for test database environment.
  • Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
  • Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
  • Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
  • Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
  • Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.
  • Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.
  • Contributed as an efficient/reliable team member for all business critical releases and changes.
  • Handled all dba work for Business promotional activities.
  • Utilized Accurev tool for code version change control activities.
  • Worked under high stress situations many times and handled the situation very effectively.
  • Performed the code reviews for all the db code coming into the database and fine tuned it before hand.
  • Worked with IBM VERITAS Active - Passive clusters.
  • Involved in 24x7 support for 4TB, 4 Node production RAC database with on-call pager
  • Installation and creation of 11g and 10g databases for Testing, Development and Production
  • Installed Golden Gate 12c on IBM-AIX Platform.
  • Implemented 12c/11g Data guard with one physical database
  • Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
  • Assist Programmers and Developers with Oracle problems.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • PL/SQL, Performance Tuning, Application Tuning and Monitoring.
  • Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
  • Extensively worked with ASMCMD for managing ASM environment.
  • Disaster recovery of Exadata Data guard Physical Standby. Failover/Switchover/Loss of Service/Rebuild/Corruption/Loss of datafile testing.
  • Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
  • Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
  • SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
  • Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
  • Having good working knowledge on teradata.
  • Performed Range Partitioning as a cause to improve the performance of the database.
  • Performed Cross platform migration using transportable table spaces and RMAN.
  • Planned and performed the database migration from SQL Server to Oracle using Golden Gate.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
  • Transformed logical database designs into physical databases using ERWIN Data Modeling Tool.
  • Build and implement test, quality assurance, and production databases and environments.
  • Coordinated strategies to move data between databases using expdp/impdp.
  • Composed maintained and monitored compliance to standards and practices.
  • Assisted IT Analysts on technical database issues and features.
  • Resolved data integration issues.
  • Performed version upgrades and patch installs.
  • Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.
  • Solid discipline in providing end-users timely updates on their problems. Installing server software.
  • ASM implementation & maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
  • Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

Confidential,Agoura Hills,CA

Sr. Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD(10.1), Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3, JAVA

Responsibilities:
  • Worked on Oracle RAC with SRDF Implementations for cross data center replication.
  • Administered the tidal job scheduler for datacenter automation tasks.
  • Worked on HP Quality Centre tool for test/dev/qa code drops and environment true-ups.
  • Implemented oracle 11g golden gate for replication project.
  • Implemented Oracle 11g Active Data guard for Disaster Recovery Solution.
  • Worked on Implementing Oracle OEM 11g Agent cloning tasks for hundreds of servers.
  • Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
  • Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
  • Actively participated on war room bridges during major releases and escalated to dba management as needed.
  • Participated in database audits and following compliance rules and regulations always.
  • Worked with HP service guard on top of oracle 10g databases.
  • Participated in requirements gathering meetings with customer while building out new db environments.
  • Effectively communicating with PM'S while working on project related tasks.
  • Prioritizing db related tasks on daily basis and completing most of them before the close of Business every day.
  • Participated in internal db team meetings with peers and management for db work/project status update.
  • Worked with offshore team and co-ordinate with them always for any database changes by means of email/phone communication.
  • Always uploaded the common share point repository with all updated work related documents for sharing purpose.
  • Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1.0.6,11.1.0.7) upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
  • Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues (created via IBM-CMR,IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4).Used IBM Mange Now.
  • Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
  • Responsible for installing(manually), maintaining, performance tuning, and monitoring of Oracle databases version 10g and 11g on AIX-5.3 in dev, QA, test and production.
  • Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
  • GoldenGate installation, configuration for replication.
  • Helped in Performing Golden Gate replication monitoring, tuning, and capacity planning.
  • Have set up the cronjobs for runalert, spacewatch monitoring, RMAN backup (level 0 and level 1) and recovery, archive log purge, deletion of archive logs and AWR reports on AIX-5.3.
  • Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.
  • Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
  • Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.
  • Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager (GRID CONTROL) 10.2.0.4 to solve the performance issues.
  • Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
  • Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
  • Analyzed the tables and indexes manually whenever required. Manually refreshed the materialized views (used for replication) whenever the job fails to refresh them.
  • Created new schemas, tables, indexes, jobs, tablespaces and granting the previleges to the user as per demand and also written pl/sql code to delete million rows by committing after every 10,000 rows.
  • Monitored and checked the invalid objects like jobs, procedures etc and recompiled manually after solving the problem for objects to become invalid.
  • Installed the oracle dataguard on 11g (physical standby database) on IBM-AIX-5.3for high availability, disaster recovery and used dataguard broker for switchover and failover using utility DGMGRL.
  • Deployed the patches for grid agent and oms for the version 10.2.0.4 and troubleshooted the problems in uploading agent and securing agent.
  • Troubleshooting application failures including performance and database connectivity problems and job failures.
  • Performance tuning of corporate databases, using tools like sql trace, tkprof, AWR, ADDM, SQL Tuning.
  • Administrated the automatic storage management (ASM) like adding the disk groups.
  • Worked on Automatic Storage Management (ASM) for managing data in SAN. Worked with ASMCMD utility for monitoring the ASM and experienced in ASM like adding new disks, creating new disk groups and configuring these disk groups into ASM on AIX-5.3.

Confidential,Overland Park,Kansas

Oracle DBA

Environment: Oracle 10g/9i, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g, RAC,TOAD

Responsibilities:
  • 24/7 Production Database Administration Support
  • Installed and Configured Oracle 9i/10g RAC.
  • Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
  • Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
  • Managing two node RAC databases on Red hat Linux advanced server 2.1.
  • Performed Database migration from Oracle 9.2.0. To 10.1.0.3
  • Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
  • Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
  • Monitored the growth of the database objects for capacity planning.
  • Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
  • Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.
  • Perform requirements gathering, data mapping, metadata management and databasemodelling.
  • Designed and implemented OLS oracle 9i label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
  • Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
  • Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
  • Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files
  • Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
  • Backup and recovery utilizing RMAN.
  • Working with the application support people to resolve database related issues and running the scripts for the application support people.
  • Creating users and database links, snap shots on production and development servers.
  • Maintaining system security, defining of roles, profiles etc.
  • Checking CRON jobs. Monitoring Application specific background processes.
  • Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
  • Use Oracle Metalink Support to resolve different issues related to database servers, security patches.
  • Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
  • Performing Online and Offline database backups on schedule.
  • Scripting of Automated backup for Cold / Hot backups.
  • Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
  • Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
  • Perform database cloning/exp/imp to setup identical databases in the production and development environments.
  • Upgrade/Migrated the production and development databases from 9i to 10g.
  • Involved in Database sizing, Capacity Planning.
  • Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine tuned for better performance.

Confidential

Jr. Oracle DBA

Environment: Oracle 9i/8i/8/7.13/6, NCR Mainframe/Servers, UNIX SVR4, Windows NT, PL/SQL, Bourne Shell, SQL Loader, EXP/IMP, SQL*Forms, SQL*Report, Pro*C.

Responsibilities:
  • Supported high availability for production databases and development databases by designing and implementing different backup and restore strategies using either OS/UNIX or Oracle Techniques.
  • Ensured production database systems performance by monitoring and tuning memory, database and operating system parameters; backed up database, restored data as needed.
  • Assisted Sr. Oracle DBA in Performing production database health check, performance tuning, operation auditing. Replicated databases for Developer team and QA team by setting up testing database, testing environment, test cases and live/stress tests.
  • Implemented database job processing via Oracle and UNIX crontab.
  • Maintained Microsoft SQL Database Server 2003.
  • Net8 Configuration for Clients Connection.
  • Designed, implemented, troubleshoot and maintained database application systems including Payroll, Sales, Account Payables/Receivables, General Leger, Bank Leger, Inventory, and Customer Order.
  • Performed data replication between units.
  • Created users and set permissions.
  • Analysed system requirements for over 10 database (Oracle 6, 7, 8) applications, defined user interfaces and system functionalities, implemented systems using Oracle Forms, Reports, wrote SQL, PL/SQL procedures; performed database upgrades.
  • Assisted team in successfully maintaining, debugging, trouble-shooting 7 huge transaction-intensive enterprise databases; achieved excellent performance, least planned down time.
  • Managed database security using groups and roles.
  • Created database objects and managed the permission access on the objects with necessary security.

Hire Now