SUMMARY:

• 8 years of experience as an Oracle Database Administrator, encompassing experience in installation, migration, maintenance, client support, analysis, designing, development, testing, and administration of oracle databases, which included understanding the requirements, upgrades, performance tuning, backup recovery, cloning and space management using ORACLE 11g, 10g, 9i, performing the role of Oracle Database Administrator according to the set standards and time-lines.
• Extensive knowledge on database administration for Oracle 11g, 10g, 9i, with experience within very large scale database environment and mission critical large OLTP systems
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager OEM , TOAD, Oracle SQL Developer in various versions.
• Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g/9i, OLTP multiple instances /OLAP databases in production.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates CPU's in various environments.
• Installed and maintained Oracle 11g/10g RAC with ASM OCFS2 File systems.
• Proficient in setting up the network connections setting up Listener and TCP/IP Connections .
• Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Have implemented ORACLE STREAMS for replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for DR and high availability.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle 11g features in these utilities.
• Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups using data-pump /cold backups , manage statistics, Disk space management.
• Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL Loader and External tables.
• Performance tuning of the database SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various UNIX Shell Scripting.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams Replication .
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

Technical Skills:

Professional Experience

Confidential

Oracle DBA

Responsibilities:

• Utilized the Advisor Central utilities, AWR, ADDM, and SQL Tuning Advisor to provide Oracle Database Performance Tuning.
• Important key member of team that built a database private cloud for the company's customers.
• Used OEM Grid control to provide support and administration for Oracle RAC system environment.
• Used Golden gate and Data guard replication tools to make data highly available across the system.
• Installed and configured Oracle Enterprise Manager 12c with the new features to administer RAC and non RAC, Golden Gate and Data Guard High availability
• Configured and utilized .Net Api and JDBC to connect to oracle database.
• Set up Data Guard environment by creating physical standby database for disaster and loading performance purpose and also a logical standby database for the management team for reporting and business decision making purpose.
• Set up replication of the production database with Oracle Data Guard.
• Responsible of creating, maintaining and managing oracle database for the departments from planning, testing and through production.
• Administered database storage, created, maintained and controlled the storage objects using ASM features.
• Monitored Table space and resized the Data files in order to respond to the growth of the database storage system.
• Generated department database users account as needed, setting up the secured profiles and with the right privileges.
• Controlled and examined database transaction to provide the consistency by identifying locks conflict and resolving them.
• Adjusted undo Table space size as needed
• Configured Archive log mode for the company departments for database backup purpose.
• Planned and implemented oracle RMAN backup and recovery procedures.
• Configured ASM files system and created disk group to simplify the storage management of the Data files, Control files and Redo log files.
• Performed logical backup using data pump and traditional Export and Import utility.
• Supported Oracle Database migration from 11G to 12C
• Documented and complied with company policies and standard operating procedures
• Upgrade Oracle Database from 9i to 11G

Environment: Oracle 9i to 11G and 12C OEM Grid Control, Linux, Oracle Data Guard, Oracle RAC, Redo Log Files, Mongo

Confidential

Oracle DBA

Responsibilities:

• Created Oracle 11g database for departments, from planning and testing through production.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation.
• Utilized SQL Tuning Advisor to tune SQL statement and the recommendations to rewrite poorly performing SQL code.
• Installed, configured and supported Oracle Enterprise Manager, evaluated Oracle Database Monitoring and PL/SQL tools.
• Modified SQL Loader control scripts to eliminate while spaces generally used for data loading and Tuning SQL statements using Explain Plan and STATSPACK.
• Installed managed 10g R3 OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed Schema as well as Table level Replication using Oracle Golden-Gate and also did set up Disaster Recovery solution using Golden-Gate.
• Created bit-map Indexes for data warehouse databases.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Worked with ETL group for understating mappings for dimensions and facts.
• Configured Physical and Logical Standby database for reporting environment.
• Set up users account and allocated them their privileges, defined their roles.
• Managed undo data to making sure they are available for rollback, and for reading.
• Multiplexed the redo log file using the OEM tools of oracle and ensured a proper recover data for the database in case of disaster.
• Install Oracle 9i, 10g and 11g on Linux and Windows for the training department.
• Implemented and created hot or online backup procedure.
• Partnered with all other teams, the development team, designers team, the administration team and users to provide best solutions by maintaining the best standards of practice.

Environment: Oracle 9i, 10g and 11g, SQL, OEM tools, Linux, SQL, Data Guard, Mongo , PL/ SQL, SQL Loader

Confidential

Oracle DBA

Responsibilities:

• Implemented Oracle Database 10g 2 Node Real Application Cluster RAC .
• Maintained and troubleshooting cluster-ware components in 10G RAC environment.
• Used oracle configuration assistants like Database Configuration Assistant DBCA for creating databases, Database Upgrade Assistant DBUA for upgrading databases.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup recovery solutions using RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Involved in writing for shell scripts for taking RMAN backups.
• Restored and Recovered database at the times of occurrence of critical failures using RMAN.
• Extensive used Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs change requests for future reference.

Environment: Oracle /10g/9i, HP-UX, OEM 10g, Oracle 10g RAC.

Confidential

Jr. DBA

Responsibilities:

• Review of Database logical and Physical design.
• Installation, setup and configuration of DATA GUARD.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc and Implementing Database Security, Management of role-based security.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory SGA Tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure and Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files Trace files.
• Implemented schema level, table level and bidirectional oracle streams.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: Oracle 10g and 9i, OEM, Linux, RMAN, Export/Import, SQL, PL/SQL, SQL Loader