SUMMARY

• Over 8 years of experience as an Oracle Database Administrator in the Database Installation, Development and Production Systems, Supporting leading global teams in a wide variety of cutting edge environments.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, Unix shell scripting, korn shell scripting and documentation.
• Experience in OLTP/DSS/VLDB database systems, managing large Oracle Databases and Data Warehouse Systems.
• Strong experience in Installation, Configuration and Administration of 11i/R12 Oracle Applications.
• 4 years of good experience in Patching, Cloning, Troubleshooting and System Administration of Oracle e - Business Suite 11i/R12.
• 4+ years of experience in troubleshooting http(s), forms, reports, concurrent managers/programs of Oracle Applications 11i/R12
• Worked with Oracle Databases (11g/10g/9i/8i), ASM, RAC and Datagaurd on Unix/Linux/Windows platforms.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases 11g and Oracle Applications.
• 5 years of Extensive Experience in Installing and Upgrading Oracle 9i/10g databases on production, test and development environments on Solaris and Linux boxes.
• 3 years of Proficient Experience with Standby Database, Data Guard, Replication.
• 3 years of experience in Installation and Involved in Implementing RAC Database with 2 and 4 nodes.
• Knowledge on Oracle 11g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Configured and Implemented more than 10 computers with HACMP on AIX, Linux environment to share the data on various file systems.
• Installation, Configuration and Administration of Oracle Data Integration (10.1.3.5) and ODI 11g.
• 5 years of strong experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup.
• Oracle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• 3 years of experience in Implementing Streams, Data Pump, Export and Import utilities.
• Strong skills in shell, perl and korn shell scripting to automate jobs.
• 5 years of Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• 4 years of Proficient experience in Database performance tuning using Statspack, TKPROF, SQL Trace, and Explain Plan.
• Experience in Troubleshooting oracle databases using sqltrace utilities.
• Excellent Knowledge on Oracle Support processes for technical requests with Metalink.
• 6 years of proficient experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Data modeling, Oracle Data Dictionary - meta data, Logical and Physical Database Design, Backup and Recovery procedures.
• Good Knowledge in Data Modeling tools like Erwin.
• Experiencing in basic and advanced replication
• 4 years of Experience in using OEM 10g,TOAD
• 1 years of Experience in Implementing and configuring 12c OEM.
• Expertise in maintaining Database Security using auditing.
• Experience in configuring Oracle Advanced Security Option (ASO) and Secure Sockets Layer (SSL) on both server and client machines.
• Experience in Data Migrations and Benchmarking.
• Experience in Installation and Configuration of MS SQL Server 2000 & 2005.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Installation, Configuration and Updating of Oracle Business Intelligence tools.
• Involved and Implemented physical and logical database design and construction with data modeling application software ER/Studio.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 4.x, 6x, MS SQL Server 2000 & 2008,Windows NT,XP,VM 4, 5

RDBMS: Oracle 12c/11g/10g/9i/8i

Languages: SQL, PL/SQL, C, C++, Perl, Korn, Unix/Linux Shell Scripting

Tools: RMAN, OEM 10g/11g/12c, SQL*Loader, EXP, IMP, EXPDP, IMPDP, TOAD, SQL Developer

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR

Database Modeling: Erwin 4.0, UML 2.0

Other: EMC, NetApp, SAN, NAS, Veritas NetBackup, IBM TSM

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Oracle DBA

Responsibilities:

• Strong working experience in 24 X 7 Production database administration, data warehouse systems and monitoring to ensure a proactive problem recognition and resolution of very large database issues.
• Converted a single instance database to Oracle RAC 10g and implemented 4 node 11g RAC on test environment.
• Installed and Upgraded Oracle 11g database from Oracle 10g database on development, test and production environments.
• Installed and Upgraded Oracle Grid Infrastructure Database 11g
• Created and maintained SOPs for RAC, Datagaurd Installations and Configurations and Monitoring.
• Installed, Configured and Maintained Oracle Applications 11i/R12.
• Created Users, Responsibilities, Custom Tops and Applications in 11i/R12.
• Monitered users and forms using Oracle Applications Auditing Profile options and Custom options.
• Managed Oracle Applications Security (Password Policy, Concurrent Session Control)
• Troubleshooted Oracle e-Business Suite Application login, forms, reports and concurrent requests issues
• Extensively performed cloning and patching of Oracle Applications 11i/R12
• Created Oracle Database RMAN Backups and Recovery Scripts.
• Actively Monitered Oracle 10g/11g RAC & ASM using OEM 12c and Custom Scripts.
• Experience in configuring Oracle Advanced Security Option (ASO), Data Masking and Secure Sockets Layer (SSL) on both server and client machines.
• Performed tablespace Encryption and Data Masking in Test, Staging and Production environments.
• Involved and Implemented Database migration from Oracle 10g to Oracle 11g.
• Implemented Upgrades and Migrations using Data Pump, Export & Import utilities on both 9i, 10g and 11g Databases.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented and Involved in Hot, Cold and Logical backup plans
• Oracle 9i & 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK and OEM 12c
• Proactive database monitoring using OEM 12c.
• Created Scripts for scheduling and maintaining level 0 and incremental cumulative level 1 RMAN backups to the FRA
• Developer Environment Setup, Support, Cloning and Refreshes using RMAN Methodology.
• Installed, Configured and Mainted e-Business suite R12 Applications and SOPs.
• Performed database cloning to setup test and development database
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures
• Written Korn, Perl, shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Installation of Oracle version 10g on Solaris, HP-UX and AIX boxes.
• Implemented and configured High Availability Multiprocessing (HACMP) on AIX 5.4 to share the data on file systems.
• Analized, implemented, developed and communicated with the design of Enterprise scale database application using ER/Studio.
• Database dot release upgrades using oracle universal installer and catpatch.sql
• Was involved in developing a disaster recovery (DR) plan and Stand by Database
• Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK
• Installed ODI, Defined Topology, Models, Integrations and Agents for Hyperion ERPI using ODI 11g
• Conducting sizing & capacity planning for Oracle databases.
• Upgraded Discoverer Administrator from older version to new for administrative tasks and also applied most recent OLAP patches.
• Installed and Configured AMDOCS CRM, Billing and OSS software for oracle.
• Experience in reading Alert. Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Serves.

Environment: Oracle Server 10g /11g, SQL, PL/SQL, Sun Solaris 9, HP-UX 11, Red Hat Linux 4.x, 6.x, Windows Server 2008

Confidential, Alameda, CA

Oracle DBA

Responsibilities:

• Excellent working skills in 24x7 Oracle Production Database and Data Warehouse Systems.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Installed and supported OEM 10g on Windows and Linux.
• Health Checkup of the databases using AWR, ADDM.
• Create table spaces, tables, and users for custom applications.
• Performed Schema/Tables/Databases export using Data Pump, Export and Import utilities.
• Refresh/Cloning of Database and applications for development, testing
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions)
• Created Menus, Functions, Personalizations, Concurrent Programs, Responsibilities and registered Custom Top Applications in 11i/R12
• Troubleshooted Long Running Concurrent Requests, Forms, Reports and Blank Page issues.
• Cloned and Patched Oracle Applications 11i/R12
• Monitored and Managed Oracle Applications 11i/R12 through SOPs
• Performed System Administration and Security of Oracle e-Business Suite 11i/R12
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Data refresh from production to test and development
• Database patching using opatch and Application patching using adpatch.
• Installed and Configured grid monitoring tool for Oracle 10g Database.
• Proficient with Standby Database, Data Guard and Replication
• Experience in SQL tunning using STATSPACK, EXPLAIN PLAN and TKPROF.
• Implemented 2 node RAC Database on Linux Operatin System.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Installed HACMP on AIX 5.3 box with more than 8 nodes to share data among multiple computers.
• Good knowlede of Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database on different operating systems.
• Migration of Database from 9.2.0.8 and to 10.2.0.4
• Installation, Configuration and Updating of Oracle Business Intelligence (10.1.2.1 & 10.1.2.0.2 Releases) tools
• Implemented and Configured Data Modeling Erwin tool in Oracle 9i and refined the tool to confirm that referential integrity as defined.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Implemented and Involved in local and downward streams.
• Diagnose and troubleshoot Database problems and failures.
• Performed Installations, Configurations and Clonings of ERP Applications and Databases.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 9i to 10g.
• Perform SQL tuning and assist developers with coding PL/SQL
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Written SQL and Shell scripts to monitor tablespaces and extent growth.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• OS level activities like space monitoring of Mount points
• Automation of Startup Shutdown on all Production and Development Database.
• Daily Health Check Up of the Database

Environment: IBM AIX 5, 6, Redhat Linux 4.x, 6.x, Oracle 9i/10g, Windows Server 2008

Confidential

Oracle DBA

Responsibilities:

• Responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities.
• Participated in a team environment for the delivery and maintenance of data and/or database management systems.
• Provided interpretation and responses to vulnerability assessments from written benchmarks or scanning tools
• Provided technical, interpersonal and administrative skills in performing day to day work
• Escalated issues in a timely manner and provide mitigation recommendations to Data Team Lead and Project Director.
• Identified architectural issues and proposed alternative solutions
• Adhere to database management standards and guidelines
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools
• Performed installation of 10g RAC on Linux environment with two nodes and Oracle Cluster File System (OCFS) as storage.
• Supported 40 production and 100 plus development and testing databases with database ranging from 100GB to 2TB.
• Excellent Experience in installing 9i and 10g databases on HP - UX and LINUX.
• Highly experienced in using STATSPACK, AWR to check health of database & hardware.
• Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT
• Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Performed database Cloning using RMAN, hot and cold backup to setup test and development database.
• Upgrade and Migration of Database from 9i to 10g Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Maintaining schemas and partitioning tables.
• Experienced with all kinds(Status, Performance, Trend Analysis) of DB MONITORING
• Experienced with SRVCTL for monitoring and configuring RAC Environment.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Designed and Developed shell scripts to automate the processes and to proactively monitor the database.
• Created table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with space management, conducting sizing, capacity planning and security.
• Applied Critical patch updates (CPU) and PSU patches released by Oracle.
• Advanced replication using Oracle Streams and Oracle Data Integrator 10g (10.1.3.5)
• Created Topology, Models using ODI Designer and Configured Procedures and Agents Scheduling
• Experienced with building physical standby databases and point in time recoveries.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools

Environment: Oracle Server 10g/9i, SQL, PL/SQL, Windows, Linux/Unix

Confidential

Jr. SQL Developer / Oracle DBA

Responsibilities:

• Worked with Oracle Databases (10g/9i/8i), RAC on Unix/Linux/Windows platforms.
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Logical and Physical data modeling.
• Enforcing the Null and check constraints.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases and Disaster Recovery Database.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Using TKPROF, EXPLAIN PLAN and STATSPACK for the Better performance.
• Monitoring of database for growth and performance using scripts and manage engine tool.
• Monitoring Database for fragmentation and correcting them.
• Customization and development of Unix shell scripts, Korn and Perl scripts.
• Partitioning strategies for very large tables.
• Diagnose and troubleshoot Database problems and failures
• Implementing range, list partitions, hash sub partitions.
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Configured targets using OEM 10g
• Monitoring of database for growth and performance
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Handling day-to-day activities
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Involved in the installation of Oracle 9i on Windows NT and Linux.
• Installation Configuration and Maintenance of RAC, Stand by database.
• Execute Hot, Cold and RMAN backups and recoveries.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Used TOAD and SQL Developer tools for querying and troubleshooting PL/SQL queries and codes.
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Cloned environments to create patch test, development and QA environments
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Applied High priority, security patches downloaded from Metalink
• Monitoring the Database storage and Day to Day activities.

Environment: Oracle Server 10g/9i, SQL, PL/SQL, Windows NT/2000, Linux/Unix, Solaris