PROFESSIONAL SUMMARY:

• 6 years of Oracle DBA experience with Oracle 12c, 11g, 10g on UNIX, Sun Solaris, AIX and Windows.
• Experienced in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using export/import, Expert in disaster recovery.
• In - depth knowledge of setting up RMAN backups using control file and Recovery Catalog, and maintaining catalog schema. Proficient in creating auxiliary and duplicate databases using RMAN.
• Extensive knowledge in implementing PL/SQL features like nested tables and collections for high performance of stored procedures.
• Hands on experience in Oracle WebLogic server 11g (10.3.6), 12c (12.1.3) installation, maintenance, patching and troubleshooting.
• Strong knowledge in Migrating Oracle 11g to 12c.
• Proficient in Installation, Troubleshooting, Maintenance and Technical Support for Oracle (12c, 11g and 10g) Databases, Oracle Enterprise Manager Grid Control.
• Installation and configuration of Oracle WebLogic Server 12c/11g
• Installation, configuration and administration of Fusion Middleware
• Deploying various J2EE and enterprise applications on managed servers.
• Experience in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD
• Highly skilled in Oracle DBA - Installation, Administration, Creating Backup & Implementing Recovery Strategy, Performance Monitoring/Tuning and Database Security for Databases having more than 300+ users.
• Maintenance and development of database objects like Queues, Tables, Indexes, Stored Procedure, Constraints, Triggers, Table & Index Partitioning, DB Links, Users, Roles, Profile and SQL NET and Listener.
• Strong attention to details, technical and analytical skills with excellent interpersonal and communications abilities.

TECHNICAL SKILLS:

Operating Systems: AIX, Windows

RDBMS: Oracle 12c, 11/10g, 9i, SQL Server

High Availability: RAC, ASM

Languages: SQL, PL/SQL, UNIX Shell scripting, T-SQL

Tools: RMAN, OEM, ERWIN, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, performance analyzer

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential

Responsibilities:

• Performing database upgrades from Oracle 11.2.0.1 to 11.2.0.4 to 12.1.0.1 to 12.1.0.2.
• Responsible for backup and recovery using RMAN, Flashback Technology and user managed backups.
• Performing regular health checkup of production and test databases and performance of Oracle application system.
• Carry out Database or Schema level refreshes using the traditional export/import and Data pump or backup utilities.
• Managing and performing Tablespace Management, Undo Management, Redo log management, Control file management, online Redo log management and user privilege management.
• Administer and manage the Oracle Instance using custom scripts and 10g Oracle Enterprise Manager (OEM) database control and Grid Control.
• Performs Database tuning such as memory tuning, Application tuning using tools like tkprof, explain plan, hints, ADDM and AWR Reports.
• Performs database physical and logical design and procedures for Production, Development, Q&A, Test and Training servers.
• Proactively tuning databases using SQL scripts, ADDM and AWR reports.
• Assist with Installation, maintenance and tuning of Oracle 11g RAC databases including ASM.
• Responsible for installation and configuration of Oracle Fusion Middleware applications including, but not limited to Oracle WebLogic Server (11g/12c), Oracle Business Intelligence (12c), Oracle HTTP Server.
• Work with Oracle support for resolution of critical issues and report progress and project activities to team members/Project Manager on a continuing basis.
• Support Data Guard databases, performs failover and switchover from primary to standby databases when needed.
• Performs database backup and recovery using RMAN auxiliary method.
• Perform logical backups such as tables and schema backups using Oracle Data pump export and import utilities.
• Creating and managing database objects, creating Regular views, sequences, partitions, and refreshing Materialized Views as needed by the development team.
• Participates after hours On-call database support.

Environment: Oracle 9i, 10g, 11g, 12C, Unix shell script,\, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories

Oracle DBA

Confidential

Responsibilities:

• Created and configured database by making changes to the Initialization Parameters in parameter file and dynamically in session.
• Performed backup and recovery using Oracle user managed backup such as automated or manual cold backup and hot backup procedures.
• Wrote scripts for informing the DBA's regarding the status, performance and Space Management of the Database.
• Upgraded database from 10g to 11g database using Database upgrade assistant, export/import utilities and using oracle scripts. Managed and monitored hot standby database using (Data Guard) as well as monitoring primary database by using Unix Shell scripting.
• Performed tuning such as database tuning, SQL tuning such as query optimization.
• Prepared and reviewed database specifications, testing and changing control management programs migrations. Upgraded the database from 10g to 11g database and applied database patches (CPU).
• In depth knowledge of setting up RMAN backups and recovery, RMAN tuning, and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.
• Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, granting roles and privileges, archiving of alert logs, verifying error entries and checking for space usages/overages.

Environment: Windows2000, Oracle 9i, PL/SQL, Oracle DBA Enterprise Manager, SQL*Loader, Shell scripts