Oracle Data

Bramhanand Lingala

Email: *****.*******@*****.***

Phone: 603-***-****

Executive Summary

Bramhanand has over 10 years of experience in IT Industry as an Oracle Core and Application DBA specializing in Golden Gate, RAC, Data Guard, ASM, RMAN, EBS R12, and OBIEE.

Good level of experience in installation/upgrade/patching, configuration of oracle RAC environments (10g/11g/12c) and administration of the cluster environments.

Support includes routine DBA tasks such as database upgrades, migrations, refreshes, clones backup and recovery of full and partial databases using RMAN, implementation and support for database availability performance tuning of SQL and PL/SQL code, system and database performance tuning of database environments.

Extensive experience on Golden Gate Implementation, configure, maintain, trouble shoot, and upgrade of golden gate environments.

Support Oracle applications e-business suite (EBS) 11i and R12 installations, Upgrade, configuration, cloning, security, patching, upgrades and maintenance using AD and other utilities.

Integration of Oracle EBS environment with golden gate and OBIEE for Data Ware House environment setup, worked on OBIEE (Business Intelligence tools) related activities for DAC, Informatics and RPD.

Project Experience

Working as Oracle ADBA

Role: Oracle ADBA

Client: AT&T (US)

Duration: Oct 2015 – Present

Golden Gate implementation for server migrations from Solaris to Linux

Implementation of Golden Gate with unidirectional using source as data file to target oracle DB table

Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.

Troubleshoot Golden Gate issues related extracts, replication lag, Tran data, mapping issues etc.

Configure capture, extract and replicate process for Golden Gate

Proficiency in implement, build, setup Golden Gate environments.

DBA Support for 12c/11g/10g RAC Multi Node configurations

Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.

Planned and implemented Oracle RAC 10g, 11g, 12c and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).

Experience in upgrading the RAC databases 10g/11g and

Migration of the tables spaces using transportable table spaces, logical backup and recovery using export/import, and data pump utilities.

Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).

Installed and configured oracle Grid control and deployed agent on managed targets.

Worked as Oracle Core and EBS Apps DBA.

Role: Senior DBA

Client: Leighton Contractors (Australia)

Duration: Apr 2012 – July 2015

Implementation of Golden Gate with unidirectional and bi-directional model.

Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.

Custom object Setup for OBIEE in the Golden Gate replication

Troubleshoot Golden Gate issues related extracts, replication lag, Tran data, mapping issues etc.

Configure capture, extract and replicate process for Golden Gate

Monthly Golden Gate environment refreshes /setup activities for the test and pre-production environments

Proficiency in implement, build, setup Golden Gate environments.

Integration of EBS/Golden Gate with OBIEE for reporting purposes

OBIEE support for DAC, Informatics, RPD re-instantiation and Fusion Middle configurations.

Production DBA Support for 11g/10g RAC Multi Node configurations

Implementation and configuration of Oracle GOLDEN GATE.

Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild.

Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.

Setup and configure RAC environments 10g/11g/12c

Upgrade RAC environments 10g/11g/12c

Planned and implemented Oracle RAC 10g, 11g, 12C and Standby Databases (Data Guard) for High availability

and Disaster Recovery (DR).

Experience in upgrading the RAC databases 10g/11g/12c and

Migration of the databases using transportable database, table spaces export/import and data pump utilities.

Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).

Installed and configured oracle Grid control and deployed agent on managed targets.

Good experience with Oracle grid control, Oracle enterprise manager (OEM), ASM, AWR, ADDM,

Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.

Migrate non-RAC to RAC EBS database

Implemented OEM 11g/12c

As Oracle EBS Apps DBA:

Support Oracle applications e-business suite (EBS) 11i, R12 and R12.2 installations, configuration, cloning, security, patching, upgrades and maintenance using AD and other utilities.

Migrate customizations from previous release.

Utilize extensive experience in applying patches through adop.

Work with experience in applying patches on FMW products.

Perform with good experience in refreshing R12.2 instances - single node and multi-node.

Interact closely with system administrators, developers, technology stack team and server tech team.

Implement 11g/12C OEM grid.

Execute Oracle EBS administration and monthly clones and support on day-to-day critical activities.

Employer: Convergys Information Services, - Duration - May 2005 – Apr 2012

Worked for different clients below and provided support simultaneously as primary and secondary DBA.

Role: DBA Analyst Lead

Infinys – Duration May 2005 to Oct 2007

Clients:

Cricket – Duration Jul 2007 to April 2012

NTelos – Duration June 2007 to April 2012

Duke – Duration May 2007 to April 2012

AWCC – Duration Aug 2009 to April 2012

Assisting the team lead in managing, leading the analysts on the database team as well as managing the team workload in order to achieve an effective, useful and versatile database environment.

Coordinate with DBMS vendor support services regarding database problems and issues.

Configuration, Setup, Design, Install & Implementation of Oracle 10g Grid/10g RAC,ASM,RMAN / 11g/10g RAC (Real Application Clusters)

Implemented Golden gate unidirectional replication on RAC using ACFS file system.

Implemented 11g Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.

Monitored Golden gate using 11g Golden gate Plugin and shell scripts for alerting GG process down alerts.

Create, configure and Upgrade databases 10g/11g

Experience with multiple facets of Data Guard including logical, physical, Active DG

Coordinate requests of server resources with the server Systems Administration teams.

Install, configure, and test database and database related software patches, packages, and new releases.

Perform and maintain database backups, recovery, and refreshes.

Coordinate with Application Development/Production Support teams on creating and maintaining user access, roles, and privileges.

Manage and maintain database architecture including DR database replication and backups.

Used Erwin tool for Designing database objects

Ability to multi-task and balance the different paces of development and support for multiple applications in support mode and projects in flight in providing application DBA services.

Strong understanding of application and infrastructure technologies.

Performance Tuning: Experienced in identifying poor performing SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE and OEM Grid Monitoring.

Worked on transportation of Table spaces, Data archival, Re-organization of tables and restoration.

Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.

Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottlenecks. Provide technical direction to system administrators for tuning.

Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.

Employer: Mahindra British Telecom, Pune, India

Associate (Developer & DBA)

Client: British Telecom

Duration - Aug 2004 – May 2005

Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.

Granted resources, privileges and roles to users

Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization

Wrote Audit programs for data consistency check and validation

Automated SQL*Loader to load the data from the flat files

Used Materialized Views, Packages and Dynamic SQL

Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables

Tested and modified codes for quality

Certifications

Oracle Certified Associate, 10g

ITIL Foundation Certified

Education

MBA (Systems) from S. K. University, India, Duration 1998-2000

Technologies

Databases: Oracle 9i, 10g, 11g and 12c

Operating Systems: Red Hat Linux, HP-UX, Sun Solaris

Middle ware: Oracle Web Logic Server, Oracle SOA, AIA, PIPs, OBIEE, Web tier

Web Server: OHS, IIS, Apache, Tomcat

Monitoring tools: 11g EM/12cEM/ Fog light

Languages: SQL, PL/SQL, C, Shell Scripting.

Utilities: Golden Gate, RMAN, ASM, Oracle Grid Control, Data Guard, SQL*Loader, EXP, IMP, Data pump, SQL developer, VERITAS Net Backup, APEX

Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, AD Tools, Pl / Sql Developer, putty.

ERP: Oracle Apps 11i, R1213, R12.2, SAP

Contact this candidate