Sql Server Oracle

Dushyanth Vaddi

Oracle & SQL Server DBA (OCP *i, 10g, MCDBA)

? abncle@r.postjobfree.com Chicago, IL ?

Phone: 312- 402- 2225

* ***** ** ********** ** the IT specializing in Oracle & SQL Server

Database Management Systems.

Expertise in Performance Tuning, Migrations, Scripting, Disaster

Recovery techniques, Backup

Recovery for Oracle 11g RAC,10g RAC,9i,8i Databases, SQL Server 2005,

2005 databases, Oracle

Fusion Middleware and Oracle Application Server 10g.

Hands on experience with Oracle 11g, 10g Real Application Clusters (RAC)

installation, maintenance

& as a production support DBA.Strong experience as an Oracle 11g, 10g,

9i, 8i Database

Administrator. Provided 7X24 production DBA support along working with

the engineering &

development teams for test, production Oracle, SQL Server & Datawarehouse

Databases on UNIX,

Linux, Sun Solaris 9, 10 & Windows Server 2000/2003.

Hands on experience with Installation, Configuration and maintenance of

Data Guard and RAC. Good

Knowledge of Installation, Configuration, Monitoring and Maintenance of

Oracle Databases, ASM,

CRS/Clustware & SQL Server Databases.

Expertise in Database Installations, Configuration, Monitoring,

Maintenance, Patches, Data Migration,

Database upgrade, Database Security and supporting 6+ Terabyte Databases

and DB Applications.

Excellent Knowledge in RMAN, Conventional Backups, Recoveries, RMAN

Scripting.

Expertise in Performance Tuning, Troubleshooting, SQL Tuning, Query

Execution Plans, Hints, AWR

reports, Statspack Reports, UNIX base monitoring, STATS gathering,

Partitioning, Data Retention.

Exerience in SQL & Shell Scripting.

Supported Data warehouses design, data loading, maintenance & support.

Installation, Configuration

& maintenance of Oracle warehouse Builder & Cognos.

Experience in administrating SQL Server 2000 & 2005 databases along with

design, upgrading

patching and tuning the SQL Server databases.

Experience with backup & recovery procedures, troubleshooting &

configurations for SQL Server

2000 & 2005 databases including setup of Database Mirroring, Log

Replication.

Excellent working knowledge of Oracle Application Server 10g including

Installation, Tuning

Clustering and supporting various applications. Configuring SSO, OID &

tuning reports for oracle

Application server.

Professional Certifications:

. Oracle Certified Professional 10g Data Base Administrator. (OCP 10g)

. Oracle Certified Professional 9i Data Base Administrator. ( OCP 9i)

. Microsoft Certified Data Base Administrator SQL Server 2000. (MCDBA)

. Oracle Certified Associate Oracle Application Server 10g. (OCA)

Technical Skills:

. Databases : Oracle 9i, 10g, 11g RAC, MS SQL Server 2000

& 2005, MS Access.

. Middleware : Oracle Application Server 10g, Web logic,

SSO, OID, LDAP.

. Programming : SQL, T-SQL, PL/SQL, Linux, UNIX, Shell

scripting.

. Tools & Utilities : SSIS, DTS, RMAN, Data Pump, Dataguard,

Cognos, OWB, OEM, Grid Control.

. Operating System : Linux, UNIX, Solaris 9, 10, Windows 2000/2003.

. ERP's : PeoplesSoft, Navision, Oracle E-

Business Suite

. Others : SAN, Erwin, Toad, Weka, SQL Developer,

VMware, Vi Editor,

VERITAS Net backup, Falcon IpStore.

Work Experience:

Safeguard Properties LLC, Valley View, OH

September 2007 - Present

Oracle Database Administrator

Directed installation, configuration and administration of several Oracle

server releases across multiple platforms. Planned and executed multiple

server upgrades and migrations. Coordinated capacity planning through in-

depth trend analysis. Calculated space utilization and application growth,

and projected database sizing. Initiated and executed disaster recovery and

backup initiatives. Delivered regular updates to upper management and

stakeholders on database system status. Collaborated with business analysts

and development teams in design and deployment of relational databases from

legacy data. Facilitated database performance tuning.

Key Projects and Achievements:

. Spearheaded design, assembly and implementation of large-scale databases

with replication and multi-node configurations saving an estimated $120k

annually for the company in license fee and maintenance.

. Established and ensured compliance with methodologies and standards,

including security policies and standardized procedures and controls.

. Instrumental in planning and execution of client merger project from

different applications & platforms to a single platform, with

accountability for integrating financial data into financial systems;

identified and delivered solution for recurring space shortage issue,

leading to an annual savings of $100K.

Responsibilities:

Designed and implemented Oracle Real Application Clusters (RAC) on Solaris

for an OLTP application with Transaction Application Failover and high

transaction volume.

Deployed Disaster Recovery (DR) solution for Oracle 10g using falcon store

and database mirroring for SQL Server 2005.

Implemented Oracle 10g Dataguard for High Availability. (HA) and maintained

stand by database for reporting purposes.

Implemented strategy for partitioning and management of historical data

tables in RAC.

Install, maintain & support Oracle Warehouse Builder (OWB) for

datawarehouse.

Carried out a strategy to direct OLTP transactions and ad-hoc queries to

separate RAC nodes using

database service name. This helped system to manage workload effectively.

Maintain the Oracle 10g RAC environment and troubleshoot performance

problems.

Install & Manage Oracle Application server 10g cluster for Oracle forms &

reports for high volume reporting applications.

Troubleshooting & Tune Oracle Application Server 10g report performance.

Configure active-active HA solution for Oracle App Server 10g.

Upgrading Oracle Databases from 9i to 10g and from 10g to 11g.

Upgrading SQL Server Databases from 2000 to 2005 and associated

applications.

Configuring SSO for oracle application server, OID & LDAP.

Performance tuning, troubleshooting & monitoring using ADDM and Automatic

Workload Repository Advisor in Oracle and SQL Profiler in SQL Server for

very large OLTP databases (VLDB'S).

Drawing software & hardware requirements for the new applications.

Implemented partitioning and materialized views for Oracle 10g Databases.

Building test strategies, backup & recovery models for Oracle & SQL

servers. Refreshing test databases.

Managing backup & Recovery for Oracle on Linux using RMAN and MSSQL Server

on Windows.

Providing 24/7 production DBA support for Oracle, MSSQL Server databases

and

Oracle Application Server.

Going through the day-to-day user requests and troubleshooting the database

related problems.

SQL scripting for MSSQL Server and shell scripting for Linux servers to

perform database maintenance operations and as required by the

applications.

Perform DB patching, Cloning, DB Installation, troubleshoot

issues/errors/incidents, Collaborate with Oracle support for bugs & issues

resolutions and personal research.

Handle and perform clients Service Request for Incident Management, Problem

Management and Change Management.

Design, develop and deploy logical and physical test and production

database solutions for

Oracle 11g, 10g database and SQL Server 2005 DB's.

. Audit the MSSQL Server & Oracle databases and implement security

policies.

. Maintaining terabytes of data storage on Hitachi SAN. Configured the

logical volumes

using Veritas software.

. Installed and configured the Veritas enterprise edition cluster file

system for RAC.

. Support Oracle Database with .Net & Java Applications.

. Documentation for the projects design and implementation.

. Implemented Flashback Recovery for Oracle 10g Databases which helped in

recovery of the data in

the systems several times.

. Designing and Developing Data warehouse and data marts depending on the

business requirements.

. Install, Configure & maintain cognos for Oracle and SSIS for SQL Server

2005

datawarehouse databases.

Used Erwin to Analyze, design entity-relationship diagrams, data model

solutions and reports based on the business requirements

Environment : Oracle 9i, 10g, 11g, RAC, RMAN, SQL Server 2000 & 2005,

Oracle Application Server 10g, Red Hat Linux, Solaris

9, 10, Database Grid Control,

Cognos, OWB, Windows 2003, HP -UX, SSIS, Dataguard,

Toad, Veritas Netbackup,

SSO, OID, LDAP, Falcon IpStore, Cognos.

DePaul University, Chicago, IL

Oracle Database Administrator

January 2005 - August 2007

Coordinated installation, configuration and deployment of multiple Oracle

database server releases. Designed and set up databases aligned with

company's IT standards. Designed & Implemented Disaster Recovery solutions.

Monitored daily database performance / availability, backup and reporting

jobs. Planned and implemented database schema and security changes.

Key Projects and Achievements:

Leveraged highly complex decode function to initiate and execute daily SQL

load jobs for multiple

platform feeds.

Played key role in design implementation of PeopleSoft ERP.

Deployed Monitoring tools & scripts for database maintenance saving

monitoring time for the DBA team.

Responsibilities:

. Install and Maintain Oracle 10g RAC for the PeopleSoft Financial & HR

Applications.

. Testing Disaster Recovery solutions using RMAN hot backup & dataguard.

. Linux shell scripting for monitoring oracle Database status, security &

backups.

. Shell scripting & sql scripting for refresh of Oracle 9i & 10g test

databases using hot backups.

. Designed and documented a data migration routine to move production data

from

SQL Server to Oracle using DTS, Text Files, SQL Loader and External

Tables.

Prepared documentation on HA system, recovery scenarios, data conversion,

system setup, configuration for Linux hardware, Oracle Software

Installations, database creation and naming conventions. Hardware, Oracle

Software installations, database creation and naming conventions.

. Automated refresh of oracle & SQL server databases from production to

test environments.

. Cloned/Refreshed databases from Production database using RMAN and hot

backups.

. Implemented backup and recovery strategies using export/import, RMAN

. Design, develop and implement test & production databases for Financial,

HR & academic

PeopleSoft Applications.

. T-SQL scripting for monitoring SQL Agent, checking offline databases,

performance monitoring

for SQL Server 2000 & 2005.

Leading the transition of various SQL Server functions/tasks from version

2000 to 2005 including log shipping setup, monitoring and configuration

modifications.

Worked on cross platform migrations for all Oracle versions.

Monitored tablespace size, resizing tablespace, relocating data files for

better disk I/O.

Created user, allocation of appropriate tablespace quotas with necessary

privileges and roles

for Oracle & SQL Server databases.

. Provide backup and recovery support, monitoring & performance tuning for

Oracle 9i,

SQL Server 2000 & 2005, PeopleSoft apps.

. Using statspack to identify bottlenecks, errors in Oracle and SQL

Profiler in MS SQL Server.

. Created backup plan design and implementation using cold/hot backups,

Flash copy, Volume copy

and RMAN backup technology.

. Reorganized the database architecture to work efficiently and for better

response time.

. Troubleshooting and performing RE-ORG of tables, archive logs and data

files,

etc in RAC environment.

. Oracle installation and migration to new releases.

. Used OEM Grid Control Diagnostic and tuning packs to tune the application

and SQL queries

. Upgrading & Patching oracle databases, SQL Server Databases and

PeopleSoft applications.

. Provide on-call production (24/7) database support, troubleshooting &

problem solving Oracle 9i,

10g & SQL Server 2005 & 2005 issues.

. Implemented best practices for database security polices, naming

conventions, backups etc..

. Creating daily, quarterly and yearly maintenance plans for Oracle 9i, SQL

Server 2000 & 2005.

. Used SQL-Loader utility to load data into oracle database from external

files.

. Use Import, Export, SQL*Loader to load and backup data

Environment: Oracle 9i, 10g, RAC, Grid Control, SQL Loader, OEM, SQL

Server 2000 & 2005,

PeopleSoft, Linux, UNIX, Windows 2003, HP-UX,

PL/SQL, Discoverer, SAN, RMAN.

City of Springfield, Springfield, MA

Nov 2002 - Nov 2004

Database Administrator

Responsibilities:

Create & maintain Oracle databases across multiple platforms and setup

backups.

. Builds included everything from configuring the Solaris and HP-UX

environments, installing Oracle

software and patching to desired levels including one off patches,

creating instances, recompiling

invalid objects, recalculating statistics.

. Develop, Implement and administer database policies and procedures.

. Applied patches and migrated databases from one platform to another,

along with upgrade from

oracle 8i to 9i and maintain an updated platform matrix.

. Work with software developers to develop and enhance applications.

. Increased company's main application performance, by providing

proactive tuning and setting

database maintenance plan for mission critical application running

. Conducted optimization and performance tuning of database, SGA and

SQL*Net/Net8

. Managed archived redo files, DB-links & Partitions, loading data for

users by using SQL*Loader

. Set up Cron jobs to monitor file systems usage, archive logs, backup

logs, periodically clean up these

File systems, and also monitor RMAN Hot Backup Scripts

. Tuned Oracle Initialization Parameters

. Support developers in tuning Database and applications for optimal

performance

. Upgrade, analyze and testing of the test and production database.

. Created database physical/logical layout design and procedures for

production,

development, test servers.

. Performed capacity planning to create and maintain the database

environments.

. Gathered Database Instance Statistics & generated reports using

STATSPACK

. Responsible for physical and logical models of the database.

. Design and implement database backup and recovery procedures using

RMAN.

. Administration and configuration of Web Logic Server 6.1.

. Set up multi-master replication, dealt with conflict resolution and

performance issues.

. Creating and maintaining table spaces, tables, indexes, users, roles,

privileges and security

. Configuration of server with OLTP system, runtime connection & load

balancing.

. Tuned the multiple databases for Performance. Involved in security

audit of databases and servers.

. Wrote packages, functions and procedure for reporting.

. Implemented security protocols for the database.

. Provided 24x7 on-call supports.

Environment: Oracle RAC 9.2.0, SQL, PL/SQL, SQL Loader, OEM, Oracle 8,

9i,Web Logic

Oracle Forms, Reports, Developer 6i, Linux, UNIX,

Windows 2003, Solaris,

.

Education:

. Master of Science in Information Systems

DePaul University, Chicago, IL

. Bachelors of Science in Electronics.

Loyola College

References: Available upon request.

Contact this candidate