Oracle DBA

***- ***-**** * ***

PROFESSIONAL SUMMARY:

9+ years of experience as Oracle Database Administrator, providing 24x7 production support on 11gR2/10g/9i/8i databases on different Platform.

Expert knowledge in installing oracle database server on HP-UX, AIX, LINUX and migration of oracle server from 9i to 10g and 10g to 11g and 12c.

Strong experience in implementing ORACLE STREAMS, and two types of standby databases supported by logical standby and physical standby.

Hands On experience in implementing Data masking policies for protecting the sensitive data in the database.

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 using Data Guard.

Hands on experience using rman active duplicate form database migration and database refresh.

Ample knowledge on Exadata Architecture, Smartscan, and Advanced compression.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 12c OEM Grid monitoring.

Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.

Experience in installing, configuring and maintaining Audit Vault and Database Firewall.

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, 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 implementation of Goldengate for the replication of data from primary to downstreams for reporting and archival purposes.

Hands on experience in implementing Classic and Integrated Extract/Replicats for Goldengate Replication .

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, RMAN, Database Vault, Audit Vault, Database Firewall, GoldenGate (OGG), RAC, Oracle Exadata, Data Masking, Oracle TDE, Oracle APEX, Data Guard, SQL Loader, SQL*Trace,

Tools: SQL*Loader, Toad, SQL Developer, OEM Grid Control 11g, 12c.

Languages: SQL, PL/SQL, JSP, C#, C, C++, XML, UNIX Shell Scripting, Perl.

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE

Wells Fargo, West Des Moines, IA Mar’ 15 – Till Date

Oracle Database Administrator

Installation, configuration, Maintenance and Support of Oracle 11g and 12c Databases as a part new Project implementation.

Migration of databases from non-Exadata to Exadata environments using RMAN.

Knowledge about Smartscan and advanced compression of Exadata.

Familiar with cellcli command line interface in Exadata environments.

Implemented Oracle Goldengate for replicating data from Primary to downstream systems such as data warehousing for reporting purposes and history databases for archival purposes.

Upgrading Goldengate versions from 11g to 12c and converting Extracts/Replicats from classic to integrated mode.

Converted Goldengate Classic replicat to Co-ordinated replicat to improve the throughput of golden gate apply.

Building and maintaining Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery.

Created and monitored Virtual Private Database (VPD) policies for securing sensitive data in PI tables.

Installed and configured Oracle Audit Vault and Database firewall in non-production environment as a proof of concept.

Configured Database Vault and implemented Realms and command rules for fine grained access control on database objects and restricting super users from accessing the sensitive data.

Pro-Active Monitoring of the Databases using 11g and 12c Enterprise Manager (OEM) and working on Root Cause Analysis and documenting the issue resolution steps for future reference.

Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch .

24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Responsible for installation of Oracle Clusterware (CRS ) also referred as Grid Infrastructure from 11g and creating the RAC and Standalone databases.

Migration of databases from Non-ASM (filesystem also referred as Logical Volumes ) to ASM i.e Automatic Storage Management.

Loading huge datasets into the database using SQL Loader during ETL operations.

Database refresh from production to lower environments using cascade standby and masking data for Dry runs before the production releases.

Responsible for optimizing sql queries and tuning the long running queries as a part of performance improvisation.

Tuning performance of the database using tools like STATSPACK, EXPLAIN PLAN, TKPROF, SQL TRACE, AWR and ADDM reports.

Writing UNIX shell scripts for the automation of RMAN backups, and Import and export procedures

Worked on Database Wallet and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption.

Testing the functionality of Key Vault in storing the TDE wallet keys from all the non-production databases as a proof of concept.

Providing the Go-live and Post –golive Support for the database performance related issues and Ensure that all the work is documented for future reference.

Environment: RedHat Enterprise Linux, EXADATA Oracle 11g, 12c. Data Guard, RMAN, Datapump, RAC, OEM 12c, Oracle Audit Vault, Database Firewall, GoldenGate (OGG), Transparent Data Encryption (TDE), Oracle Key Vault (OKV).

Costco Wholesale Issaquah, WA (With Oracle Consulting) Jul’14 - Feb’ 15

Oracle Database Administrator

Costco is a membership warehouse club that provides a wide selection of merchandise, plus the convenience of specialty departments and exclusive member services. Costco Travel and Costco Pharmacy are the other major components of Costco.

Responsibilities:

Administering Oracle 11g Production, Test, and Development environments on Redhat Enterprise Linux and IBM AIX.

Installed, configured and maintained Oracle Audit Vault and Database Firewall for collecting audit data from multiple databases.

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 active-active 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 active-active Oracle-to-Oracle replicated environments utilizing GoldenGate.

Developed shell scripts for the automation of daily jobs and reports to schedule in crontab.

Implementing and maintaining database security (create and maintain users, roles and assign privileges).

Masked sensitive data columns in a table to import data from production to Test environments using Oracle Data Masking.

Oracle Database and SQL tuning using EXPLAIN PLAN, TKPROF, AWR and ADDM reports.

Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

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 Data Guard/standby databases for fail-over purposes.

Migrating the databases from non-Exadata environments to Exadata environments using dataguard switchover.

Upgrading databases from 11g to 12c.

Data loads using SQL loader utility.

Migrating the Non-ASM single instance databases to ASM RAC instance.

Configured, managed, and monitored, Exadata hardware.

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, Audit Vault, Database Firewall, GoldenGate, Data Guard, RMAN, Datapump, Oracle Virtual Private Database, Data Masking, Transparent Data Encryption (TDE).

JPMorgan Chase Columbus, OH (With Oracle Consulting) June’13 – Jun’14

Oracle Database Administrator

J.P. Morgan is a leader in asset management, investment banking, private banking, treasury and securities services, and commercial banking. JPMorgan Chase & Co. is an American multinational banking corporation of securities, investments and retail. It is the largest bank in the United States by assets.

Responsibilities:

Administering Oracle 11g/10g production, test, development environment on IBM-AIX.

Database Refreshing / Replication from production to testing using Datapump Exp/Imp and RMAN Active Duplicate.

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.

Worked with Golden Gate Active-Active (Bidirectional) Replication.

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).

Healthways, Franklin, TN (With Hewlett Packard) Nov ’12 – June’13

Oracle Database Administrator

Healthways has always been at the forefront of healthcare transformation. Started 30 years ago with programs to support diabetes care, progressed to help set the first national standards for disease management, evolved to support the continuum of health across populations, and finally expanded their scope from physical health to overall well-being improvement.

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.

Tyco International, Princeton, NJ Nov ’10 –Nov ‘12

Oracle Database Administrator

Tyco International Ltd. is a diversified, global company that provides thousands of products and services vitally important to customers around the world. Products and services of Tyco International include electronic security solutions and alarm monitoring, fire-fighting equipment and breathing apparatus, as well as water transmission and distribution, heat tracing and flow control solutions.

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.

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.

Sanofi, Bridgewater, NJ June ’09-Nov ’10

Database Administrator

Sanofi, a global and diversified healthcare leader, discovers, develops and distributes therapeutic solutions focused on patients’ needs. Sanofi has core strengths in healthcare, with 7 growth platforms: diabetes solutions, human vaccines, innovative drugs, consumer healthcare, emerging markets, animal health and the new Genzyme.

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.

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.

Fannie Mae, Reston, VA Oct ‘08- June ’09

Oracle Database Administrator

Fannie Mae is a government-sponsored financial firm (GSE) chartered by Congress with a mission to provide liquidity, stability and affordability to the U.S. housing and mortgage markets. The Project deals with the internal implementation between the bankers and Fannie Mae, where the bankers provides the details of customers to FM, and here the Employees will process Loans depending up on the customer’s credit records.

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.

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.

Airtel, India Jun ‘07 –Sep ’08

Oracle Database Administrator

Bharti Airtel Limited is a leading integrated telecommunications company with operations in 20 countries across Asia and Africa. Headquartered in New Delhi, India, the company ranks amongst the top 5 mobile service providers globally in terms of subscribers. In India, the company's product offerings include 2G, 3G and 4G services, fixed line, high speed broadband through DSL, IPTV, DTH, enterprise services including national & international long distance services to carriers. In the rest of the geographies, it offers 2G, 3G mobile services.

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.

Educational Qualification:

Bachelors of Technology in Computer Science, Jawaharlal Nehru Technological University, India.

Contact this candidate