PROFESSIONAL SUMMARY:

• Certified Lead Oracle DBA/Architect, with over 13+ years of experience in Oracle 10g, 11g, 12c, ASM, ACFS, RAC, DATAGUARD, DR, GRID CONTROL.
• Certified Database Administrator of experience as Oracle 12c/11g/10g/9i DBA
• Expert in Relational Database concepts and have been involved in Entity - Relationship modeling
• Expertise in Installation, maintenance, upgradation, administration, backup and recovery of Oracle database
• Expertise in Installation and Configuration of 12c cluster ready services and database in NFS and ASM file systems
• Migrated Oracle Physical Databases to Exadata Servers such as Full Rack X2-2 which has 6 CPU’s and total of 8 database server nodes and migrated to half rack which has exactly half the capacity
• Experience in Administering High Availability Databases, 10g RAC
• Basic & Advanced Replication environments
• Evaluate running Oracle Database on AWS (Amazon Relational Database Service (Amazon RDS), and Amazon Elastic Compute Cloud (Amazon EC2)
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases
• Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems
• Experience in Installation, Configuration & re-configuration of Oracle for Large Database on Unix/Red hat Enterprise Linux, Oracle Enterprise Linux, Sun Solaris and Windows environments
• Hands on using Oracle Enterprise Manager (OEM) 9i/ (Grid Control) 10g for database monitoring/performance/diagnostics
• Upgrading Oracle Golden gate 11.1.1.0 to 11.2.1.0.1
• Work with Oracle XML database and oracle text technology
• Installing Oracle Golden Gate for EBS Reporting Databases
• Golden Gate replication solutions design and implementation
• Performance and Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR reports, ADDM Reports, Tkprof and Explain Plan Methods
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import) and proficient in RMAN
• Expertise in configuring, maintaining replication using Oracle Streams at table level (Unidirectional, Bi-directional)
• Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage
• Oracle 9i RAC / 10g RAC implementation & administration using Oracle Cluster ware (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery)
• Experience in replication using golden gate, materialized views
• Replication and Extracting data and applying on production using Golden Gate
• Effective troubleshooting of database and performance problems
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
• Involved in different scenarios of OLTP as well as DSS databases
• Experience in Database Security and Auditing
• Enabling various alerts for Space Management
• Hands on Experience in using tools like Data Pump, SQL Loader
• Performed Instance Cloning, Code migration processes, Oracle grid-control
• Proficient in INDEX REBUILDING and INDEX TUNING
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM)
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB)
• Have exposure to Automatic Storage Management (ASM) configuration
• Excellent personal time management, organizing, analytical and problem-solving skills
• Good communication skills to work independently and in a team environment
• Excellent team player and flair to learn and implement new technologies.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server, My SQL, DB2, MS-Access

Oracle and other DB related Tools: SQL*Loader, SQL*Net, OEM, TOAD, ER-studio, Oracle migration work bench, Oracle Parallel Server, Oracle Replication, OID, Data Guard, ASM, Golden Gate, Oracle Data Integrator, RAC, OLAP, SQL backtrack and DevOps tools.

Operating Systems: Z-Linux, Sun Solaris, HP-UX, AIX4.3.3, Red Hat Linux 7.2, and Windows Server 03/08/12/16, AWS, Azure.

Languages: VB6.0, C, Pro*C, SQL, PL/SQL

Scripting Languages: Shell scripting, VB script, JavaScript, Perl

Markup Languages: HTML, XML (knowledge).

Web Servers: IIS, Apache, IBM

Serverside Tools: ASP, PHP

Reporting Tools: MS Project, MS-Office, MS-Visio, MSBI, VERITAS, Informatica, Ab Initio, oracle warehouse builder.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Lead Oracle DBA

Responsibilities:

• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on Oracle Linux 6.
• Implemented Data guard, creating both Logical and Physical Standby databases in 11g RAC environment for the Production databases.
• Implemented golden gate bi-direction replication.
• Install, configure and provides technical support for Oracle 11g Release 2 RAC databases as well as non-RAC databases.
• Experience Linux environment with Apache Tomcat, experience on Amazon AWS.
• Configured OEM 12c enterprise manager cloud control and upgraded various 10g agents to 12c agents.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metal ink to resolve them in timely manner.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Migrated key systems from Oracle hosting Environment to Amazon Web Services
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Capture, Propagation, apply using Golden Gate and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Performing responsibility as Oracle Exadata Machine Administration.
• Oracle10g/11g Migration from Non Exadata to Exadata DB with or without Golden Gate.
• Extensively developed PL/SQL Packages, Procedures, Functions, Triggers, and Sequences for implementing the business rules
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used AWR reports to monitor the database performance.
• Perform Backup and Recovery thru RMAN.
• Migrated Test, UAT, IAT and Production databases on Amazon AWS EC2 architecture.
• Tested the initial data load option of Golden Gate during the environment build.
• Refreshed multiple databases for Development and Testing upon short request.
• Oracle services have been used to configure Golden Gate high availability for the RAC nodes.
• High availability of Golden Gate is achieved by creating Golden Gate vips and services for RAC databases. If one node is failed Golden Gate automatically failovers to the other node.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 12c.
• Performed Export/Import through Data Pump.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 11g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases.
• Upgraded from 10g to 11gR2 with Golden Gate as the downtime is very less, also configured extract and replicate features.
• Installed and configured Teradata for monitoring the Golden Gate replication during the upgrade from 10g to 11gR2.

Environment: Oracle 11GR2, 10gR2, 9x, ORACLE & AWS SQL, PL/SQL, Golden gate 11x, Sun Solaris, Red Hat, OEM, and RMAN, RAC, OCFS, CRS, ASM, Shell Scripts, Net Backup, NAS, Exadata x4-2, x3-2, OEM 13c /12c, Oracle 12cRAC, 11gR2 RAC, 11gR2 Active Data Guard, RMAN, TOAD, SQL Developer, SQL Server 2012/2008, AIX 7.1, Oracle Linux 6.7, Red hat 6, Windows 7, OEM 12c, Oracle 12c RAC, 12c Active Data Guard, RMAN, TOAD.

Confidential, Middletown, NJ

Sr. Oracle DBA

Responsibilities:

• Installation, maintenance and tuning of RAC and standby databases OLTP, DSS and Data Warehousing using customized shell scripts.
• Creating ASM instance/maintaining ASM (adding, removing disk to disk group etc.)
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, warehouse, and business object repositories.
• Applied patches to Oracle Databases.
• Upgrading development and production databases to Oracle 11gR2.
• Proactive database monitoring using 11g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Extensive Performance Tuning, Memory (SGA) Tuning.
• Worked on scaling and load distribution on AWS.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Setup Golden Gate parameter files for extraction and replication.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Recovering Golden Gate corruptions.
• Performed other DBA activities like including space management and performance monitoring.
• Replicated Data using Golden data for encrypted columns (Wallet).
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.
• Experience in installation of Cassandra on 16-node cluster
• Good understanding of Cassandra architecture like gossip, snitch, seed node, anti-entropy, partition key, hash value, etc.

Environment: Oracle 11GR2, 10gR2, SQL, PL/SQL, Golden gate 11x, ORACLE & AWS Red Hat, OEM, and RMAN, RAC, OCFS, CRS, ASM, Shell Scripts, Net Backup, NAS, Exadata, Exadata x4-2, x3-2, ZFS Storage, ODA, Oracle OEM 12c, Oracle 12c, 11gR2 RAC, 11gR2 Active Data Guard, RMAN, Golden Gate, TOAD, SQL Developer, ODI Studio, Oracle Linux 2.6, Windows 7.

Confidential, New York, NY

Oracle DBA

Responsibilities:

• New server set-up, which includes Oracle Software installation and database creation.
• Building, installing Oracle instances.
• Configuring the RMAN backups/cold backups/hot backups etc.
• Export/import and Data pump used for migration of Oracle DB’s and refresh of Dev/QA Environments.
• Manage Live, Development and Test Staging Database Environments.
• Responsible for release management of all database related artifacts.
• Review of Queries for new CRs.
• Responsible for all database deployments, scripts, data fixes for all environments.
• Maintaining database schemas objects like Tables, Indexes, Views, Database links, Synonyms, etc.
• Migration Project with UNIX to Linux migration of Oracle 9i/10g to Oracle 11gR2 databases with Non-RAC/RAC and ASM.
• Good Knowledge on Oracle Streaming and Advanced security/Transparent Data Encryption.
• Refresh of test/development Databases using RMAN/hot backup, export/import data pump.
• Monitored indexes and analyzed their status for performance tuning and query optimization (Done lot of SQL tuning).
• Upgraded Oracle 10g and lower Non-RAC databases to Oracle 11g including data warehouse databases.
• Used SQL Trace, TKPROF, STATSPACK, per stat, Explain Plan, AWR and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM, Oracle streams and Data Guard.
• Upgraded the Oracle 10g database to 11gR2 version and also applied patch set and interim patches whenever required to make the database software up to date.
• Design and implementation of backup, recovery, Disaster Planning and failover plans.
• Assisting developers in SQL tuning and optimization using Explain Plan, TkProf and SQL Trace.
• Monitoring scheduled processes like stale stats, retention policy, archive destination, enable/disable triggers configured in database and database maintenance scripts.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• BACKUP, configure RMAN centralized backup for all database. Create standby database from Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA.

Environment: Oracle 12c/11g/10g/9i, SQL Server, HP UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, RMAN, Data pump(exp) SAN/NAS, 10g/11g RAC, Data Guard, SQL*Plus, PL/SQL, ASM, ADDM, RAC, TKPROF, Bug tracking tool.

Confidential, New York City, NY

Oracle DBA

Responsibilities:

• Responsible for Database Administration for day to day operational support of Oracle and Versant databases as well.
• Ensuring that database backups of different environments are being taken successfully.
• Monitoring database administration, monitoring using OEM 10g/12C and migration from 10g/12C OEM of the targets.
• Effectively addressing data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM.
• Exposure on AWS Relational Database Service (RDS), AWS Database Migration Service (DMS), Elastic Compute Cloud (EC2), Elastic Cache, Elastic Load Balancing, Elastic Block Store (EBS).
• Exposure in install/configure/upgrade the High-Availability Hadoop Clusters.
• Exposure in Importing and exporting data from different databases like MySQL, Oracle Into HDFS and Hive using Sqoop.
• Participated in DB Release activity in environments that use DevOps tools like JenKins and SVN.
• Working experience of AWS and Oracle cloud products and services.
• Scheduling jobs and troubleshooting in case of failure.
• Performing restores and data refreshes as per the requirement using impdp/expdp and sqlplus.
• Run scripts to create database objects and data manipulation as required.
• Responsible for performance upgrades to newer DBMS versions or preparing upgrades to newer DBMS versions or preparing an application to upgrade itself.
• Documented Design and change management for all process.
• Manage sharing of resources amongst applications.
• Primary DBA for 84 databases and responsible for all quarterly refreshes, upgrades, patches, monitoring and administration.
• Database and schema refreshes using impdp/expdp, imp.exp, Cold clone and RMAN duplicate very often.
• Performance tuning including database and SQL tuning to improve performance using tools like AWR, ASH, Explain Plan and thereby gathering stats, creating indexes, hints and altering parameters whenever required.
• Assisted in logical and physical database design.
• Installed, upgraded and patched Oracle software and associated applications.
• Wrote PL/SQL procedures, triggers and functions to enable plug and play of multiple data sources.
• Trained a new DBA in our environment.
• Participating in on call rotations supporting more than 2500 oracle and versant databases.

Environment: Oracle 12C/11g/10g/9i, RAC, OID, OEM 12C, ASM, SVN, Jenkins, Delphix, Hadoop, AWS, Azure, Windows Server, AIX, Linux, HP-UX, PL/SQL, RMAN, MSBI, Versant 6.4/5/6, SQL Server, SAP, Upstream, Downstream, TOAD, SQL Loader, Shell Scripting.

Confidential -Paterson, NJ

Oracle DBA

Responsibilities:

• Performed database refresh using data pump from production to dev environment.
• Installed PRISM application, configured and fixed the issues.
• Updated FAR at production, dev and QA environment.
• Verified the dbms jobs running successfully and fixed the broken jobs.
• Troubleshoot and resync the physical standby database at Data Guard.
• Refreshed schema using data pump export/import.
• Created RMAN backup script, scheduled the job and validated the backups.
• Database refreshed and upgraded from 10g to 11c using cold backup.
• Analyzed user requirements, planned system requirements and data flow; conceptualized while defining architectural design resulting in smooth flow of Systems Development Life Cycle (SDLC)
• Analyzed database performance by running AWR, ADDM and ASH.
• Performed database tuning running SQL tuning advisor to analyze query running slow.
• Monitored, managed tablespace usages and increased the tablespace size.
• Installed the quarterly CPU patches.
• Performed DR exercise and brought the database up using RMAN restore database and recover the database.
• Cloned the database using cold backup.
• Analyzed the disk space usage and deleted the old backups that are more than fifteen days old.
• Configured and run the STATSPACK to analyze instance health, load summary page and high resource SQL statements.
• Install 12c golden gate for the database replication.
• Configure golden gate manager, extract and replicate.

Environment: Oracle 10g/11g,12c with Data Guard, RHEL 5, Windows Server 2008 R2, VMWARE ESX, VERITAS Clustering Services, SQL*Plus, Oracle SQL-Developer, TOAD