SUMMARY:

• Oracle 10g and11g DBA Certified Professional (OCP).
• More than 12+ years of professional experience in Oracle DBA (12C/11g/10g/9i/8i/7x) having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation in UNIX, AIX, Sun Solaris, Windows 2000/NT, Exadata Linux high - availability environments.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments and experienced full life cycle of Production, Development, UAT and QA databases administration in Oracle.
• Experienced in Installing and configuring ASM and Oracle 11gR2/10g RAC for high availability databases.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), SQL Profiles, SQL TRACE, TKPROF and Explain Plan.
• Expertise in design, development, implementation of Enterprise Data Warehouse, Data Modeling, Data Marts, Data Mining, Operational Data Stores, Metadata Transformation and Client Server applications.
• Extensive knowledge on ORACLE Databases administration 10g, 11g of sizes ranging from 200GB to 5TB.
• Experienced of Oracle Golden Gate (GG) installation, configuration and troubleshooting Golden Gate Extract and Replicat issues.
• Having good experience in configuring Grid OEM 12C cloud control and Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications.
• Experienced in Database design including creation, modification, and deletion of tablespaces, data-files, rollback segments and schema's, creating schemas (Tables, Indexes, views, sequences, synonyms, roles, and users).
• Strong team player, team leader, implemented projects independently, commitment towards learning, posses excellent communication, project management, documentation, training, and interpersonal skills in Finance, Transportation, Software, Engineering and Construction Industries in both government and private sectors.

TECHNICAL SKILLS:

RDBMS: Oracle 7.x/8i/ 9.2.0/10.2.0/11 g/12C RAC, Oracle OEM 10/11g/12c, Sybase 11.9.2, SQL*Loader, MS Access 7.0,, SQL Server 2000, Informix, and DB2.

Applications: Oracle Siebel 8.1, Apex 4.1, Maximo 6.5.1 and Primavera 6.2

Business Intelligence Tools: Oracle Reports 6i/9i/10g, Oracle Discoverer 4.1

Data Warehouse/ETL Tools: Warehouse Builder, Informatica Powercenter 8.1, Microsoft Visio 6.0, SQL Navigator 4.x, EZ-SQL 2.9, Toad 9.1/8.6, PL/SQL Developer 7.1 and SQL Developer.

Oracle CASE Tools: Designer 6i/9i.

Hardware and Servers: Dell Work Stations, IBM PC Compatibles, Pentium PCs, Citrix Server, and Windows Terminal Server, High End Sun Servers.

Operating System: Windows 2000 Server/Professional/Vista, Sun Solaris 11 UNIX (AIX, SUN, SCO), SUSE Linux (9 &10), MS DOS, Windows 95, 98, Windows NT/XP/Vista.

User Interfaces: Forms 6i, 5.0, & 4.5 Visual Basic 6.0 & 5.0, ActiveX, COM/DCOM.

Backup Tools: VERITAS, TSM, Tivoli/Omni.

Web Servers/ Technologies: IBM WebSphere 7.0, Oracle 9i/10g/11g AS, Weblogic 11g/12c, Oracle Report Server, Web Logic 5.10, HTML, DHTML, VB Script, Java Script, JSP, ASP, IIS, FTP, JRUN, Reflection and J2EE.

Languages: SQL, PL/SQL & SQL*Plus, Java 2.0, C and Pro* C.

Scripts: PL/SQL, Perl, UNIX Shell.

Other Tools: PVCS Tracker, PVCS Version Manager.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior Oracle Database Administration

Responsibilities:

• Serving as a senior DBA, ensuring and maintaining QA and prod environment databases, objects, application/database wallet and client installation design meet FRB business requirements, implemented unified Audit in all databases environment with Oracle Label security Policies to restrict certain user access, contributing my time creating, monitoring and maintaing oracle 11g and 12c databases, Capacity Planning, Space Management, Backup & Recovery, and Database/Memory/Application Performance tunning.
• Involving on maintaining and Implementing various high availablility and Disaster Recovery technologies 11g and 12c databases including RAC (Real Application Cluster), DataGuard, Golden Gate and grid control on QA and Production databases in Sun Solaris and Linux Environments.
• Projects Highlight: Participate with DE design and creation of CAPS database 12c (QA and PROD) from the scratch using oracle clusterware two node Real Application Cluster environment (RAC) with ASM, especially CAPS History database implementing through the cascade standby database 11g software installation, setup and configuration in 12c servers for a 1tb caps history 11g database and then upgrade database to 12c and then unplug and plug in to the 12c container.
• Refreshing Oracle databases/Object/Schema time to time basis via RMAN duplication or Data Pump QA and Production environments based on the user request from Federal Reserve Bank's market group.
• Extensive experience in Grid Clude Control Oracle Enterprise Manager (OEM) installation and configuration 10g,11g and 12c versions. Download the Grid Agent in OMS server and install in lot of QA and Prod Servers. Monitoring/Maintaining/Managing OEM in all QA and prod databases.
• Proficient knowledge in SQL, PL/SQL, stored procedure, function, grants and triggers optimization. Working with business groups, developers to design, implement table/index partition strategies for performance, data archiving and purging task to roll out new projects
• Participate every quarter applying Oracle CPU, PSU, Bug fixing, JDBC and JDK latest PATCHES from Oracle in DEV, QA and PROD environments in order to keeping the database upto date. shutdown and startup Cron Jobs, Golden Gate replication, OEM agent before and after patches.
• Responsible for setting and managing user accounts, granting proper required privileges with single signon SSO (12c databases) to users based on MACS and JIRA requests on time. Solve conflict and missing user accounts with MACS.
• Upgrade numerous oracle database 11g to 12c using dbua/manual oracle methods and also participating all 11g databases migrated to 12c pdbs.
• Involve implement and enhance database backup RMAN, Datapump and Manuel traditional hot/cold backup and recoveries. Managing RMAN backup scripts, scheduled jobs, monitored, maintained, troubleshoot backups via NetBackup 6.5 policies, Created cron automated backup, purging and sent email status summary reports.

Environment: Sunsolaris, Linux, Oracle 11g/12c databases, Oracle Recovery Manager (RMAN), Flashback, Data Pump, Grid Control Oracle Enterprise Manager 12c, Oracle RAC11/12C, ASM,, Datawarehouse/CAPS/OPICS/Fedtrade/RST/PQS/EMB/SEMB/Informatica/GTX/SPOT/COFFER/FIRCO/Apex applications, Unix Shell Programming, Golden Gate 12.2,SQL Developer, MACS and JIRA.

Confidential , NY

Senior Oracle Database Administration

Responsibilities:

• 24x7 Production database administration (Oracle 10g,11g and12C), support and monitoring to ensure a proactive problem recognition and resolution of database issues on Unix servers (Solaris, Linux and Exadata).
• Responsible for in Oracle Installations 10g/11g/12c, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.
• Extensively used and setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Lead DBA role in 10gR2 to 11gR2 database upgrades on multiple production database simultaneously.
• Performed Schema as well as Table level Replication and Disaster Recovery solution using the Oracle Golden Gate.
• Installation of Oracle RAC 11gR2/10g four Node with ASM File systems and Managing Cluster (OCR and Voting Disk) and RAC (SRVCTL) Environment efficiently. igration 50% of production database from Solaris to Linux exadata.
• Responsible for Daily Health Check of the Databases, ensuring all production successful (periodical) Backups and troubleshooting query issues and recommend proper index, execution plan & profile using Performance & tuning tools such as ASH, AWR, TKPROF and sql tunning advisor.
• Have good experience in database creation in oracle 12c using multiple PDBs.
• RMAN database cloning to same/different server.
• Participation in design reviews for upcoming application enhancements, provide on-call support and day-to-day support for all Siebel/Maximo/Apex/primavera applications problem (non prod and prod databases environment).
• Expert with OEM Grid 12c Control.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability
• Simulation of production database transaction in test environment using Oracle Record and Replay (RAT) when performance problems.
• Writing Unix Shell Scripting for running scheduled backups (using datapump /cold backups), and make Disk space and job done alert.
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
• Developing and Implementing Disaster Recovery (DR) Plan (perform every year DR plan at DR location and documented modifed scripts for all production databases).

Environment: Sunsolaris, Linux, Oracle 10g/11g/12C, ASM. Exadata x3, Oracle Recovery Manager (RMAN), Grid Control 11g,OEM Cloud Control 12c, Weblogic 11g, IBM WebSphere 7.0, Apex 4.1,Oracle RAC11gr2, Golden Gate 11gr2, Unix Shell Programming, Warehouse Builder, Maximo/Siebel/Primavera/Apex application, XML Publisher Report.

Confidential, Kearny, NJ

Oracle Database Administrator

Responsibilities:

• Installed and configure oracle 10g, 11g RAC databases on Linux, Solaris, exadata and Windows based servers of Oracle database server and clients.
• Involved in 24x7 Oracle production Database Administration.
• Performed up gradation of databases from lower version (10g) to higher version(11g).
• Installed and implemented 2, 3 nodes cluster for Test and Production environment.
• Configured ASM disk groups to store Data files, redolog files, and control files.
• Created (Data guard) physical standby database for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.
• Writing Unix Shell scripting for automating tasks and alert jobs.
• Provide and implemented RMAN backup strategy with retention policy of 35 days to keep the latest 2 days backupsets on disk and move rest of the backupsets to tape.
• Extensive monitoring dev1, feb, host and roc databases and using Data Pump expdp/impdp or BCV or RMAN to clone/refresh Schema, database from Production to Test and Development Environment.
• Upgraded databases from 10g to 11g.
• Experience with Oracle Golden Gate software.Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performed recovery from missing or corrupted data files, redo log group, control files and recovery from block corruption (dbverify) .
• Monitored production database using automatic workload repository (AWR) and automatic database diagnostic monitor (ADDM) .
• Analyze and monitor wait events on production databases to implement improvements for buffer busy waits/sequential & scattered read contentions.
• Timely monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.
• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommending solutions for faster execution.
• Strong knowledge of PL/SQL code optimization, and assistiance to developers for tunning scripts.
• Reviewing and resizing conspicuously over allocated tablespaces (wherever possible) thus improving the time-frame for cold backups.
• Improved DW performance by implementing advanced Oracle Data Warehousing features: Materialized Views, Partitioning, External Tables, Dimensions, Parallel Execution, Table and Index Compression, Star Schema, Rely Constraints, and Change Data Capture.
• Monitoring alerts and checking database free space, allocating and maintaining free space for optimal Database performance.

Environment: Sun Solaris/Linux/Windows, Exadata, Oracle 10g/11g RAC, ASM, Golden Gate 11g, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Dataguard.

Confidential, Jamaica, NY

Oracle Database Administrator/Architecture

Responsibilities:

• Installing and Managing Oracle 9i, 10g & 11g Database on Linux, AIX and Solaris operating system.
• Installed & managed 10g R3 OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Data refresh from production to test and development.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups Plan growth and changes, capacity planning.
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practices
• Setting up new Development & Production environments.
• Automation of Startup Shutdown on all Production and Development Database
• Tune the SGA components like buffer cache, shared pool to avoid paging & swapping hence reducing I/O bottle-necks in 9i, 10g environment.
• Reviewing and resizing redo logs (wherever possible) to reduce the redo log space requests and ensuring multiplexing/mirroring of members.
• Tablespace and object reorganization to remove the fragmentation.

Environment: AIX, Windows, Oracle 9i/10g/11g, Oracle Recovery Manager, Oracle Enterprise Manager, Oracle Dataguard, EXP/IMP, PL/SQL using PL/SQL Developer 7.1 and TOAD 9.1, perl, SQL*Loader, Warehouse Builder, Oracle Report, XML Publisher Report, Erwin, PVCS, Oracle ADF.

Confidential, Nassau County, NY

Oracle Database Administrator/Architecture

Responsibilities:

• Oracle DBA support including installations, configurations, backup/restore & recoveries, database performance tuning, tuning applications, database monitoring & operating system configurations, assisting in the logical and physical database and providing general support to developers.
• Performed the RMAN complete recovery, tablespace recovery, datafile recovery, controlfile recovery, online redo log file recovery.
• Creation and maintenance of test schema.
• Advanced performance tuning techniques using Oracle wait interface.
• Oracle replication (advanced replication, materialized views etc).
• Configured and maintenance Oracle Data guard for production database and standby database support.
• Devising various solution methodology, process definitions, job management, execution plans etc.
• DBA script created and maintained in the DBA share folder.
• Database connectivity (tnsnames, listener, database links, synonym etc.).
• Database user and role administration.
• Oracle database performance tuning using statspack, explain plan, tkprof and OEM.
• Design and implement DB security, user management
• Maintain and Monitored Perl, SQL and PL/SQL automation schedule jobs
• High availability, 24/7, Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Suggested and documented PL/SQL tables (Nested and Index-By tables) and VARRAYs with BULK BINDS and BULK COLLECTS.
• Monitoring alerts and Checking database free space, allocating and maintaining free space for optimal Database performance.
• Experience in Siebel Administration & Management (System & Application) and Production Support including deployment and migration activities from Development through Testing in Production environment.

Environment: Oracle 9i and 10g, Oracle Siebel CRM 8.0, SQL, PL/SQL, SQL*Loader, perl, Oracle Enterprise Manager, Oracle Recover Manager, Report 10g, Warehouse Builder, XML Publisher, Windows NT, Sun Solaris, Oracle 10g AS, Erwin, PVCS Version Manager, CVS Version Manager.

Confidential

Oracle Database Administrator/Database Developer

System Design and Development Responsibilities:

• Daily house keeping activities like checking database growth and taking appropriate actions for capacity management
• Created the physical and logical data model using Erwin
• Ensuring availability of all tablespaces and data files
• Managing various kinds of backup and Recovery Issues, online backup and offline backup
• Maintain data security by creating views, DB owners/users and granting/revoking permissions and roles.
• Monitoring the Database for growth and add space to the table spaces.
• Cloning of the production database to the test and development for testing and development purpose.
• Monitor, tune, size, backup, recover, analyze, defrag, migrate
• Use of libraries, triggers, and built-ins, complex program units (functions, procedures) to implement business logic.
• Involving in the testing.
• Using EXPLAIN plan utility to analyze the cost involved in query processing and tune it for faster retrieval.
• Data extraction, loading and manipulating using SQL*Loader, Export/Import utilities using direct and conventional paths.
• Monitoring Alert log and background trace files for warning, alerts and error messages.
• Writing back end objects like stored procedures, functions, anonymous blocks, triggers, views using PL/SQL.
• Using parameterized / non-parameterized explicit and implicit cursors, UTL file functionality on PL/SQL blocks.
• Writing exception handling routines to trap error codes / messages on PL/SQL blocks.

  Writing scheduled scripts/batch procedures for database backups.

• Using PVCS Version Manager for version management of the codes.
• Using Oracle Warehouse builder to mapping the Source to Target and improve the performance.

Environment: The project was developed using Oracle 7.3,8i, RMAN, Oracle Designer 2000, SQL, PL/SQL, SQL*Loader, Developer 2000, Discoverer 4.1, Windows NT, Sun Solaris, IIS, J2EE ( JAVA, JSP, JDBC, HTML, DHTML Forms 4.5, Reports 2.5 & PL/SQL on Pentium & PC