We provide IT Staff Augmentation Services!

Sr Oracle Dba Resume

2.00/5 (Submit Your Rating)

San Francisco, CA

SUMMARY:

  • Having 8+ years of experience as an Oracle Database Administrator providing 24x7production and Development databases (Oracle Database Appliance,12c/11g/10g/9i) support and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Golden Gate, Exadata Administration, production support, RMAN, ASM, Data Guard, space management, database security.
  • Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g, 12c on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
  • Installation and maintaining Real Application Clusters (Oracle RAC 11g, 10g)
  • Proficient with Oracle Standby Database (Data Guard) setup, Data Guard Broker, Active - Data Guard, Replication, Upgrade, Refresh, Cloning, DG - Fail Over and Switch over’s
  • Worked on Oracle Golden Gate12c replication setup
  • Installation and configuration of Oracle Enterprise Manager 12c
  • Experience in upgrading the database from Oracle 9i to Oracle 10g & oracle 10g to oracle 11g and migration of the databases using transportable database, tablespaces export/import, data pump utilities.
  • Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).
  • Experience in Migration Projects. Hands on experience in-updating from Oracle 9i to 10g (10.2.0), 10g to 11g to 12c and applied oracle patches.
  • Experience in Data Warehouse environment.
  • Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
  • Migrated databases using Golden Gate, Transportable tablespace and Datapump from 9i, 10g to 11g.
  • Expertise in maintenance, upgrades, administration, backup and recovery of Oracle Exadata systems.
  • Extensive experience in using Korn Shell scripts for Regular backup, instance start and shutdown and for automation
  • Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
  • Installed, administered, and monitored the GoldenGate on Oracle, Exadata, and Cloud environment replication
  • Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
  • Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
  • Co-ordinate with UNIX administrators for space managements on various servers.
  • Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager.
  • Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
  • Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
  • Monitoring and management of various database components (logical & physical) like table- spaces, segments and data files.
  • Experience on Data Replication using Snapshot, Materialized views, import/export.
  • Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
  • Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
  • Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
  • Experienced in database security and authentication day to day activities.
  • Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
  • Have implemented ORACLE STREAMS.
  • Setup, Configured and Maintained Oracle Data Guardto control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
  • Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
  • Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS.
  • Demonstrated ability to identify root causes of problems, consider both long and short-term impact of proposed solutions and develop workable solution. Ability to manage multiple project tasks with changing priorities and tight deadlines.
  • A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

SKILL:

HP: UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x, VMware and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 12c/11g/10g/9i/10gRAC.

Languages: SQL, PL/SQL, C, C++, C#, VB.NET, JAVA, XML, UNIX Shell Scripting.

Tools: RMAN, OEM, CRS, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, Oracle Golden Gate, Exadata, TOAD, Data pump, MS Access, Data Mapping, Data Guard, Golden Gate 10.4

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

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

EXPERIENCE:

Confidential, San Francisco, CA

Sr Oracle DBA

Responsibilities:

  • Experienced in migrating 11gR2 databases from Solaris to UNIX exadata machine using cross platform migration best practices.
  • Extensive experience in conducting RAC HA Failover testing for newly created RAC databases on exadata machine.
  • Simulated various failover scenarios including stopping database service, killing PMON & LGWR process, stopping instances with normal, immediate and abort failover etc.
  • Scheduling meetings & Driving call to conduct Batch & Web services Select and DML operations failover operations.
  • Aggressively involved in pre-migration activities including replacing CDC with triggers and performance testing for scrubbed databases.
  • Experienced in Performance testing efforts to make sure newly created databases on exadata platform are meeting business SLA's.
  • AWR vs. ASH report analysis with ongoing research as part of performance testing for exadata vs. legacy machines in order to support business applications.
  • Hands on experience in identifying static large tables from database to exclude them from Golden gate replication from source to target to speed up migration activities.
  • Participating actively in ongoing research for Mongo, Hadoop and Cassandra databases to forecast business requirement.
  • Hands on experience in administrating Oracle 12c databases on Exadata platform including scheduling backup jobs using OEM 12c.
  • Worked with developers to provide performance tuning support with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, ASH, ADDM, SQL TRACE.
  • Experienced in implementing backup and recovery strategies for production & Dev environment.
  • Golden gate replication setup and administration for existing and newly created relplicat and extract processes.
  • Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
  • Experienced in RAC Load Balancing across batch and services long running jobs in RAC environment.

Environment: Oracle 12c/11gR2/10g, Cassandra, Hadoop, Mongo DB, Red Hat Linux, Oracle Golden Gate, TOAD, RMAN, Exadata, SQL server, OEM12C, Grid Control, Data Guard, SVN, GitHub, STATSPACK, AWR, ASH, TKPROF, Explain Plan.

Confidential, Boston, MA

Sr Oracle DBA

Responsibilities:

  • 24x7 production support for several mission critical systems which utilize multiple Oracle databases on Exadata platform.
  • Installed and configured Oracle 11g & 12c databases on a variety of operating systems including UNIX/LINUX and Solaris environment.
  • Worked on 11gR2 RAC, Exadata and 12c databases for Administering, testing, and implementing databases in test, development, production-like, production and standby databases environments.
  • Worked on database software installs, upgrades, and patches.
  • Performed oracle database upgrade from Oracle11g to 12c.
  • Validating the RMAN backup’s for restore and cloning the database using RMAN for building and refreshing the Standby databases.
  • Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
  • Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
  • Experienced in Golden Gate replication and extract setup for database migration using Unidirectional and Bidirectional methods.
  • Worked on databases consolidation into a single database in Exadata.
  • Worked on moving Oracle 10g database of a Specialty company which Cardinal bought into Oracle 11g Exadata.
  • Hands on experience in troubleshooting Golden Gate replication setups in ABEND status and provided possible resolutions to start replication setups.
  • Performance tuning activities like Operating System Tuning, SQL Tuning, Database/Instance Tuning
  • Implemented Oracle 12c advanced security features for an organization including Transparent Data Encryption, Oracle Data Redaction, and Virtual Private Database etc.
  • Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
  • Experienced in administrating oracle databases, Golden Gate setups on Exadata X5 environments.
  • Extensive experience in migration schema from one database to other along with Golden Gate replication setup associated with schema objects and ensure replication setups up & running after migration..
  • Deployment support activities for application team, Solution Architects, Unix and Storage team to accomplish successful deployment.
  • Extensive experienced in table partitioning including Table rebuilding from one partition type to other.
  • Hands on experience using Oracle Enterprise Manager 12C (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
  • Migrated databases using Golden Gate , Transportable tablespace and Datapump from 10g to 11g.

Environment: Oracle 12c/11gR2/10g/9i, Sun Solaris, Unix, Ignite, Windows NT / 2000, Red Hat Linux, Oracle E-business suite, Oracle Golden Gate, TOAD, RMAN, Exadata, SQL server, OEM12C, Grid Control, Data Guard, STATSPACK, ETL, AWR, Explain Plan.

Confidential, NY

Sr Oracle DBA

Responsibilities:

  • Installation, configuration and administration of Oracle databases using Oracle software, tools & utilities. Installation of oracle software and created database using DBCA and manually.
  • Expert in san storage migration from old storage array to new Confidential storage array with online ASM rebalancing operation.
  • Communication with application team owner, Solution Architects, Unix and Storage team to accomplish successful san storage migration using online ASM method.
  • Hands on experience in building and managing ASM storage for existing and new database environment.
  • Creating and maintaining database environments as per the requirement for development, testing and production usage.
  • Experienced in generating AWR reports for multiple database environments manually and using scripts for various time intervals.
  • Performed Explain Plan analysis for Query Optimization and SQL tuning.
  • Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.
  • Performed Golden Gate replication setup activities for Oracle-Oracle, Oracle-Sybase, Sybase- Oracle, Sybase - Sql server databases.
  • Monitored the Golden Gate processes, checking the performance using the Golden Gate Director.
  • Restored database on different server with same or different file system using RMAN technology.
  • Extensive Performance Tuning, Memory (SGA) Tuning, net backup, Confidential (Time finder and SRDF), RAID, RAW Devices.
  • Installation, Implementation and Maintenance of the Oracle database.
  • Created and managed the database objects such as tables, indexes and views
  • Performed oracle software cloning using dB clone utility to fulfill business need to keep same software version.
  • Created and managing the database storage structures which includes data table spaces, index table spaces, rollback table spaces and rollback segments
  • Loading the database with SQL*Loader
  • To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
  • Performing the logical and physical structure of tables, indexes, modeling normalization and foreign key constraints.
  • Hot/Cold Backup and Recovery and Cloning of databases using RMAN utility.
  • Database maintaining including backups, recovery, imports/exports.
  • Expert in scheduling and maintaining various jobs in OEM 12C.

Environment: Oracle 11gR2/10g/9i, Sun Solaris, Unix, Ignite, Windows NT / 2000, Red Hat Linux, Oracle E-business suite, TOAD, RMAN, Exadata, SQL server, OEM12C, Grid Control, Data Guard, STATSPACK, AWR, Explain Plan

Confidential, Corning, NY

Oracle DBA

Responsibilities:

  • Performed day to day DBA activities on Oracle 9i, 10g, 11g database.
  • Experienced in Data mapping to achieve business requirement from target to source location.
  • Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
  • Provided estimation for new environment database storage with UNIX administrators for space managements on various servers.
  • Implemented Data guard, Golden Gate, Streams for faster Disaster Recovery.
  • Performed backup and recovery of GoldenGate replication and administrated GoldenGate replication security
  • Worked on setting up Data Guard on RAC in Oracle 11g & Exadata.
  • Managed patching and upgrade of Exadata Storage Server’s.
  • Experienced in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
  • Database maintaining including backups, recovery, imports/exports and Exadata.
  • Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
  • Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
  • Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
  • Monitored and managed various database components (logical & physical) like table- spaces, segments and data files.
  • Experienced on Data Replication using Snapshot, Materialized views, import/export.

Environment: Oracle 11g/10g/9i, Sun Solaris, VMware, Windows NT / 2000, Red Hat Linux, Oracle E-business suite, TOAD, RMAN, SQL server, Exadata, OEM, Grid Control, Data Guard, STATSPACK, AWR, Explain Plan.

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

  • 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
  • Performed day to day DBA activities on Oracle 9i, 10g, 11g database
  • Performed migration from 9i to 10g from AIX to Linux.
  • Coordinate with UNIX administrators for space management on various servers.
  • Installed Oracle 9i and 10g, 11g RAC database on Red Hat Linux.
  • Installed RAC on Oracle 10g and worked on ASMfeature of Oracle
  • Installation of ASM into various storage parameters like SAN and NAS.
  • Installation, Configuration and Maintenance of Oracle RDBMS Software.
  • Upgrading databases to Oracle 11g from Oracle 10g.
  • Creating and maintaining the Oracle databases.
  • Created and managing the database objects such as tables, indexes and views.
  • Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
  • Unix Shell scripting in (cshell)csh, (korn shell)ksh for automating startup/shutdown of databases, getting system alerts.
  • Applying patches both Server side and Client side.
  • Setting up new environments (Development, Production etc.).
  • Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration
  • Worked in data ware house environment.
  • Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
  • Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
  • Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
  • Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
  • Worked on import/export and SQL- loader.
  • Setup backup and recovery procedures using RMAN.
  • Involved in I/O tuning by moving data files and redo log files to faster disks.
  • Used analyze table, analyze indexes to tune queries and increase performance.
  • Used hints for SQL tuning and optimization.
  • Created the conceptual model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
  • Expanded Physical Data Model (PDM) for the OLTP application using Erwin

Environment: Oracle 11g/10g/9i, Sun Solaris, Windows NT / 2000, Red Hat Linux, Oracle E-business suite, TOAD, RMAN, SQL server, OEM, Grid Control, Data Guard, STATSPACK, AWR, Explain Plan.

We'd love your feedback!