SUMMARY:

• Total 6 years of experience as Database Administrator in Production, Development and Testing Environments.
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, Golden Gate, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments and mission critical large OLTP and OLAP systems.
• Proficient in maintaining 10g, 11g, 12c and 18c databases.
• Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 8i, 9i, 10g and 11g. Managing Very Large Database. Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, DataPump tools.
• Managed databases on Exadata x7
• Maintained databases on Exadata X5
• Experience in project life cycle includes Requirement gathering and Analysis, Database design, Database development (SQL, PL/SQL), Test, Implementation & Support. Upgrading and Migrating of Database from lower version to higher version.
• Experience includes using Golden Gate to support data replication in the Oracle database environment.
• Experience with Enterprise Manager Grid Control. Backup: Using OS backup (Hot and Cold). Oracle backups, generally through Export - Import utilities, also through Recovery Manager (RMAN) . Worked on Database Performance Tuning, SQL Tuning and Optimization.
• Worked with SQL& other tools including creating database objects like tablespaces, tables, views, indexes. Administrating Database in various platforms like WIN … SUN SOLARIS 8/9, HP UNIX and Red Hat Enterprise Linux.
• Maintaining data integrity and tune database for optimum performance and availability. Excellent in troubleshooting Oracle Network issues. Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Designed a solution with timelines by planning the Data Center Migration using standby configuration.
• Data Center Migration options used are Export/Import with DataPump, Cross-Platform Transportable Table space and Application specific methodology to capture changes and replay.
• Ability to move a group of databases within the same downtime window.
• Installation, Configuration and Automation of Oracle DBA Monitoring Tools. Ability to support and work within standard software development life cycle (SDLC) practices. Applying Patches for Database& Upgrading Database Versions.
• Implemented Graceful Switchover and Switchback between Production and Standby Databases. Ability to handle Projects and worked efficiently with other team members, Project managers, System Administrators & Application Developers. Also refreshing Database as per the requirements of the clients (CLONING)
• Configured Oracle Golden Gate 11g.
• Used Export/Import to do table level and full database defragmentation. Provided on-call production database support. Creating Indexes and Monitoring Performance. Data loading using SQL Loader (from Text files to Database) . Perform Daily Logical backups using exp.
• Extensive testing of all mission critical databases at different level (unit, system, integration)
• OEM 10g Grid Implementation for Production Monitoring.
• Application of Oracle 11g upgrade for OEM Grid.
• Oracle Enterprise 11g R2 installation and configuration in Linux.
• Perform RMAN operations (Incremental Backups) . Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC. Performed SQL Tuning by using explain plan and TKPROOF.
• Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability at operating System.
• Implemented Disaster Recovery for Oracle Databases in Production.
• Evaluated and ensured the efficiency of application database backup and recovery procedures.
• Ensure that the database systems are well documented and that documentation is maintained in a timely fashion Develop and publish database administration best practices.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
• Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
• Ability to perform database code migration, change management and data management through the various stages of the development life cycle.
• Ability to independently investigate, analyze and troubleshoot problems, to determine and provide accurate resolution and root cause.
• Good experience in 24/7 Production Environment Support.
• Excellent communication skill & Interpersonal skill.

TECHNICAL SKILLS:

Operating System: Window 2003/2008, Sun Solaris, UNIX, HPUX, AIX, RHEL

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Databases System: Oracle 18c,12c,11g R2/10g R2/9i/8i, RDBMS, MSSQL, RAC, Standby

Web Technologies: HTML, XML

Application Server: Web logic Server, IIS.

Documentation Tools: MS Word, MS Excel, Microsoft Project, Visio.

Tools: /Utilities: SQL*Loader, TKPROF, Export, Import, RMAN, Erwin, Oracle OEM, Grid Control, DB Console, SQL Developer,SQL*Plus, SQL*Loader, Oracle Data Pump, STATSPACKEXPLAIN PLAN, and TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Troy, Michigan

Oracle DBA

• Configured Data Guard to provide high availability by implementing Physical standby database.
• Used RMAN duplicate feature to move/clone databases on Linux, AIX and Unix.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Supported database on Exadata X7
• Performed Silent installation on Exadata.
• Applied patches on computer nodes, Exadata home and storage cells.
• Migrated standalone databases to Exadata
• Implement disaster recovery with use of Exadata
• Migrated standalone databases to RAC on Exadata
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 11g to 12C and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e., 9i, 10g,11gand 12C.
• Database migration from 9i to 10g to 11g. Then from 11g to 12C R2.
• Designed, configured, and maintained backup and recovery policies including RMANbackups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Migrated databases to AWS
• Build new servers on AWS
• Worked on project to migrate databases to AWS instance
• Set up oracle instances on AWS cloud
• Recovered and clone database using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) withcritical production database.
• Proactive performance monitoring, and capacity planning for future database and servergrowth.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience withadministration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuningand monitoring, troubleshooting, backup and recovery, installations and configurations on an asneeded basis.
• Used external tables and SQL*Loader to import data from flat files.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible forTroubleshooting performance and networking issues. Basic OS system administration.
• Strict adherence to policies and procedures - specifically in regard to change management.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources on a daily basis Able to work effectively with multiple teams at once.
• Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills anddiscipline for Change Management practices processes
• Solid discipline in providing end-users timely updates on their problems. Installing serversoftware.
• Monitored database space requirements and adjusted for future needs.

Environment: Oracle 9i/10g/11g/12C databases, 9i/10g/11g/12C (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, SQL*Loader, Physical Backups, Grid Control

Confidential, Barrington, IL

Oracle DBA

• Oracle DBA duties involving development and production support such as installations,configurations,backup/restore & recovery, database monitoring & operating systemconfigurations, database performance tuning, assisting in the logical/physical database design,applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production anddevelopment environments.
• Oracle Applications server including OID. Implementation of Oracle Applications Server foruse with Portal, Custom Forms and Reports and Discoverer 6i.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
• Involved in discussions with the management regarding the advantages/disadvantages andupgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Upgrading OEM Repository and Installing OEM 10g Grid Control to monitor all thedatabases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applicationsusers/information systems/processing specialists
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Setting up privileges to create local and remote objects
• Create materialized views to refresh data at regular intervals.
• Using materialized view logs to reduce the replication time costs for fast refreshes.
• Upgrading/Migration from Oracle 9i databases to 10g and 11g. 11g to 12C R2.
• Installing of quarterly security patches on all non-production and production servers.
• Cloning/replicating/refreshing production databases to test/ development environmentsusing RMAN scripts.

Environment: UNIX, Oracle 9i/10g, Oracle 9i AS, VERITAS Netbackup, Net worker