We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Monterey, CA

PROFESSIONAL SUMMARY:

  • Overall 7+years of experience in the Information Technology field as Oracle Database Administrator having hands on experience in database administration, development, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security on various environment like HP - UX, AIX, LINUX and Windows.
  • Extensive knowledge on database administration for Oracle 12c/ 11g RAC/10g RAC/9i/8i.
  • Good experience in installing and upgrading Oracle ebusiness suite.
  • Experience in Configuring Single Instance, Oracle Real Application Clusters(RAC) and Automatic Storage Management(ASM).
  • Expert in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring, cloning, upgrading and migration of oracle software and tools.
  • Solid experience on Upgrading Oracle databases for Oracle 11g,10g, 9i.
  • Solid experience in Oracle Recovery Manager (RMAN), and standby database using Data Guard.
  • Expertise in the database infrastructure design which also include Real Applications Clusters (RAC), Standby Databases (Data Guard).
  • Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
  • Data transferring with export/import utilities and Data Pump and SQL* Loader.
  • Good experience in SQL, PL/SQL Programming (Functions, procedures, packages and triggers).
  • Developed SQL, UNIX and LINUX shell scripts to automate DBA functions. Diagnosed problems and implement corrective actions.
  • Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL*Net.
  • Experience working with Oracle Data Integrator (ODI).
  • Maintained large production as well as development/test/stage databases which involve Data warehousing and OLTP applications.
  • Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.
  • Proficient with OEM, Erwin, SQL Developer, RMAN and Toad.
  • Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export, Auditing, RMAN
  • Experience in implementing Oracle Streams and in installation and administration of Golden Gate using bi-directional Replication from Enterprise Dataware house to downstream at client database locations.
  • Experience in Capacity Planning and Bench Marking.
  • Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
  • Experience in working with Big Data Appliance with Oracle Exa-data Machines.
  • Capable of working under pressure and stiff deadlines with 24/7 Database support.
  • Experience in analyzing, translating business requirements to technical requirements and architecture.
  • Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, STATS PACK, SQL TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g R2 RAC, 10gR2 RAC, 9i, 8i, 7.x, Server 2012/2008/2005, IBM DB2.

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows.

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

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD.

Tuning Tools: TKPROF, EXPLAIN PLAN, S TATSPACK, AWR, OEM Grid Control, EXADATA.

PROFESSIONAL EXPERIENCE:

Confidential - Monterey, CA

Sr. Oracle DBA

Responsibilities:

  • Involved in 24x7 Oracle Production Database Administration.
  • Installation, configuration, Maintenance and Support of Oracle 11g and 12c Databases as a part new Project implementation.
  • Planning, implementing and validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 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.
  • Installation of 11.2.0.3 RAC(4 node) from the Scratch and the maintenance of the high available Databases.
  • Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM’s native rebalancing feature.
  • Installing and configuring Grid Infrastructure & Database software. (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of Clusterware).
  • Created check point table, did Data load using Expdp and Impdp for replication in Golden gate.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Performing Backup/Restore of all the Oracle databases using RMAN .
  • Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
  • Implementing Physical and Logical Standby setups Data guard Configurations.
  • Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
  • Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
  • Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
  • Involved in Production Support for Critical Application Databases when needed.
  • Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
  • Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX).
  • Design and implement disaster recovery procedures according to standards. Work closely with the application developers and Operations to ensure reliable database usage. Implement and maintain Replication Services.
  • Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
  • Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
  • Managing the cluster resources and performing health check of all instances within the cluster.
  • Installed and Configured Golden Gate for replication of production databases to Reporting Databases and troubleshooted Golden Gate issues.
  • Replication and Extracting data and applying on production using Golden Gate.
  • Managing Capture, data pumps, replicate processes for data replication in Golden gate.

Confidential, Wayne, MI

Sr. Oracle DBA

Responsibilities:

  • 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,11.2) & 11gR2 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.
  • Implementing Physical Standby Active Data Guard in both 10g & 11g environments
  • Involved in installation, configuration and support of Oracle 11g RAC.
  • Worked on using the Materialized views for large Data Replication between 2 production databases.
  • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
  • Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.
  • 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.
  • Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
  • Recovering Databases when there is any Physical or Logical Corruption.
  • Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
  • Implemented Transparent Data Encryption (TDE) for compliance related databases.
  • Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
  • Responsible for purging and archiving the production databases.
  • Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
  • Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
  • High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
  • Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab (UNIX), Scheduled Tasks (Windows) and Maestro 7.0 (Job Scheduling Tool).
  • Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
  • Used DBMS * packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
  • Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
  • Assisted developers with the Tuning during the development and tuned the applications.
  • Environment: Oracle 9i,10.2.0.4,11.1.0.6, IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX, IBM AIX,WebSphere,Solaris5.9,TOAD,SQL Developer.

Confidential, CA

Sr. Oracle DBA/Developer

Responsibilities:

  • 24x7 on-call production database and applications support.
  • Implemented Oracle Data pump and stream instantiation, created single and multiple source environments, managed LCR s in Oracle Streams.
  • Installed and configured Oracle Enterprise Manager Grid control 12c on Windows server 2008.
  • Providing full life cycle on DBA/on call support for Production Databases, administering, UAT, Development and QA databases.
  • Translating technical and Business requirements into efficient Logical and Physical data models.
  • Installed & configured Web logic server on UNIX platform and deployed applications.
  • Contention and providing centralized management for Disks.
  • Supported installation and setup of ORACLE Cluster’s and RAC database.
  • Monitoring and Administrating ORACLE RAC databases on ORACLE 11g Clusters.
  • Good experience with multi master replication setup & Administer with Golden Gate tool.
  • Setup reporting server using ORACLE Streams from various data sources.
  • Performed database Migration from Windows platform to Linux using RMAN (Convert) and Data pump.
  • Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
  • Worked on Features: ASM and RMAN. Data Base Recovery (complete & Incomplete).
  • Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
  • Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
  • Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export, Auditing, RMAN.
  • Experience with BMC Remedy tool for all change management process.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Enhancing performance using various components like SQL TUNING ADVISOR, ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
  • Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
  • Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
  • Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
  • Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
  • Performed Table, Index Partitions for increased performance and for better storage management.
  • Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
  • Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
  • Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
  • Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
  • Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netback up.
  • Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
  • Performed Export and Import utilities in SQL SERVER databases.

Environment: Oracle 11g RAC, 10g, SQL Server, Red Hat Linux, IBM AIX, Data Guard, ASM, PL/SQL, RMAN, GoldenGate.

Confidential, Franklin, TN

Oracle Database Administrator

Responsibilities:

  • Actively participated in the installation of 10 g RAC on LINUX environment.
  • Installed 10g RAC (2 Node) on RHEL 4 Server and converted/added a node to 3 Node RAC for production databases
  • Administering Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
  • Provide admin support to APEX applications.
  • Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
  • Using the tools such as TKPROF, EXPLAIN PLAN and TRACE FILE to tune SQL Queries.
  • Performed database Cloning to setup test and development database.
  • Conducting sizing & capacity planning for Oracle databases.
  • Manage Oracle RAC database configurations utilizing GoldenGate and Data Guard to ensure maximum availability and data protection.
  • Maintaining schemas and partitioning tables.
  • Implemented the Security using ORACLE Database Vault.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
  • Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Creating tablespaces, tables, and users for custom applications.
  • Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Experienced with Dataguard Implementation.
  • Implemented oracle high availability solution using oracle 10g Physical Standby.
  • Importing data from flat files into database using SQL loader and External Tables.

Environment: HP-UX, IBM-AIX 6.1, Oracle 9i, 10g, 11g, Oracle Enterprise Manager (OEM) Grid Control, Oracle Spatial, RAC, Database Vault, Label Security, Datapump Exp/Imp, RMAN, TOAD, SQL Developer, SQL*Loader, ASM.

Confidential

Oracle DBA

Responsibilities:

  • Part of a 5 member DBA team which was involved in the maintenance of the Oracle 9i/8i databases for the Production as well as the development environments.
  • 24x7 Production database and applications support.
  • Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
  • Configuring RMAN backup to various databases.
  • Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
  • Experience working with Oracle Data Integrator (ODI).
  • Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
  • Review alert logs and dump files to check for any problems related to the database.
  • Database cloning to setup identical databases in the production and development environments.
  • Create and maintain users, roles and privileges & Auditing Triggers.
  • Upgrade/Migrated the production and development databases from 8i to 9i.
  • Oracle 9i Streams Replication setup and Configuration.
  • Setup and configured 2 node Oracle 10g RAC with ASM.
  • Back end Programming/scripting using SQL and PL / SQL.
  • Created table partition and index partition.
  • Troubleshooting for Production database issues/Performance issues.

Environment: Oracle 10g RAC9i/8i, HP-UNIX, Linux SUSE, SQL, Oracle Replication, Explain Plan, Toad

Confidential

Oracle DBA

Responsibilities:

  • Involved in 24x7 Oracle Production Database Administration.
  • Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and roles administration, schema management.
  • Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
  • Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.
  • Installed and configured Oracle 10g.
  • Migrated Oracle 9i database to Oracle 10g.
  • Storage and space management including table spaces and data files.
  • Monitoring Database for fragmentation and correcting them.
  • Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.
  • Monitoring and Management of table space growth, extent growth.
  • Planning and implementation of Backup and recovery procedures and Maintenance of Database.
  • Performed Backup/Recovery using RMAN.
  • Wrote scripts for Startup, Shutdown and automation of backups.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Prepare the documents of the process and knowledge transferring about the project to the new team members.
  • Involved in the process of tuning and refining queries of various applications.
  • Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.

Environment: Oracle 10g RAC9i, SQL, Explain Plan

Hire Now