Engineer Oracle

Sai Puli

***** ***** *** *******, *********, VA, 201**-***-*** 4297(H),703-***-****(C) *******@*******.***

CAREER PROFILE

Over 8 years of IT-experience as Oracle DBA with expertise in all aspects of Oracle DBA tasks

• Experience in installation and configuration of Oracle 10G & 11G real application clusters (RAC)

• Experience in installation, configuration and cloning of oracle 10G & 11G RAC databases.

• Experience in installation of oracle 10G using Storage Area Networks (SAN)

• Excellent Backup and recovery scenarios and have good experience in recovering 10G & 11G databases.

• Experience in designing and implementing enterprise wide backup solutions using 10G &11 GRMAN.

• Implementing patches to clusters and database.

• Implemented oracle 10G security by strictly following the PCI requirements

• Experience in oracle 10G performance tuning.

• Experience in setting and maintenance of standby databases.

• Experience in loading data using SQL* loader.

• Written PL/SQL procedures and triggers, and enforced business rules and manual auditing.

• Experience in developing UNIX shell scripts to automate DBA tasks.

• Experience in maintenance and production support of 24/7 oracle databases.

• Experience in 24-hrs 7/day on-call support. Interfaces with users, vendors, and all MIS groups.

• Strong communication and coordination skills;

• Requirements analysis, design, development, and implementation of the database(Life cycle, used Visio for

the development of ER (Entity Relation) diagrams and Doors for the requirement analysis)

• Experience in design and implementation of Disaster recovery procedures (risk management).

• VMware experience in cloning Linux and other OS

EDUCATION:

• Master in information systems, from Phoenix University (AZ), USA

• Master of Technology in Structural Engineering, from JNT University, India

• Bachelor of Engineering in Civil Engineering from Andhra University, India.

• Bachelor of Sciences in Math, Physics, Chemistry from Andhra University, India.

• Professional Membership: Member of Institution of Engineers (India)

• Database management,, software design and Web development courses from George Mason university(Virginia).

• Computer Organization (Computer Architecture), Computer Science II, Assembly Language, Java Programming I

and Discrete Math from NVCC(North Virginia Community College)

Software and Hardware skills:

HARDWARE: SUN Enterprise E4500, E3500, E450, E420R, E250, SPARC 5, 10, 20, HP, DELL/ COMPAQ Servers,

Siemens Nixdorf Servers, Macintosh, and Intel Pentium PCs, RS-6000, Sun A-5200/A-1000, HP DL 385,HP

EVA8100,IBM SAN DS5000

OPERATING SYSTEMS: Linux Redhat 4.o, Solaris 2.6/2.7/2.8, SCO/UNIX 5.x, Linux 5.2, HP/UX, Windows

95/98/NT/XP/2000, DOS.

SOFTWARE TOOLS: Oracle Enterprise manager, RMAN, JDBC, Visio, SQL Navigator, Toad,

RDBMS: ORACLE 11.1.o./10.2.0.4/9.2.0 / 8.0.5 / 8.1.7/7.3.2,

LANGUAGES: SQL*PLUS, PL/SQL, C-K SHELL, Java, ColdFusion, C

PROJECT EXPERIENCE:

Oracle DBA at Camelot Integrated Solutions Inc, ( Jan ’08- present )

As oracle DBA responsibilities include building new Oracle 10G RAC Production & development servers, installing ORACLE

10g & 11g databases, tuning production servers, managing backups using RMAN .

Responsibilities:

• Worked on 11 g and created clustered database

• Developing necessary SQL queries for accessing the Oracle Database.

• Responsible for allocation of tasks to team members, monitoring and guiding development and making sure on

target completion of project. Also making sure, development system adhered to standards of proposed architecture

• Structured the database like table spaces

• Creating and maintaining users like assigning proper privileges, profiles, table spaces and quotas on different table

spaces.

• Worked on applying patches to 10 & 11G clusters and database

• Planning backup and recovery strategy.

• Wrote PL/SQL blocks for timely invocation of triggers.

• Installation, configuration and cloning of oracle 10 & 11 G databases.

• Designing and implementing enterprise wide backup solutions of oracle 10 & 11G using RMAN.

• Administered and improved performance of 2 TB production databases.

• Monitor the growth of the database objects for capacity planning.

• Create and maintenance of oracle 10 & 11 G logins and users.

• Managing permissions to different users and groups.

• Setting Scheduled Database Backups and Data Transfer jobs.

• Loading data using SQL* Loader 10G & 11 G.

• Writing and fine-tuning of Stored Procedures and triggers.

• Generating SQL queries, reports from the oracle database-using Toad.

Hardware: HP DL 385 with Redhat 4 HP DL 380 G3 with windows 2003, Intel Pentiums with WIN NT based clients.

Oracle DBA MIL Corporation Inc. USA (Sept ‘07- Dec ’07)

(As consultant to Department of Commerce)

Project Context: United States foreign trade with 18 countries that liberated from erstwhile USSR

• Maintained IIS web servers and Oracle database server for supporting the trade application. Applying required

CF patches on the server and testing as required.

• Maintained the trade application in response to new requirements and standards – such as generating

automatic reminder emails to users attending trade meetings or conference calls.

• Performing user account administration. Applying required enhancements and code changes to the trade

application following a certain release management process.

• Provide troubleshooting assistance and debugging for application programming issues.

• Worked on the creation of both oracle (9i) and Access databases

• Worked on 9i oracle database and created SQL queries, reports, and performance tuning

Environment: Cold Fusion Studio 4.5, Cold Fusion Application Server MX 6.0, Microsoft IIS Server, Oracle Database 9i

and MS Access

Oracle DBA at Camelot Integrated Solutions Inc, ( Jan ’07- Aug/07 )

As oracle DBA responsibilities include building new Oracle 10G RAC Production & development servers, installing ORACLE

10g database tuning production servers, managing backups using RMAN

Installation, configuration and cloning of oracle 10 database

Worked on applying patches to 10

Generating SQL queries, reports from the oracle database

Wrote PL/SQL blocks for timely invocation of triggers.

Written data extraction procedures using SQL * PLUS.

Import and Export data using Sqlloader

Systems Analyst, Anacomp Inc, USA (Nov ’05 – Feb 06)

Herndon Data Center:

Worked on the following tools and system software. Besides these, worked with customer integration and call tracking -

receiving calls from customers opening tickets, and sending them to DTS analysts, DBA and UNIX administrators and

also with storage network management,

Tool/System software How I used

Net Support Manager Used to connect remotely to servers

Watchdog, Inbox, Purge, Used for data transmission services

Transit Manager, and

Decompression Station

Ingestion Automation Working with the production servers, checking Staging where

Decompression station writes files on Unix server, clean up of data from the

database after checking errors,

HP Openview To monitor network connections between data centers

WebMon To monitors clients websites

Patrol To monitor real time disk space utilization on production servers and

system performance

Scoop To monitor/control the usage limits a customer has on database.

AMASS Archives Management and System services

Rodan Created user for outside access that retrieves customer data and tests

response times

Mtester To pull back customer submitted files that are too large

2-tier To help troubleshoot web issues

Environment: UNIX (Sun Solaris), Sybase, Microsoft Excel, JavaScript, HTML, SQL & Shell scripts

Programmer/Analyst, Sabreis Inc, USA (Feb ’03 – Oct ‘05)

Client: RARE Conservation Organization www.rarecenter.org

Worked on streamlining Rare Center data and create a centralized structural database, which allows the management

and the users to access, organize, analyze and report information related to its sites, and projects. The process

involved requirements gathering, analyzing, planning, designing a whole web based application, which retrieves data

from a relational database (MySql Server). Worked on building an on-line donation module for users to pledge to the

organization. This system is implemented using Java technology.

• Developed JSP Pages and servlets using Eclipse IDE to serve web pages for the site.

• Written SQL statements to obtain data and results for weekly status reports.

• Generated SQL * PLUS reports.

• Written data extraction procedures using SQL * PLUS.

• Written SQL Loader scripts to load data into Oracle tables for further processing.

• Written shell scripts to call SQL * PLUS and SQL Loader scripts.

Environment: Windows 2000, ASP, VB6.0, XML, MySQL, oracle, HTML, JavaScript, J2EE

Programmer Analyst, IIT Inc, USA (Feb ’00 – May’01)

Client: MRAC (Mortgage Risk Assessment Corporation) www.homepriceanalyzer.com.

Served as a developer in converting a VB application to a web-based application for client. The web application allows a

user to log-on and evaluate the price of their home based on comparisons in the neighborhood. It allows the user to

search the property address based on zip code and other refined criteria.

• Build MS sql database as per the needs of the client

• Wrote sql business queries as required by the business needs

• Applied Patches to the database backups

• Attended performance tuning testing

• Wrote Java applications (servlets) for various business requirements

Environment: Active Server pages, VB 6.0, XML, SQL server 7.0 & Java Servlets, Style sheets

Support DBA, SAI, USA (June ’98 – Feb’ 00)

Performed as database administrator with the following tasks.

• Written sql queries to report different requirement as required by management.

• Performed backup and recovery using rman.

• Created users with required privileges.

• Installed development database and supported development database environment.

• Installed test database and generated sanitized test data.

Environment: oracle 8.0.5 Windows 2000.

Hardware: Hp DL 385.

Project Engineer, H.S.LIAO SDN.BHD, Malaysia (Nov ’95 - Jan ’98)

• As a Project Engineer I was involved in two fast track major commercial complexes.

• Endah Parade is a 2.5 Million Sq.Ft commercial complex with 3 basements, 8 floors and water theme park on the

8th floor.

• Vision – City is a 1.8 Million-Sq.Ft complex with 4 basements and 6 floors(DAEWOO)

Other assignments related to Civil and Structural Engineering work experience which involved various roles, such as

planning, estimating and budgeting, design, implementation and executing Major water supply projects are

summarized listing the organization and duration.

Consultant, V.K., Consulting Engineers, India (Jan ’94 - Nov’95)

Deputy Executive Engineer, APHMHIDC, India (Jan’88 - Nov’95)

Structural/Sanitary Engineer, New Transcentury Foundation (Jan‘85 - Dec’87)

(A US based organization in Yemen Republic

Structural/Sanitary Engineer Ministry of Public Works, Sana’a, Republic Of Yemen

(Dec‘81-Dec’84)

Junior Engineer, Ministry of Panchayat Raj, India (Dec‘71 - Nov ’81)

Site Engineer, Central Water and Power Commission, India (July ‘71 - Dec ’71)

Contact this candidate