ANKIREDDY
[Send email using form at bottom]
ORACLE DATABASE ADMINISTRATOR
A hands-on, skilled and detail-oriented certified Oracle Database Administrator
with 14 years of broad-based expertise in the areas of database administration,
real application clusters, data guard, data replication, oracle applications
administration, application server administration, backup and recovery, on call
support, change Management, project management, data migration, computer
operations, systems engineering, SDLC, data modeling 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:
• Real Application Clusters RAC & ASM
• Database and SQL Performance Tuning
• Oracle Apps and Database Upgrades
• Oracle Application server
• Unix Shell, SQL and PL/SQL Scripting
• SQL Server Administration
• OEM Grid and Data Guard
• RMAN Backup and Recovery
• Oracle E-Business Suit Administration
• Oracle Streams and Advanced Replication
• SSO, OID, BPEL, OBIEE and BI Publisher
• Logical and Physical Database Modeling
EDUCATIONAL BACKGROUND
Master of Technology in Computer Science
Jawaharlal Nehru Technological University, Hyderabad, India, 1998
Master of Science in Mathematics
Sri Venkateswara University, Tirupati, India, 1994
TECHNICAL CERTIFICATIONS
Oracle Certified Database Administrator 11g
Oracle Certified Expert in RAC
Oracle Certified E-Business Suite Administrator in R12 & 11i
TECHNICAL PROFICIENCIES
Database: Oracle 8i, 9i, 10g and 11g, SQL Server 2005
Operating Systems: IBM AIX 5.3, Sun Solaris 5.10, Red hat Linux 3.5, 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, RMAN, NetBackup,
SQL Loader, ER Studio, VSS, Clear Case,
Data Guard, Data Pump, Streams, Workflow
Local County
April 09
to Present
Lead Oracle DBA
Client is Local County ITS division providing hosting and data centre services
for all the county departments. ITS provides services in information systems
planning, network design and telecommunications project management; systems
implementation and maintenance, and hardware, software and data integration. ITS
also maintains data centers. This project involves supporting 16 production
(sizes ranging from 500GB to 4.5 TB) and 126 non production databases.
Responsibilities
• Installation and maintaining of 4-node Oracle Real Application Cluster
Databases (RAC) with ASM for Oracle 11g and 10g.
• Performing Node Addition to the existing RAC Database and conversion of Single
Instance to RAC databases
• Patching CRS and RAC databases using all-node and rolling patching methods
• Performed cross platform migration and upgrade of Oracle Databases from AIX to
LINUX
• Setup and Managed Standby databases for both Physical and Logical using Oracle
Data Guard for performing both planned and unplanned switchovers and failovers.
• Implementing strategy to direct OLTP transactions and ad-hoc queries to
separate RAC nodes using database service name to manage workload effectively.
XEROX, Portland, OR, USA
Mar 08 to Mar 09
Lead Oracle DBA
Client is a leading developer, manufacturer and supplier of printing and imaging
solutions for customers in more than 150 countries. Also makes things easier for
businesses and consumers to move information between the paper and digital
worlds. This project involves supporting 22 production databases (Including
Oracle 4 E-Business databases) and 210 non production databases.
Responsibilities
• Installed, configured and administered different Oracle products including
Oracle server, Enterprise manager (OEM), RAC and ASM
• Designed and implemented Oracle 10g Real Application Clusters (RAC) for an
OLTP application
• Implemented Oracle 10g Dataguard for High Availability. (HA) and maintained
stand by database for reporting purposes.
• Cloned/Refreshed databases from Production database using RMAN and hot
backups.
• Day-to-day user requests and troubleshooting the database related problems,
requests
• Worked on cross platform migrations for oracle databases between different
operating systems.
• Working with management on database Sizing and Infrastructure requirements
Bank of America, NY, USA
Jun 07 to Feb
08
Oracle DBA and Apps DBA
Bank of America is implementing Finance 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
• Providing day to day support for Development and Production Instances in 10gR2
• Installing and configuring RAC With ASM with 10g databases using VERITAS
Clusters on Solaris OS
• Upgrade Oracle instances from 9i to 10g and 11g
• Resolution of issues through Oracle Support, TAR, Metalink
Alcoa, Pittsburgh, PA, USA
Apr 06 to May
07
Oracle DBA
Supporting multi terabyte Production and development instances used for
manufacturing aluminum products at Alcoa. It involves supporting many Oracle
databases (OLTP, OAPS, GDW and HR) from different regions (North America, South
America, Australia).
Responsibilities
• Creating and maintaining multi terabyte Production and Development Instances
in 10gR1/2
• Designing and Creating custom applications, tables, indexes, Partitions and
Materialized views and migrating to Production
• Maintenance and Troubleshooting of Oracle Applications, Discoverer and
Database
• Writing shell scripts and SQL scripts to monitor and maintain the Oracle
Applications database.
Titan Industries, Bangalore, India
Apr 04 to Mar 06
Lead Oracle DBA
This project involves development of web based applications using Oracle
databases at Titan industries Limited for the Jewellery Division. This project
involved designing deploying and supporting oracle instances. Project also
involves supporting new Oracle Applications 11i implementation.
Responsibilities
• Creating and maintaining Oracle databases 9i and 10g
• Applying patches to Oracle databases
• Create table spaces, tables and users for custom applications.
• Perform SQL and Database tuning
• Checking database health by running stats pack regularly and tuning long
running queries.
Hewlett Packard, Bangalore, India
Jun 02 to Apr 04
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.
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.
• Tuning the database and SQL’s.
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..
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.
• Production support for the Application
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
• Conducting training classes on database administration
• Contacting Oracle Corporation for technical support.
|
