Oracle DBA Sample Resumes

 

 

Phone: +91-886*******.

E-mail: [email protected]

Objective:

To excel in the industry and to serve the company to my fullest capabilities taking up challenging assignments, enhancing interpersonal skills, sincerity, team spirit and correctness at work place that would lead to the fulfillment of personnel and corporate goals.

Facilities Management

·         Having around 1 years of experience in software development using Oracle SQL, PL/ SQL (including Procedures, Functions, Triggers, Packages)

·         Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.

·         Sound knowledge in Oracle 10g/ 9i & PL/SQL programming.

·         Data Conversion from Flat files to Oracle using Oracle SQL* Loader.

·         Analyzing of SQL statements using EXPLAIN PLAN to improve the performance.

·         Comprehensive Application development experience using Oracle Forms and Reports.

·         Having good analytical and programming capabilities.

Experience Summary:

Team : Purchase Order System

Designation : PL/SQL Developer

Client :BrainEye InfoTech Pvt Ltd

FirstGlobalSoftware

Jul 2010 – Till Date.

Key Roles & Responsibilities:

·         Collected User Requirements by participating in meetings and studying existing System.

·         Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer.

·         Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, packages, Cursor, Ref Cursor and Triggers.

·         Inolved in analysis, design, coding and Testing.

·         Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.

·         Front End Screen was developed using Forms 9i.

·         Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

·         Used SQL LOADER to upload the information into the database.

·         Used Explain Plan for query optimization.Created Database design and converting them into database objects.

·         Wrote test cases and performed Unit testing.

·         Involved in writing Technical Specification Documentation.

Technical Skills Summary:

Languages : SQL , PL/SQL , C , HTML.

Databases : Oracle 10g/9i.

Tools/ Utilities :Sql*Loader, Forms& Reports.

Operating Systems : Windows (XP/NT/Server 2008 family), Ubuntu .

Educational Background:

Degree : Bachelor of Engineering

Branch : Telecommunication Engineering

Institute : K.S Institute of Technology, Bangalore

University :Vishveshwaraya Technological University, Belgaum.

Year of passing: July 2010

Percentage : 58%

Personal Details:

Name :xxxxx

DOB : 06-12-1985

Sex : Male

Languages known :English,Hindi,Kannada,Telugu,Tamil

Address : # 968, 9th Cross, 2nd Main, SBM Colony,

Girinagar 4th Phase, Bangalore – 560085.

Contact Number :+91-886*******.

E mail :zxxxx@r.xxxxxxxx.com

Declaration:

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

 

 

Contact: 0091-xxxxxxx
E-Mail: p*******@yahoo.com

Seeking managerial level assignments in Oracle PL/SQL Development / Database Administration with a leading organization of repute in IT sector preferably in Pune /Bangalore / Hyderabad

Profile Summary

 A focused professional with nearly 4 years of experience in:

·         Software Engineering ~ Database Administration ~ System Analysis

·         Requirement Gathering ~ Query & Package Optimization ~ Oracle PL/SQL Development

·         Expertise in applications encompassing system design & analysis, development and implementation

·         Deft in handling project management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters

·         Possesses extensive experience with in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity

·         Extensively worked on SDLC, J2EE, Oracle SQL, PL/SQL, Oracle Forms and Oracle Reports

·         An effective communicator with honed people management, relationship management, analytical & coordination skills

Core Competencies:
Managerial

·         Handling end to end project management activities inclusive of planning, effort, design, scope, estimation, resource coordination and delivery as per specified timeframes

·         Leading & managing project teams throughout the project lifecycle and providing them support & guidance on technical and project-related issues

·         Managing code deployment, change management and quality assurance; providing technical support to Application Development Teams and setting / maintaining standards

·         Preparing work plan, design activities, use case, etc.; carried out the study of the current system

Functional

·         Creating tables paces, rollback segments, user maintenance, database security imposition by creation and granting of roles & privileges, performance tuning, backups, tuning of SQL statements and support for oracle toolsets and utilities

·         Undertaking design & development, testing, debugging and troubleshooting of the application; overseeing smooth implementation of the application

Organizational Experience:

Infosys Technology Limited, Pune as Senior System Engineer

Key Result Areas:

·         Spearheading entire gamut of operations inclusive of:

·         Mapping client requirements by participating in meetings and studying existing system review

·         Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer

·         Backend Programming using PL/SQL, Stored Procedures, Functions Packages, Database triggers for Oracle 10g/11g and also SQL queries and migration scripts

·      Using SQL TRACE and Profiler, Pl/SQL developer tools for debugging, Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns

·       Providing Front End Support using J2EE, experience in working with application servers like Tomcat, Web Sphere

·         Creating complex relational and data warehouse infrastructures DB Objects (Triggers, Stored Procedures) / DB Models and associated architecture

·         Designing application CSS for 24 companies like Nomura, Shire, Addidas, Videophone and UBS (Union Bank of Switzerland), etc.

·         Looking after analysis, design, development, maintenance, testing, documentation and implementation based operations

·         Managing OLTP, OLAP components, stored procedures, triggers, analytical functions and complex queries

·         Working on Composite data types, Cursors, Dynamic SQL and Global Temporary tables

·         Accountable for issue resolution and root cause analysis

·         Monitoring the design and development of reusable enterprise systems and various web applications using J2EE technologies like Servlets, JSP, and JDBC

·         Rendering services as Onsite Coordinator since 1 year, directly interacting with clients gathering requirement, and do the development as well as assign work

Highlights:

·         Rewarded with:

·      Spot Award for Excellence in Quarter Q1 11-12, Q2 11-12

·         3 Quarterly Awards

·         An appreciation from Business Head of the client

·         Dexterously cleared Infosys Training with 4.52 CGPA

·         Essayed a stellar role as:

·         Offshore Database Anchor for coding standards and best practices

·         Onsite Coordinator for the execution of Corporate Employee Financial Services based project using PL/SQL Programming, database optimization

·         Meticulously contributed in the successful:

·         Execution of projects such as Washsale and TFM, Swiss Banking Secrecy Waiver, etc.

·         Deployment of the code review packages in UAT which facilitated the timely running of automation scripts

·         Proactively trained the team members on the process improvements

Academic Details:

BE Computer Science & Engineering GirdharSikshaEvamSamajKalyanSamiti Group of Institutes

Certifications:

·         Oracle Certified Associate (OCA)-Oracle Database SQL Expert & Oracle Database 10g: Administration I 1Z0-042

·         Banking and Capital Markets

IT Skills:

Databases : Oracle 10g, 11g, Database Design and Normalization

Operating Systems : Microsoft Windows, Unix

Languages : PL/SQL, SQL, Java, JSP and ANT

Web Technologies : HTML, CSS

Application Server : Tomcat, Websphere

Tools : Toad, PL/SQL Developer, RAD (Rapid Application Developer Tool)

Others : Basic UNIX Commands and Shell Scripting & Tuning Poor SQL Queries for Performance Improvement

Social Engagements:

·        Rendered services as the Member of Green Peace Organization

·      Contributed in Charity Donations

Personal Details:

Date of Birth :17thSepter, 1985

Address :Schaffhauserstrasse 463, Zurich – 8052

Languages Known :English& Hindi

(Refer to Annexure for Project Details)

ANNEXURE

Major Project:

 Title: Corporate Employee Financial Services (CEFS)

Client Union Bank of Switzerland (UBS)

Synopsis: A CMMI Level 5 Project, department of UBS Wealth Management US delivers first class equity compensation plan services and support for stock, options, restricted grant awards, performance grant awards, stock appreciation rights and employee stock purchase plans.UBS Corporate Employee Services (CEFS) delivers comprehensive expertise, professional implementation and effective communication support for your equity-linked compensation plans throughout their life cycle.
Role: Deftly carried out the following accountabilities based on:

·         Backend Programming using PL/SQL, Stored Procedures, Functions Packages, Database triggers for Oracle 10g, 11g and also SQL queries and migration scripts

·         Serving as DB Anchor for the team, for following Coding Standards and best practices during database development

·         Analysis, design, coding and testing

·         Using SQL TRACE and Profiler, Pl/SQL developer tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns

·         Handling composite data types, cursors, dynamic SQL and global temporary tables

·         Following the coding standards and best practice in project and served as DB Anchor for same

·         Providing Front End Support using J2EE, experience in working with application servers like Tomcat, Web Sphere

·         Maintaining proper documentation of the application

·         Looking after the issue resolution, root cause analysis and designing applications like Nomura, Shire, Addidas, Vodaphone and UBS (Union Bank of Switzerland), etc.

 Design and development of reusable enterprise systems and various web applications using J2EE technologies like Servlets, JSP and JDBC

	·         Six plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis and Design, Development and Documentation at various levels.
	·         Performed Oracle 8i/9i/10g software and database installation and upgraded various versions.
	·          5.0 + Years of professional experience in different aspects of Oracle Apps Database Administrator/System Administrator of ERP (Oracle Applications 11.5.10.2/9/8) on 8.x/ 9.x production database
	·          Experience in administering, tuning and monitoring database using Toad, OEM
	·         Designed strategies for performing database backups and recovery
	·         Debugging with procedures, Function, Triggers, Packages and other PL/SQL objects
	·         Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask
	·         24x7 on-call Production support fordatabase activities.

 

TECHNICAL SKILLS
Databases:	Oracle 8i / 9i / 10g, SQL Server,MS Access
Operating Systems:	UNIX, Windows NT/2000
Programming Languages:	PL/SQL, UNIX Shell Script
Database Tools:	Toad, OEM, DBA Studio
ETL Tools:	SQL Loader, Erwin
Version Control Tools:	Visual Source Safe
Telnet Tool:	Putty, Hummingbird Connectivity (9.0)

PROFESSIONAL EXPERIENCE

Client Name	From Date - To Date
Oracle DBA

Project : Maintenance and support for oracle 7/8i/9i/10g databases.

Responsibilities:

 

	Supporting more than 40 instances.
	·         Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
	·         Automated hot backups using a combination of incremental, differential and full RMAN backups.
	·         Maintaining archive data on appropriate storage devices.
	·         Tracing, troubleshooting with database performance and tuning issues.
	·         Export/Import of oracle databases.
	·         Tuning SQL queries.
	·          Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
	·         Analyzing and validating database objects.
	·         Coordinating with team members.
	·         On call support 24x7.

Environment: Oracle Server 7.0.3/8i/9i/10g, SQL Server, HP –UNIX, AIX, Sun OS, Clarify, SPIN, Business objects.

Client Name	From Date - To Date
Oracle DBA

Project: Maintenance and support for oracle 8i/9i databases.
Responsibilities:

	·          Supporting more than 30 instances.
	·          Installing 9i database.
	·           Upgraded oracle 9i /10g.
	·           Extensively worked on Real Application Cluster (RAC).
	·         Creating stand by database.
	·         Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
	·          Automated hot backups using a combination of incremental, differential and full RMAN backups.
	·          Maintaining archive data on appropriate storage devices.
	·         Tracing, troubleshooting with database performance and tuning issues.
	·          Export/Import of oracle databases.
	·          Tuning SQL queries.
	·         Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
	·         Analyzing and validating database objects.
	·         Coordinating with team members.
	·         On call support 24x7 .

Environment: Oracle Server 9i/10g, Sun OS, FLS

Client Name	From Date - To Date
Oracle DBA

Project: Brodvision Maintenance and support for oracle 8i/9i databases.

Responsibilities:

 

	·           Installing 9i database.
	·         Upgraded oracle 9i /10g.
	·          Creating stand by database.
	·         Extensively worked on Real Application Cluster (RAC).
	·           Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
	·          Automated hot backups using a combination of incremental, differential and full RMAN backups.
	·         Maintaining archive data on appropriate storage devices.
	·          Tracing, troubleshooting with database performance and tuning issues.
	·          Export/Import of oracle databases.
	·         Tuning SQL queries.
	·          Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
	·         Analyzing and validating database objects.
	·          Coordinating with team members.
	·         On call support 24x7.

Environment: Oracle Server 8i / 9i / 10g, Sun OS, Broadvision 7.1

Client Name	From Date - To Date
Oracle DBA

Project : Upgrade from oracle 8i to oracle 9i

Responsibilities:

 

	·         Installing 9i database.
	·          Upgraded oracle 8i to 9i.
	·          Provided and implement the DR solution.
	·         Used Oracle Dataguard tool for creating the standby database.
	·          Automated the process of oracle backup.
	·          Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
	·         Tracing, troubleshooting with database performance and tuning issues.
	·          Export/Import of oracle databases.
	·          Tuning SQL queries.
	·         Maintaining archive data on appropriate storage devices.
	·         Analyzing and validating database objects.
	·          Coordinating with team members.
	·         On call support 24x7.

 

Client Name	From Date - To Date
Oracle DBA

Project: Maximo Management System
Responsibilities:

	·           Installing ORACLE 8i Server and application tools.
	·           Allocating system storage and planning future storage requirements for the database.
	·         Involved in writing stored procedures/functions as per requirements.
	·          Maintaining archived data on appropriate storage devices.
	·         Controlling and monitoring user access to the database.
	·          Database performance and tuning issues.
	·         On call support 24x7.

Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, Toad, Windows NT Maximo 4.1.

Client Name	From Date - To Date
Oracle DBA

Project : Payroll Management System 

The project involves maintaining the monthly payroll of employees of a company & handles the following functions. Maintaining the employee attendance, recording daily working hours, Calculation for standard deduction & net salary.

Responsibilities:

 

	·         Study and Analysis of Business requirements
	·         Interacted with the Technical Design team and contributed in impact analysis and creation of the Technical specifications.
	·         Consistently delivered work assignments within given timeframe, with high quality and zero defect work which was highly appreciated by the client
	·         Was involved in database design and implementation.
	·         Participated constructively to help and enable team members with their challenges
	·          Provided technical assistance to the testing team to understand and setup the testing scenarios and to execute technical intervention test cases.
	·         Involved in end-user training and creating user manual document

Environment: Oracle 8i, Forms 4.5, Windows NT, HP - UNIX

EDUCATION
Degree from Ozmania University - 1996
CERTIFICATIONS