PROFESSIONAL SUMMARY:

• Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 RAC environments for high availability and load balancing.
• Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 8i to 9i ,9i to 10g and 10g to 11g .
• Over 7 years of experience as Oracle Data Base Administrator, providing 24x7 production support on 11gR2/10g/9i/8i databases on different Platform.
• Strong experience in implementing ORACLE STREAMS, and two types of standby databases supported by logical standby and physical standby.
• Hands on experience in Data guard, Grid control, streams, replication, monitoring batch performance.
• Extensive knowledge on database backup/recovery strategy RMAN , Import/Export Data pump, Capacity Planning, Replication Streams standby databases, Oracle configuration management, Data guard, database cloning, refresh and patch management.
• Established Disaster Recovery for Oracle 11g RAC database.
• Ample knowledge on Exadata Architecture, Smartscan, and Advanced compression.
• Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
• Expert in using Oracle development tools such as Tool for Oracle Application Development TOAD , Oracle Reports builder, Forms 6i, SQL developer, SQL Plus, Oracle Enterprise Manager OEM , Crystal reports and PL/SQL Developer.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Ample knowledge in GoldenGate implementation.
• Deep knowledge and hand on experience on Oracle Database Vault, Data Encryption and other Oracle Security related features.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Designed and developed database applications and data warehousing for business intelligence.
• Ability to coordinate in a team as well as to work individually.

PROFESSIONAL SKILLS

• Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, IBM AIX 5.1, 5.2, 6.1, Red
• Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows.
• Data Bases: Oracle 11g,10g/9i/8.x, Oracle 10g Real Application Clusters
• RAC . MS SQL Server 2000/2005/2008, DB2.
• Software Applications: Datapump, Recovery Manager RMAN , GoldenGate, RAC, Oracle Exadata, Oracle APEX, Data Guard, Database Vault, SQL Loader, SQL Trace,
• Tools: SQL Loader, Toad, SQL Developer, OEM Grid Control.
• Languages: SQL, PL/SQL, JSP, C , C, C , XML, UNIX Shell Scripting, Perl.
• Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Administering Oracle 11g Production, Test , and Development environments on Redhat Enterprise Linux and IBM AIX.
• Installing Configuring Oracle Clusterware and troubleshooting using cluvfy and handling common issues.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Configured and built Golden Gate Extracts/replicat for multiple databases.
• Implemented High availability using GoldenGate Replication. Implanted Bi-directional replication using GoldenGate.
• Manage Oracle RAC database configurations using GoldenGate and Data Guard to ensure maximum availability and data protection.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate
• Implementing and maintaining database security create and maintain users, roles and assign privileges .
• Database tuning, Application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Creating and maintaining materialized views, using them for replication where GoldenGate is not yet configured.
• Implementing Oracle TDE Transparent Data Encryption in all of our new/existing databases for Tablespace encryption.
• Maintaining the Wallet files, and backing them up using automated scripts/jobs to eliminate the loss of wallet files.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Migrating the databases from non-Exadata environments to Exadata environments using dataguard switchover.
• Migrating the Non-ASM single instance databases to ASM RAC instance.
• Configured, managed, and monitored, Exadata hardware.
• Applied patches on an Exadata environment.
• Knowledge on Smartscan and advanced compression of Exadata.
• Familiar with cellcli command interface in Exadata environments.

Environment: IBM AIX 6.1, RedHat Enterprise Linux, EXADATA Oracle 11g, 12c. RAC, OEM 12c, GoldenGate, Data Guard, RMAN, Datapump, Oracle Virtual Private Database, Transparent Data Encryption TDE .

Confidential

Oracle Database Administrator

Responsibilities:

• Administering Oracle 11g/10g production, test, development environment on IBM-AIX.
• Database Refreshing / Replication from production to testing using Datapump Exp/Imp.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Installed and implemented GoldenGate to replicate data between databases.
• Configure and build heartbeat monitoring in GoldenGate.
• Identified and produced necessary documentation of best practices for GoldenGate.
• Implemented necessary monitoring scripts for GoldenGate in unix/perl scripting.
• Recovery of Database using oracle recovery manager RMAN Performed full recovery and point in time recovery .
• Installed and configured Oracle Label Security in 11gR1 R2 for row level security of sensitive PI data.
• Installed and configured Oracle Database Vault in 11gR1 R2 for fine-grained access control and for separation of duties in the database.
• Created and configured Realms, command rules for restricting privileged users such as DBAs from accessing/altering highly sensitive data in the database.
• Installed and configured Database Vault in a 12c test environment with advanced secure application roles for POC.
• Architected and implemented GoldenGate replication between SQL Server data warehouse and Oracle capacity and performance management repository.
• Implemented transparent data Encryption TDE . Used TDE with both Encrypted columns and Tablespaces.
• Used Oracles Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.
• Monitored and provided weekly reports on the server's memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Created and monitored Virtual Private Database VPD policies for securing sensitive data in PI tables.
• Performed database cloning to setup test and development database.
• Conducting sizing capacity planning for Oracle databases.
• Migration of Database from 10g to 11g and applying patches whenever required.
• Migrated from SQL server database to oracle database.
• Upgrade of Databases from 10g to 11g.
• Installed ASM environment and migrated database from NON-ASM to ASM.
• Configured and monitored Physical Standby database for maximum performance mode Oracle Data Guard

Environment: IBM-AIX 6.1, Oracle 10g, 11g, and 12c, RAC, OEM 11g, 12c, Transparent Data Encryption TDE , Datapump exp/imp, Data Guard, ASM, Golden Gate, Exadata, Control M, Oracle Label Security, Oracle Database Vault, Oracle Virtual Private Database VPD .

Confidential

Oracle Database Administrator

Responsibilities:

• Actively participated in the installation of 10 g RAC on LINUX environment.
• Installed 10g RAC 2 Node on RHEL 4 Server and converted/added a node to 3 Node RAC for production databases
• Administering Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
• Provide admin support to APEX applications.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database hardware.
• Using the tools such as TKPROF, EXPLAIN PLAN and TRACE FILE to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing capacity planning for Oracle databases.
• Manage Oracle RAC database configurations utilizing GoldenGate and Data Guard to ensure maximum availability and data protection.
• Maintaining schemas and partitioning tables.
• Implemented the Security using ORACLE Database Vault.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Creating tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Dataguard Implementation
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.

Environment: HP-UX, IBM-AIX 6.1, Oracle 9i, 10g, 11g, Oracle Enterprise Manager OEM Grid Control, Oracle Spatial, RAC, Database Vault, Label Security, Datapump Exp/Imp, RMAN, TOAD, SQL Developer, SQL Loader, ASM.

Confidential

Oracle Database Administrator

Responsibilities

• Installation and Maintenance of Oracle 9i, 10g, 11g on IBM-AIX, LINUX and Windows platforms.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Implemented the Oracle 10g, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Install and Configure Oracle Apex 4.1 in the RAC environment
• Provided Oracle Application Server and Oracle APEX implementation and support.
• Used Oracle Transparent Data Encryption and Database vault to encrypt some of the data in the database.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server's memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
• Replicated data using GoldenGate.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Designed, developed and maintained UNIX shell scripts and Perl scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Administered 10g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR and ADDM.
• Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, 10g, 11g, RAC, TOAD, OEM, AWR, ADDM, DATA GUARD, RMAN, Golden Gate, Diagnostic and Tuning Advisors.

Confidential

Database Administrator

Responsibilities:

• Install, upgrade and maintain Oracle software products/versions on Linux, Sun Solaris and HP-UX.
• Backup of Database Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc .
• Configured and Maintained oracle 10g 2 node RAC, Standby database.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• Implemented Database Security, Management of role-based security
• Implemented Oracle 11g Data guard for high availability.
• Applied Oracle DST Patches on Oracle database.
• Maintenance of database security using Data Vault, VPD and Oracle Label Security
• Performed day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Wrote a number of UNIX shell scripts and Perl scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• User creation and enforcing security using privileges and roles.
• Automated the processes by using CRONTAB.
• Database performance tuning using STATPACK, Explain Plan, AWR, ADDM, ASH.
• Cloning databases using scripts as well as RMAN.
• Installation, setup and configuration of Data Guard.

Environment: Oracle 10g with RAC and ASM, ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Data Guard, AWR, ADDM, Cronjob, Erwin, O/S: RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, ASM Packages.

Confidential

Oracle Database Administrator

Responsibilities:

• Database monitoring and performance tuning using OEM Oracle Enterprise Manager and STATSPACK.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches
• Scheduled several backups through RMAN.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Extensive application tuning through STATSPACK, explain plan, SQL Trace.
• Worked on decommission of database and services which are no more required
• Monitored the Oracle Streams topology and performance.
• Identified the long running transaction through V session longops and also for Rollback monitoring which is an enhanced feature of Oracle 10g.
• Used EM on Oracle 10g for diagnostic summary, host CPU utilization, finding wait events, alerts Log errors etc.
• Re-engineered system to J2EE using Oracle 10g backend database.
• Extensively used SQL Queries Sub queries, correlated sub queries and Join conditions to handle data mapping.
• Performed the SGA tuning, monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g/11g, PL/SQL, SQL PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software 5.0 , VERITAS Cluster, RMAN.