SUMMARY

• Having 8+ years of experience in Oracle Database Administration on various database platforms from 12c/11g/10g and 9i. I have worked on database tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, backup and recovery, cloning, auditing, SQL, PL/SQL.
• Working knowledge on Oracle Exadata X2 - 2 Servers.
• Experience in using Golden Gate to support data replication in the Oracle database environment.
• Experience in upgrading Golden Gate from v9.5 to v10.4 and from v10.4 to v11.1.
• Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.
• Used parameters to configure, install and manage ASM instance in 11g RAC.
• Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Experience in Installation, Configuration and Maintenance of Oracle 12c/11g/10g RAC with ASM and single instance database.
• Experience in maintenance of Production, Testing, Development, RAC, Standby databases/ Dataguard.
• Configuration and Management of Data Guard on RHEL and OEL.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and Cluster Interconnect Tuning (RAC).
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Managed Oracle and SQL server in High Availability environments using Failover, Clustering, Mirroring, Dataguard and Cloning technologies.
• Support& troubleshoot Oracle streams.
• Installed 10g Grid agent on servers and configure OEM, Grid control.
• Experience in database full Backup (hot and cold), Incomplete Backup, DataPump Export/Import, SQL Backtrack and Restore procedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Expertise in Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle EBS Database and Application Tiers.
• Oracle Database Administration in a variety of environments like Oracle Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL.
• Experience in installing, maintaining, upgrading and patching Oracle versions 11g/10g/9i.
• Migrated database from 9i, 10g, 11g to 12c by using Scripts and applied patches by Opatch utility.
• Experience in tuning the database using AWR, STATSPACK, ADDM Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Experience in using oracle Streams for replication of database.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, and Recycle Bin.
• Experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Experience of Auditing, Oracle Security, OEM13c and TOAD.
• Experience in Very Large Multi-Terabyte Database (VLDB) and performed migrations in this environment.
• Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
• Documented all Oracle database installations and database operations.
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i, RAC 11g/10g

Operating System: Linux, HP-UX 11/11i, Sun Solaris, AIX and Windows NT/2003/2008R2/Windows 7/windows 8/Windows 10

Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting

Tools: /Utilities: SQL*Loader, DataPump (Export/Import), OEM13c, RAC, RMAN, TOAD, AWR, ADDM, STATSPACK, TKPROF, Oracle Grid Control, Log Miner.

PROFESSIONAL EXPERIENCE

Confidential, Bloomfield, CT

Sr. Oracle DBA

Responsibilities:

• Responsible for both managing and supporting all Production, Development, Stage instances of Oracle Version 10g, 11g, 12c databases.
• Creating 11g databases on 11g databases on Exadata machine. RAC database /EXADATA maintenance such as patching/disk replacement/support hardware failure/repair/performance issues.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate. Managing and setting up the configuration of GoldenGate Director
• Architect GoldenGate (10.x and 11.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments, DDL replication using Golden Gate
• Worked on cloning instances from production to dev and stage environments.
• Responsible for testing the behavior of 11gR2 RAC database using Veritas cluster file system.
• Working collaboratively with teammates across the technical teams.
• Installed and managed 11gR2 RAC database and 10g Database R 2 10.2.0.5 11 g Grid Control
• Provided support to setup Dataguard and Dataguard Broker on development and test environments.
• Worked with application team and performance team to help them tune their queries.
• Worked extensively on Enterprise Manager (Doing Blackouts, Adjusting Thresholds etc)
• Set and document standards for use of databases to use Data guard in Maximum availability mode.
• Building Clone instances for Development and Test teams.
• Develop custom utilities to automate manually intensive tasks including mass schema changes.
• Responsible for applying CPU patches on most of the production databases.
• Extensively worked on configuring OEM grid control agent on new servers, registering new databases in 11g OEM13c Grid Control and automated RMAN and datapump backups in 10g/11g OEM Grid Control
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
• Responsible for implementing Veritas cluster file system on LINUX OS and 11gR2 database in the production and Test environment
• Managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup’s logs and alert logs.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, tablespaces and other database objects.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Creating table spaces, tables, indexes, users, etc.
• Enrolled users and maintain system security and integrity, ensuring compliance with database license agreements
• Controlling and monitoring user access to the database. Monitoring Rollback Segments.
• Importing of dumps using impdp/expdp utilities.
• Provide technical assistance to all internal/ external customers and team members during system problems and implementation.
• Provided 24x7on call support for all the production and development Oracle databases.

Environment: Oracle 12c,11g,10g, 9i, RAC, 13C OEM, RMAN, Data Guard, TOAD 12.1, DBArtisan UNIX, Linux 6.0,AIX, ASM, RMAN, Exadata, Golden Gate, Apex, PATROL

Confidential, MN

Oracle DBA

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Upgrade of database from 10.2.0.4 to 11.1.0.6 by applying patches using Opatch utility.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, Grid Monitoring.
• Experience with Oracle Applications R12
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Cloned database for test environment.
• Administering Real Application Cluster (RAC) databases running on Cluster File system.
• Migrated database objects from database to other server by using Export/Import, Datapump.
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup’s logs and alert logs
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and use datapump jobs for loading the subscriber and history related data at replicated site.
• Database Capacity Planning & configuration (redo and stream sizes), design staging schema and use of DBMS STREAM ADM packages.
• Handful of experience with ERWIN tool for data modeling.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Applied patches and database re-organization using oracle enterprise manager (OEM).
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• System wide tuning using UTLBSTAT and UTLESTAT (stat pack).
• Maintained Very Large Multi Terabyte (VLDB) around 14TB+ in Data Warehouse Environment for DSS.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, roles, user management, and maintenance.
• Load data from OLTP systems into data warehouse databases.
• Documentation of Oracle database operations and training of backup personnel.
• 24x7 on-call production database support.

Environment: ORACLE 9i/10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11,AIX 5,Toad, SQL, PL/SQL, ERWIN, Dataguard, DataPump, OEM, RMAN, SQL*Loader, Streams, Shell Scripting, SQL Server, Data Warehouse, OLTP, Oracle Application R12.

Confidential

Oracle DBA

Responsibilities:

• Installed, Created and maintained 2 Node 10g RAC with ASM and created database for production, development and test environment on HP-UX platform.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Migration of Database from 9.2.0.6 to 10.2.0.2 (RAC)
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp).
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g.
• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX servers using IOSTAT, NETSTAT, VMSTAT, TOPAS and PRSTAT.
• Applying upgrade patches, maintenance and interim patches on all the databases
• Designed physical and logical database structures and created, managed Tablespaces.
• Applied High priority patches downloaded from Metalink.
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Gathering schema stats and monitoring the index usage.
• Documented backup and recovery plans and tuning procedures.

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, Red Hat Linux 4.x, HP-UX 11, Windows 2003, AIX, Data Warehouse, ERWin, Netbackup, OEM, SQL*Loader, Grid Control, RMAN, ASM, Dataguard, TOAD, Datapump.

Confidential

Oracle Administrator

Responsibilities:

• Installing Oracle 9i/10g RAC on AIX and RHEL creating database for production, development and test environments.
• Assisting developers and 24*7 production database supports.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN, Complete and incomplete recovery of database
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Migration of database from 9i to 10g in the production and development.
• Performed SQL query optimization by gathering statistics and by using explain plan, STATSPACK, TKPROF and SQL Trace.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g RMAN’s New Features and Data guard(stand by database)
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
• Used RMAN for Cloning of the creating database in test and development environment.
• Performed migration of database with Export, Import, Datapump and SQL*Loader jobs.
• Periodically uploading data from flat files using SQL*Loader
• Monitoring production systems to establish status and conduct proactive maintenance
• Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
• Online index rebuilds. Controlling and monitoring user access to the database. Monitoring Rollback Segments.
• Estimation and creation of Control file, Log file (including multiplexing), Data files, Tablespaces and rollback segments.

Environment: Oracle 10g/9i/ RHEL, IBM-AIX, Windows NT, RMAN, Datapump, SQL, PL/SQL, exp/imp, TOAD, SQL*Loader.