Sql Server Oracle

Nagarjuna Yarlagadda

Cell:706-***-****

Email:abipcz@r.postjobfree.com

Summary:

. Over 8 years of total IT experience with 7 years specialization as an

Oracle DBA administering very large Oracle Databases (VLDB) up to size

of 6 Tera Bytes

. Over 4 years experience in Oracle 10G RAC installation, configuration,

administration and upgrade

. Expert experience in Design, Development, installation, configuration,

Implementation, Patching and Administration of Database Systems using

Relational Database Systems, Oracle 8i/9i/10g, Oracle Application

server (10gR2) & Microsoft SQL Server 2000 running on Solaris 8, HP-

UX, Red Hat Linux, Windows NT/2000/2003 Advanced Servers

. Experienced in creation of Standby Databases and Data Guard

Architecture

. Implementation of a complete Hot/Cold Backup solution utilizing RMAN

via a Recovery Catalog, Media Management, Backup Sets, Lists and

reports, Channel allocation, Restoring files, Media recovery and

Integrity checks. Strategy included development of daily, weekly and

monthly strategy incorporating incremental backups, intraday archive

log backups. Also used Computer Associates ArcServe 2000 for Oracle in

conjunction with RMAN to Backup and Recover databases

. Implementation and use of the Oracle Enterprise Manager (OEM) as well

as the Performance Tuning and Diagnostics Packs. Implemented various

secondary-monitoring korn/bourne scripts

. Participated in data sourcing, extract data investigation process and

worked with teams to develop PL/SQL code to extract, clean and sort

data for flat file generation, code SQL*Loader control files to load

data

. Monitored Oracle Database using Quest Central and OEM, to minimize the

performance problems

. Oracle Database tuning for long running concurrent jobs using Stats

pack, TKPROF, etc.

. In addition to database administration, worked on Security

Administration at a database standpoint

. Expertise in Space monitoring, Functions, Procedures, Triggers &

Packages, and Object Management

. Experienced in working with Data Warehouse environment and installing,

configuring and administering SQL Server 2000

. Extensively worked on developing technical and function requirements

for end-users and developers by gathering requirements and worked on

most of the phases of the Software Development Life Cycle

. Responsible for implementing policies and procedures to ensure the

integrity, security, availability, and accessibility of company's

databases

. Well conversant in translating business requirements into creation of

database objects: tables, indexes, constraints, packages, stored

procedures and functions using Oracle tools

. 24x7 production support

Technical Expertise:

Databases

Oracle 8i/9i/10g, RAC, Oracle Application server (10gR2/10gR3), MS SQL

Server 2000, MS Access

Operating Systems

UNIX (Suse LINUX (9.3), RHEL 4/5, and AIX (5L)), SUN Solaris SPARC 10,

Windows (XP/NT/2000/2003 Advanced Server), MS DOS

Database Administration Tools

Oracle Enterprise Manager, TOAD, SQL Enterprise Manager, SQL *plus, RMAN,

SQL Developer, Spotlight, Shareplex, Hotsos profiler, Computer Associates

ArcServe 2000

Oracle/Unix utilities

Exp/Imp, DataPump, SQL*Loader, Trace output formatter, STATSPACK, DBVERIFY

Languages

UNIX Shell Scripting (Korn, Bash), awk, nawk, SQL, PL/SQL, XML, HTML

Editors

vi, sed

Modeling Tools

UML, ER Diagrams, Sequence Diagrams, Data Flow Diagrams

USANA Health & Sciences, SLC, UT

Apr 2010 -- Till Date

Sr. Oracle Consultant

USANA Health Sciences is one of America's leading companies in the field of

health and nutrition. USANA Health Sciences, Inc., is a direct selling

company. Independent Associates distribute and sell scientifically based

nutritional and personal-care products.Net sales for USANA Health Sciences

in 2008 were approximately US $429 million. USANA Health Sciences operates

in fourteen markets: Australia, New Zealand, Canada, the United Kingdom,

the Netherlands, Hong Kong, Japan, Taiwan, Korea, Singapore, Mexico,

Malaysia, Philippines, and the United States. The corporate headquarters

are located in Salt Lake City, Utah.

Responsibilities

. Troubleshooting the issues on node eviction on the 3 node RAC

. Performing the best practices for listener configuration on the RAC

environment for the fail over process

. Performing the process of cleaning up left over traces of node

deletion process

. Monitor and analyze the traffic flow across the RAC interfaces

. Executing the task of adding node to existing 3 node RAC

. Performing changes on the RAC related to IP Address change on the

subnet in the network

. Changing the name of the ASM instance as per the requirements of the

customer

. Deploying the agents on the database to monitor through grid control

Accomplishments

. Clean out the left out traces of the deleted node from OCR

. Adding a new node to the existing 3 node RAC

. Performing the changes for RAC around IP change on the subnet

. Providing best practices for the fail over mode in RAC

. Providing solutions for the performance issues around RAC

. Suggesting best practices on RAC for data warehouse

. Followed-up projects work with crisp documentation

Environment:

Oracle RAC 10g,ASM,RMAN,Grid Control, RHEL 4, NetApp Storage, Toad,

Shareplex,Hotsos Profiler

Tomax Corporation, Salt Lake City, UT

Oct 2007 - Apr 2010

Sr. Oracle Consultant

Tomax is one of the leading providers of innovative management solutions

for the retail industry. For over 25 years, Tomax has served over 100

retail chains with forecasting, point of sale, store systems, reporting and

optimization tools in addition to application hosting to benefit retailers'

bottom-line results. Today, Tomax is the only software solution provider

exclusively serving the retail market with organic solutions spanning the

entire Demand-Driven Retail Continuum.

Responsibilities

. Installing, configuring and performance tuning of a 3 node 10g RAC

multi-terabyte high throughput OLTP production environment on Redhat

Linux platforms and NetApp Filer storage

. Applying latest CPU patches to 3-node RAC environment

. Cloning databases from prod to non-prod environments and performed

device allocations

. Performance tuning of the database with respective the file system I/O

by also using AWR,ADDM reports.

. Partitioning of the tables and online re-org of the tables for the

better response of the SQL

. Trouble shooting issues with Retail.net, JBOSS Portal, JPOS (Point Of

Sale) and the Database

. Working closely with the architects and the development team for the

better performance of the database.

. Tuning of the database parameter for the better performance of the

system

. Installing, configuring, administering & troubleshooting errors on

Oracle Application Server (10gR2) and Portal applications

. Configuring forms, reports and custom applications on the application

server

. Participating in 24X7 on-call rotation for production support of all

customer accounts

Accomplishments

. Upgraded 10.2.0.3 RAC database to 10.2.0.4 and performed node

addition/deletion on RAC

. De-RACed a 3 node 10g RAC DB to a single instance DB

. Configured the Dbconsole for single instance and 3-node RAC database

. Administered high volume online transactional database (1 Million

transactions a day)

. Separated the indexes, data, rollback segments and redo log files on

separate disks to minimize contention, Monitored the buffer cache hit

ratio and the dictionary cache miss ratio. The DB_BLOCK_BUFFERS and

SHARED_POOL_SIZE were increased, resulting in tremendous improvement

in performance.

. Resolved the issues around the performance bottlenecks and library

cache locks and latch wait events

. Checked IO, CPU or memory bottlenecks and suggest appropriate measures

. Followed-up projects work with crisp documentation.

Environment:

Oracle RAC 9i/10g, RHEL 4/5, NetApp Storage, Toad, Hotsos Profiler,

LogMiner, JBOSS Portal, JPOS, OAS 10R2

Adelphia Communications/Time Warner Cable, Coudersport, PA

May 2006 - Aug 2007

Sr. Oracle DBA Consultant

Responsibilities

. Installed 10g DB on AIX and RHEL Server and performed performance

tuning/ monitoring

. Setup Production, Dev, Test, QA, UAT, FTP and Data warehouse databases

on AIX

. Configured the Netvault with the database on Solaris/AIX

. Did Heterogeneous connectivity between databases and performed

database migration across cross platforms

. Responsible as secondary DBA for Remedy Applications

. Analyzed SQL statements in relation to Oracle's optimizer

. Installed Jserver, HTTP server and SQL server DB

. Created DTS packages for data loads from SQL server

. Fixed problems encountered during the data load from the database to

the warehouses

. Wrote multiple shell scripts for monitoring/administration of the DB

. Checked IO, CPU or memory bottlenecks and suggest appropriate measures

. Used oracle tools (sql*loader) to create procedures to migrate data

from legacy systems

. Verified daily & monthly loads

. Managed indexes, partitioned tables

. Configured the Netvault server with Oracle Rman

Environment:

Oracle Enterprise manager, Oracle 9i,10g PL/SQL,Sun Solaris, Veritas

Netbackup, Netvault, IBM AIX, Windows 2000, SQL server 2000, MySQL, Toad,

DBsaint.

ValuAmerica, Greensburg, PA

Jan 2005- Mar2006 Sr.

Oracle DBA

Value Doc system is a system to manage information related to property

assessment & mortgage. This system acts as bridge between Financial

Institutions/mortgage companies and the property appraisal agents in the

field. The system is based on Oracle Backend Database server and Forms &

Reports as front end.

Responsibilities:

. Wrote Stored Procedures according to specs and control files for input

to SQL*Loader utilities for loading data from external files into the

Oracle database

. Allocated the system storage and planned future storage requirements

for the production database system

. Performed Database Security and Integrity using Audit trial feature

. Prepared the design specifications document for creating Tablespaces,

Indexes, Rollback Segment, Users, privileges and roles and monitored

them

. Resolved locking problems and maintained the available free space in

the database

. Overall Oracle Server Administration of Oracle 9i Production and

Development Databases on Sun Solaris and AIX

Environment:

Oracle Enterprise manager, Oracle 9i/8i/8.0, PL/SQL, Windows NT/2000,

SQL*Loader, Sun Solaris 8, AIX.

Kone corporation, NYC, NY

May 2004 - Jan 2005

Oracle/SQL Server Database Administrator

Responsibilities:

. Responsible for over 15 production databases plus their development

and UAT incarnations

. Implemented a Oracle 9i RAC solution for Material Management System

. Translated logical database model into optimal physical database

design for implementation required for business solutions (e.g. Online

Billing, Cash Management and Data Warehouse Systems)

. Responsible for installation and configuration of databases and

created database links between them

. Performed load balancing for large databases

. Responsible for capacity planning and migrated tables and indexes to

different tablespaces in the process

. Designed/performed backup and recovery strategies on development and

24 X 7 production databases

. Used RMAN in conjunction with Veritas Netbackup to perform backup and

recovery

. Cloned dev/test databases from production databases for

development/testing purposes

. Performed Database Security Administration including User Maintenance

and granting privileges

. Provided a high degree of coordination between users, technical and

corporate entities, ensuring effective data management and application

implementation

. Implemented and maintained Data Warehouse (DWH) System and SQL Server

2000 database

. Pulled data from SQL Server 2000, Sybase, DB2 and flat files into Data

Warehouse staging area

. Used Veritas Netbackup to backup and recover SQL Server 2000 databases

. Managed and Monitored SQL Server 2000 Security for the company's

intranet web page

. Monitored SQL Server systems activity by using traces and System

Monitor

. Responsible for performance tuning and code review exercises for most

of the database in PCJ

. Created standby databases for PCJ Bill Payment Systems to achieve high

availability

Environment:

Oracle: 7.x /8 / 8i /9i, SQL Server 2000, O/S: UNIX (Sun Solaris, HP-UX),

Windows (NT/2000/Advanced Server), TOAD, OEM, svrmgrl, SQL*PLUS, RAC,

Explain Plan, STATSPACK, SQL*LOADER, UNIX Shell Scripts, Veritas Netbackup

BlueCrossBlueSheild, Providence, RI

May 2003-Apr 2004

Oracle DBA

Responsibilities:

. Coordinated Backup and Recovery operations over all databases,

ensuring 100% recoverability

. Wrote Stored Procedures according to specs and control files for input

to SQL*Loader utilities for loading data from external files into the

Oracle database

. Planned, Installed and Configured Oracle Database on Solaris server

. Created Table space, Data files, Indexes, Rollback Segment and also

users and granting them privileges and roles.

. Performed Database Tuning and Security and Integrity according to SOX.

. Resolved locking problems and maintained the available free space in

the database.

. Wrote extensive Sub Queries, PL/SQL procedures, functions, database

triggers and packages.

. Responsible for writing database programming to Store/Retrieve the

information from the database using SQL

. Designed and created schema objects like Database tables, indexes,

views, synonyms, and all schema objects in Oracle

. Wrote pl/sql procedures/functions and shell scripts to automate and

monitor the data load

Environment:

Oracle: 9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced

Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting,Quest

software tools,PL/SQL navigator,BMC patrol.

Pennsylvania Power Ltd, Allentown, PA

May 2002 - Apr 2003

Oracle DBA

Responsibilities:

. Monitored tablespaces, Indexes, extents, sessions & performance tuning

using OEM

. Responsible for setting up Backup and Recovery procedures

. Developed Indexes wherever required to improve the performance

. Responsible for implementing policies and procedures to ensure the

integrity, security, availability and accessibility of company's

databases

. Implemented Security management through grants and triggers. User

account creation, group creation and setting up of privileges and

accesses

. Responsible for support of Oracle Production database systems,

including database administration activities, database performance

monitoring, tuning, capacity planning

. Perform Oracle upgrades and data migrations among various platforms

. Designed, developed, tested and debugged PL/SQL Package, Procedures

. Performed database and SQL tuning using in-house scripts and database

tools

. Implemented scripts to automate Oracle backups utilizing different

approaches such as hot and cold backups and export and import

utilities

Environment:

Oracle 8.1.7, 7, SQL 7 Databases, PL/SQL, RMAN, TOAD, OEM, IIS 4.0/5,

Microsoft Windows NT (4.0,2000, XP, 95,98), SAN.

Madison Madison, Detroit, MI

Dec 2001 - Mar2002

Database Developer

Madison Madison International is Company that offers a full-range of design

services including architecture, engineering, planning, and graphic design

since 1954. They are leaders in designing Schools, churches, commercial

facilities, government facilities, public housing, and interior design.

They also participated in Master plans, urban design studies, site plans,

and site selection. Signage, multi-media presentations, printed materials,

logos, corporate identity packages, and Web sites. MMI has been featured in

Forbes, Engineering News Record, Ebony, and Essence magazines.

The project is to maintain databases on Cities vendors, customers and

employees, to debug errors and tune the tables as per requirements provided

by the oracle application developers for interfacing and conversions.

Responsibilities:

. Developed Vendor Conversion Program to import vendors from the legacy

system into Oracle with required validations to avoid creation of

duplicate vendors and sites

. Used PL/SQL extensively to develop interface tables for uploading data

from legacy systems into Oracle database. Also, used Ref cursor,

cursors in packages

. Designed, coded, developed and implemented forms, reports and

Interfaces.

. Data extraction, loading and manipulation using SQL*Loader and PL/SQL

. Actively involved in training the team members with new enhancements

made to system and system flows

. Created and maintained the database in MS access for the projects

handled and to implement Forms and Reports upon request.

Education: BS in Computer Science

Contact this candidate