SUMMARY:

• 6+years of experience as Oracle DBA having hands on 12c, 11g, 10g on AIX, HP - UX, SOLARIS, Linux, and Windows servers; experience with RMAN, and standard backup and recovery procedures; practicality of Data Guard, upgrades and patches, knowledge of SQL Server databases.
• Excellent experience in production support, installation, configuration, upgrades, Migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• 24*7 production database support with Support to developers & end-users.
• Expertise in development, testing and implementation of Backup and Recovery strategy Using RMAN, Data pump and Export/Import utilities.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.
• Implemented Data guard (Physical Standby) for RAC databases.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Expertise includes Oracle Databases (11g RAC/10g RAC/9i/8i), on UNIX (HP-UX, Sun Solaris, IBM AIX)/LINUX and Windows environments
• Experienced in setting up/installation and configuration of release 11g RAC/10g R1 RAC with EMC Storage.
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with EMC.
• Extensive knowledge on database administration of Oracle 10g, 11g, 12c with experience on very large scale database environment and mission critical large OLTP and OLAP systems.
• Extensive knowledge of Oracle OEM 12c Architecture, Framework, and Infrastructure
• Strong Experience in Database Performance Tuning.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Expertise in requirements analysis, database development, debugging, problem solving and user support.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Experienced in troubleshooting traditional export/import and data pump export/import.
• Hands on experience in Installing, Migrating, Upgrading, Patching and Maintaining different oracle versions on HP-UX, UNIX, AIX, Linux and windows Platforms.
• Performed DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Implemented High availability using Golden Gate Replication.
• Implanted Uni directional and Bi-directional replication using various versions of Golden Gate.
• Expertise in maintaining Database Security using auditing.
• Hands on Dealing with database security and auditing.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Proficient in PL/SQL, SQL and UNIX Scripting
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Configuration of Oracle 10g R2 OEM Grid Control to monitor database.
• Responsible for Database schema optimization and Data modeling.
• Expertise in Multi-server management features of SQL Server by using linked servers.
• Hands on experience of MS SQL Server 2008 & 2012 Enterprise servers on production, Test and Dev boxes.
• Expertise in SQL Server Clustering and Database Mirroring implementation.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including upgrades and patching.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Created Unix Shell scripts to automate database operation.
• Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise on implementation of replication & Integration tool Shareplex.
• Responsible for, both managing and supporting all Production, Development instances of Oracle Version 8i, 9i and 10g and 11g.
• Experienced in Lead, Design and Develop the ETL processes for Data Warehouse environment.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Expertise in data migration techniques.

TECHNICAL SKILLS:

Operating systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux RHEL 3, RHEL 4, RHEL 5,, Fedora,Ubuntu,Solaris10,9,8, HP-UX. Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional)Databases Skills: Oracle 10g/11gR2, Oracle 11g/10g RAC/9i/8i, Exadata V1/V2/X22/X28, Microsoft SQL Server 2005, 2008

Tools: Oracle Enterprise Manager (OEM), Oracle Performance pack, TOAD,Office 2000/XP, Oracle 9i Developer suite 9.0.2, Oracle 11, SQL developer, TIVOLI, ERWIN

Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer(SPA), SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.

Oracle Utility: RMAN, RCONFIG, 12cOEM, Export/Import, Data Pump, SQL*Loader,DGMGRL, ASMCMD.

Storage Technologies: Oracle ASM, VERITAS Netback

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr Oracle DBA Consultant

Role & Responsibilities:

• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Provided production support for the 24x7Oracle database availability.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Implementation of High Availability solutions with Oracle 12c,11g RAC,10g RAC, Standby Database (Active Data Guard), Replication.
• Responsible for Installation of RAC and Managing RAC Environment efficiently
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• Web Logic performance tuning and upgrade to 12c and 11g
• Implemented Monitoring Templates and Incident Rule notifications using OEM 12C for database alerting.
• Worked extensively on 12C OEM and configured DB alerts for DBA
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Supported functional data warehouse projects.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain the database effectively.
• Implemented classic Golden gate replication as well as integrated replication.
• 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.
• Was responsible for setting up Golden Gate replication from SQL server to Oracle and Teradata to Oracle at table level.
• 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 and Tkprof. SQL, PL/SQL and UNIX shell scripting.
• Monitored the Applications and database using OEM and OAM.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Built 4 node RAC 10gr2 Standby database and set up DG Broker
• Setup of High Availability of the database using RAC, Standby, Data guard.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases
• Install and Configure Oracle Fusion Applications 11.1.5 on Exalogic/Exadata -- setup and Maintain system and configurations.
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
• Provide development and production support related to database
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, EXPLAIN PLAN.
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance Bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM
• Upgrade and Migration of Databases from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.

Environment: ORACLE, SQL*Plus,OEM/12c,Exadata V1/V2/X2-2/X2-8, PL/SQL, Oracle 11g/10g,RAC, Microsoft SQL Server 2005 & 2008,DB2, Golden gate, Shell scripting, Red Hat Linux 5,Solaris 10,Unix, VCS, Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad.

Oracle DBA Consultant

Role & Responsibilities:

• Providing 24x7 on call support for the business critical production real application cluster databases.
• Verify success of database backup (Maintaining RMAN Backups and Logical Backups).
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
• Responsible for Installation, Configure, setup of 10g RAC and worked on performance issues which includes node eviction and node addition.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Nodes RACASM.
• Managed two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener, log files.
• Developed PL/SQL Stored procedures, Triggers and Functions and embedded them in packages.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
• Experience with Systems Analysis, Design and Data Modeling.
• Knowledge of writing Automated Scripts in the Cron for backups and restoration.
• Used TKPROF, EXPLAIN PLAN, and STATSPACK to improve the performance.
• 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.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Monitored the production Oracle alert logs for database errors and data issues.
• Performed Database and Application Performance tuning using EXPLAIN PLAN, TKPROF, Stats pack and SQL Tuning.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Managed RAC Linux servers running Oracle in cluster environments. Performed patching of Oracle databases with latest patches from Oracle.
• Upgraded Golden gate from version 9.0 to 10.2 and also responsible for cross platform migration using Golden gate from Linux to Solaris.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistics for the cost base optimizer, index rebuilding.
• Experience in Shareplex replication.
• Work within the production support team and maintain operational consistency and efficiency.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports.
• 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.

Environment: SQL*Plus, Shell Scripting, SQL, PL/SQL, SQL*Plus Golden gate, UNIX, Red hat Linux, HP-UX, OEM, Oracle 9i/10g.

Oracle DBA Consultant

Role & Responsibilities:

• Handled the Backup and Recovery using RMAN.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM.
• Perform tuning, maintenance and support of Solaris 11 RAC.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Applied patches which include CPU as well as PSU patches and used lot of techniques to reduce the patching downtime.
• Implemented Golden gate bidirectional setup between different data centers.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Performed Database and Application Performance tuning using EXPLAIN PLAN, TKPROF, Stats pack and SQL Tuning.
• Upgrade and character set conversion of RAC databases with the aid of Oracle's Goldengate utility.
• Implemented RMAN with OEM as a backup Strategy.
• Developed and delivered LRT data warehouse classes in beginning, intermediate, and advanced logical and physical data modeling and the use of the ER/Studio modeling tool.
• Performed Backup and Recovery tasks in SQL server 2005 using SQL server Management Studio.
• Responsible for providing application development support for Query Optimization, Stored Procedures, Triggers, Indexes etc. for multiple development applications.
• Handled database migration from Solaris to Linux.
• Implemented and maintained database security (creates and maintains users, roles and Assign privileges).
• Setup Exadata for best practices and performance.
• Managed data warehouse projects improvement and growths.
• Performance monitoring, Alert Log monitoring and backup monitoring.
• Created tools and processes to automate jobs and monitor database performance (Shell Scripts)
• Expertise on implementation of replication & Integration tool Shareplex.
• 24 X 7 Production database administrations, Support to Developers, End-Users.
• Developed strategies for data extraction from various source systems, transformation and loading into data warehouse target systems.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Involved in Database migration from Oracle9i to Oracle 10g.
• Created Indexes and Monitored Performance. Data loading using SQL Loader (from Text files to Database). Perform Daily Logical backups using exp.

Environment: Oracle10g, IBM-AIX, RMAN, SQL*Plus, PL/SQL, Golden gate, DB2, Shell scripting, Microsoft SQL Server 2005, RHEL4, UNIX, SQL*LOADER, Oracle OEM, Putty, Data guard, Oracle Data Integrator

Junior Oracle DBA

Role & Responsibilities:

• Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.
• Primary DBA for production, development and testing databases. Install and configuring Oracle database 9i, 10g, Linux. Implemented 10g flashback database features. Extensively worked on SQL Tuning using AWR, ADDM, ASH and tuning advisor in Oracle 10g.
• Performance tuning expert for all Oracle Application and Database Products.
• Used various data movement utilities like export, import and Load, Planning.
• Performs DB/Application patching, DB/Application Cloning, Install DB & Application Server, troubleshoot issues/errors, DB/Application Maintenance using manual approach and OEM R1, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Monitored and tuned the Shared Pool, Database Buffer Cache and Redo Log Buffers for best performance. Troubleshooting and Recovery of Database from Data file losses. Backup and Recovery involving archiving, redo logs, data files using RMAN.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Loading the data using SQL Loader.
• Evaluated new features and enhancements in later versions of Oracle (10g) for possible implementations like Data Pump (EXPDP/IMPDP), Transportable Tablespaces, External Tables and Partitions.
• Oracle Database and SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• For testing the software I have tested different scenarios like database creation, software installation, node addition, node deletion, database upgrade in RAC environment.
• Configure listener and local service names to use load balancing, failover, dynamic service registration and multi-threaded architecture for shared servers, RAC and data guard databases. Also use naming servers, hostname and service name resolutions depending on the connections requests.
• Creating users and database links, snap shots on production and development servers.
• Modified and maintained database structures and views for the core system.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Experienced in dealing with Query execution plan, SQL trace, TKPROF.

Environment: Oracle Database (9i, 10g), Shell Script, PL/SQL, TOAD, SQL Developer, OEM Grid Control, RAC, SQL loader, TKPROF, Sun Solaris 5.9, Windows 2000/XP.