Senior Oracle Dba

Sankar Natarajan

Summary

Oracle Certified DBA (OCP 9i and 10g). Oracle 10g RAC Certified

Experience in handling very large database, Data Warehousing databases / applications.

Project Manager supporting a team of 20+ members working on various technologies.

Experience with installing and configuring database backup using hot backup scripts, RMAN, Sql Backtrack.

Proficient with Oracle DBA activities like installation, configuration and migration. Physical database design, backup and recovery of Oracle databases and shell scripting.

Experience in configuring and setting up Data Guard, Standby database and trouble shooting.

Good knowledge of ASM, Oracle streams, and RAC databases

Excellent problem solving skills, good analytical and learning skills.

Experience in tuning and troubleshooting sql statements using Explain plan, tkprof.

Provided 24x7 support for mission critical database.

Worked on software conversion project, database migration, debugged Pro C programs, redeveloped reports using Oracle Reports 2.5.

Worked on database upgrades Oracle 6,7.x, 8i,9i,10g,11g,12c

Full project life cycle experience, problem solving analytical aptitude, strong technical skills, excellent client management/people management/consulting skills, attitude for teamwork

Education /Certification:

Oracle Certified Professional (OCP Oracle 9i,10g, Oracle 10g RAC)

Bachelor’s Degree in Engineering, University of Bangalore, INDIA

Technical Skills

Oracle DBA 12c GoldenGate

Oracle Stream, GoldenGate Director

Linux, Solaris, Aix

Oracle DBA 11g,10g,9i,8i,8,7,6

Solaris, HP-UX, AIX, Linux

UNIX Scripting, Korn Shell

Real Application Clusters (RAC)

Data Guard (Standby DB)

Advanced Replication

24x7 Production Monitoring

Infrastructure Setup, Deployment

Development Lifecycle

Oracle Wait Interface, tkprof, DBMS_XPLAN, utlxpls

Statspack, Automatic Workload Repository/AWR, SQL Tuning

utlbtat/utlestat, Active Session History (ASH)

SQL Plus, SQL*Loader

Export, Import, RMAN

Windows NT, Win9x, DOS

Oracle 12c Cloud Control / OEM Grid / Database Control

Oracle Enterprise Manager

Toad, svrmgrl

Legato Storage Manager (LSM)

Tivoli Storage Manager (TSM)

SQL Backtrack, DR Planning

ASM, Raw Devices, RAID Technologies

Logical Volume Manager (LVM)

Veritas Volume Manager Sun Cluster 3.0

Sun E6500, E5500

Sun Ultra 2 Enterprise

Pentium Based HP, COMPAQ

MY SQL, SQL Server 2000, 2005, 2008

UNIX, PL/SQL, Pro*C Solaris sysadmin, Sco admin

Professional Experience:

New York ISO Jan 2023 - Till date

The New York Independent System Operator (NYISO) is a not-for-profit corporation responsible for operating the state’s bulk electricity grid, administering New York’s competitive wholesale electricity markets, conducting comprehensive long-term planning for the state’s electric power system, and advancing the technological infrastructure of the electric system serving the Empire State.

Installed and configured Oracle GoldenGate 19c for real-time data replication across critical systems, ensuring high availability and data consistency.

Troubleshot and resolved complex replication issues, including lag monitoring and data conflict resolution, minimizing downtime and ensuring seamless operations.

Configured and deployed Oracle Enterprise Manager (OEM) 13c for centralized database monitoring and management, improving system performance oversight.

Integrated the GoldenGate Plug-in into OEM 13c to monitor replication metrics such as lag, throughput, and status, providing actionable insights and improving system reliability.

Documented GoldenGate and OEM configurations, troubleshooting procedures, and replication strategies to improve team knowledge sharing and operational efficiency.

Installed and configured SQL Server 2016, setup High availability.

Performance tunning, AWR report, ASH report, Automatic Database Diagnostic Monitor (ADDM)

Configured and managed SQL Server 2016 instances, ensuring optimal performance and reliability.

Applied the latest SQL Server service packs and cumulative updates, maintaining system security and compliance with organizational standards.

Designed, implemented, and managed Always On Availability Groups for high availability and disaster recovery, ensuring minimal downtime and seamless failover capabilities.

Conducted pre- and post-upgrade testing to validate database compatibility and system stability.

Monitored and resolved performance bottlenecks using tools such as SQL Server Management Studio (SSMS) and Performance Monitor.

Documented database configurations, HA/DR strategies, and patch application processes to improve team knowledge and operational efficiency.

Environment : Oracle19c,18c, 12c AIX, Linux, Oracle Cloud control 13c, NetBackup, SQL Server 2016,2022

Department Of Health, Albany, NY August 2013 – Jan 2023

Oracle DBA

ITS to provide centralized IT services to the State and its governmental entities with the awareness that our citizens are reliant on those services. ITS set statewide technology policy for all state government agencies and monitor all large technology expenditures in the state, seeking efficiencies, lower costs and innovative solutions. Department functions and responsibilities include: promoting and supervising public health activities throughout New York State; ensuring high quality medical care in a sound and cost-effective manner for all residents; reducing infectious diseases measures in conjunction with the New York State Office of Homeland Security. As part of this mission, the Department works with the State’s health care community to ensure appropriate readiness and response to potential health threats.

Responsibilities:

Setup Oracle 12c Grid infrastructure installation on Red Hat Linux and Aix.

Set up Oracle Dataguard, configure multiple standby, perform switchover

Setup, configure database high availability using Dataguard brooker

Setup, monitor, troubleshoot GoldenGate to replication from Sybase and Oracle database.

Implemented Oracle 12c Cloud control.

Installation of Oracle GoldenGate director to monitor replication.

Configured OEM 12c GoldenGate-Plugin to monitor GoldenGate.

Setup metrics, thresholds, rman backups, apply patch, install 12c agent.

Trouble shoot GoldenGate configuration issues, replication issues, implemented new GoldenGate features.

Oracle database upgrades from 10g,11g,12c,19c.

Monitor, optimize and allocate physical data storage for database systems.

Query tuning, optimize query, tkprof, awr, ash report.

Configure Weblogic 12c, 11 versions.

Configured Sibel plugins on Oracle 12c cloud control, defining thresholds, setting up alerts, configure Sibel repository.

Maintain Logic and physical standby, maintain clusterware, trouble shoot RAC issues.

Monitor SQL server 2005, SQL server 2008, performance tuning, database administration using Management studio.

Installation of Oracle 12c Grid infrastructure, creation of pluggable database, setup RMAN backup.

Environment : Oracle Exadata, Oracle 19c,18c, 12c,11g, 10g, AIX, Linux, Oracle Cloud control12c,OEM, Siebel, WebLogic 12c, 11g, GoldGate Director 12.1.2, SQL Server 2005, SQL Server 2008, CommVault, TSM

CIGNA Corporation, Raleigh, NC January 2013 – Aug 2013

Oracle DBA Expert

Cigna one of the largest health service companies in the US market. Cigna has more than 70 million customer relationships worldwide having headquarters in Bloomfield, Connecticut. Cigna operating subsidiaries provide an integrated suite of medical, dental, behavioral health, pharmacy and vision care benefits, as well as group and individual life, accident and disability insurance, to millions of people throughout the United States and around the world.

Responsibilities:

Project manager leading a team of 17 members.

Oracle RAC 11g R2 installation.

Data Modeling using Erwin.

Monitor database growth performance tuning.

Physical design, storage.

Configure TAF, apply database patch.

Gathering application requirement, support various application releases.

Manage ETL solutions for Datawarehouse project, ETL application analysis, design, developments and implementation.

Developing ETL object interface, packages, procedures and load strategies relational types and dimension using Oracle Data Integrator.

Using Oracle Data integrator to migrate data from various source and targets including database flat files and XML files.

Interacting with Infrastructure team at various level to establish proxy, configure ports for offshore support.

Environment: Oracle 11g, OWB 11g, ODI, RHEL, OEM, ERWIN, shell script, RAD 8, Websphere, JBOSS

CMA, Albany, NY June 2011 – December 2012

Senior Oracle DBA

CMA a leading IT consultancy service based in New York. This project is being developed for NYSDOH Medicaid Data Warehouse Replacement & OHIP Data Mart Operational support. The New York State Department of Health (NYSDOH) has begun the implementation of a vision for an enhanced Medicaid Information Service Center for New York. This vision entails a robust technical architecture, a flexible, dynamic data delivery infrastructure, and an analytical reporting environment that will support the evolving needs of the Medicaid program for the State. Building a new Medicaid Data Warehouse (MDW) based on the functionality and features as required by NYSDOH.

Responsibilities:

Oracle 11G RAC installation of ASM, configure CRS, VIp using vipca utility.

Implementation of 11 G Oracle Grid infrastructures, adding node to RAC instance.

Team lead for a team of 7 members.

Table reorg, rebuild index, and optimize query performance.

Creation of shell script to purge alert logs, trace files using adrci utility

Critical patch installation.

Monitor, optimize and allocate physical data storage for database systems.

Develop, implement and maintain change control, monitor application testing identify key performance bottlenecks and suggest improvement.

Create Data model using Erwin, add / modify changes to existing data models.

Supported OBIEE with OBI Publisher and Hyperion for Datawarehouse databases.

Creation recovery catalog, scheduling backup using Oracle Data Integrator.

Configuring DB2 gateway implantation of Oracle Golden Gate to migrate data from DB@ to Oracle11.

Configuration of OID, implementation of TAF

Shell script to monitor File system, cleanup of alert logs, and installation of Oracle Grid control.

Oracle Database Upgrade from Oracle 11.2.0.1 to Oracle 11.2.0.2.

Environment: Oracle 11g, 10g, AIX, Linux, Oracle Business Intelligence Publisher 11g,Oracle Grid control, OEM, OBIEE 11g, Hyperion, Oracle BI Publisher 11g, ERWIN, VIPCA, adrci, shell script

Wells Fargo, West Des Moines, IA October 2010 – May 2011

Senior Oracle DBA

One of the largest banks in the US, Wells Fargo has about 6,600 branches in 40 states and more than 4000 mortgages and consumer finance offices nationwide. Activities include retail, commercial, and corporate banking; investment management; insurance; equipment leasing; and venture capital investment. A top residential mortgage lender in the US, Wells Fargo is also one of the largest mortgage servicers. The company owns Wells Fargo Insurance Services, one of the world's largest insurance brokerage firms.

Responsibilities:

Supporting and troubleshooting RAC databases on the Linux RedHat and AIX platforms.

Oracle installation and configuration of 10G RAC on Linux platform. Configured VMWARE with Oracle 10g RAC.

Installed Redhat Linux configured ASM.

Senior DBA and Design architecture in project dedicated to design and implementation of CORE application.

Strong Data Modeling experience. Experience using modeling tools using ERWIN, Eclipse

Performance tuning application.

Oracle streams setup for ETL data replication jobs.

Created oracle11g R2(11.2.0.1) database and tested active standby database/data guard before moving to production for high-level data availability

Migration of Oracle database from Oracle 9i to Oracle 10g using Golden Gate.

Daily maintenance/Performance Tuning

RMAN, data pump, export, cold Backup and Restore/Recovery, capacity planning, database design.

Environment: Oracle 8i, 10g, 11g, Golden Gate, Oracle Streams, Linux, AIX, RAC, ETL, Eclipse, xml.

Century Link, Overland Park, Kansas City, KS September 2009 – September 2010

Senior Oracle DBA

Century Link is a leading provider of high-quality broadband, entertainment and voice services over its advanced communications networks to consumers and businesses in 33 states. CenturyLink, headquartered in Monroe, La., is an S&P 500 company and is included among the Fortune 500 list of America's largest corporations.

Responsibilities:

Project Manager handling a team of 20+ members supporting different technologies.

Provided RAC High availability cluster and single-instance database administration/support to 800+ Oracle 8i, 9i and 10g databases on the Linux RedHat AS/SuSe (64-bit) and Solaris platforms. Responsibilities included capacity planning, database design, database creation, performance tuning, data retention, and RMAN backup/recovery/disaster recovery for Oracle9i/10g database, for database size ranging from 100GB to 1TB.

Installed, maintained production/development/test databases (8i/8i/10g/11g)

Installed, maintained and upgraded 2 production databases on two node Oracle10g RAC clustered servers on Linux using ASM/OCFS2/asmlib/rawdeveices/SAN storage

Upgraded databases from Oracle 8i and 9i to 10.2.0.1 version to Oracle 10.2.0.4 version

Performed ongoing tuning of the database instances and SQL statements.

Migrated database from oracle 8i/Solaris to oracle 10g/Linux

Setup processes/procedures for DBA’s to maintain environment

Created oracle11g R2(11.2.0.1) database and tested active standby database/data guard before moving to production for high-level data availability

Daily maintenance/Performance Tuning

RMAN, data pump, export, cold Backup and Restore/Recovery

Project Lead for architecting and implementing Oracle 10g RAC on Linux

Adding and removing node on existing RAC setup.

Installed / Configure Oracle 10g Grid monitoring system.

AWR report setup on all production database along with ADDM and collect histograms and adhoc queries.

Environment: Oracle 9i, 10g, 11g, Sql Server 2005, 2008, My SQL 5.x, AIX, Sun Solaris, Data Warehousing, Linux, RAC, Data Guard, Sql Backtrack, ETL

Department of Work and Pension, UK September 2008 – September 2009

Senior Oracle DBA

DWP has the country’s Labor Market System dealing with the unemployment having various other systems like EDON (Employer’s Direct Online) Employer feed job vacancy in the system, IJB (Internet Job Banking) job seeker can search the database directly.

Responsibilities:

24x7 production support proving support to critical database.

Involved in database designs, creating backup and recovery procedures, cloning database.

The work involves extensive interaction with the Development, Testing and Support team

Applying database patches, developing UNIX shell scripts, monitoring database, optimizing database performance.

Database cloning using RMAN. Configured RMAN backups,

Performed application tuning and performance monitoring.

Performed database upgrade from Oracle 9.2.0.6 to 10.2.0.4.

Monitoring database activities, checking for tablespace growth, interacting with application team, gathering application requirements, providing support to different application releases.

Installation of security and cpu patches.

Environment: Oracle 9i, 10g, AIX, HP-UX, Linux, OEM, Toad, ERWIN

Sprint Nextel, USA July 2004 – September 2008

Oracle DBA

Worked as a part of Data Management team handling over 200 Oracle instances, providing support to critical databases.

Responsibilities:

Team lead handling team size of 15+ team members.

Providing assistance to junior Oracle DBA during On Call support and daily activity.

Oracle 10g RAC, ASM, CRS implementation on AIX

Data Guard, Standby database, Log Miner, Oracle Advanced Queuing, 10g streams

Configuring database backup using SQL Backtrack and RMAN.

Cloning database using SQL Backtrack and export utility.

Implementing SQL Backtrack, cloning database, database upgrades.

Database cloning using Sql Backtrack.

Performed database recovery using SQL Backtrack.

Performed capacity planning and resized database accordingly.

Involved in maintenance and trouble shooting of RAC databases, use of Enterprise Grid control

Environment: Oracle 9i, 10g, 11g, ASM, Data Guard, Solaris, Siebel, OEM, AIX, Linux

Xerox Rochester, USA June 2002 – June 2004

Oracle DBA

Asset Center Management is a system designed to raise trouble tickets for hardware and software problem though a front end Peregrine application. All trouble tickets are raised though this application for the entire country.

Responsibilities:

Part of a team of 2 Oracle DBAS providing 24x7 support throughout the year.

Involved in capacity planning and resource planning. Provided documentation as well as training on process and procedures for infrastructure architecture

As part of the project archiving data for each quarter.

Writing scripts to archive data, reduced downtime during data archival, automated data archival process.

Creating shell scripts, automating file transfer, recovery procedures.

Installed and configured Oracle 9i, performed database upgrades.

Automating file transfer using SQL loader.

Perform database reorganization as required to assist performance and maximum uptime of the database

Environment: Oracle 8i, 9i, 10g, Aix, Sql Loader, Shell script

Contact this candidate