Resume

Sign in

Oracle DBA

Location:
United States
Posted:
October 19, 2016

Contact this candidate

Resume:

Bhanu Pathuri

Sr. Oracle Database Administrator

Email: acw47z@r.postjobfree.com

Ph. 912-***-****

Summary:

8+ years of experience in Oracle Database Administration, Design & Development, Implementation and Testing of Relational Database Management systems for Business solutions Extensive experience in database development and production system support, Oracle Database Administration on 24x7 critical production and large databases using Oracle 12cRAC,11gRAC, 10g RAC and 12c Standalone database.

•Providing DBA support to multipleCluster, Non-cluster and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments.

•Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU) in various environment ranging from 9i/10g/11g/12c.

•Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c database with experience within very large scale database environment and mission critical large OLTP and OLAP systems.

•Having Hands on experience working in both Application and Production support environment.

•Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.

•Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c, Configuration and Management of Data Guard 10g/11g/12c on RHEL, OEL and Sun-Solaris for Disaster Recovery.

•Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g/12c.

•Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.

•Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.

•Extensive troubleshooting of typical Oracle Golden gate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / logdump/discard file & ggserr.log analysis.

•Created documentation, design and implemented rich user interfaces using Oracle Apex.

•Performed Upgradation of databases from lower version (9i/10g) to higher version (11g).

•Implemented RMAN Backup and Recovery, Incomplete Recovery and disaster recovery using Data Guard.

•Have good experience in migrating data from Solaris, HP-Unix to Linux.

•Worked on 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.

•System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.

•Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.

•Knowledge of various storage solutions (SAN, NAS).

•Database refresh from production to QA, development and testing environments.

•Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.

•Analyzed STATSPACK/AWR Reports to identify on-going/proactive issues and Proactive Database tuning to keep hit ratios at a minimum standard guideline using STATSPACK and AWR reports.

•Support databases in Exadata environment and worked on Exadata x3-2, x4-2, x2-2 machines

•Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.

•Performing Database or schema level refreshes using the traditional EXPORT/IMPORT and Data pump or Backup utilities.

•Experience in SQL Tuning, SQL Optimization, cost based optimization and Hints.

•Set and tune System Parameters for MongoDB and Optimizing MongoDB CRUD Operations.

•Add / remove replica and shard nodes in MongoDB Cluster as needed.

•Setting up MongoDB Profiling to get slow queries.

•Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

•Extensively used BMC Remedy, Pac 2000 ticketing systems.

•Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching.

•Good analytical and problem solving skills with ability to work independently and in a team environment.

TECHNICAL SKILLS:

Operating Systems

Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.x,

Sun Solaris 9.0/10.0, AIX 5.1, 5.2, windows xp /2003/2008

Data Bases

Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC),

ASM, MySQL, SQL SERVER 2008/2012

Languages

SQL, PL/SQL, UNIX Shell Scripting

Tools/

Utilities

RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import,

RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET,

ODBC, Export/Import, Data pump, Data-Guard, Erwin, OEL,OID, Log-miner, APEX

MS Visio, VERITAS Net Backup, BMC remedy, Pac 2000, VMware, Crontab

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation

Putty, Telnet, FTP, TOAD

Work Experience:

Wilson Bank & Trust, Hermitage, TN Duration: July 14 –Till Date

Oracle Database Administrator

Responsibilities:

•Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Clusterware, Oracle 12c two node RAC for the database tier.

•Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.

•Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.

•Created ASM volumes using asmca and Created ACFS for GoldenGate v12.

•Installed GoldenGate on 12c RAC ACFS Configured Integrated Extract and Replicat on Multitenant database 12.1.0.2 and Performed Cross platform migration and used Oracle GoldenGate to migrate database from IBM-AIX 6.1 to OEL 6.1.

•Configured Bidirectional Oracle Golden Gate replication Active/Active across various sites.

•Configured Extract and Replicate pumps for GoldenGate replication 11g/12c and Troubleshooting issues in GoldenGate Environment.

•Used Logdump Utility to Investigate data on the trail and defgen to create definition files used for replication.

•Performed Zero-Down Time migration from Hp-Unix to Oracle Enterprise Linux using Expdp and Golden Gate and Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

•Used OEM 11g/12c and Administering Oracle Database 10g, 11g and 12c databases and masking sensitive data in production databases.

•Creating physical and logical database design Data Models using Erwin Tool.

•Generation of DDL scripts using Erwin Tools.

•Patching & upgrades on Oracle 12c database (whilst minimizing or eliminating the impact to live services, i.e. using rolling node patching).

•Created Oracle Apex Application from Scratch.

•Developed and maintained operational and system level documentation. Developed applications using Oracle Application Express (APEX).

•Created documentation, design and implemented rich user interfaces using Oracle Apex.

•Worked on x3-2 and x5-2 database machines.

•Setup multiple 11gR2 Active Data Guards on Exadata database machines.

•Provide and implement performance tuning recommendations of all components in EXAdata database machine.

•Provide guidance and develop Disaster Recovery strategies for the EXAdata Database machine.

•Upgraded databases from 11.2.0.4 to 12c in QA and Prod environments.

•Worked on Oracle Enterprise Manager Express for Oracle 12c RAC standard.

•Working with logical backup using Data pump and Exports/Imports Utility.

•Database Load and Transformation Techniques (SQL Loader, External Tables).

•Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries and Cloned databases using RMAN Utility.

•Installation and use of Oracle ASM (as well as traditional file system storage).

•Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.

•Creation of Users and granting them the required Roles and Privileges accordingly.

•Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between oracle servers.

•Installed and configured Oracle 12c WebLogic server and Oracle 12c HTTP servers for the application tier and web tier.

•Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Environment: Oracle 12c, RHEL 5/6, OEM, RMAN, Grid, Dataguard, ACFS, RAC, ASM, GoldenGate, TOAD, APEX, SQL*LOADER, Performance Tuning, Data pumps, Exports/Imports

Renaissance Venture Capital Fund, Ann Arbor, MI Duration: Dec 12 - June 14

Oracle DBA

Responsibilities:

•Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure.

•Administered and monitored over 120 databases both on 10g/11g on prod/test/dev environments.

•Administering Oracle Databases 10g/11g/12c of sizes ranging from 100GB to 10TB.

•Migrated databases from File-system to Automatic Storage Management (ASM).

•Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.

•Up-gradation of single instance databases from 11.2.0.1 to 11.2.0.3 on Linux.

•Responsible for using Flashback querymechanism along with automatic undo management.

•Experience in Creating Physical and logical database design Data Models using ER Studio.

•Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases

•Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.

•Implemented Data Guard with maximum availability and performance configurations for production databases.

•Worked on Active data guard, Fail over and Switch over cases.

•Hands on Experience in SQL Tuning and SQL Optimization.

•Created Oracle Tables, Table Partitions, Views, and Materialized Views.

•Worked on database security, Transparent Data Encryption, Created tables with Encrypted Columns and Managed Encryption Keys

•Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation.

•Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.

•Creation of Users and granting them the required Roles and Privileges accordingly

•Cloned schemas, objects and data on new server using Data pump utility

•Decreased Contention by reducing the Wait Events as a part of Performance Tuning

•Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions& data dictionary corruptions

•Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.

•Responsible for all database activities such as User management, space management, databasesecurity management, rollback segments& creation of DB links between oracle servers

•Ability to work effectively and can liaise as a part of team monitoring proactively

Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g, 11g, RHEL 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, TOAD, TDE, SQL*LOADER, Performance Tuning, AWR, ADDM, ASH, Data pumps, Exports/Imports

Starbucks, Seattle, WA Duration: Oct 11 – Nov 12

Oracle Database Administrator

Responsibilities:

•Involved with Installation and maintenance of Oracle 3 node RAC for high availability.

•Involved in change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.

•Worked extensively onmonitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control.

•Involved in migrating applications from single instance databases to Exadata.

•Maintained 10g/11g RAC environment and troubleshooting issues.

•Responsible for implementing Load Balancing in RAC Database.

•Performed health checks in RAC instances using Crsctl and Srvctl utility.

•Having good experience in Migrating Single Instance database to RAC Environment.

•Performed Capacity Planning, Undo segments and Health check reviews in RAC.

•Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.

•Scheduling the databases backup using Crontab and VERITAS net backup.

•Involvement in space management, rectification of lock problems, managed quotas.

•Performed Migration of databases 10g on Hp - UNIX to Oracle 11gR2 on Linux.

•Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.

•Installed Golden Gate for replication of database on 11gR2 RAC environment.

•Experience in Creating Physical Design Data Models using Erwin Tool.

•Generation of DDL scripts using Erwin Tools.

•Created, monitoring database objects like Indexes, Views, Users, and DB Links.

•Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.

•Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQLtuning advisor.

•Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports.

•Created Partition’s estimated stats on one partition1 and copied the stats to remaining partitions using dbms_stats.

•Worked with DW team on problem resolution and implemented change requests. – Performance tuning on DW such as Data extraction from production to Data warehouse.

•Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.

•Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN, Data Guard, Golden-Gate, Toad, Exadata, OEM, ASM.

Client: Siemens Medical Solutions, Bangalore, KN, India Duration: Sept 08 – June 11

Oracle DBA

Responsibilities:

•Installed and configured Oracle Products on Linux and Windows Environments.

•Involved in Installation and customization of Databases (10g&9i) in Linux and Solaris environments.

•Supported databases on AIX, UNIX and Linux.

•Evaluated the hardware requirements before upgrading/migrating the database.

•Good experience with recovery managed backups i.e. RMAN.

•Manage users, privileges, profiles and schemas.

•Experience in using automatic monitoring and management processes such as batch processing using Crontab for processes like import/export, backups & alerts of databases.

•Involved in Schema management, Table space Management, User Creation.

•Monitoring the alert logs and trace files regularly.

•Storage management, sizing the database objects, monitoring Disk usage.

•Involved in writing UNIX shell scripting for automating the jobs.

•UNIX shell scripting to automate different processes such as data loading and data analyze

•Experience with SQL query tuning, SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.

•Documented the complete project including all pre installation, post installation and database configuration steps.

•Disaster recovery planning and testing, on site recovery.

•Experienced in Tuning SQL statements using Explain Plan, Profiler and TkProf.

•Setup various automation scripts process in crontab on Various Servers to automate tasks like Analyze the Tables, Indexes and Monitor the Object growth.

•Maintained 24X7 Web based Production database with ODBC/JDBC environment

•24/7 on-call production database support.

Environment: Oracle 10g/9i, HP-Ux10.2, HP-UX, Windows, Explain Plan, Profiler, TkProf, Java, and UNIX

Educational Qualifications:

Bachelor of Technology (Computer science) – VIGNANS University.



Contact this candidate