Oracle Manager

SRIRAMA JAGAN MOHAN RENTACHINTALA (Jagan)

****, ********* **, ********,** 43230.

abntie@r.postjobfree.com

614-***-**** (cell)

Summary

Sr. Oracle DBA with 10+ years of professional Information Technology experience.

Adept at leading teams of technology professionals in Application Development and

Database Administration functions architecting, implementing, tuning, backup, recovery

of databases. Also managing a team of 6+DBA’s and 7 Developers, assigning tasks,

mentoring, performance monitoring on Oracle 10.2.0.3, 9.2.0.4 and Apps 11.5.10

versions of huge databases. Well-refined analytical and troubleshooting skills, providing

direct support to users at all levels of computer proficiency. Exceptional interpersonal

and customer relationship skills; serve as liaison between business representatives,

client management, and users.

Professional Certifications

Oracle Certified Professional (OCP) 9i and 10g.

•

• UNIX System V - From LA Salle University, Philadelphia

Education

• Post Graduate Diploma in Computer Management, A M Jain College, Chennai, India.

• Bachelors in Accounting & Finance, University of Delhi, India.

• 150+ hours Oracle Corporation Schools/University.

• Attended EMC’s Replication Manager training. In house SDLC training.

Technical Skills

Hardware Dec-Open VAX/VMS, Alpha-VAX/VMS, HP-Compaq Proliant servers

Unisys, RS 6000 RISC, Intel Pentium/486 style IBM compatibles

Op. System Unix (AIX, Solaris 2.x, HPUX 10.x/11.x, System V), Tru64,Windows NT,

VAX/VMS.Winxows XP, SQL server,windows 2000,Linux

RDBMS Oracle Applications 11i/10.7,Oracle 10g,9i, 8i/8.x/7.x, Sybase, DEC RDB,

MS Access,SQL Server, DB2

Case Tools SQL Navigator

Languages Vax/Basic, Vax/Cobol, PL/SQL 2.3,FoxPro,

Oracle SQL*Loader, RMAN, SQL*Net

Utilities

Other Tools MS Office, Vax/Vms – DTR,Lotus Notes 5.0,Erwin,Informatica,Cognos

DBA Tools DB Artisan, DB Tools, TOAD, OEM, Smart DBA and SQL Analyzer,

Spotlight,BMC Partol

Work Experience

• Providing project management and technical leadership to the DBA team.

• Review project request for scope, timeline for deployment, resources and priority.

• Provide input for projections of hardware/software requirements and professional

resources.

• Manage various infrastructure projects like Data center move, server migration and

replacement.

• Managing Oracle licensing, recommending purchases and upgrades of third

• party software’s.

• Plan, document check list and lead efforts for database upgrades.

• Installation of Oracle 10G and upgrading from 9i to 10G for over 100+ database with

sizes varying from 450Gb to 1.5 TB.

• Works with team to reduce incidents owned or impacting database group.

• Experience in architecting environments based on current demands and estimating

future requirements.

• Logical and Physical design of database – create, maintain, monitor, tune backup

and recover production, QA and Development databases.

• OEM Grid Control configuration and management. Monitoring DBA activities using

Oracle Enterprise Manager 10g Grid Control and other 3rd party tools.

• Responsible for setting up and testing Backup and Recovery procedures using

RMAN and other scripts.

• Expert knowledge in use of OEM, RMAN and strategies for backup and recovery.

• Experience in setting up both Logical and Physical Data Guard for DR Maintenance.

• Worked on high availability environment implementations RAC with 3 node

implementation. Responsible for Testing and implementation of RAC under various

OS environments AIX, Linux.

• Implemented FGA and TDE (Transparent Data Encryption).

• Developing standards for database performance tuning.

• Tuning databases for performance and analyzing I/O and other OS issues in relation

to database performance.

• Performance analysis through Statspack, ASH,AWR and ADDM.

• Provide 24X7 rotation on-call supports for production databases.

• Participating in Banks merger meetings (Sky Bank) for evaluating – databases /

servers / licenses / Application Owners/ Disk requirements.

• Managing Change controls and release management to roll out across development,

staging, pre-production and production tiers and vendor management

• Support Development and testing teams for their Database requirements.

• Test, Implement new solutions and technologies.

• Unix TSM Backup management and BCV Split copy management. HACMP Fail-over

testing.

• Cloning database in 11.5.10 apps environment with DMZ installation.

• Expert with various Oracle DBA tools (Toad,Smat DBA,SQL Developer etc)

Environment:

Oracle 11.5.10, Oracle 10g, 9i, AIX, Linux, OEM, Windows NT, Lotus Notes 7.0

• Installation of Oracle product and upgrades of Oracle Server (Oracle 10g) in

production,test and development environment.

• Allocation of required system resources for installation and maintaining databases.

• Migration databases from 8.1.7.3 to 9.2.0.3, 9.2.0.5 (oracle 9i) for all the

Dev/QA/Prod environment for over 20 databases.

• Providing Remote Oracle Database support to Client through Citrix Server.

• Design & Implement High Availability Solutions such as Advanced Replication using

Oracle Streams, and Data Guard (Physical standby database).

• Creating and configuration of development database instances for the different

projects divisions. Creating environment for the Development,QA,

Test,Integration,Staging and Production environments.

• Application troubleshooting by creating Oracle Trace by setting oracle events.

• Responsible for maintaining Systems security, Auditing Database objects and

system privileges and managing system privileges and roles for users.

• Responsible for setting up Backup and Recovery procedures using RMAN.

• Monitoring of Databases environment metrics using Oracle Enterprise Manager

(10g Grid Control) and other tools.

• Develop documentation and procedures for database administration and created

Test cases for Application testing in testing and production environments.

• Troubleshooting development,QA,Integration issues with Infrastructure Team and

implementation of systems and software into production.

• Performance tuning production Databases by using explain plans, statspack,Quest’s

Spotlight and other tools.Analyzing and tuning SQL queries for better performance.

• Refreshing Databases from Production Database to Development,QA environments.

• Oracle Tools evaluation and recommendations to various Teams.Familiar with

TCP/IP,Firewalls,Load Balancers,VPN’s,RSA Security Card.

• Actively participated in Oracle Disaster Recovery validation and testing involving

different project teams.

Environment:

Oracle 10g, 9i, (Apps) 8i Linux, OEM, Solaris 2.8, Windows NT, Alpha VAM/VMS,

Lotus Notes 5.0

• Installation and upgrades of Oracle Server from 8i to 9i for 25 instances.

• Configuring, upgrading, migrating and maintaining Geneva Proprietary Database

• Upgrading Oracle from 32 bit to 64 bit architecture.

• Creating and configuration of development databases for the different projects

division.

• Creating primary database storage structures (table spaces) and database objects.

• Creating environments for the development and Test and QA Databases.

• Responsible for maintaining Systems security, Auditing Database objects and

system privileges and managing system privileges and roles.

• Developed Backup strategies involving Physical (Hot & Cold), RMAN backups.

• Re-creating databases with the backups. Cloning Databases across different

platforms.

• Monitoring Database administration using TOAD and Smart DBA.

• Performance tuning Production Db’s using statspack, Quest’s Spotllight.

• Analyzing and tuning SQL queries for better performance.

• Refreshing Databases from Production Database to Development,QA environments.

• Development of SQL/shell/Perl scripts for DBA reports.

• Good exposure with ETL tool Informatica used for our Data warehouse project.

• Replicating Oracle 8.1.7, 9i databases using oracle Multi Master Replication.

Environment:

Oracle 9i, 8i, NT, OEM,Solaris 2.8, Lotus Notes 5.0,Tru64,HP/UX, RedHat Linux.

• Creating environments for the Development and Test Databases.

• Creating APPL_TOPS for the databases and symbolic links to APPL_TOP.

• Responsible for Oracle Applications System Administration which involved creating and

managing users & their access to Oracle Applications, defining their application

privileges, defining data groups & request groups, creating document sequences and

assigning them to documents, managing concurrent programs and managing printers.

• Managing Concurrent Manager in a centralized servers through web.

• Configuring Apache & JVM Server for Self Services connect for the testers and

developers.

• Applying Oracle PATCHES (One-off patch, Mini, Family & HR Patches) on top of

databases.

• Maintaining Databases with Veritas Quick I/O.

• Responsible for maintaining Systems security, Auditing Database objects and

system privileges and managing system privileges and roles.

• Responsible for Database Backup using Logical (Export), Cold and Hot Backups.

• Monitoring DBA activities using Oracle Enterprise Manager.

• Supporting Oracle Discover & Forms based applications and issues.

• Performance tuning of development, production databases.

• Refreshing Databases from Production Database to Development Database.

Environment:

Oracle Applications 11i/10.7, Oracle 9i/8i with Apache JVM Server, Session Server,

UNIX Server, Oracle Mail Server, OEM, Solaris 2.8

• Documentation of the dataflow and system design.

• Database creation, modification & configuration.

• Allocating system storage and planning future storage requirements for the

database.

• Responsible for maintaining Systems security, Auditing Database objects and

system privileges and managing privileges and roles.

• Responsible for setting up Backup and Recovery procedures.

• Setting storage parameters of Database objects like Tables, Indexes etc.,

• Development of UNIX shell scripts, database scripts for performance monitoring

and database administration.

• Solution for the Digital/Compaq corporate help desk and identify various level of

supporting issues for the database maintenance.

• Tuning of the database, monitor database performance, space utilization and

tablespace fragmentation, optimizing the performance of the database.

• Setting up user security and authentication within the development database

environments.

Environment:

HP-Compaq Proliant servers, Solaris 2.5, Dec-Open Vax/Vms,Oracle 8.x/7.0, Developer

2000, SQL Navigator.

• Participated in Logical and physical database design.

• Installing and upgrading the ORACLE Server and Application Tools under

Solaris/VAX VMS.

• Allocating System storage and planning storage requirements for the database

system.

• Creating primary database storage structures (Tablespace) once the application

developers have designed an application.

• Enrolling USERS and maintaining system security

• Monitoring and optimizing the performance of database using EXPLAIN PLAN.

• Maintaining Backup and Recovery and Archived data on Tape.

• Development of DCL scripts. Working with Developers and other teams members in

resolving the production issues.

Environment:

Oracle 7.X, Developer 2000, Vax/Cobol, Basic, DTR, RDB, Dec Open Vax/Vms.

Contact this candidate