SUMMARY

• 8 years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams Enterprise Manager and Golden gate on Sun Solaris, Red Hat Linux, ETL tools, HP - UX, AIX, and Windows Platforms
• Experience in Configuring Single instance, Oracle Real Application Clusters (RAC). Expertise in Installing, configuring and tuning issues in automatic storage management (ASM) and RAC for high availability databases. noledge and working experience on Oracle 12c Databases
• Installed and configured pluggable Databases
• Migrated Databases from Oracle 11g to Oracle 12c
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and data Ware-housing.
• Excellent noledge in oracle super cluster. noledge of Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Worked on Oracle Exadata X2-2 servers
• Experience on informatica (ETL) development, batch jobs and control M
• Has implemented ORACLE STREAMS and worked on both types of standby databases supported by DATAGUARD (logical standby and physical standby).
• Worked on all kinds of backup operations using RMAN (full database, datafiles, image copies, incremental back upsets, validating), using Flash recovery area, recovery operations (block media, full database, tablespace, datafiles, control files, point in time, validating) and catalog maintenance
• Excellent noledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Performed Strategic Planning, Logical and Physical Data Modelling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for maintaining many databases together on separate servers.
• Good exposure of oracle DBA task like installation, patching, cloning and upgrade of oracle database
• 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.
• Solution with strategic disaster recovery plans with different recovery procedures and methods.
• Cloned Database from Production to Test and Development and from Development to Production.
• Experience in migration of oracle database to higher version and installing patches.
• Exporting and Importing of dumps using expdp and impdp
• Experience on handling very large database (vldb).
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities).
• SQL statement tuning using Explain Plans, SQL Trace using TKPROF utility and AUTOTRACE utility. 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sql trace utilities.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA).
• Good coordinator, understanding and presentation skills with all work departments. Work as the subject matter in the matter of performance issues, reorganization, auditing the required down times and the effect on the business application between the developers, system administration and the end clients.
• Experience as On-Call 24x7 production DBA support.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/2000, Windows

Advanced Server 2000/2003:

Databases: Oracle 12c, 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005.

Oracle Database Tools: Golden gate, SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control, ASM, SQL server RMAN, TOAD, EXPORT/IMPORT, Data Pump, Data guard, logminer, Cron tab.

Tools: & Utilities: Export/Import, RMAN, Data Pump, ERWIN, ETL, Control M

Languages: C, C++, UNIX shell scripts, PL/SQL, perl

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Wilton, CT

Oracle Database Administrator

Responsibilities:

• Working on Exadata half and quarter rack servers with 4 and 2 node database clusters to support and maintain different applications.
• Working on 10g/11g and 12c versions of Oracle databases.
• Involved in installation and maintenance of oracle 11g and 12c databases.
• Performing various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Experience in monitoring SQL performance through TOAD and OEM, AWR and ASH reports, comparing execution plans of complex parallel statements, gathering statistics of large sub-partitioned tables, identifying schema object locks and resource contentions in RAC
• Implemented ASM, Migrate Databases from non-ASM file system to ASM file system with normal redundancy and external redundancy.
• Experience using database links and multiple database instances within an application.
• Involved in supporting and maintenance of SQL server 2000/2005/2008 R2 and 2012 versions of databases.
• Responsible to maintaining SQL server 2012 4 node cluster for high availability solution.
• Using Recovery Manager (RMAN) and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Creating and managing users, roles and profiles, audited and monitored databases and user access.
• Working with developers to tune their queries for high performance and less wait time.
• Involved in Setting up OID (Oracle Internet Directory) for Single sign on feature of Oracle.
• Involved in the setting up encryption and decryption of secure data in Oracle and SQL server databases.
• Writing shell scripts to monitor data guard status, taking backup and restoring databases using RMAN and data pump utility.
• Involved in yearly Off site disaster recovery testing for major applications.
• Writing windows .bat and PowerShell script to backup databases and to monitor different audit and user settings.
• Extraction of data from different flat files into Oracle Database using SQL*Loader.

Environment: Oracle 12c/11g/10g, SQL Server 2000/2005/2008/2012 , Windows Server 2003/2008/2012 , OEM, RMAN, Data Guard, Oracle ZFS, DB2 9.7.

Confidential, Cheshire, CT

Oracle DBA

Responsibilities:

• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.
• Configured and maintained 2 node RAC cluster.
• Setting the parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and managing Undo Data.
• Carrying out EXPORT and IMPORT operations on Oracle Database using the DATAPUMP utility.
• Monitoring the performance of the database using of OEM (Oracle Enterprise Manager).
• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.
• Upgraded from Oracle 10g R2 to Oracle 11g R1 database.
• Mentored and provided oversight and backup for the production Databases.
• Installed, configured and implemented 10g Dataguard as a physical standby database.
• Developed backup and recovery strategies with the use of incremental cumulative and differential backups using RMAN
• Involved in Capacity planning meetings & operations.
• Automating the daily routine activities backups using the DBMS JOBS, DBMS SCHEDULER.
• Knowledge in oracle super cluster.
• Used Automatic Workload Repository (AWR) for analyzing the database performance.
• Use TOAD to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
• Automating the routine DBA tasks through CRON.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles for user actions .
• Used Flashback feature to return database objects to a previous state.
• Communicated with Oracle support via the Metalink in order to troubleshoot important issues.

ENVIRONMENT: Oracle 10g and 11g, RHEL 4, HP-UX, Windows 2008, Oracle Enterprise Manager - OEM, Toad, Sun Solaris

Confidential, OMAHA, NEBRASKA

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3 node RAC environment.
• Database Refresh from one version to another version.
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguarded Exadataclusters for maximum availability.
• Disaster recovery of Exadata Dataguard Physical Standby.
• Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.
• Use of RMAN for backup operations with Exadata.
• Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
• Scheduling the backups for the database using EM 12C cloud control.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the Bi-directional replication.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Daily Health Check Up of the Database using AWR, ADDM.
• Perform Daily Monitoring of Oracle Instances, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Configured and Implemented Cold/Hot Backups Also configured database cloning using RMAN.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Experience with UNIX and SQL commands.
• Managing databases on multiple servers.

Environment: Oracle 10g, 11g, Linux 4/5, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Exadata X3-2, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential, Pittsburg, PA

Sr. Database Administrator

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager
• Installed Oracle Streams for Basic and Advanced Data Replication between Oracle Databases and other databases.
• Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 later 10.2.0.4 and applying patches whenever required.
• Cloned/Refreshed Oracle Databases for development and testing
• Partitioned large tables to increase the performance.
• Performance tuning of Oracle Database Objects by fixing row chaining
• Installed and Configured Oracle Dataguard for Oracle 10g & 9i for the maintenance of Stand by database
• Extensive use of Oracle Dataguard for protection of critical production data & provide data / disaster recovery support.
• Extensively used JAVA for development and administration of various relational databases objects
• Optimization and tuning SQL queries using TRACE FILE,TKPROF,EXPLAIN PLAN Extensively used JAVA for development and administration of various relational databases objects
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK
• Tuning heavy data loads, monitoring and Performance tuning
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN
• Performed block recovery using RMAN. Performed backup validations using RMAN
• Oracle Database monitoring, troubleshoot and resolve the issues
• 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, Granting required privileges to users
• Defining and Implementation of backup and recovery strategies
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required
• Writing scripts for the system and database for effective functionality and report generation
• Applied High priority, security patches downloaded from Metalink.
• Involved in Logical and Physical database design.

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD, Solaris8/9, PUTTY

Confidential

Jr. Developer/Oracle DBA

Responsibilities:

• Installing Oracle 10g and upgraded it to latest 10g patch set on HP-UX 11.23
• Migrating applications from non-clustered oracle 8i/9i/10g databases to new
• Monitoring and supporting Applications using OEM 10g Grid Control
• Created PARTIONING of its types like Range, List & Hash by the specific use.
• Implemented Oracle Streams for Replication and applying patches
• Implemented schema level, table level and bidirectional oracle streams.
• Registering Databases to Oracle 10g GRID
• Registering Databases to RMAN Catalog
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Data pump.
• Coordinated with teammates while working with Java scripting and JSON.

Environment: Oracle 9i, ASM, Oracle 10g Grid Control, Oracle 9i, HP-UX 11.23.