Manager Oracle

Location:

Alpharetta, GA, 30005

Salary:

120K

Posted:

June 06, 2012

Contact this candidate

Resume:

Operations Manager - ITIS

Cognizant Technology Solutions

Summary:

• Experience in Oracle database administration, Consulting and support of several

• Oracle products including Real Application Clusters (RAC), Dataguard, RDBMS and

• Enterprise manager / Grid Control with Oracle Corp

• Oracle Certified Master (OCM) in Oracle 10g,

• Oracle Certified Expert in RAC and Managing Oracle on Linux

• Experienced in the Installation, Administration and Upgrade of RAC databases.

• Expert in RAC and Single Instance Performance Tuning and SQL Query tuning.

• Experienced in Database Migrations and Upgrades (8i , 9i & 10g ) as well as migrations of the Oracle database across platforms.

• Advanced level knowledge of replication technologies : Golden Gate, Advanced Replication.

• Lead and Support DBA teams for nearly 5 years

• Worked on Production, Development, Test and Large databases with database sizes in several terabytes and hundreds of users with high number of concurrent transactions for several Fortune 500 companies.

• Bachelor of Engineering (B.Tech.) in Computer Science and Engineering and Masters in Computer Science( M.S ) in Software Systems.

• Experience in System administration on Solaris, Linux and Windows with

• good working knowledge of AIX, HP-UX and HP Tru64

• Experience in Scripting using shell, sql and plsql.

Technical Skills:

• Operating Systems - Linux ( Red Hat, Suse), Solaris 8/9/10, Free BSD, HP-UX 11i, AIX 5L, Win 9x, Win2k, Windows 2003 Server

• Databases - Oracle Real Application Cluster (RAC) Databases 9i /10g, Single Instance Databases 8i / 9i / 10gR2 / 11g, MySql

• Tools - Oracle 10g Grid Control / 10g DB Console, Oracle Enterprise Manager 9i, Toad

• Languages - SQL, PL/Sql, C, C++

• Web Programs - HTML, DHTML, JavaScript

Professional Experience:

Cognizant Technology Solutions

E-trade Financial

Oracle DBA lead

May 2010 – Till Date

Responsibilities:

• Lead a team of 5 DBAs in developing and standardizing Oracle High availability architecture.

• Develop automated procedures for centralized deployment of Oracle products.

• Develop automated procedures for centralized deployment of Oracle Patches.

• Migrate databases from Sybase to Oracle providing Superior performance and availability.

• Migrate databases from Veritas file systems to ASM in RAC and Non RAC environments.

• Design, Develop and automate Backup and Restore procedures using RMAN.

• Perform stress tests on RAC databases using swing bench and scripts and identify break points

• Develop Active Dataguard based DR solution, confirming to an application swing time of one minute.

Cognizant Technology Solutions

Emdeon

Operations Manager ITIS

Apr 2009 – Apr 2010

Responsibilities:

• Lead a team of 7 DBAs to administer 250 databases of which 70 are production databases.

• Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine tuned them. Tuned ETL process of data warehouse databases to reduce load time. Worked with application developers on SQL tuning.

• Periodically clone multi-terabyte databases to QA and UAT.

• Design and developed alerting mechanism for several databases using Shell scripting, Netcool monitoring and Grid control.

• Resolved several production issues in mission critical databases and restore service within Emdeon’s SLA.

• Scheduled and executed several planned maintenance operations like Patching, upgrading , redesigning (denormalizing , partitioning etc)

• Restored databases using RMAN to fix corruption and storage issues.

• Support Dataguard based DR sites and Replication ( Golden Gate and Advanced Replication) based DR sites.

• Schedule on-call rotation shifts, allocate tasks to DBAs and monitor progress. Report progress of Projects and support activities to client management.

• Effectively manage a team of Oracle DBAs in addition to the above technical activities to deliver expected Service to the client.

Environment: Oracle versions /8.1.x/9i/10g/11g including RAC, Data guard, Replication, Sun Solaris, IBM AIX, Redhat Linux, Windows, ASM, CRS, OCFS, Raw devices, JFS, CFS, ext2, ext3, AdvFs, NFS, FAT, NTFS, GPFS, Plsql, SQL, C, Shell scripting, Oracle Enterprise manager 1.x /2.x /9.x /4.0 /10g, Grid Control, Toad, EMC.

Everest Consulting Group

Client: Emdeon Corporation

Oracle DBA Lead

May 2008 – Apr 2009

Responsibilities and Contributions:

• Lead a team of 7 DBAs to administer 250 databases of which 70 are production databases.

• Periodically clone multi-terabyte databases to QA and UAT.

• Design and developed alerting mechanism for several databases using Shell scripting, Netcool monitoring and Grid control.

• Resolved several production issues in mission critical databases and restore service within Emdeon’s SLA.

• Scheduled and executed several planned maintenance operations like Patching, upgrading , redesigning (denormalizing , partitioning etc)

• Restored databases using RMAN to fix corruption and storage issues.

• Schedule on-call rotation shifts, allocate tasks to DBAs and monitor progress. Report progress of Projects and support activities to client management.

• Mentored and on-boarded two new DBAs in team.

Client: Iappz Solutions Inc, Hoffman Estates , IL

Senior Oracle DBA

Feb 2008 – May 2008

Responsibilities and Contributions:

• Design and Develop high availability Database solution based on Oracle Real Application Cluster.

• Install Software and configure Oracle CRS Cluster on San storage.

• Deploy Oracle Application 11i database on this cluster.

• Device backup policies and maintenance tasks for application databases.

• Setup up monitoring strategy using cron jobs and shell scripting.

• Install ASM for storage management and configure for data storage.

• Performance tuning of backend database of Oracle Apps to provide maximum application performance.

Client: Oracle India Pvt LTD

Senior Software Engineer ( Sr. Oracle DBA)

Jan 2005 – Feb 2008

The role involves working as part of customer focused teams like Product / Premium Support and Consulting. It also involves the Installation, Administration, Maintenance and Tuning of Oracle Single Instance and Clustered databases (8i, 9i and 10gR2) in Development / Production environments, configuring Oracle DataGuard for Disaster Recovery of the Production databases and performing planned and unplanned switchovers – failovers, Configuring ASM for use with both RAC and Single Instance databases, Database Migrations to the latest versions and Upgrades to the latest patchsets, patching the databases using Opatch , Identifying and resolving database corruptions and Internal errors and performance tuning.

Client list included online trading companies like Amazon and Ebay, entertainment media like ESPN, Financial and banking institutions like Fidelity, Capital One, Duetsche Bank, HSBC, Royal Bank of Scotland, ICICI Bank and Citibank, Postal companies like UPS, Airlines like Boeing and Qantas, IT majors like Cisco, HP, Sun, Dell and SAP, Telecom sector companies like Vodafone, AT&T, Bharti Mobile, BT, Korea Telecom and China Telecom, Car majors like Ford and Williams, Manufacturing and other majors like General Electric, Goldman Sachs, EDS, Xerox, Lucent, Posco, Agilent and TI

Responsibilities and Contributions:

• As a member of the Global product support (GPS) wing of Oracle, the primary responsibilty is to support production critical databases of customers worldwide.

• Primary competencies include Oracle internal errors, general DBA issues, Database corruptions, backup and recovery, performance tuning (query and instance).

• Secondary competencies: Network related errors, High availability.

• Handles 60-70 critical production-down database failures a month.

• Mentored several new joinees in team.

• Have extensive experience in handling database production down issues. Several production down cases are handled every month.

• Worked on various architectures such as Oracle Parallel Server (OPS), Real application Clusters (RAC), HA, Multi-threaded Server (MTS), data warehousing and Replicated databases.

• Physical database administration experience includes database creation, cloning of databases, moving data between databases and schemas in the same database, Oracle utilities (Export and Import), SQL*Loader.

• Performance tuning of Oracle Server as well as SQL statement tuning. Monitoring database to watch performance (hit ratios, waits, and locks) as well as tuned SQL statements (traced SQL statements, explain plan on the SQL, recommendations to reduce cost). Substantial performance gains were achieved as a result of tuning efforts.

• I was part of the 11g beta support program. Underwent inhouse training in Oracle 11g new features. Have experience working on 11g.

• Gained expert level kowledge of general DBA activities like:

• Unix administration skills

• Oracle Installation and configuration of

• Single instance DB

• RAC

• Data Guard

• Rman Repository

• Advanced Replication & Streams

• Patching, migration and upgradation

• Performance monitoring and tuning

• Storage and User management

• Data loading, exporting and salvaging

• Backup and recovery

• Various database corruptions

Environment: Oracle versions 7.x/8.0.x/8.1.x/9i/10g/11g including RAC, Sun Solaris, HP-UX, IBM AIX, United Linux, Redhat, Suse Linux, Windows, ASM, CRS, OCFS, Raw devices, JFS, CFS, ext2, ext3, AdvFs, NFS, FAT, NTFS, GPFS, Plsql, SQL, C, Shell scripting, Oracle Enterprise manager 1.x /2.x /9.x /4.0 /10g, Grid Control, Toad, Netapp.

Client: Vaman Technologies R&D LTD

Junior Software Engineer

Oct 2003 till Dec 2004

Responsibilities and Contributions:

• A member of the Core Technical Committee of Vaman.

• Improving query performace by cost reduction.

• Generating cost information for queries and populate in fixed views.

• Worked on generating a query plan from the optimizer similar to the ‘explain plan’ feature of Oracle

• Achived signifacance performance improvement in tuning the kernel as well as the Network Agent.

• Assisted two new employs in implementing MPI in Vaman.

Environment: Oracle versions 8.1.x/9i including RAC, Sun Solaris, HP-UX, IBM AIX, United Linux, Redhat, Suse Linux, Windows, oracm, OCFS, Raw devices, SQL, C, Shell scripting,c,c++,sqlserver

Client: Media Computer Services, Muscat, Oman

System Analyst

Mar 2003 till Sep 2003

Responsibilities and Contributions:

• Troubleshooting network and hardware.

• Maintaining in-house win2000 network with 40+ clients and 2 servers.

• Configuring and trouble shooting client’s networks

• Installing new networks at client sites

• Configuring client routers

• Also provides training for employs in resource handling in the network at client sites.

Client: Nascent Technologies

System Administrator

Sep 2002 till Feb 2003

Responsibilities included:

• Installation and configuration for Domain controllers & member services in Multiple 2000 Domain Infrastructure

• Adding static DNS entries and monitoring critical 2000 services

• Provide primary support for windows 2000 environment including DHCP, DNS & creation of windows 2000 accounts

• Internet related activities for the organization, installed and configured CISCO router with lease line and connecting it to the Intel switch, assisted in VPN, monitoring and maintenance of WAN links.

• Designed and built standardized development environment. Created backup, deployment and monitoring process to all development services, LAN and WAN.

Education and Certifications:

• Master’s Degree in Software Systems.

• Bachelor’s Degree in Computer Science and Engineering.

• Oracle Certified Master (OCM - DBA) in Oracle 10g.

• Oracle Certified Expert on RAC and Managing Oracle on Linux.

• Oracle Certified Professional in Oracle 9i.

Contact this candidate