SUMMARY:

• Five (5) years of Oracle DBA experience with Oracle 12c/11g/10g on UNIX/Linux/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.
• 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, Grid Control and OEM.
• 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.
• Experienced in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.
• 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 technical and analytical skills with excellent interpersonal and communications abilities.

TECHNICAL SKILLS:

• Oracle 12c/11g/10g
• UNIX
• Linux
• AIX
• Windows 2003/2008R2
• Windows NT/2000
• SQL Loader
• PL/SQL
• TOAD
• Data Guard
• Oracle Grid Control
• OEM
• Unix Shell Scripting and MS Office Suites.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Performing several databases upgrade from Oracle 10.2.0.1 to 10.2.0.4 to 11.2.0.1 to 12c
• 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.
• 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.

Jnr. Oracle DBA

Confidential, Brunswick, MD

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.