Manager Oracle

Summary:

Over * years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security.

Over 8 yrs. of experience as an Oracle DBA on production / stage /development environment.

Installation, patching, updates, configuration maintenance of Oracle 10g RAC, 11g RAC, Standby Databases (Data Guard).

Created development, testing, staging, production, RAC and standby databases.

Management of schemas, objects & Partitioning the tables & indexes.

Development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.

Proactive Monitoring, identifying areas that need to be improved in the database using Stats pack, AWR, ADDM and OEM Grid Monitoring.

Experienced in using Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.

Experience in cloning the oracle homes and upgrades.

Working experience on database 10g, 11g upgrades.

Experienced in user management, roles, profiles and centralized user management using OVD, LDAP and OID architecture.

Experienced in Hot/Cold Backup and Recovery and Cloning of databases.

Experienced in Backups and Recovery and Cloning of databases using RMAN.

Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning.

Planned and implemented Disaster Recovery & high availability solutions using Oracle Standby Database.

Experience in installation of OEM12c.

Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Stats pack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, buffer cache, redo mechanisms.

Experienced in using golden gate for data replication.

Experienced in Oracle Support processes for technical requests through Metal ink and other Support Procedures

Experience in golden gate maintenance, installation and troubleshooting.

Migrating databases from physical disks to ASM related disks.

Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, OLAP, Backup and Recovery procedures.

Experienced in database migration across platforms using transportable table spaces and RMAN.

Good written and verbal communication skills with a customer service oriented attitude.

Excellent Communications and Presentation skills

RDBMS

Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2005 and Oracle Applications 11.5.10.2 and R12.1.1,Vertica

OPERATING SYSTEMS

HP-UX 10.x, 11, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

LANGUAGES

SQL, PL/SQL, T-SQL, MYSQL, C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS

DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Cluster ware, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

Professional Experience:

8X8,Inc Sanjose,CA Oct’14 – present

Sr.Oracle database consultant

8x8 hosted VoIP communications free companies from the burdens of outmoded on-premises systems that thwart productivity and drain profits. Flexible, scalable cloud solutions combine ease of use and management simplicity with rigorous security, compliance and reliability.

Responsibilities:

Handling mission critical databases on cluster 24x7 environment.

Building active data guard as high availability disaster recovery solution for Production databases.

Maintaining unidirectional golden gate replication b/w source and target databases.

Configuring and troubleshooting cron jobs for RMAN backups, monitoring for alert log errors, batch jobs and export jobs.

Installed OEM12c and Monitoring mission critical business databases.

Administer data on both OLTP and OLAP databases.

Implementing OVD architecture for the centralized user managed using LDAP and OID.

Providing solutions to various ora errors.

Doing monthly database refresh according to request.

Creating new databases for developers.

Doing table level, schema level refreshes.

Providing monthly tenant storage usage reports for various cluster databases and anticipating usage growth.

Handling Performance issues at application level and database level.

Applying regular quarterly CPU patches and keeping the databases up to date with the Oracle security updates.

Providing support to 10g RAC databases.

Rolling patching and upgrades of 10gRAC databases.

Upgrading the databases from 9i to 10g.

Cloning the Oracle home and upgrades.

Creating health monitoring UNIX shell scripts.

Trouble shooting the user access issues.

Creating User profiles, roles.

Working closely with the application teams on scheduling the patching windows.

Cloning the databases regularly for the reporting databases and stage environments.

Tuning the database level performance issues.

Taking AWR reports and analyzing them periodically for better performance.

Creating Backup schedules and taking periodic backups both offline and online using RMAN.

Participating in corporate DR drills and ensuring the data protection.

Working with Oracle on critical database bug/issues.

Creating partitions for partitioned tables periodically.

Managing materialized views and refreshes.

Creating DB links to heterogeneous environments for the data warehouse.

Periodic index management, index rebuilding.

Doing code deployments on production according request after approvals.

Investigating and providing solutions to long running queries.

Creating new schema and assigning privileges on database.

Investigating various diagnostic reports like stats pack, Awr repots to improve performance.

Providing support to 10g/11g RAC, databases.

Established master-master replication and master slave replication between various MySQL servers.

Environment: Red Hat Linux, Oracle 9i/10g, Oracle Enterprise Manager, RMAN, 10G, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008.

BIAS Corporation, Atlanta GA Aug’12 – Sep’14

Sr.Oracle database consultant

BIAS Corporation is one of Oracle's elite Platinum partners specializing in design, implementation, and maintenance of comprehensive IT solutions for some of the world’s leading organizations.

Responsibilities:

Responsible for administration and supporting Oracle 9i, 10g and 11g databases.

Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 .

Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation

Installation, Upgrade and Configuration of Oracle (8i, 9i, and 10g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 10g and worked on ASM.

Involved in designing of disaster recovery using Data Guard, High Availability using RAC.

Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings

Configuration, maintenance and tuning of Oracle 10gRAC.

Installing and configuring Recovery Manager (RMAN) and Flash Recovery.

Performance Tuning, Memory (SGA) Tuning, RMAN backup

Cloning databases using scripts as well as RMAN.

Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.

Utilized oracle golden gate replication to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.

Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets.

Oracle replication using Golden gate and active data guard.

Partitioning large objects to improve the performance and manageability

Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.

Used Active Data guard makes a read-only replication of a given database.

Security User Management, Privileges, Role, Auditing, Profiling, Authentication.

Advanced security management configurations like OVD, OID and LDAP for the centralized user access management

Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager's (OEM's), Oracle cost based optimizer, SQL analyzer, top session, top SQL, Performance Manager, Stats pack. For SQL tuning using "Explain plan", "TKPROF", "SQL_TRACE", Optimizer modes, using Optimizer hints, Gathering statistics, Stats pack.

Create database maintenance plans, including updating statistics, rebuilding indexes, structure modifications, Capacity plans, and index analysis.

Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.

Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side.

Writing scripts for backup and recovery, Import and export procedure.

Environment: Red Hat Linux, Windows 2000/2003, Oracle 9i/10g, Oracle Enterprise Manager, RMAN, 10G, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008.

Hitachi consulting’s,GA Aug’10 - Jun’12

Sr.Oracle DBA

Responsibilities:

Handling Oracle performance related issues at instance level and SQL level for enterprise data warehouse.

Finding the right materialized view refresh techniques using explain_mview, tune_mview procedures.

Working with the partitions.

Tuning the Oracle instance, SGA components, DB files etc.

Tuning the PL/SQL code.

Tuning at the object level including tables, indexes, views etc.

Generating AWR report and analyzing the top events and other

Generating ADDM reports.

Providing support to 10g/11g RAC, databases.

Taking the Stats Pack reports

Analyzing the trace files using TKPROF.

Tuning the SQLs with different optimizers ( 9i,10g )

Suggesting to developers on effective SQL writing

Upgrading oracle binaries from lower versions to higher versions (9i/10g/11g).

Providing on-call support during the crucial periods.

Co-coordinating with the UNIX team, developer, application support and DBA team.

Taking AWR reports and analyzing them periodically for better performance.

Creating Backup schedules and taking periodic backups both offline and online using RMAN

Participating in corporate DR drills and ensuring the data protection.

Working with Oracle on critical database bug/issues.

Creating process documents for the DBA activities and making sure that team adhere to the process outlined.

Golden gate installation, maintenance.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export / Import utilities.

Maintaining stringent response / resolution SLAs.

Creating partitions for partitioned tables periodically.

Managing materialized views and refreshes

Creating DB links.

Periodic index management, index rebuilding.

Environment: Oracle 11g/Oracle 10g, ASM, RAC Oracle App Ser/Mid-Tier, Oracle Gateway, Discoverer, Rman, SQL, PLSQL, Shell, Shell, Awk.

Sierra Atlantic, Hyderabad, India Sep’09 - Jul’10

Oracle DBA/ Application DBA consultant

Responsibilities

Install Configure and upgrade of Oracle Databases.

Design and implementation of backup and recovery strategy using RMAN.

Table space and Storage Management.

10g RAC Design/Installation/Configuration/Support.

Disaster recovery using Standby database and Database cloning.

Monitoring database health by scheduling shell scripts through cron jobs.

Creation of Database, Table spaces and Schemas.

Designing Logical and Physical Layout of the databases.

Implementation of Oracle Advanced replication environment and mechanism.

Patch application working with AD utilities- ad patch, adadmin, admerge, adctrl, adclone.

Enforcing data integrity constraints on the tables in accordance with data model.

Performance tuning of SQL statements using ‘Explain Plan’, SQL Trace and Tkprof.

Creating snapshots, database links that are required for distributed databases.

Rebuild index for better performance.

Coordinated with Oracle Corp for technical issues.

Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.

Monitoring Index Usage.

Administration of 10g Data Guard for high availability.

Involved in design and implementation of the data warehouse.

Monitoring daily refresh of reporting databases.

Responsible for the scheduling of the batch programs.

Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.

Involved with installation and maintenance of ORACLE 10g RAC database for high availability.

Environment: Oracle 9i/10G on AIX/Sun Solaris/Linux/Windows

Bank of India, Mumbai, India Feb’07 - Nov’09

Oracle DBA Consultant

Bank of India (BOI) is commercial bank with headquarters in Mumbai, Maharashtra, India. Founded in 1906, it has been government-owned since nationalization in 1969. Bank of India has 4545 branches as on 31 December 2013, including 54 branches outside India. BoI is a founder member of SWIFT (Society for Worldwide Inter Bank Financial Telecommunications), which facilitates provision of cost-effective financial processing and communication services.

Responsibilities:

Handling high availability (24/7) database in onshore-offsite model

Handling Performance issues.

Applying regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates

Creating health monitoring Unix shell scripts

Scheduling the health scripts using cron tab, mailx.

Trouble shooting the user access issues.

Creating User profiles, roles.

Working with the development team on DBA issues.

Application support functions

Application issue trouble shooting,

Collecting the requirements

Analyzing the requirements

Testing the updates.

Environment: Oracle Applications, and Oracle 10g, 9i, Sun OS, IBM-AIX, Linux.

EDUCATION

Bachelors in mathematics from AcharyaNagarjunaUniversity, Guntur, AP completed in 2006.

Masters in computer applications pursued from Osmania University, Hyderabad.

Contact this candidate