Oracle Dba Resume
Pittsburgh, PA
SUMMARY
- I have 6 years of experience in IT industry, worked as Oracle Database Administrator in Retail, Ecommerce, Financing and Banking segments, Health care, encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Monitoring and tuning RAC, Dataguard, Goldengate, Grid Control.
- Extensively Worked on databases in mission critical large OLTP systems in a variety of environments like Oracle Linux, HP UNIX(HP - UX) 11i, Red Hat Enterprise Linux (RHEL).
- Expertise with planning, creation, administration and troubleshooting of Oracle 12c/11g/10g OLTP (multiple instances)/OLAP databases in production.
- Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
- Monitoring of the databases using Oracle Enterprise Manager (12c and 13c).
- Responsible for Monitoring 24/7 Production Support and Performed upgrades from Oracle 11g to 12c and applied patches.
- Involved in implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using .02 on 11g/12c).
- Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Goldengate & Dataguard.
- Implemented disaster recovery databases using dataguard & configured physical standby on 11g/12c.
- OracleGoldengate installation, configuration, troubleshooting Goldengate Extract and Replicat files.
- Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases i.e. Active Dataguard & Snapshot Standby.
- Solid experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
- Created and monitored database objects like Tables, Indexes, Views, Users and DB links.
- Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader.
- Worked along with System and Network Administrators for minimal downtime of the Databases.Involved in doing extensive administrative tasks on UNIX & Red Hat Linux server Databases
- Proven abilities in establishing effective task priorities, working independently and participating as an integral part of a team in fast-paced and multitasking environment.
- Worked on building and rolling out new 12c databases for test/dev/prod environments.
- Implemented oracle 12c active standby database for test database environment.
- Installed, Configured Oracle 12c Goldengate on Oracle 12c Database. Have knowledge on OEM 13c.
- Performed mass deployment of OEM agents on different hosts and registered the databases on those hosts to the OEM for monitoring.
- Worked with projects/operations/professional services team and coordinated multiple tasks at hand with expertise and solid plan.
- Implemented Oracle 11g Golden-gate for replication project.
- Participated in requirements gathering meetings with customer while building out new db environments.
- Experience in applying Critical Patch Updates (CPU Patches) and patch set updates (PSU patches) on Databases.
- Implemented efficient methods for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution, block corruption and Defrag scenarios across diverse environments.
- Extensive experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
- Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs.
TECHNICAL SKILLS
Database: OEM 12C, Oracle 12c, 11gR2, Oracle 11gR1, Oracle 10gR2.
Oracle Products: Real Application Cluster, Golden Gate, Dataguard, Import and Export, Data pumps, Automatic Storage Management, Oracle10g/11g/12c (Grid Control), RMAN, OEM.
Operating System: Oracle Linux, HP UNIX(HP-UX) 11i, Red Hat Enterprise Linux (RHEL).
Languages: SQL, PL/SQL, C.
Tools: & Utilities ADDM, DBCA, AWR, ASH, Toad, Putty, ERWIN, ETL tool.
PROFESSIONAL EXPERIENCE
Confidential, Pittsburgh, PA
Oracle DBA
Responsibilities:
- Administering and supporting Oracle database environment over 95 databases, up to 15TB, utilizing advanced concepts such as Goldengate, Dataguard and Oracle RAC combined on all the production, development and testing environments.
- Configured, administered, and monitored a Streams environment using various tools like OEM console.
- Deployed and configuring database entries and monitoring of the databases using Oracle Enterprise Manager (12cOEM).
- Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
- Worked on ASMCA and used SYSASM for creating disks, drop and add disks to disk groups and tuning ASM parameters per requirement.
- Configured disaster recovery databases using dataguard and performed DR Testing.
- Performed switchover and monitor using DGMGRL.
- Worked on Active dataguard and performed Troubleshooting dataguard environment.
- Involved in OracleGoldengate installation, configuration, troubleshooting Goldengate Extract and Replicat files.
- Used Defgen utility to create definition files in Goldengate.
- Migrated databases using Goldengate with minimal downtime.
- Implemented and supported Goldengate replication in production, and development environments.
- Hands on experience in Installing Goldengate Replication, tools in Goldengate logdump, Defgen for troubleshooting issues in environment.
- Involved in up-gradation of databases from 11g to 12c and applied patch set and interim patches whenever required.
- Involved in Oracle 11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup.
- Standby Database (Dataguard) setup and configuring DB links.
- Maintained Dataguard to ensure high availability, data protection and disaster recovery for enterprise data.
- Upgraded development and production databases from 11g to12c on Linux.
- Involved in Installation and Configuration of Management agents in 12C (Cloud Control).
- Used 12C/11G grid control Maintenance, tuning and monitoring databases.
- Providing Application Support for performance and database related issues.
- Worked with teams and Involved in building Databases.
- Worked on storage Indexes and tested their behavior with different query predicate conditions.
- Documented and logged errors in Goldengate environment and worked on OLTP Compression.
- Extensively used Log dump utility and define utility for resolving issues in Goldengate.
- Extensively used data pump for migrating data between platforms.
- Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
- Involved in scheduling incremental, cumulative and full backups and configured retention policy Using RMAN.
- Applied patching on 11g/12c and Up-gradation of Hp-Unix critical databases from 11.2.3.x to 11.2.4.x.(11gr2).
- Performed Explain Plan analysis for Query Optimization and SQL tuning.
- Performed Database and SQL tuning by using various Tools like AWR, ADDM, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.
Environment: OEM13C, OEM 12C, Oracle 11gR2/12C, Solaris/Linux, SQL, OEM, RAC, ASM, Dataguard 11g/12c, Goldengate, Putty, RMAN, Explain Plan, AWR, ADDM, ASH, Flashback, Data Pumps.
Confidential, Silver City, NM
Oracle Database Administrator
Responsibilities:
- Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
- Worked in build stage, Installed and configured oracle software, databases from scratch
- Installed and configured RAC (2node) & created Databases using dbca.
- Created ASM disk groups and managed grid infrastructure network resources.
- Responsible for Monitoring 24/7 Production Support and Performed upgrades from Oracle 11g to 12c and applied patches.
- Configured, administered, and monitored a Streams environment using various tools like OEM console.
- Installed standalone servers on ASM, created disk groups on ASM.
- Worked on ASM and Performed SAN migration.
- Implemented load balancing using 11.2.1.0.6 OracleGoldengate.
- Installed and configured, troubleshooting Goldengate Extract, pump and Replicate processes.
- Troubleshooting Goldengate issues in both development and production environments.
- Implemented and supported Goldengate replication in production, and development environments.
- Zero downtime migration using oracle datapump and Goldengate between Oracle 11g and 12c with Linux, Solaris, and Windows platforms.
- Migrating and upgrading Oracle Database from 11gR1 on Solaris/Windows to 12cR2 on Linux environment using datapump and Goldengate replication.
- Configured disaster recovery databases using DATAGUARD & worked on 11g feature active dataguard.
- Applied patches on standalone servers using Opatch utility and upgraded Opatch utility from lower version to higher version.
- Using SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.
- Having Good experience in monitoring databases.
- Implemented data transfer using Data Pumps and Export/Import utilities.
- Involved in scheduling incremental, cumulative and full backups and configured retention policy.
- Performance tuning of the oracle databases using the following tools/utilities: OEM, OEM 12C, AWR, ASH, ADDM, tkprof, DBMS stats.
- Performance tuning of the databases using: OEM, OEM12C, Toad, AWR, ASH, SQLT, DBMS stats, explain plan.
- Implemented advanced features AWR, ADDM reports for monitoring database performance, Modified and updated the Performance tuning scripts.
- Mentoring Level-II DBA’s and involved in 24x7 Production-on calls supports for all the production databases with Oracle.
- Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching.
- Improved the security feature of the data in a schema with the database vault feature, redaction and created realm using 12C Oracle Enterprise Manager.
- Installed and configured the Oracle Goldengate and involved in troubleshooting Goldengate issues.
- Worked with app support team to understand the complete replication requirement.
- Enabled DDL replication in database and enabled supplemental logging.
- Efficient use of Imp/Export Jobs for schema migration and tablespace migration.
- Designed multiple extract and replicate parameter files for overall replication.
- Duplicate database using RMAN utility for Oracle 11g from Prod to Non-Prod databases.
- Analyzed goldengate issues from ggserr.log file and used logdump utility for troubleshooting.
- Configured multiple goldengate environments, few extracting from online redologs and few other extracting always from Archive logs.
Environment: OEM 12c, Oracle 12C/11g, Goldengate, Putty, Toad, RMAN, Dataguard, OEM, Grid Control 11g/12c, AWR, ADDM, ASH, Explain Plan.
Confidential
Database Administrator
Responsibilities:
- Configured Oracle Dataguard for Oracle Disaster recovery.
- Implemented and operate allGoldengateprocesses.
- Setup theGoldengateReplication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database.
- Implemented Oracle database backup & recovery solutions using RMAN.
- Extensive use of Oracle Data Pumps Exports/Imports utility for moving data among the servers.
- Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
- Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
- Worked with Data pump to take the logical backups of databases.
- Experienced in performing Point in time recovery using RMAN.
- Involved in designing logical and physical data models using Erwin.
- Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
- Installation, Configuration, Upgrade, patching of Oracle RDBMS in development, test and production environments on Various OS Platforms like Linux, AIX and HP-UX.
- Refresh/Cloning of Database and applications for as and when needed.
- Involved in creating tables, views etc.
- Monitoring and tuning using different Oracle utilities like AWR, SQL trace, TKPROF, Explain plan.
- Implementing User management strategies: schemas, Objects, user profiles roles and privilege management etc. As per application requirements.
- Preparing the Documents: Installation/Upgrades/Patching/cloning/Issues /New activities are documented for the User and shared along with the team.
- Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges andpermissionsto appropriate groups.
- Applying Patch set update and critical patch updates.
- Experience in code migration, database change management and data management.
Environment: OEM 12c, Red Hat Linux 4.x, 5.x, Hp-Unix 7.1, Oracle 11g/12C, AWR, Explain Plan.
Confidential
Oracle Database Administrator
Responsibilities:
- Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
- Implemented Dataguard and administered the production database.
- Responsible to schedule backups through RMAN.
- Involved in Up-gradation of databases from 9i to 10g.
- Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
- Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
- Converted physical standby databases to Snapshot standby database.
- Implemented Oracle database backup & recovery solutions using RMAN.
- Configured and Tuned RMAN for better performance and backup strategies.
- Involved in writing for shell scripts for taking RMAN backups.
- Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
- Implemented scripts to capture high resource utilization query's, Implemented scripts for daily monitoring like db status, free space etc.
- Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
- Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
- Tuned the SGA, Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Table spaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.
Environment: Oracle Windows, IBM-AIX, RHEL, Oracle 10g PL/SQL, SQL*PLUS, Oracle Enterprise Manager 9.2.0/10g, RMAN