SUMMARY

• Over 9 years of experience as Oracle Database Administrator, providing 24/7 support of both production and development environments, which includes Database creation, installation, configuration, administration, upgrades, patching, performance tuning, backup and recovery, space management, security, cloning, migration and troubleshooting on both Unix (Sun Solaris, IBM AIX, HP - UX & Red Hat Linux) and Windows environments on multiple versions of Oracle (Oracle 9i/10g/11g and 12c ).
• Experience in installation and configuration to support data replication in Oracle Database environment.
• Working as a Oracle DBA Architect. Implementation started from scratch level.
• Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms.
• Monitored and Detected Alert Log Files, Listener Log, Redo Log status, trace files for the database.
• Recovered Oracle Database using RMAN.
• Installed Oracle GoldenGate 11g and 12c on Production Server.
• Cloned Database from Production to Test and Development and from Development to Production.
• Experience in Upgrade and Migration of oracle database to higher version.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with.
• Implemented 3 node RAC and RHEL Servers.
• Created Users and Tablespace with same names as per client requirement.
• Applied PSU Patches for every quarter
• Designed and implemented Backup and Recovery strategies using conventional and RMAN utilities.
• Hands on experience of database backups and recovery methods like Export/Import,
• Worked on Export and Imports by using Legacy and Datapump also
• Installed 12c Container Database(CDB) and Pluggable Database(PDB) on RHEL Server.
• Configured 11.2.0.3, 11.2.0.4 and 12.1.0.1 Oracle Data Guard on RHEL
• Installed Oracle Golden gate
• Co-ordination with Oracle Support.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles.
• Created Tablespaces for Schema's.
• Experience in Transparent Tablespace
• Co-ordination with Oracle Corporation for technical support, new products and releases, technical discussion/support.

PROFESSIONAL EXPERIENCE

Confidential - NJ

Sr. Oracle DBA

Responsibilities:

• Created Oracle Database 10g, 11g and 12c on AIX and Linux Servers.
• Database Migrations from Non Cloud to Cloud Servers
• Applied PSU Patches for every quarter
• Database upgrades from 11g to 12c.
• Implemented 3 node RAC on RHEL Server and worked on srvctl and crvctl commands
• Worked on EXPDP and IMPDP for Refresh activity.
• Installed &configured 12.1.0.1 on Linux.
• Taking backup of databases using RMAN
• Responsible for applying PSU patches on most of the production databases
• Installed Oracle GoldenGate (OGG) 11g on Production and QA Servers.
• Configured Oracle Active Data Guard on Linux Server.
• Installed Oracle Enterprise Manager on various production environments

Environment: RMAN, AIX, RAC, OEM 12CSQL, PL/SQL, Toad, AWR, OEM 12CEXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 11g, Oracle 12c, RHEL, HP-Unix and PeopleSoft.

Confidential

Sr. Oracle DBA & SME

Responsibilities:

• Experienced in working and monitoring the databases by using Oracle Enterprise Manager.
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Worked and Export and Imports for refresh activity.
• Provided Daily Health Check Reports for Telecom and Solutions.
• Installed 12c Container Database(CDB) and Pluggable Database(PDB) on RHEL Server
• Migration of Database from Non-Cloud Server to Cloud Servers.
• Monitoring Oracle Database by using OEM 12C, OEM 13C.
• Recovered Oracle Database using RMAN.
• Crated Profiles for Non Human users.
• Worked on scvctl and crsctl for RAC and Implemented 3 Node RAC on RHEL server.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different tablespaces.
• Worked on Database Encryption.
• Worked on PUS Patches for every quarter.
• Installed Oracle Golden gate on DEV, QA and Prod Environments

Environment: RMAN, AIX, RAC, OEM 12C, SQL, PL/SQL, Toad, OEM 12CEXPDP, IMPDP, EXP, IMP, AWR, Unix Shell scripting, Oracle 10g, Oracle 11g, Oracle 12c, RHEL, HP-Unix, OBIEE, Hyperion and PeopleSoft.

Confidential

Oracle DBA & SME

Responsibilities:

• Installed 10g, 11g Oracle database on Linux and AIX.
• Installed Oracle Golden gate for replication
• Configure Oracle Data Guard (Active Data guard ) on Linux Servers.
• Good experience on Export and Import by using expdp and impdp
• Applied PSU Patches for every quarter
• Installed Oracle GoldenGate (OGG) 12c on Bi-directional purpose.
• Migrated Oracle Database from Non Cloud Servers to Cloud Servers
• Provided database related services to their development and QA environments.
• Provided Daily Health Check Reports for Telecom and Solutions.
• Recovered Oracle Datafiles using RMAN.
• Implemented 3 node 11.2.0.4 RAC on RHEL
• Logical and Physical backup procedures.
• Data exports from production and staging databases.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Run oracle AWR to tune the databases.

Environment: RMAN, AIX, RAC, OEM 12CSQL, PL/SQL, Toad, OEM 12CAWR, EXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 11g, Oracle 12c, RHEL, HP-Unix, Siebel, OBIEE and Hyperion

Confidential

Oracle DBA & SME

Responsibilities:

• Analyzed business requirements and built logical data models that describe all the data and relationships between the data. Designed and implemented physical database
• Installation and configuration of Oracle 10g database server and their version upgrades.
• Installation of Oracle Applications on HP-UX (Single User & Rapid Installation).
• Responsible for performance tuning. Extensively worked SQL tuning, database tuning and operation systems tuning.
• Worked and guided the team for analysis, design and testing phases of the project.
• Created USERS and Tablespaces, Worked on creating profiles to non Human Users
• Installed Patches for every quarter.
• Actively involved in code reviews and guiding the developers for quality and timely deliverables.
• Worked in the knowledge transition to the other team members on the common architecture of ETL.
• Used several utilities and tools to perform performance tuning & monitoring
• Applied patches, successfully upgraded Oracle. Worked on Storage, Network configurations.
• Developed PL/SQL procedures, assisted /supported dev team with database related issues.
• Designed and implemented Oracle Database, Back up & Recovery.

Environment: RMAN, AIX, RAC, OEM 12CAWR, SQL, PL/SQL, Toad, OEM 12CEXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 11g, Oracle 12c, RHEL, HP-Unix, Siebel, OBIEE, Hyperion and Financial.

Confidential

Oracle DBA

Responsibilities:

• Installation, Upgradation and Maintenances of Oracle Server on Linux.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN
• Provided System support for both development and 24/7 production environment.
• Provided Daily Health Check Reports for JD Edwards
• Backups and Recovered Oracle Database using RMAN.
• Assisted in configuring optimal Oracle 10gR2 RAC architecture.
• Worked on Migrations from 10g to 11g.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Applying patches and Migrations works and work closely with Oracle to keep application environment up to date.

Environment: RMAN, AIX, RAC, OEM 12CSQL, PL/SQL, Toad, OEM 12CEXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 9i, Oracle 10g, Oracle 11g, AWR, Oracle 12c, RHEL, Wind-chill, Web logic, HP-Unix, Hyperion and JD Edwards.

Confidential

Oracle DBA

Responsibilities:

• Analyzed business requirements and built logical data models that describe all the data and relationships between the data. Designed and implemented physical database
• Installed 11g Oracle database on Linux and AIX.
• Configure Oracle Active Dataguard on RHEL Server.
• Worked on Refresh Activity for Export and Import using Traditional and Datapump too.
• Provided database related services to their development and QA environments.
• Provided Daily Health Check Reports for OEIEE, Hyperion, Finance.
• Created and Configured Databases on Development, Test and Production Environments.
• Applied PSU Patches in all environments.
• Worked on Exports and Imports for different schemas. Designed and implemented Oracle Database, Back up & Recovery.

Environment: RMAN, AIX, RAC, OEM 12CSQL, PL/SQL, AWR, Toad, OEM 12CEXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, RHEL, HP-Unix, Siebel, Wind-chill, Web logic, OBIEE and Hyperion

Confidential

Oracle DBA

Responsibilities:

• The work involves overall maintenance of ORACLE database, performance issues, tuning, backup, and other database related activities.
• Worked on Exports and Imports for schema refresh.
• Implemented Oracle Replication to enable database fail over incase of system or database crash.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc which are kept in CRONJOB
• Also worked for network management.
• Day to day performance monitoring and tuning of database.
• Installed and Configured Oracle Data guard for Oracle 10g for the maintenance of Stand by database.
• Created Tablespace, Alter tablespace, Datafiles adding, resizing.
• Worked with users to determine system requirements.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: RMAN, AIX, RAC, OEM 12CSQL, PL/SQL, Toad, AWR EXPDP, IMPDP, EXP, IMP, Unix Shell scripting, Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, RHEL, HP-Unix and Siebel.