Oracle Data

Muralidhar Reddy Vemireddy

SR.ORACLE DATABASE ADMINISTRATOR ENGINEER

Ph:972-***-*****116

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

EXPERIENCE SUMMARY:

Over 8+ years of experience in Oracle Database Administration, supporting a large and diversedatabase application portfolio of 24 7 mission-critical production systems, development and test systems.

Oracle Database Administration experience in variety of different environments like Red Hat Linux,Windows HP-UX, SUN SOLARIS and AIX.

Excellent experience in installation, configuration and administration of Oracle 8i, 9i, 10g, 11g/12c RAC databases inUNIX/LINUX, Solaris, HPUX, AIX and Windows environment.

Expert in Real Application Testing (RAT).

Expert in Performance Tuning, Sql query tuning, SqlPerformance Analyzer.

Expert in design and implementation of database backup strategy and performed full, incremental and Cumulative backups using RMAN

Set up database and server monitoring and alerting with OEM (Oracle Enterprise Manager) Grid Control, Database Control, or by shell scripts. Track the growth of databases for capacity planning and resource management.

Good experience in SQL, PL/SQL Programming, Shell Scripting, Partitioning, Logical andPhysical Database Design.

Knowledge in Data migration using Golden Gate

Expertise in data transfer using Export/Import and Data Pump.

Knowledge of Cognos software tools and applications.

Experienced in heavy data loading from flat files to oracle tables using SQL* loader.

Excellent experience in cloning oracle databases for development and testing.

Extensive experience in writing SQL, PL/SQL packages, functions, stored procedures, triggers to implement business logics of oracle database.

Proficient in using OEM, RMAN, ASM and Data Guard.

Develop best practice guidelines for Oracle database developers; make recommendations on software tools, capacity planning, and infrastructure designs. Develop quality assurance policies and procedures.

Ability to work on own initiative and as part of a team. Excellentverbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.

TECHINICAL SKILLS:

Operating Systems

Red Hat Linux 4.x, 5.x,HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, IBM AIX 5.1, 5.2, 5.3,6.1 and Windows 95/98/ME/NT/2003/XP.

RDBMS

Oracle 11g/10g/9i/8i/7i, Oracle 10g/11g/12c RAC.

Tools & Utilities

RAT,RMAN, ASM, OEM/Grid Control, EXP, IMP, Data Pump, TOAD, SQL*Loader, Golden Gate, Cognos 8, 8.4 Express.

Languages

SQL, PL/SQL, C, C++, UNIX Shell Scripting, Perl.

Other

HP Data Protector, NetApp, Veritas NetBackup, TSM, DB Monitoring, MS Visio.

EDUCATION:

Bachelor of Technology

CERTIFICATION:

Oracle Certified Professional.

PROFESSIONAL EXPERIENCE:

CAPITAL ONE Mar’13 – Till Date

Role: Designated Database Administrator.

Environment: Oracle 12c, 11g/10g RAC, UNIX Shell Scripting, HP-UX,AIX 6.0, 6.1.

Responsibilities:

24 X 7 Production,non-production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.

Supported Singlehandedly second largest database in Capital One.

Successfully set up a four-node cluster and RAC data warehouse on Linux – Using ASM.

Real Application Testing and Open_TextSuport.

Livelink support to applications, code writing,scripting and developing.

Performance Tuning of queries and applied sql performance analyzer and query tuning optimizer.

Dataguard setup with 2 node Primary RAC.

OEM repository and agent creation on all instances.

Created Preproduction and captured load for stats and performance.

Supported DEV and QA environments for the top 5 usage applications in Cap1.

Performance Monitoring and tuning usingOEM Grid Control,STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.

Up gradation of Database 10g to 11g and applying patches whenever required.

Provide support to Data ware housing and business intelligence applications.

Developed scripts for cloning, monitoring, database backup and recovery.

Managing standby database and performed Switchover and Failover scenarios.

Cloned Oracle Databases for development and testing.

Involved in Data modeling, Logical database design, physical database design, normalization and denormalization.

Management of security, granting and revoking permissions to users/roles as and when required.

Writing PL/SQL functions, procedures, packages and triggers.

Partitioned large tables and created indexes to improve the performance.

Daily Health Check Up of the Databases and applications.

Monitoring Growth of tables and undertaking necessary steps for re-organization as and when required.

Priority Health, Grand Rapid, Michigan Sep’11 – Feb’13

Role: Sr.Database Administrator

Environment: Oracle 11g RAC/10g RAC, 9i, Data Guard, UNIX Shell Scripting, SUN SOLARIS 10 and RHEL 5.

Responsibilities:

24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.

Installed and configured multi node Oracle 11g RAC.

Converted a single instance database to Oracle RAC.

Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.

Performance Monitoring and tuning usingOEM Grid Control,STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.

Up gradation of Database from 9i to 10g, 9i to 11g, 10g to 11g and applying patches whenever required.

Cross platform Migration of databases.

Involve in installation, configuration and maintenance of Cognosenvironment.

Provide support to Data ware housing and business intelligence applications.

Oracle Streams Replication setup and Configuration.

Developed scripts for cloning, monitoring, database backup and recovery.

Experience in Golden Gate with replication of data in databases

Managing standby database and performed Switchover and Failover scenarios.

Cloned Oracle Databases and Oracle applications for development and testing.

Involved in Data modeling, Logical database design, physical database design, normalization and denormalization.

Management of security, granting and revoking permissions to users/roles as and when required.

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

Writing PL/SQL functions, procedures, packages and triggers.

Partitioned large tables and created indexes to improve the performance.

Daily Health Check Up of the Databases and applications

Monitoring Growth of tables and undertaking necessary steps for re-organization as and when required.

Procter& Gamble, Cincinnati, OhioJan’10 – Jul’11

Role: Oracle DBA

Environment: Oracle 10g RAC/11g RAC, SQL, PL/SQL, RMAN, ASM, DataPump, SQL*Loader, HP-UX, AIX andRedhat Linux.

Responsibilities:

24 X 7 Production Oracle database on call pager support and administration.

Installed 3 node10g RAC, Standby Databases (DataGuard) and documented the process.

Good experience of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities

Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.

Planned and upgraded DB including patch updates (CPU/PSU), performance tuning using (AWR/ASH/ADDM), managed Oracle partitioning, Materialized views, cross platform migration of Oracle from Solaris to Linux, created linked Server between Oracle &Sql Server 2005.

Production application migrations; database performance monitoring, tuning, and troubleshooting; Partitioning and MViews support, database reorganization and defragmentation, physical database refresh and schema/table level refresh; database upgrades, apply patches, database; design, develop, and implement automated data backup and restoration procedures; Unix scripts to automate DB tasks,On call support.

Maintained and setup streams for schema level propagation and SQL apply.

SQL, PL/SQL Programming, Shell Scripting, Partitioning, Logical and Physical Database Design.

Done the documentation and provided on-site production support.

Performed several complex recoveries on production systems and configured RMAN and OS backup strategies for large databases. Also used RMAN for cloning/standby database creation.

Member of the Change Control Board group responsible for approving any changes to the Test/Pre-prod/Production environment which included product upgrades/patches/hot fix and database/server/network tuning.

General Insurance Corporation of India, Hyderabad, IndiaMay’08 – Sep’09

Role: Jr.Oracle DBA

Environment: Oracle 10g /9i, HP-UX, Sun Solaris 2.5, 2.6, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER.

Responsibilities:

Responsible to provide 24 x 7 database administrative activities over different database servers.

Involved in Installation, Upgrade from Oracle 9i to Oracle 10g and Configuration of Oracle NET services.

Extensive experience in Performance Tuning, Memory Tuning etc.

Applied patches including both one-off patches using OPatch as well as patch sets.

Refresh/Cloning of database and applications for development and testing purpose.

Standby Database setup and configuration.

Worked alongside programmers and database developers for contributing to the development processes.

Enabled and analyzed trace files using TKPROF analysis and system wide event tracing.

Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.

Involved in decision making for the naming convention of datafiles, redolog files, tablespaces and segments.

Written shell scripts and automated nightly jobs using crontab to schedule the backups, exports and refreshing databases from production.

OS level Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.

Tuning SGA, I/O Tuning, Identifying database contention and the offending connections.

Written and configured RMAN for cloning databases.

Proactive monitoring of databases and applying RDBMS patches along with quarterly CPU updates.

Monitored the background processes activity including trace files along with setting the appropriate number of DBWR processes along with init.ora configuration for the database.

Assisted with the migration of database procedures and code from development to production instances by working extensively with the change management team.

Involved in conducting training sessions for fellow DBAs in administering Oracle databases 10g technology.

RelianceCommunication,Hyderabad,IndiaAug’07 – Apr’08

Role: Jr. ORACLE DBA

Environment:Oracle8i/9i, Linux, Solaris 2.5, Windows NT/2000, Toad.

Responsibilities:

Installing and configuring ORACLE 9i on LINUX and Solaris.

Worked in Development Support for Oracle based systems and Unix based Server environments

Upgraded databases from Oracle 8i to Oracle 9i.

Handling day-to-day activities.

Monitoring Database for fragmentation and correcting them.

Planning and implementation of Backup and recovery procedures and maintenance of Database.

Installation, Maintenance and Administration of Oracle Databases for Developers & testers.

Experienced with Space Management and Security.

SQL, PL/SQL, Shell Scripting.

Management of table space growth, monitoring data files additions, extent growth

Planning Backup and Recovery Strategies for various database environments.

Performing backups and recoveries using hot & cold backups.

Involved in Remote Database Maintenance.

Performed Database, OS and application tuning.

Developing shell script to automate the processes.

Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Monitoring Scheduled jobs of the daily activities for the performance of all the databases.

Prepare the documents of the process and knowledge transferring about the project to the new team members.

Created PL/SQL procedures (jobs) to automate maintenance tasks.

Used Database export/import using expand imp utilities.

Performed Data loads using SQL loader utilities.

Contact to the development team to solve the issues with the new enhancement releases.

Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

Contact this candidate