Professional Summary:

• 10 years of experience as an IT professional which includes 8 years as an Oracle Database administrator Oracle DBA on Windows/NT and Linux platforms
• Hands on experience in all aspects of Database Administration such as installation, upgrade, patching, migrations, cloning, backups, database security management etc.
• Proficient in using OEM Oracle Enterprise Manager , SQL Developer, TOAD, Spotlight, Export/Import, Export/Import data pump.
• Expertise in maintaining Database Security using security compliance auditing.
• Expertise in loading data from flat files using external tables, SQL LOADER.
• Performance and Tuning experience, specializing in SQL and Database/Instance Tuning, and Operating System Tuning.
• Profound knowledge of Oracle Enterprise Manager 10g.
• Applied patches as required for Oracle Databases.
• Experience in Database migration on various platforms.
• Proactive and self-taught, Ability to work under extreme pressure.
• Excellent communication skills, effective team player and a decisive leader in motivating and coordinating a team of people to ensure the service levels are met
• Strong Experience in Installing / configuring / maintaining Production, QA DEV Oracle 10g/11g/RAC 11g in UNIX/LINUX, HP-UX and Windows Servers.
• Management of schemas, objects, indexes and tables partitioning, and indexes optimization for high-performance applications.
• Database defragmentation and reorganization, optimizing the database storage according to the application purpose.
• Experience in ORACLE Database administration including space management, User Management roles and profiles , Password Management.
• Experience in Data warehousing and ETL INFORMATICA
• Hands on experience with RAC Cluster ware configuration and administration.
• Worked extensively in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using Oracle features Export/Import Data pump, ADDM, Grid Monitoring, Recycle Bin.

Technical skill set:

Primary Skills : Oracle Database management Oracle 9i, 10g, 11g , PL/SQL

Operating Systems : Windows NT / 2000, Linux, HP-Unix, Solaris

Protocols : TCP/IP, SNMP, SSH, FTP and Telnet

Oracle DB utilities : OEM, DBCA, Oracle Net Manager, EXPDP/IMPDP, RMAN, Exp/imp, Tkprof, Lsnrctl, SQL Plus, Opatch

Remote Administration : Putty, VNC, Terminal Service, SSH Telnet, TSM Tivoli

Middleware : Exposure to Oracle application Server 10G, Trained on RAC10g

ETL tool : Informatica 8.6

Professional Experience:

Confidential

Oracle DBA Developer

Roles Responsibilities:

• Creation of Databases, Instances for Test, Development, Stage and Production Servers.
• Monitoring and managing day-to-day operations, Managing schema objects, such as tables, indexes, and views
• Created database users, security maintenance by assigning quotas, roles, privileges, profiles and providing database access to users as per the policy standards.
• Applying database patches using Opatch Utility on a quarterly basis.
• Performed Hot/Cold cloning as a part of data migration
• Data migration using Transportable tablespaces
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
• Migration of databases between various environments using logical backups
• Monitoring databases through OEM grid control
• Performance monitoring and managing parameters to provide fast query responses to 'front end' users.
• Disaster Recovery Planning and implemented drills
• Remote application clustering
• Create and implemented RMAN backup and recovery strategy
• Logical backups using Data pump
• Collecting statistics through AWR and ADDM Report
• Implement pl/sql scripts for changes in the user applications
• Actively performed Disaster Recovery drills
• Data refresh from production to non-production servers for testing purposes
• Developed and extensively used SQL queries for backend testing of the database depending on the technical specifications
• Good understanding of ETL design principles and worked on Informatica 8.6 to derive complex mappings using ETL transformations such as Expression, Aggregator, Rank, Router, Lookup, Filter, Joiner, SQ, Stored Procedure and Sorter
• Frequent interaction with the QA, Development team and the application team members for support and applications maintenance.

Environment: Oracle 11g/10g, TOAD, RMAN, SQL server, OEM, PL/SQL, Data Guard, AWR, Informatica.

Confidential

Oracle DBA

Roles Responsibilities:

• Supported 1000 databases on Windows, UNIX and Linux operating systems, of versions ranging from Oracle 9i to Oracle 11g and on domains from finance, marketing sales.
• 24 7 support with rotational oncall duty
• Responsible for planning, coordinating and implementing security measures to safeguard the databases
• Administered database issues through incident ticketing system, User access security and maintenance, created users and assigned profiles, quotas, roles privileges to different users
• Test programs or databases, correct errors and make necessary modifications
• Work as part of a project team to coordinate database development and determine project scope and limitations
• Performed data refresh, data reorg, space management issues, Index rebuild, connections using database links
• Capacity planning for new Production, Development and Test databases.
• Created primary objects tables, views, indexes storage structures tablespaces once application developers have designed the application
• Migrated Databases from lower versions of Oracle 11G
• DR Planning, Implementing and testing for production databases.
• Installation of Oracle RDBMS software and OEM agent software as per the Standard run book.
• OEM agent configuration, adding targets to OEM repository, setting up credentials and blackout when needed. Monitoring Dev, QA and Prod database issues through 10g OEM.
• Involved in the DCC Data Center Consolidation program and migrated databases
• Responsible for database backup and recovery using Exp/imp, Datapump, RMAN
• SPOC for the coordinated management of Database Builds and Database decommissioning activities
• From Singapore data centers to North American data center
• Co-coordinating with Oracle support for any technical assistance and work till the solution implementation
• Senior member of the DBA team, and had proactively taken the responsibility of cross training and mentoring the new team members with the process knowledge.

Environment: Oracle 11g/10g/9i, RMAN, SQL server, OEM, PL/SQL, Data Guard, AWR, UNIX, LINUX.

Confidential

Oracle DBA/Sys Admin

Roles Responsibilities:

• Oracle Application Server 10G installation, Forms deployment, Reports deployment, and APACHE server
• Application server upgrade
• Oracle Database Upgrades
• Exports using datapumps, Weekly cold backups.
• Database builds
• Troubleshooting database space related issues.
• Advising clients on Application server hardware sizing

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 10G, Database Tools/Utilities, Oracle Enterprise Manager.

Confidential

Oracle DBA

Roles Responsibilities:

• Installing Oracle software and creating new databases as per the Standard run book.
• Following the ITPM standards for all database related and non-database related activities.
• DR Planning, Implementing and testing for production databases.
• Automation of logical backups and RMAN backups using shell scripts.
• Responsible for database backup and recovery using Exp/Imp. Checking the failed backups and troubleshooting.
• Data refresh using logical backups, RMAN backups, Disk backups and TSM backups.
• Migration of data from prod to Dev and QA environments.
• Installing and configuring OEM in all the database servers. Understand the process flow of OEM to ITSM system. Identify the issues with the ticketing process and suggesting the configuration changes in the main OMS server.
• Implementation of Ford's internal tools such as PEN, PAR and FOSA.
• Using OEM advisory modules to resolve undo retention and performance issues
• Upgrading to latest Oracle releases. Applying Patches on Oracle databases.
• Creation and modification of database objects.
• Proactively monitoring the database's health and taking preventive or corrective actions.
• Implementing oracle 10g new features like datapump
• Enabling auditing options for the database accounts based on the job function.
• Controlling database security - Creating users and assigning profiles, quotas, roles privileges to different users, system security, and data security and auditing.
• Capacity planning for new Production, Development and Test databases.
• Monitoring the Oracle Home location, datafile location, audit file destination and request space whenever needed
• Resizing the datafiles of the tablespaces. Purging the SYSAUX tablespaces.
• Checking the free space available for the tablespace and adding the space partitioning table
• Raising Oracle TAR for resolving critical problems.
• Troubleshooting the connection issues.
• Participating in regular In-house and client meetings.
• Monitoring the ticketing system, analyzing the criticality of the tickets and assigning resources to the tickets

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, Linux.

Confidential

Oracle DBA/Oracle Apps DBA

Roles Responsibilities:

• Supported the Internal project 'Archivejinnie' as Apps/Core DBA.
• Modification and addition of primary storage objects, Addition of tablespaces, datafiles and modification of tablespaces, datafiles.
• Implement and Maintain Database Security. Creating / Altering / Dropping Users as and when required and administer their respective quotas. Create and Maintain Roles and assign necessary privileges to users according to business rules.
• Concepts of Oracle Applications Overview, Technology layer, Database Structure, File System, and Environment files.
• Handling and monitoring concurrent managers.
• Handling AOL and System Administration.

Environment: Oracle 11g/10g, TOAD, RMAN, SQL server, OEM, PL/SQL, Data Guard.