SREEKUMARREDDY ANKIREDDY
[pic] [pic]
[pic]
abmlut@r.postjobfree.com
ORACLE APPLICATIONS DBA
A hands-on, skilled and detail-oriented certified Oracle Applications DBA
and Oracle DBA with 14 years of broad-based expertise in the areas of
oracle applications administration, oracle applications implementation,
database administration, high availability, patching, cloning, advanced
oracle applications configurations, Project management, data migration,
performance tuning and programming/applications development. Works closely
and effectively with end-users and mentors co-workers, increasing
performance and efficiency. Innovative and creative problem solver, who is
results oriented, has an aptitude for learning and can maximize resources
while possessing a sense of urgency.
AREAS OF EXPERTISE:
Oracle E-Business DBA 11i & R12 Oracle E-Business System
AD Utilities, Patching & Cloning Administration
Shared Apps Tier and PCP Real Application Clusters and ASM
Database, Applications and SQL OEM Grid and Data Guard
Tuning Oracle Streams and Advanced
RMAN Backup and Recovery Replication
Unix Shell, SQL and PL/SQL Oracle Database Upgrades
Scripting Logical and Physical Database Modeling
[pic] EDUCATIONAL BACKGROUND [pic]
Master of Technology in Computer Science
Jawaharlal Nehru Technological University, Hyderabad, India, 1998
Master of Science in Mathematics
Sri Venkateswara University, Tirupati, India, 1994
[pic] Technical cERTIFICATIONS [pic]
Oracle Certified E-Business Suite Administrator in R12 & 11i
Oracle Certified Database Administrator 11g
Oracle Certified Expert RAC
[pic] Technical proficiencies [pic]
Database: Oracle 8i, 9i, 10g and 11g, SQL Server 2005
Operating Systems: Sun Solaris 5.10, Red hat Linux, IBM AIX 5.3, HP-
UX 10.2/11.x, Windows 2000/2003
Middleware: Oracle Application Server, Oracle Application
Express, SOA and BPEL, OID and SSO,
OBIEE and BI Publisher
ERP: Oracle E-Business Suite 11.5.9,
11.5.10.x, R12
Tools: OEM, Toad, SQL/PLSQL, Oracle Developer
Forms & Reports, SQL Loader, ER Studio, Data
Loader, VSS, Clear Case, Data
Guard, Data Pump, Streams, Workflow, RMAN, Control-M
[pic] PROFESSIONAL EXPERIENCE [pic]
Worked as Lead Oracle Apps DBA and Oracle DBA in projects with reputed
clients
State Government, Local County XEROX, Portland, OR, USA
Alcoa, Pittsburgh, PA, USA
Bank of America, NY, USA Verizon Data Services, Tampa, FL, USA
GE Capital, Danbury, CT, USA
Hewlett Packard, Bangalore, India Astra Zeneca, Bangalore, India
Titan Industries, Bangalore, India
Tata Consultancy Services, India
Local County
April 09 to Present
Lead Oracle Apps DBA
Client is Local County ITS division providing hosting and data centre
services for all the county departments. ITS provides information systems
planning, network design and telecommunications project management; systems
implementation and maintenance, and hardware, software and data
integration. ITS also furnishes radio system design, implementation and
support.
Responsibilities
. Installing and maintaining 4-node Oracle Applications R12 instance
. Support and maintain 16 Oracle Applications 11i/R12 instances
including production.
. Performing Cross platform upgrade of Oracle Applications from Oracle
Apps 11.5.9 on Windows to R12 on AIX.
. Configuring Oracle Applications R12, APEX and BPEL with OID and SSO
. Installing and maintaining Oracle Databases and Oracle Application
server instances
. Cloning and Patching Oracle Applications Instances and Databases using
Rapidclone, adpatch, distributed AD, OPatch
. Troubleshoot problems with concurrent managers, Apache, Jserv
processes, and database performance.
. Supporting R12 Implementation by AIM methodology
. Day to day Application maintenance such as creating or modifying
users, assigning Responsibilities to users, creating and running
Request
. Responsible for weekly cloning of production
. Implemented Oracle Enterprise Manager (OEM) and configured all the
databases to it.
. Installing RAC with ASM and Configuring with Custom Applications and
Oracle Applications
. Allocating and monitoring the work performed by DBA Team.
. Installing and configuring Oracle Application Express APEX,OBIEE, BPEL
and SOA
. Formulating and implementing backup strategy using RMAN for Production
Instances
. Meeting with Clients and Reporting the status and Progress of
different Projects
. Performed pro-active monitoring and performance tuning of Applications
and Database environments using OEM, AWR and ADDM.
. On call support of Production Databases and Applications
. Installing and Configuring data Guard for high available production
instances
. Collaborate with Enterprise Architecture teams on recommendations and
changes in service/integration best practices, standards, processes
and frameworks
. Automating tasks using OEM jobs
. Creating applications and database maintenance scripts using SQL,
PL/SQL and Shell scripts
. Configuring and monitoring workflows
Environment: HPUX, Sun Solaris 10, Red hat Linux 3.5, IBM AIX 6.3, Windows
2003, Oracle Apps R12/11i, Oracle 11g/10g/9i, APEX, OID, SSO, OBIEE, OAS,
AD utilities, Oracle Enterprise Manager (OEM) TOAD, Oracle CRS 10.2.0.4,
OEM 10.2.0.4,Jdeveloper,BPEL
XEROX, Portland, OR, USA
Mar 08 to
Mar 09
Lead Oracle Apps DBA
Client is a leading developer, manufacturer and supplier of printing and
imaging solutions for customers in more than 150 countries. Also makes
equipment for businesses and consumers to move information between the
paper and digital worlds.
Responsibilities
. Creation and maintenance of Single/Multi node Applications R12, 11i
environments using Rapid Install and Rapid clone/refresh.
. Completed multiple upgrades in Release 12,11i (from 11.5.x to 11.5.10)
. Supporting Applications R12 Implementation (Oracle's AIM methodology)
and 11i Production Instances
. Configuring Shared Apps Tier and Parallel Concurrent Processing
. Maintenance Pack/Family/One off Patching. Cloning Production instances
to test and development
. Day to day Application maintenance such as creating or modifying
users, assigning Responsibilities to users, creating and running
Request
. Performed multiple Database upgrades (8i, 9i, 10g, 11g).
. Installed, Administered and troubleshooting issues related to Oracle
RAC Databases for Oracle 10g
. Configuring Custom Applications and Oracle Applications with RAC
. Configuring Data Guard for Production systems and OEM Grid for all
oracle instances
. Designed the Backup and Recovery strategies and performed Backup and
Recovery of Oracle Database and Applications environment.
. Performing apps sysadmin activities, user management and registering
custom applications
. Installing and Configuring Oracle Application Server, SOA and BPEL,
OBIEE and Discoverer Applications
. Monitoring and Performance tuning of Applications and Database
environments
. Automating and documenting the process as appropriate by creating
scripts and instructions.
Environment: SunT2000, EMC DMX SAN, HPUX, Solaris 10, IBM AIX 6.1, Veritas
VCS, Oracle Apps R12/11i, Oracle 11g/10g/9i, PL/SQL, OBIEE,SQL, Shell
Scripts, Datapump, AD utilities, Oracle Enterprise Manager (OEM) TOAD,
Oracle CRS 10.2.0.4, OEM 10.2.0.4, RMAN
Bank of America, NY, USA
Jun 07 to
Feb 08
Oracle Apps DBA and Oracle DBA
Bank of America is implementing Finance and HR modules in Oracle
Applications Release 12 for transaction hub Activities. The project also
involves and supporting and upgrading 11i instances including production,
test and development instances.
Responsibilities
. Support new implementation on Oracle Applications Release 12
. upgrading DEV and SIT instances from Apps 11i to Release 12
. Participating logical and physical database design
. Transforming logical data model into physical structures in database
. Implementing High Availability architecture for Oracle Applications
using RAC and Data Guard
. Analyzing and Applying Patches using PAA, Distributed AD and Staged
APPL_TOP for Oracle Applications and Database
. Creating and configuring workflow, custom Applications and custom
Objects
. 24 X 7 Production server support
. Upgrade Oracle instances from 9i to 10g
. Periodically cloning the production server on to UAT server.
. Configuring advanced replication and streams for data replication
. Administering and Configuring and tuning Concurrent Mangers
. Implementing Oracle Applications Tablespace Model and Shared
Application Tier file System
. Oracle Applications and Database tuning using ADDM and tracing/TKPROF
. Interacting with the end users, coordinating between development and
functional team
. Installing and Configuring OEM Grid for Production and Development
Instances
. Implementing Partitioning and Materialized Views
. Resolution of issues through Oracle Support, TAR, Metalink
Environment: Sun SPARC M8000,HP 9000,HPUX 11i, Oracle Apps R12/11i,Oracle
10g/9i, PL/SQL, SQL, Shell Scripts, SQL*Loader/Import/Export Scripts, OEM
10.2.0.1, TOAD
Alcoa, Pittsburgh, PA, USA
Apr
06 to May 07
Oracle Apps DBA
Alcoa is the world's leading producer and manager of primary aluminum,
fabricated aluminum and alumina facilities, and is active in all major
aspects of the industry. This project involved in Managing DBA Team at
offshore and onsite and supporting Oracle Applications Production and
development Instances. It involves supporting Oracle applications 11.5.8
and 11.5.10 instances (OLTP, OAPS, GDW and HR) from different regions
(North America, South America, Australia).
Responsibilities
. Analyzing and applying Patches for Oracle Applications and databases.
. Cloning of Oracle applications instances and databases
. Space management and capacity planning for oracle applications
. Upgrading GDW Apps instances from 11.5.8 to 11.5.10.2
. Performance Tuning with respect to Database and Oracle Applications
Using Statspack, ADDM, Tracing and TKPROF
. Support Development Team with customizations
. Designing and Creating custom applications, tables, indexes,
Partitions and Materialized views
. Configuring Oracle Applications 11i with RAC and ASM
. Monitoring Oracle Databases and Applications with OEM Grid
. Backup and recovery of Oracle applications and databases.
. Maintenance and Troubleshooting of Oracle Applications, Discoverer and
Database
. Monitoring, coordinating with off-shore team.
. Working with Oracle Support to resolve SRs
. Writing shell scripts and SQL scripts to monitor and maintain the
Oracle Applications database.
Environment: HP 9000 SD64, HPUX 11i, Oracle Apps 11i, PL/SQL, SQL, Shell
Scripts, SQL*Loader/Import/Export Scripts, TOAD, Oracle 9i/8i
Titan Industries, Bangalore, India
Apr 04 to Mar 06
Lead Oracle DBA
This project involves new implementation of Oracle applications 11i at
Titan industries Limited for the Jewelers Division. This implementation
includes OPM, OM, PO and Finance Modules. Provided Apps DBA support for
functional and technical implementation team.
Responsibilities
. Define instance strategy for complete implementation cycle
. Create and Support Oracle Apps Instances
. Apply database and applications patches and Cloning.
. Support and maintain Oracle Applications 11.5.9/10 instances
. Installed and configured RAC for Apps 11i
. Upgrading Apps from 11.5.9 to 11.5.10.1
. In charge of Master/Reference Data conversion.
. Working with Oracle Diagnostics to resolve functional and Technical
issues
. Create and maintain custom responsibilities and menus.
. Cloning of Oracle applications Instances.
. Movement of custom programs and reports to production.
. Enforcing naming standards, maintaining the custom application top,
and setting up concurrent requests.
. Create table spaces, tables, and users for custom applications.
. Maintain and Monitor Oracle schemas, SGA, table space and extent
growth.
. Assist Programmers and Developers with Oracle problems.
. Write Korn shell scripts to monitor and maintain the Oracle
Applications database.
. Write Shell scripts and RMAN scripts for database and applications
backup.
. Perform SQL and Database,Applications and concurrent Manager tuning
. Unix system administration on AIX using smitty
. Checking database health by running stats pack regularly and tuning
long running queries.
. Create and monitor plan for the resolution of production issues
Environment: IBM P630-6c4, IBM AIX 5L 5.2, IBM HACMP, Oracle Apps 11i,
Oracle 9i, PL/SQL, SQL, Shell Scripts, SQL*Loader/Import/Export Scripts,
TOAD
Astra Zaneca, Bangalore, India
Jan 03
to Mar 04
Oracle DBA and Apps DBA
Client was using Oracle Applications version 11.0.3 to manage its Process
Manufacturing, Finance and SCM operations. The Oracle Applications system
is on Windows NT platform. To leverage on the improved functionalities of
Oracle Applications 11i and IBM AIX platform, Client plans to upgrade
Oracle Applications from version 11.0.3 to the latest version of 11i
(11.5.9).This project involves both upgrade and cross platform migration.
Responsibilities
. Cross platform upgrade from Windows to AIX
. Create and Manage Oracle Apps 11i Instances
. Cloning of Oracle Applications and Databases
. Create and maintain custom responsibilities and menus
. Analyzing and applying patches to Oracle Applications instances
. Application System Administration and AOL
. Troubleshoot Database and Applications problems
. Backup/Recovery of Instances
. Export/Import of Oracle Instances
Environment: Windows NT, IBM AIX 5L, Oracle Apps 11i/11.0.3, PL/SQL, SQL,
Shell Scripts, SQL*Loader/Import/Export Scripts, TOAD
Hewlett Packard, Bangalore, India
Jun 02 to
Dec 02
Oracle DBA
This Project involves Migration of legacy system which Uses Cobol Programs
using HP Image database to use Oracle 8i.This involve changing data access
components in Cobol programs and OCI to Use Oracle database.
Responsibilities
. Create / Backup / Restore testing databases.
. Design strategies for Conversion of Cobol programs
. Design tools for automatic conversion of Cobol code.
. Data conversion from Turbo Image database to Oracle.
. Schema design/create in oracle equivalent to Turbo Image.
. Developing libraries in OCI for data access from Cobol.
. Developing Tools for code conversion
Environment: Windows NT, IBM AIX 5L, Oracle Apps 11i/11.0.3, PL/SQL, SQL,
Shell Scripts, SQL*Loader, Import/Export Scripts, TOAD
Verizon Data Services, Tampa, FL, USA
Dec 01 to May 02
Oracle DBA
This project involves implementing Siebel CRM for Sales system automation.
Responsible for migrating legacy salestrak system data to Siebel on DB2.
This project involves mapping business process to new CRM system and
migrating data to Siebel.
Responsibilities
. Involved in business data analysis of Salstrak system.
. Design / Creation of staging area tables in database.
. Loading of data into initial tables.
. Developing procedures for transfer of data from initial to master
tables.
. Reorganizing the data among databases.
. Backup staging area databases
. Tuning the database and SQL's.
Environment: Windows NT, Oracle 8i, IBM DB2, ODBC, PL/SQL, SQL, Shell
Scripts, SQL*Loader/Import/Export Scripts, TOAD
GE Capital, Danbury, CT, USA
Dec 99 to
Nov 01
Oracle DBA
This Project is to automate the process of calculating the residual value
of an asset based on the classification, manufacturer, model, base value
and the modifiers. This process helps the client to make accurate decisions
about the current policies in the market. This helps to make new policies
based on the existing policies. Users of this system are sales persons,
credit persons, analysts who can review the policies if that is not an
existing one. There is provision for creating new users for the remotely
giving various levels of right to different group of users.
Responsibilities
. Participate in design of logical structure of database.
. Responsible for implementing the logical data model.
. Creating Database objects such as tables indexes triggers Etc.
. Creating databases for development, testing, quality and production.
. Loading Master data.
. Reorganizing the data among databases.
. Migrating databases and application from 8.0.5 to 8i
. Coordinating with the Java developers during the development.
. Establishing backup and recovery procedures for development and
production databases.
. Tuning the database and SQL's for application.
. Production support for the Application
Environment: Solaris 2.6, Oracle 8i,PL/SQL, SQL, Shell Scripts, SQL*Loader
Import/Export Scripts, TOAD
Tata Consultancy Services, Bangalore, India
March 98 to Nov 99
Oracle DBA
TCS is Oracle support partner. TCS is involved in the sales and Support of
Oracle Products. This involves installing Oracle products, providing
training on Oracle Products and resolving any issues reported by customers
Responsibilities
. Pre-sales demonstration of Oracle Products and tools
. Installation and configuration of Oracle Products
. Migrating databases from 7.x to 8.x.
. Configuring the database for archive log mode and stand by mode
. Assist clients in Space management
. Creating and supporting Databases.
. Establish object requirements, size of tables, their type etc.
. Assist clients in Backup and Recovery procedures.
. Creating recovery procedures for the specific database.
. Automating the process of backups using Oracle Enterprise Manager.
. Tuning Databases through Oracle supplied scripts.
. Tune database parameters to improve performance.
. Conducting training classes on database administration
. Contacting Oracle Corporation for technical support.
Environment: Solaris 2.5,HPUX, Digital Unix, SCO Unix, PL/SQL, SQL, Shell
Scripts, SQL*Loader/Import/Export Scripts, TOAD, Oracle 8i.7.3.x
IT Solutions Pvt. Ltd, Hyderabad, India
Dec 94 to
Oct 96
Oracle Developer and DBA
This project is automation of Transportation Department activities like
Registration of Vehicle, issuing of License and Centralizing complete
state data in one central Database. System establishes the connection
between the Central Server at Hyderabad and the remaining centers which are
located at remote places. This project is also planned to establish online
information security at check posts, so that the taxes or punishments to
the vehicle owners can be levied on the spot.
Responsibilities
. Creation of database, tables, users, roles in Oracle7.0.
. Tune Oracle memory (Shared Pool, Library Cache, Data Buffer Cache).
. Developing stored procedures and packages
. Development of reports in Pro*C and SQL
. Performance tuning which includes creating indexes, analyze, explain
plan
. Creating rollback segments, etc. Shell Scripting in csh and ksh
. User management, Privileges, Roles, Auditing, Profiling,
Authentication
. Managing Space, Table spaces, Segments and Extents, Rollback Segments
& Data Dictionary.
. Maintaining Day-to-Day Activities & Data Base Maintenance.
Environment: Windows NT, PL/SQL, SQL, Oracle 7