We provide IT Staff Augmentation Services!

Sr. Oracle Database Engineer Resume

2.00/5 (Submit Your Rating)

TX

SUMMARY:

  • Over 8+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
  • Extensive experience in database administration for Oracle 9i, 10g, 11g and 12C with experience in very large-scale database environment and mission critical large OLTP and OLAP systems
  • RAC Installation and Maintenance, setting up and configuring Dataguard, performing all kinds of Backups and Recoveries, Cloning databases, Hand on experience in Installing Goldengate Replication, auditing and product support.
  • Hands on experience in Oracle 10g, 11g and 12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to this cluster database for High Availability and Recovery.
  • Setup and maintenance of various versions of oracle engineered systems such as Oracle Database Appliance (ODA) V1, X3-2, X5-2 & X6-2 and Exadata X3-2 & X5-2.
  • Migrated Single Instance databases to RAC Environment.
  • Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases.
  • Have good knowledge about Physical and Logical structure of a database.
  • Hands on experience in Grid Control (11g) and INSTALLED OEM 13C for database Monitoring/Performance/Diagnostics.
  • Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-TRACE, TKPROF, ADDM and Explain Plan Methods.
  • Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
  • Configured and Maintained RMAN Catalog Database and schemas and involved in registering the Databases to RMAN Catalog.
  • Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
  • Experience in installing and configuring Goldengate (OGG) 12.2 for data replication, migrations and upgrades.
  • Experience in Database migration using tools like DATAPUMP, Export/Import and Transportable Tablespaces and RMAN Duplication.
  • Good experience in PATCHING AND UPGRADATION from 10.2.0.x to 11.2.0.x & 11.2.0.x to 12.1.0.x
  • Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
  • Implementation and administration of Oracle Audit Vault, VPD, VPC and data encryption for sensitive data.
  • Experience in using OEM 12c to manage Oracle Database Vault and applying patches to a Database that is protected by Oracle Database Vault.
  • Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.
  • Install, Administer, and Optimize MongoDB instances.
  • Migrated some of the Document based capital markets related databases to MongoDB from Oracle 11GR2 with cross platform migration tool Oracle GoldenGate.
  • Configuring, implementing and supporting High Availability (Replication) with Load balancing (sharding) cluster of MongoDB having TB’s of data.
  • Backup and restore mongo databases and Optimizing MongoDB CRUD Operations
  • Experience as On-Call 24x7 production DBA support, application/development DBA.
  • Proficient in working with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
  • Adequate working experience with ITIL process oriented projects, fulfilment of SLA’s (service level agreements). Prepared standard documentation for continuous business, services and process improvement plans for the client and vendor.
  • Excellent oral and written Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Operating Systems: HP-UX10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, IBM-AIX, WindowsXP/ 2003/2007/2010, Red Hat Linux RHEL 4.x, 5.x.,6.x, EXADATA V2(X2-2)

RDBMS: Oracle 12c,11g,10g,9i, Oracle 10g,11g and 12C Real Application Cluster (RAC)MySQL (4.x.x/5.x.x)

Languages: SQL, PL/SQL, C, XML, UNIX Shell Scripting.

DB Management: TOAD, OEM, SQL Developer.

Tools: /Utilities: RMAN, OEM, OMS, SQL*Loader, Export/Import, TOAD, Data pump, Query builder, Net Backup, MS Access.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas Fort Worth, TX

Sr. Oracle Database Engineer

Responsibilities:
  • Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases in production and non-production environment on both Solaris and Oracle Enterprise Linux platforms.
  • Setup and maintenance of various versions of oracle engineered systems such as Oracle Database Appliance (ODA) V1, X3-2, X5-2 & X6-2 and Exadata X 3-2 & X5-2.
  • Applied the latest security patch 12.1.2.11.0 on all the ODA’s starting from Lab to Production and documented the same steps and collected all the logs and provided them to other teams for their reference.
  • Replacing the faulty memory and storage disks on all the ODA’s when needed.
  • Install, configure and administer Oracle Real Application Cluster (RAC) for versions 10g/11g/12c on ODA and Exadata super clusters.
  • Upgrade and migrate databases from Oracle 11g to 12c in a RAC environment.
  • Performing regular database administration functions including monitoring, analysis, and tuning of Oracle databases to achieve optimum performance.
  • Capacity planning and timely review of database and infrastructure architecture.
  • Installed the latest Oracle Enterprise Manager OEM 13C and installed all the new agents and added all the databases and hosts to OEM for monitoring.
  • Oracle Dataguard setup and monitoring for Disaster recovery.
  • Installed the latest Goldengate 12.2 on all the new Customer Hub and Cabin Crew Automated services application related databases.
  • Migrated Oracle Streams to latest Goldengate 12.2 for all the application related to Legacy US airways applications.
  • Setup and configuration of Data Domain and NetBackup.
  • Writing and modifying the existing Shell, PL/SQL Scripts for scheduling the latest RMAN DD boost backups in all the non-prod and Prod environments.
  • User management in compliance to PCI/DSS standards.
  • Used various ticketing tools like Service Now, Cherwell ITSM, BMC service desk and HP ticketing tools at the enterprise level.
  • Administering the storage and network issues along with the performance issues on the Exadata storage clusters.
  • Creating, administering and maintaining MySQL, MongoDB in private and public clouds both Pivotal cloud foundry and IBM Bluemix.
  • Active research on migrating the traditional databases to cloud as a part of Enterprise delivery acceleration project to offer better performance and reliability to the customers.

Environment:: LINUX, OE-Linux, Oracle 11G and 12c, OEM 12c and 13c, UNIX, SQL, Oracle text, Oracle Partitioning, Goldengate, Physical Standby (Active Dataguard, normal standby), Oracle Database Appliance V1, X3-2, X5-2 & X6-2 and Exadata X3-2 & X5-2.

Confidential,Des Moines,IA

Sr. Oracle Database Administrator

Responsibilities:
  • Maintaining the availability of Oracle Database versions 12c, 11g, 10g in both Production and lower environments.
  • 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.
  • Also tested disaster recovery with database failover and switchover also tested Goldengate (OGG) replication using DBFS filesystem and ACFS for GG binaries.
  • Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using Dataguard switchover, Export & Import (Datapump).
  • Implemented Oracle Goldengate (OGG) (both Classic and integrated capture) for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for retention based archival purposes.
  • Worked on setting up of Goldengate (OGG) 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
  • Installed Goldengate version 11 and version 12 with latest patches applied on DBFS filesystem and ACFS filesystem, also worked on testing OGG 12.2 new features.
  • Implemented Goldengate integrated replicat and coordinated replicat (available from OGG 12c) to improve the performance of data replication to targets.
  • Customization and development of K- shell scripts required for monitoring space usage, backup jobs, stats gathering, Goldengate Process Monitoring etc.
  • 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 and worked on OKV (Oracle Key Vault).
  • Implemented OVD and Kerberos setup.
  • Also Implemented OID (Oracle Internet Directory) i.e. LDAP directory on Oracle databases.
  • Implemented Audit Vault for collection and consolidation of Audit related information and Database Vault for security and compliance purposes.
  • 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.
  • 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.
  • Upgraded the RAC and standalone databases from 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 and 12.1.0.2).
  • Pro-Active Monitoring of the Databases using 12c Enterprise Manager and fixing the issues, also working on Root Cause Analysis and documenting the issue resolution steps for future reference.
  • Applied the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using Opatch.
  • 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Involved in Upgrading and migrating non-critical internal databases to SQL Server 2012 and SQL Server 2014 from oracle using oracle Goldengate.
  • Capacity Planning and requesting the storage required by analyzing the database growth.
  • Providing the Go-live and Post - go live Support for the database performance related issues and ensure that all the work is documented for future reference.
  • Aiding in activities such as knowledge sharing and knowledge transfer.

Environment:: LINUX, IBM-AIX, Oracle 10G, 11G and 12c, OEM 11G and 12c, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Goldengate, Physical Standby (Active Dataguard, normal standby), Logminer, Oracle 12c, 11gR2 and 10g R2 RAC and Standalone.

Confidential

Sr. Oracle Database Administrator

Responsibilities:
  • Perform CORE DBA tasks such as Database Administration on Oracle 10g and 11g environments.
  • Upgrade and Migration of Databases from 10g to 11g and 11g to 12C, applying patches whenever required.
  • Continuous Performance monitoring and tuning of the databases and application using OEM.
  • Daily Health Check Up of the Database using ADDM, AWR.
  • RAC Administration involving managing of instances, ASM, cluster resources.
  • Work with the production support team and maintain operational consistency and efficiency.
  • Configuration of 11g Dataguard for Higher Availability of Tier-I databases along with 11g RAC Scalability.
  • Installed and configured Oracle APEX for development of functional capability.
  • Installation and configuration of Goldengate for replication of data from OLTP to Reporting Databases (DW).
  • Developed shell scripts for tracing Oracle errors, free space in the table spaces and free disk space in Archive destination for production database.
  • Experience using Data pump utility for taking logical backups on database, schemas and tables with partitioning.
  • Involved in deploying new application and setting up replication between the databases using Goldengate.
  • Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity.
  • Implement physical database changes, testing, and performance tuning by reviewing database activity, progress, and performance reports.
  • Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
  • Used Data Pump for schema refresh, database refresh and used RMAN for backing up databases.
  • Provided 24x7 on call support.
  • Creating and refreshing materialized views.
  • Working as Senior Oracle DBA to support mission critical databases. Involved in up gradation/migration of 10g (10.2.0.2, 10.2.0.3, 10.2.0.4 and 10.2.0.5) RAC to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) RAC with ASM, performance tuning, capacity planning and back up recovery.
  • Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import, Table Move and online redefinition procedures.

Environment:: Oracle 11g, 10g, 9i, Red Hat Linux 5.x, 6.x, RAC, OEM, ADDM, AWR, Goldengate, EXADATA V2(X2-2), Data Guard, ASM, SQL *, SQL Server, Data Pump, Data vault, TOAD.

Confidential,Grand Rapids,MI

Oracle Database Administrator

Responsibilities:
  • Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Managing Data Guard, Replication, Backup and Recovery support and performance tuning etc.
  • Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control (OEM) OMS Installation.
  • Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
  • Worked on OEM 11g grid for monitoring the Listeners present in the oracle environment.
  • Worked in troubleshooting RAC and implemented ASM features.
  • Well Experienced in taking Backups for a very huge 15-Tb Database.
  • Daily backups using RMAN.
  • Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
  • Having good experience in user management, Table space Management, Session Management, undo Management issues.
  • Installed 12c agents on hosts and discovered targets. Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
  • Handy in utilizing Data Pump tool for exporting and importing the data between databases.
  • Used Data Pump for schema refresh, and RMAN for database refresh and used RMAN for backing up databases.
  • Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
  • Having good exposure in user management, Table space Management, Session Management, undo Management issues.
  • Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
  • Generated AWR, ADDM and ASH reports for database issues
  • Installed 12c agents on hosts and discovered targets.
  • Created new Groups, Templates, and Incident Rule sets in OEM 12C.
  • Designed and tested patching through OEM 12C.

Environment:: Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, OEM-12C, RMAN, RAC, ASM, Golden Gate, Grid, Dataguard, Net-Backup, Team quest tool.

Confidential,Glendale,CA

Oracle Database Administrator

Responsibilities:
  • Installation, Configuration and maintenance of Oracle 11g/10g database software on RHEL and Oracle Enterprise Linux (OEL).
  • Configured 3-node Real Application Cluster (RAC) and monitored RAC instances with Oracle Enterprise Manager Grid Control (OEM).
  • Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
  • Configuration of Oracle ASM on RHEL and HP-UX and managing disks and disk groups.
  • Done migration of non-ASM database to ASM databases.
  • Implemented ASM on RAC databases and standalone databases.
  • Involved in monitoring the database related activities using Oracle Enterpriser Manager 10g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM).
  • Performed oracle database refreshes using Expdp/Impdp from production to test database.
  • Performed backups of schemas and database using Data Pump (Expdp/Impdp) as per requirement.
  • Done with performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
  • Cloning of Databases using RMAN.
  • Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
  • Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
  • Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
  • Performed Range Partitioning as a cause to improve the performance of the database.
  • Daily incremental backup and weekly full backup of databases using RMAN.
  • Participated in regular on-call support for production databases.

Environment:: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager, Database Control, TOAD, OEM 12c, ASM, AIX, Goldengate.

Confidential

Jr. Oracle Database Administrator

Responsibilities:
  • Involved in Installation and customization of Databases (10g&9i).
  • Involved in Schema management, Table space Management, User Creation.
  • Monitoring the Extraction and loading processes of Data.
  • Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
  • Responsible for Oracle implemented backups like LOGICAL & PHYSICAL i.e. Export & import
  • Evaluated the hardware requirements before upgrading/migrating the database.
  • Good experience with recovery managed backups i.e. RMAN
  • Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
  • Documented the complete project including all pre-installation, post installation and database configuration steps.
  • Manage users, privileges, profiles, and schemas.
  • Experiences in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
  • Used analyze table, analyze indexes to tune queries and increase performance.
  • Tuning Oracle 9i database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Environment:: Toad, Oraclecle9i/10g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, Shell Scripting.

We'd love your feedback!