We provide IT Staff Augmentation Services!

Lead / Sr. Oracle Dba Resume

Seattle, WA

SUMMARY:

  • Ten (10)years of experience as an Oracle Database Administrator and AWS.Having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
  • Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12cwith experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Excellent experience in installation, setup and configuration of Oracle 10g, 11g,and12cin HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
  • Having hands on experience in management and database administration of Oracle applications on Exadata platforms.
  • Expertise in upgrading the databases from Oracle 9i to Oracle 10g, Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
  • AWS Cloud expertise in administration, migration and enterprise configuration.
  • Architect AWS instances to migrate on premise application to cloud.
  • Design architecture diagram for different application.
  • Working Experience with Oracle Data Guard
  • Working Experience with RAC and ASM
  • Created Read Replica Database for Production Database.
  • Experience in Database Migration from Linux to RDS Database
  • Experience with Database Migration from Non Cloud Servers to Cloud Servers
  • Working experience with Database Upgrades
  • Migrated On Premises Oracle Database to AWS RDS Database.
  • Experience with High Availability features (RAC and DataGuard).
  • Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
  • Good exposure to oracle technologies like AWR, ASM and data pump Export and Import.
  • Having knowledge on the ORACLE EXADATA for the extreme performance of the database.
  • Prepared Standard Operating Procedure Documents

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g, and 9i

Oracle Products: Golden gate, Oracle Exadata, Data Guard Broker, OEM, RMAN,ASM and RAC

Programming Languages: SQL, PL/SQL, JAVA, C, C++

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP, 2003, 2008, 2010 and 2012.

Other Tools: SQL Developer and pgAdmin

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead / Sr. Oracle DBA

Responsibilities:

  • Currently working on Database Migrations from Non Cloud servers to Cloud Servers
  • Configured Oracle Data Guard for Production Database
  • Implemented Oracle Golden Gate for Replication from Production to Test environment.
  • Created Materialized View to get data from one Production to another Production Database
  • Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
  • Configured GoldenGate Integrated components for Active-Passive
  • Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
  • Installed and configured GoldenGate Agent to work with OEM GoldenGate Plugin.
  • Configured Oracle Data Guard Broker for Production Database.
  • Scheduled background job through Control - M
  • Experience with Oracle to Oracle Migrations

Confidential, CO

Lead / Sr. Oracle DBA

Responsibilities:

  • Worked on 2 Node RAC for Production Database.
  • Applied Quarterly patches for Oracle Database
  • Worked on ASM file system
  • Good working experience with OEM 12c cloud control.
  • Applied Patches for every quarter
  • Working experience in Oracle Data Guard
  • Created and Configured Oracle GoldenGate from Production to Test environment
  • Experience with Change Management for all the database changes.
  • Worked on Migration from RHEL Server to Exadata Oracle Database
  • Worked on Export and Import for Schema Refresh
  • Worked on Oracle Exadata server for infrastructure and in other similar projects

Confidential, NJ

Lead / Sr. Oracle DBA

Responsibilities:

  • Worked on 2 Node RAC for Production Database.
  • Applied Quarterly patches for Oracle Database
  • Worked on ASM file system
  • Good working experience with OEM 12c cloud control.
  • Applied Patches for every quarter
  • Working experience in Oracle Data Guard
  • Created and Configured Oracle GoldenGate from Production to Test environment
  • Experience with Change Management for all the database changes.
  • Worked on Migration from RHEL Server to Exadata Oracle Database
  • Worked on Export and Import for Schema Refresh
  • Worked on Oracle Exadata server for infrastructure and in other similar projects
  • Used srvctl command to start and stop RAC Database

Confidential

Sr. Oracle DBA

Responsibilities:

  • Applied Patches for every quarter.
  • Experience in supporting Confidential implementation.
  • Experience in handling large database up to 14TB in size with 4 nodes cluster on various flavors of UNIX.
  • Resolved Replicate/extract/pump issues and upgraded classic EXTRACT to Integrated capture to overcome the compression table’s issue.
  • Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages
  • Experience in Managing Applications on oracle 11g / 10g RAC databases using ASM file system with server control utility (SRVCTL) and CRSCTL for high availability RAC.
  • REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
  • Hands on experience with 11g new features such as ADRCI, Duplicate from Active database, ASMCMD, Memory parameters, Incidents etc

Confidential

Sr. Oracle DBA

Responsibilities:

  • Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.
  • Worked as a part of team in Data Center Migration project for 6 months.
  • Daily database administration tasks including backup and recovery through RMAN, Import/Export
  • Performed data transfer using Export and Import
  • Applied patches for every quarter in Oracle database.
  • Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
  • Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
  • 24x7 remote support and on call Database support for Database developers & end-users.
  • Experienced in implementing Oracle Database advanced security practices.
  • Implemented Oracle DataGuard for PROD Environments.
  • Successfully configured and installed Oracle Golden Gate for replication.
  • Helped in developing applications based on Oracle Exadata platforms.
  • Maintained the Heart beat tables to check the lag between the sites.
  • Installation and configuration of OEM 12c on RHEL.
  • Worked with application team to resolve conflict handlers and trouble shooted the replication issues.
  • Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard
  • Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Responsible for administration and supporting Oracle10g database.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Successfully migrated databases from old server to Cloud Servers
  • Installation, Upgrade and Configuration of Oracle 10g Database.
  • Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
  • Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
  • Configuration, Administration and tuning of Oracle 10g and 9i RAC.
  • Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
  • Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
  • Data Refresh in Test and Integration Databases using Transportable Table spaces.
  • Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
  • Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10gRelease 2.
  • Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
  • Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
  • Provided database/application tuning including as reducing lock contention, analyzing objects.

Confidential

Oracle DBA

Responsibilities:

  • Created NEVER EXPIRY Profile for Application users.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Implementation of 10g DataGuard on IBM-AIX.
  • Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  • Created Users, Privileges, Roles in Oracle Database.
  • Used RMAN (Recovery Manager) utility to take backups.
  • Applying security patches both Server side and Client side and Performed testing.
  • Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.

Confidential

Oracle DBA

Responsibilities:

  • Created Users, Roles, and Profiles and provided privileges in Oracle Database.
  • Created Standard Procedure Documents
  • Modified scripts as per technical specifications.
  • Created Tablespaces and Adding Datafiles in Oracle Database.
  • Database Monitored through BMC Patrol
  • Analyzed the table structures using Analyze command.
  • Involvement in all phases of the project life cycle.
  • Designed Database tables as per technical specifications.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  • Implemented automated backup strategy using the UNIXshell script CRON UTILITY.

Environment: Oracle 9i,10g and 11gEXP, IMP, IBM-AIX, Windows XP/NT, PL/SQL, SQL, Supported Applications likeSIEBEL, OBIEE, Hyperion, WindChill, JD Edwards and ServiceNow.

Hire Now