SUMMARY:

• Seeking a challenging position in database administration that requires proactive participation and induction of experience & theory into practice for the realization of organizational and professional growth
• Over 15 years of experience in Oracle database administration, backup and recovery, schema maintenance, performance tuning, performance monitoring and space management.
• Experienced in Oracle Database 12c, 11g, 10g, 9i, 8i, 8, 7.3 installation, configuration and administration on Sun Solaris, Windows NT/2000/2003 Servers and Linux.
• Experienced in developing and implementing standards, procedures for operation, access control, backup and recovery policies of database servers.
• Experienced in developing scripts (Shell, SQL, and PL/SQL) to monitor databases, disk I/O, processes, memory (paging/swapping), Network and CPU utilization.
• Experienced in Installation and Configuration of Logical and Physical Standby databases, Data Guard, RMAN and Recovery Catalog.
• Experienced in cloning the database using export/import, transportable tablespaces and RMAN.
• Experienced with multi tenancy architecture, Transportable tablespaces, Data Pump, AWR, ADDM and most of the new features of Oracle database 12c/11g.
• Recovered database when Windows NT Operating System crashed and where there was no backup.
• Configured and administered physical and logical standby databases using DATAGUARD and manually.
• Monitor DATAGUARD implementation regarding connectivity issues and log shipping.
• Troubleshoot archive log shipping and register missing logs with standby database in Data Guard configuration.

TECHNICAL SKILLS:

Technology: Win NT 4.0, 2003 server, AIX, Sun Solaris and Linux

Languages: C, SQL, PL/SQL, COBOL and UNIX Shell Programming.

Databases: Oracle 12c, 11g, 10g, 9i, 8i, 7.x and MS Access.

Tools: Oracle OEM, Data guard, Data pump, DB Artisan, Toad

GUI: VB 5.0, Developer 2000

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Configure, install, administer and tune Oracle databases.
• Patch, upgrade and troubleshoot database upgrades and performance.
• Resolve day to day issues of Oracle databases and issues faced by end users.
• Database refreshes and cloning using Data Pump and RMAN.
• Configure, administer and troubleshoot Oracle standby databases using Data Guard as part ensuring High Availability.
• Identifying log shipping failures and resolving log apply gaps.
• Configured and implemented snapshot standby database for prod code/data testing.
• Implemented observer for automatic failover of standby database in case of primary database crash
• Participate in disaster recovery design, testing and execution.
• Design process for database change management issues related to environment migration.
• Developed and ensured compliance with all system, disaster recovery and security audit policies.
• Work with application team with their development efforts.
• Experienced in performance tuning, query optimization using SQL tuning advisor.

Environment: Windows, Linux, Sun Solaris, Oracle 11g, 12c RMAN, Service Now, Data Guard, Autosys, GRID and ASM

Confidential, Wilmington, DE and Washington, DC

Oracle DBA

Responsibilities:

• Install, upgrade, administer and tune Oracle 10g, 11gR2 and 12c databases corporate wide.
• Worked with Oracle 12c container and pluggable databases.
• Support PROD, DEV and TEST environments of applications corporate wide.
• Perform patching and upgrade of various versions of Oracle databases.
• Monitor databases using Oracle Enterprise Manager (OEM) grid control and shell scripts.
• Coordinating application releases and 24x7 DBA support.
• Configured and administered Oracle physical standby databases using Data Guard.
• Administered Physical Standby in Maximum Performance mode and resolved log shipping and log apply issues.
• Plan and setup of backups using RMAN and Logical exports. Define backup retention policies based on the business requirements for all environments.
• Database performance monitoring and troubleshooting including query tuning and index optimization.
• Working with application team with their required modifications to database.
• Write PL/SQL procedures, triggers and functions when needed.
• Proactive patching of all environments to be in compliance with corporation regulations.
• Followed ITIL processes for Change, incident and service request management corporate wide.
• Configured ASM and installed Grid infrastructure and RAC databases in test environment.
• Installed and configured Golden Gate in test environment.
• Extensive knowledge on VM Ware and managing databases on Oracle Virtual machines

Environment: Sun Solaris, VCS, Oracle 10g, 11g, 12c Maximo, RMAN, Toad, ISM, GRID, RAC and ASM

Confidential, Herndon, VA

Oracle DBA

Responsibilities:

• Supporting production, acceptance, development and test databases.
• Troubleshooting performance issues and database tuning.
• Implementing baselines, database refreshes and Coordinating database releases.
• Configuring and administering Resource Manager.
• Involved in troubleshooting OLTP and OLAP database issues.
• Managing very large databases from 5TB to 35TB in size.
• Managing large tables, partitions and Indexes.
• Worked with oracle 10g/11g on AIX and Sun Solaris Operating Systems.
• Used DATAPUMP for all database export and import purposes.
• Migrated large databases from one environment to another.
• Supported databases and applications 24x7 on rotation schedules.
• Tuning of Cost Based Optimizer (CBO) parameters.

Environment: Oracle 10g/11g, DB Artisan, IBM Rational Clear Quest, Remedy, Oracle EM, Data Pump.

Confidential, Washington DC

Oracle DBA

Responsibilities:

• Support production environment including infrastructure, application and database issues.
• Configure, troubleshoot OID database and infrastructure server.
• Involved in analysis, database design, coding, and implementation of applications.
• Extensively involved in upgrade of databases, application servers from various versions of 9i to 10g.
• Configure and troubleshoot Logical and Physical standby databases using Data Guard and manually.
• Configure, troubleshoot Application Servers and Database Servers.
• Deploy releases in all environments.
• Support users, Developers and Testers in all environments.
• Apply patches to database, application and infrastructure servers.
• Raise SRs with Oracle.
• Configure, manage and troubleshoot OC4J instances.
• Configuring the connection pool, garbage collector and discoverer.
• Organizing database refreshes as per client requirements.
• Tuning database and applications.
• Installed, upgraded and configured the grid control.
• Monitored the production databases on daily basis and performed database maintenance tasks. Configured Enterprise Manager alerts for different database metrics.
• Performed fine - tuning of SQL queries for maximum efficiency and performance.

Environment: Oracle11g, 10g, 9i, PL/SQL, UNIX, Linux, RMAN, OC4J, OID, Oracle Application Servers etc.

Confidential

Oracle DBA

Responsibilities:

• Extensively involved in installation and administration of both Oracle 9i and 10g databases
• Managed Development, Test and Production databases.
• Cloned Databases to produce another set of Prod, Pre Prod, QA and Training.
• Planning and monitoring of proactive maintenance activities required to ensure ongoing database operations at required SLA levels,
• Managed storage based on design.
• Tested & implemented backup and crash recovery scenarios on test environment (9i/10g) using RMAN
• Providing 24x7 database support to all production, test and development databases.
• Resolved Issues escalated by various development teams using Oracle databases as backend.
• Backup and recovery using RMAN, change management, Data Modeling, scripts for various database activities, troubleshooting etc.
• Worked under tight schedules for successful development and implementation
• Managed security. Database Tuning.
• Created database backup/recovery using RMAN.
• Database and Application troubleshooting.

Environment: Sun Solaris, Linux and Windows Oracle 10g/9i/8i, RMAN.

Confidential

Oracle DBA

Responsibilities:

• Involved in Database Administration, managing multiple databases on Windows and Sun servers.
• Involved in Planning, Designing, Creation of database, managing backups and designing recovery strategy, tuning application code & stored procedures.
• Involved in Maintenance of database, monitoring growth, storage planning, analyzing & cleaning up logs etc.
• Extended Support to clients for database related problems on production database.
• Worked on managing multiple Databases and underlying database objects such as Indexes, Triggers, procedures, functions, partitions, packages, cursors etc.
• Worked on PL/SQL optimization for faster execution and better performance of the Database.
• Managing backend security, Users and Privileges.
• Providing 24x7 database support to all production, test and development databases.
• Resolved Issues escalated by various development teams using Oracle databases as backend.
• Worked under tight schedules for successful development and implementation

Environment: Oracle 9/8i, Windows XP, Windows NT, Sun Solaris 8.