Oracle DBA Sample Resumes

Oracle DBA Sample Resume 2-5 Years Experience



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