We provide IT Staff Augmentation Services!

Lead / Sr. Oracle Dba Resume

TN

PROFESSIONAL SUMMARY:

  • Ten (10) years of experience as an Oracle Database Administrator, Exadata DMA 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 12c with 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 and 12c in Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
  • Having hands on experience in management and database administration of Oracle applications on Exadata Quarter RACK and Half RACK 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.
  • Working Experience on ORACLE EXADATA for the extreme performance of the database.
  • Prepared Standard Operating Procedure Documents

TECHNICAL SKILLS:

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

Oracle Products: Golden gate, Oracle Exadata DMA, 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: RDBMS, SQL Developer Putty and pgAdmin

PROFESSIONAL EXPERIENCE:

Confidential, TN

Lead / Sr. Oracle DBA

Responsibilities:

  • Responsible for providing 24X7 production support for critical Payments, Financial, and connectivity applications’ Oracle 11g and 12c databases on Solaris and RHEL.
  • Worked on Database Migrations from On Premises to AWS RDS Database
  • Worked on Quarter Rack and Half Rack Exadata on X5 and X6 machines.
  • Worked on Database Migrations from one datacenter to another datacenter
  • Piloted the Planning and Migration of Oracle databases from In-premises Datacenters to AWS Cloud including homogeneous and heterogeneous migrations
  • Experience in Database Migration from on Primacies to AWS RDS Database using Export and Import
  • Experience with Amazon Web Services ( AWS) RDS object storage, monitoring and notification services (SNS and Cloud watch).
  • Worked on AWS RDS to Oracle Migrations
  • Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard
  • Involved in Installation and configuration of Oracle 10g &11g RAC using Cluster ware and ASM.

Confidential, WA

Lead / Sr. Oracle DBA

Responsibilities:

  • 24x7 Production Database administration and applications support
  • Supporting multiple databases for Production, Development, Test and Staging purposes
  • Applying upgrade patch, maintenance (opatch) Patches on all the Exadata databases.
  • Refreshing Dev and test instances with data from Production on a regular basis.
  • Installation of Oracle 11g/10g RAC and Standby Database for High Availability and Disaster Recovery purpose.
  • Provided performance tuning of Oracle Databases on Exadata.
  • RMAN point in time recovery and Instance recovery done.
  • Worked on the migration of Oracle databases to Oracle databases.
  • Upgrade and Migration of Database from 10g to 11g and 11g to 12c applying patches whenever required.
  • Monitoring and optimizing the performance of the Database
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Creating OEM alerts that provides notifications.
  • Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Confidential, CO

Lead / Sr. Oracle DBA

Responsibilities:

  • Worked on 2 Node RAC for Production Database.
  • Applied Quarterly patches for Oracle Database
  • Worked on Half RACK Oracle Exadata DMA
  • Database Monitored through OEM 12c Cloud control.
  • Applied Patches for every quarter
  • Working experience in Oracle Data Guard
  • Created and Configured Oracle GoldenGate
  • 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 DMA server for infrastructure and in other similar projects

Confidential, NJ

Lead / Sr. Oracle DBA

Responsibilities:

  • Installed Oracle database and Oracle Grid Infrastructure software on IBM PowerHA /HACMP clusters
  • Worked on Exports and Imports for Refresh task.
  • Worked on Documentation and Build Plan for Database Upgrades and Patches
  • Good working experience with OEM 12c cloud control.
  • Applied Patches for every quarter
  • Working experience in Oracle Data Guard
  • Implemented Oracle GoldenGate from Production to Test environment
  • Created custom KEYS on IAM for AWS
  • Created Oracle Database on AWS RDS Service, created Tablespaces and Users
  • Worked on Database migration from On-Primises to AWS RDS Oracle Database
  • 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.
  • Database Monitored through Oracle Enterprise Manager (OEM)
  • Experience in supporting Oracle Corporation implementation.
  • Conducted Meetings for all level of Escalations
  • Prepared Build Plan for Database Migrations Activity
  • Experience in handling large database up to 2 TB 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:

  • As a Oracle DBA, Installation, configuration, maintenance and tuning of Oracle 11g and 10g.
  • Worked as a part of team in Data Center Migration project for 6 months.
  • Daily database administration tasks including backup and recovery through RMAN
  • Performed data transfer using Export and Import
  • Created Build Plan for Quarterly Patches and Database Upgrades
  • Created NEVER expiry profiles for all system USERS
  • Worked on Database Health Check for every Quarter
  • Created Database Links from DEV Database to TEST Database
  • Applied patches for every quarter in Oracle database.
  • Worked on Exports and Imports for Schema Refresh task
  • 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 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

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.
  • 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, 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,PeopleSoft, ODA, JD Edwards and ServiceNow.

Hire Now