SUMMARY

• Over 7 years of experience as Oracle Data Base Administrator, providing 24x7 production support on 11gR2/10g/9i/8i databases on different Platform.
• 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 .
• Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 RAC environments for high availability and load balancing.
• 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.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, IBM AIX 5.1, 5.2, 6.1, RedHat 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*TraceTools 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, Issaquah, WA

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, Columbus, OH

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, Franklin, TN

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, Princeton, NJ

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, Bridgewater, NJ

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, Pittsburgh, PA

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.

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
• Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Involved in designing the database, identification of the objects and creating tables.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Developed PL/SQL scripts for exception handling.

Environment: ORACLE 8i, 9i, SQL, PL/SQL, Cron job, Import/Export, UNIX AIX 5.1.