SUMMARY:

• About 3+ years of experience in IT industry as Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management and database security on various platforms LINUX, AIX, UNIX, SUN SOLARIS. Experience in Golden gate; practicality of Data Guard, knowledge of SQL Server databases.
• Excellent experience in production support, installation, configuration, upgrades.
• 24*7 production database support with Support to developers & end - users.
• Extensive knowledge on database administration of Oracle 10g, 11g, 12c with experience on very large scale database environment.
• Expertise in Installation, maintenance and tuning of RAC Applications.
• Implemented Data guard (Physical Standby) for RAC databases.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Created and administered physical standby using data guard set up Snap Shot standby using dg broker.
• Experience in Capacity Planning and Bench Marking.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Experience in Database Performance Tuning.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, OEM Grid Control and manual scripts.
• Migrations, patches, performance tuning, backup and recovery, cloning.
• Experience in development, testing and implementation of Backup and Recovery strategy Using RMAN, Data pump and Export/Import utilities.
• Knowledge in Red Hat Linux system administration.
• Experience on Golden Gate Uni-Directional and Bi-directional Replication.
• Expertise in Oracle Golden Gate installation, configuration.
• Hands on experience in implementing golden gate classic and integrated capture and integrated replicate process.
• Hands on experience in Installing, Migrating, Upgrading and Maintaining different oracle versions on UNIX, Linux and windows Platforms.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, and sequence), space management, monitoring, scheduling jobs.
• Performed Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Managing Users, roles and privileges, space management Creating storage structures, Performance tuning.
• Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL LOADER.
• Good experience in SQL, PL/SQL, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Good Interpersonal communication skills and Documentation Skills.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Good coordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Operating systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux RHEL 3, RHEL 4, RHEL 5, Ubuntu, Solaris10,9,8, HP-UX. Windows

Database Skills: Oracle 12c, Oracle 10g/11gR2, Oracle 11g/10g, Oracle 11g/10g RAC.

Tools: Oracle Enterprise Manager (OEM), TOAD, SQL developer, RMAN, Data pump, Golden Gate, Password Vault, Toad, SQL- Navigator.

Performance Tuning: Grid Control, AWR, ADDM, SQL performance analyzer.

Oracle Utility: Export/Import, Data Pump, SQL*Loader, RMAN, 12C OEM.

Database Advance Feature: RAC, Data Guard, Standby Database, Oracle Golden Gate, Grid Control.

PROFESSIONAL EXPERIENCE:

Confidential,Dallas, Texas

Oracle Database Consultant

• Experienced working on different database versions like Oracle 10g, 11g and 12c databases.
• Provided production support for the 24x7 Oracle database availability.
• Responsible for managing production, development & test databases and applications.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Involve in code test and migration on all the environments. Handle requests from application team and also resolve issues reported. Set up rules in OEM to monitor space for all the environments and schedule scripts through OEM and crontabs.
• Simulated copy of production databases into test databases for the application and upgrade testing.
• Built 4 node RAC 11gr2 Standby databases and set up DG Broker.
• Managed multi nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Implemented several designs of Golden gate which include uni-directional, bidirectional, Ddl, Schema level, Table level and handled the project from gathering the requirements to designing, implementing the replication and setting up the monitoring.
• Installed and configured the Oracle Golden gate and also involved in troubleshooting Goldengate issues.
• Setup goldengate uni directional and bi-directional replication between 2 data centers.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily alert logs.
• Refreshed non-production environment with production using data pump.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Database cloning/exp/imp to setup identical databases in the production and development environments.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Review alert logs and dump files to check for any problems related to the database.
• Develop shell, PL/SQL and SQL scripts to implement automation of ongoing administration and maintenance tasks.
• Created encrypted passwords in UNIX and Linux servers by using SQL crypt utilities.
• Handled all database schema passwords and import all passwords into password vault tool.
• User Account auditing by auditing default tablespace, temporary tablespace assigned, grants, privileges, roles, profile, database links created for remote database connection, grants with admin option, password management.
• Developed and managed alert system to monitor database errors, broken jobs, invalid object status, space, and locks on objects.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created the index for increasing the performance of data conversion process.
• Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Created new functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts.
• Created database links to retrieve data from multiple servers.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.

Environment:: ORACLE,SQL*Plus, OEM/12c, PL/SQL, PL/SQL Developer, Oracle12c, 11g/10g, Oracle 11g/10g,12c RAC, Shell scripting, Oracle Enterprise Manager, Data guard, RMAN, Golden Gate, UNIX/LINUX, SOLARIS, Password Vault, Toad.

Confidential,Irving, TX

Oracle DBA

• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Worked as part of a team and provided 24/7 support when required.
• Involved in Database migration from Oracle10g to Oracle 11g.
• Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Create and manage documentation on the configuration and support of the Oracle databases.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Manage Schema Objects.
• Monitor Alert log Files and trace files.
• Involved in Installation and configuration of the Oracle Golden gate and also involved in troubleshooting Golden gate issues.
• Setup monitoring for the golden gate abends, lags.
• Administer database user accounts, create, modify and deactivate user accounts; assign and monitor user access rights.
• Monitor the user sessions and take appropriate action to kill the inactive sessions.
• Evaluated new features and enhancements in later versions of Oracle (10g) for possible implementations like Data Pump (EXPDP/IMPDP), Transportable Table spaces, External Tables and Partitions.
• Creating users and database links, snap shots on production and development servers.
• Support migration and loading of data into oracle database using SQL*Loader.
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Loading the data using SQL Loader.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
• Tested the loaded data and documented the errors and reporting.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning
• Performance monitoring, Alert Log monitoring and backup monitoring.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write
• Installed and configured Grid Control to monitor all databases centrally.
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: ORACLE, SQL*Plus, PL/SQL, Oracle 11g/10g, Golden Gate, Red Hat Linux 5, UNIX, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad.

Confidential

Junior Oracle DBA

• Responsible for Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Handled the Backup and Recovery using RMAN.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Implemented Monitoring Templates and Incident Rule notifications using OEM 11g for database alerting.
• Monitored the user sessions and take appropriate action to kill the inactive sessions.
• Created users and database links, snap shots on production and development servers.
• Created databases, tablespaces, tables, indexes and other database objects.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Coordinated with developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Created Indexes and Monitored Performance. Data loading using SQL Loader (from Text files to Database). Performed Daily Logical backups using exp.
• Managed users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Planning and implementing Backup strategy for the databases using RMAN & Scripting backups every two weeks on the application database.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints, SQL and PL/SQL.
• Monitored the Applications and database using OEM.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) for Performance Tuning.
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment.
• Provide development and production support related to database.
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system.
• Performance Tuning of Databases, Oracle instances, and Applications. Identified Performance Bottlenecks using AWR, and ADDM.

Environment: ORACLE, SQL*Plus, PL/SQL, Oracle 11g/10g, Red Hat Linux 5, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad.