Manager Oracle

PROFESSIONAL SUMMARY:

SUMMARY

Oracle **g 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/11g/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

Federal Reserve Bank of New York, NJ Feb 2016 – Current

Senior Oracle Database Administration

Federal Reserve Banks handle billions of dollars in currency each day. In the district served by the Federal Reserve Bank of New York, currency is processed at the East Rutherford Operations Center in New Jersey. Each business day, the New York Fed processes more than 19 million notes deposited by depository. Providing all oracle Environment Database system Administration support on Feds Markets Group.

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.

New York City Housing Authority (NYCHA), NY Jan 2012 - Jan 2016

Senior Oracle Database Administration

The NYCHA is committed to increasing opportunities for low- and moderate-income New Yorkers by providing safe, affordable housing and facilitating access to social and community services. More than 400,000 New Yorkers reside in NYCHA’s 334 public housing developments around the five boroughs, and another 235,000 receive subsidized rental assistance in private homes through the NYCHA-administered Section 8 Leased Housing Program and NYCHA addressing many key challenges, from preserving aging housing stock through timely maintenance and modernization of developments, to increasing resident access to a multitude of community, educational and recreational programs, as well as job readiness and training initiatives.

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.

NJTransit, Kearny, NJ Aug 2009 – Jan 2012

Oracle Database Administrator

NJ TRANSIT operates an extensive transportation system to meet the differing needs of New Jersey’s

residents, ranging from traditional bus and commuter rail to new and expanding light rail services. Njtransit also provide services for people with disabilities and for local community connectors, as well as support for privately operated transit.

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.

MTA (LIRR), Jamaica, NY Nov 2007 – Oct 2008

Oracle Database Administrator/Architecture

The MTA Long Island Rail Road is the busiest commuter railroad in North America, carrying an average of 288,000 customers each weekday on 728 daily trains. A subsidiary of New York State's Metropolitan Transportation Authority, the MTA Long Island Rail Road marked its 174th Anniversary in 2008.

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.

System Design and Responsibilities:

Using Functional Requirement Specification document to get the user requirement

to analyze, design and develop this project.

Extract the schedule information from the Train Planning Scheduling System (TPSS) and fare information from the M&R system.

Generate the routes through dbms_scheduler by weak day and weekend partitions and monitoring the cross_over train, business rules, departure and arrival timing, running date, peak hour, non-peak hour, published, non_published connection, West East Connection and Straight line Connection.

Maintained the retrieval packages with the ref_cursor to retrieve the routes between departure and arrival station for IVR/Agent/Web application with different time frame.

Maintained and implemented new train, train@stop, station and branch special messages, which includes bus indicators and IVR messages.

Implemented the business logic for shea program on event (game) day.

Implemented separate schema for first, second and third connection of suppression logic.

Using Shell script to write call data loading package to routines for the interim and final tables.

The C2S and C2P process to copy trillions of data to final (SFPUBLIC) environment for customer performance.

Monitoring the Copy to production table’s data and routes combination

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.

Leviton Manufacturing, Nassau County, NY Oct 2004 – Oct 2007

Oracle Database Administrator/Architecture

ISO9001 Company. Leviton was founded in 1906 to manufacture a single product: tip mantles for gaslights. Since then, the company has become a leading North American producer of electrical and electronic products.

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.

Perfect Technology Solutions, India May 1997 - Aug 2002

Oracle Database Administrator/Database Developer

Perfect Technology Solutions is a full-service specialty-staffing firm providing flexible and permanent staffing solutions for hiring organizations and career management in the specialty skill areas of Information Technology, Finance and Accounting and Pharmaceutical. I supported their own project Materials Management Systems as well as Finance and Leasing System (FIS) belong User: Saravana Finance Limited. This project deals with various deposit modules, loan modules and hire purchase.

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

EDUCATION

Post Graduate Diploma in Computer Science and Application, India - 1997

Bachelors of Science from Bharathi Dasan University, Tamil Nadu, India - 1996

CERTIFICATIONS/TRAINING

Oracle Database 11g Administrator Certified Professional (OCP-DBA)

Oracle Database 10g Administrator Certified Professional (OCP-DBA)

Oracle 10g Forms Developer Certified Professional (OCP-Developer)

Successfully completed Training in oracle 11g RAC and Grid Infrastructure Administration Accelerated Release 2.

Successfully completed Training in Oracle10g Database Performance Tuning from Oracle.

Java Sun Certified Programmer.

Contact this candidate