OBJECTIVE

• To pursue a challenging position as a DBA in a software design and development firm that utilizes my skills and experience.

SUMMARY

• Over 10 years of experience in IT industry. Extensive experience in various roles in implementing life cycle of the projects as a DBA, developer, architect.
• Has extensive knowledge of data architecture, data warehousing and business intelligence solutions.
• Possess excellent technical, leadership, organizational and communication skills.
• Proven ability to lead in both, business and technical environments, to define and assign tasks, and to coordinate project activities.
• Experience in both operational and analytical environments, deployment and implementation is of corporate Data warehouses and Data Marts, Metadata and relational applications.
• Worked as business Architect, Data Modeler, Data Architect and Systems Analyst.
• Strong in data modeling techniques, database design and implementation.

TECHNICAL SKILLS

Hardware: PCS, Sun Sparc, Hp - 9000, NCR 3450, AIX

Operating System: MS-DOS, Unix, Unix Server 4.0, Hp-Ux, Sun/Os, Ms-Windows, WindowsNT.

Software: Datawarehouse, informatica tools 5.0/6.0, Cognos, Business objects.Oracle 7.2/7.0/8.0/8 i/9i, Ms-Access, Oracle*Forms 4.5/6.0/6i,reports 6i, Sql, Pl/Sql Oracle discoverer, Oracle*Reports, sql loader, ERWIN, Oracle*Graphics 2.5, Visual Basic 3.0, Peoplesoft 8.0, Peoplecode, Peopletools I/Ii, Sqr/Sql, Designer 2000, data modeling, Powerpoint, Sqr Reportwriter, Ms-Word, Excel

Language: Basic, Sql, Pl/Sql

Applications: Peoplesoft Financial, Peoplesoft HRMS / Payrol, StudentAdmin Module.

Database: Oracle 5.0 to 10g

PROFESSIONAL EXPERIENCE

Confidential

DBA

Responsibilities:

• Worked on AIX system supporting retail databases and financial databases.
• Coordinated with sysadmins to build lpars in a RAC environment.
• After LPARS were built, installed oracle software and created databases in the RAC environment.
• Built data guard in RAC environment.
• Applied patches as required.
• Set up export, RMAN backup scripts to take backup and other scripts as per the requirement.
• Wrote shell scripts to set up backups, alertlog file rotation, cleaning up the log files as required.
• Performed various database activities such as performance tuning, monitoring, and maintenance of users.

Technical Environment: Confidential -AIX, oracle 10g, RAC, Clusterware, Dataguard, TOAD, PL/SQL, OEM,SQL Server

Confidential

DBA

Responsibilities:

• Applied database patches as required.
• Provided day-to-day support for users and application databases.
• Troubleshooted performance issues and problems on databases.
• Analyzed and resolving data issues that caused problems on production databases.
• Created database objects as required to implement data projects and size storage structures appropriately.
• Implemented database changes in production, testing, staging environments.
• Created user accounts on different databases as required and also managing security issues.
• Migrated databases objects from one database to another by using export and import scripts.
• Created database objects as per the requirements such as tables, indexes, tablespaces, views etc.
• Checked backups and taking backups of different databases as required.
• Wrote scripts for database monitoring and performance tuning. Supporting QA and development team with the database activities. Maintaining and creating userids, roles etc. Applying releases and patches for various databases.

Technical Environment: WindowsNT, Sun-Solaris, TOAD, SQL/PLSQL, Oracle 9i, 10g, OEM.

Confidential, MA

PeopleSoft Developer

Responsibilities:

• Worked in PeopleSoft Student Admin Module, HR and financial modules.
• Troubleshooted daily issues with design and coding using peopletools, application engine.
• Supported customers and resolving issues with student admin application.
• Created SQR’s for certain customizations and to produce output files and to load data.
• Worked on “on-line student admission” project which is in design phase.

Technical Environment: PeopleSoft 8.6.0, peopletools, Application engine, configuration Manager. WindowsNT, sun-solaris, TOAD, SQL, SQR, oracle 9i, database size: gigabytes

Confidential, Windsor, CT

Application DBA/Data Modeler

Responsibilities:

• As a part of the assignment I was also involved in application tuning, problem resolution, and the management of database integration and migration activities, table maintenance, data Modeling.
• Involved in physical designing of databases, debugging existing scripts, data base user creation and permission on live production Financial Databases where security and uptime are of prime importance.
• Created tables, tablespaces, and indexes using physical design of designer 2000.
• Responsible to monitor the day-to-day tasks of team members to maintain consistency, effective communication, and tasks completed on time, project related issues and resolutions, etc.
• Was involved in tuning, used explain plan, statspack, sqltrace and views like v$session wait.
• Worked closely with many developers on a daily basis to process requests such as executing the codes in production environment, table structure changes, tuning of query, releasing locks, security issues etc.
• Queried v$session wait, v$session, v$sysstat, v$session wait, v$sgastat to check session waits. Locks, dictionary cache, library cache.
• After migration of the developer’s code from one environment to other, used sql scripts to find if there are any invalid objects or if developer is missing any access requirements to the required tables (inserts, updated etc).

Technical Environment: Oracle 8i/9i, Windows NT 4.0, PL/SQL, SQL PLUS, Toad and Developer2000, database size: terabytes, 6 to 8 databases.

Confidential, Denver, CO

Data Modeler

Responsibilities:

• After creating the ERD model and thereby creating the database, created indexes, tablespaces, and maintaining the tables. Modules are created using designer 2000, which has Web Server option, and by using this option modules are generated and deployed on the web.
• Created forms and reports for those modules.
• Analyzed and documented existing databases, data structures, definitions, metadata, ETL processes.

Technical Environment: Oracle 8i, Windows NT 4.0, PL/SQL, SQL PLUS, and Designer2000, forms 6.0/6i, reports 6.0/6i. Database size: gigabytes, two databases.

Confidential

Programmer

Responsibilities:

• Was Responsible for developing and designing Forms, Reports.
• This project involved modifying existing Oracle applications reports using designer 2000 and created reports from the scratch and registered in the Oracle applications.
• The modules include financials, accounts receivables, purchasing. Designed Sales Order report, Invoice report, Request for quotation report.
• Designed some custom conversion forms. This project deals with the automation of Pittsburgh steel inventory, sales order, invoices etc. In the process, created some tables also. Wrote procedure depending on the requirement

Technical Environment: Oracle 7.3.4, Windows NT 4.0, PL/SQL, SQL PLUS, Developer2000, Designer 2000, Oracle Applications 11.0, database size: terabytes, databases 4 to 5.

Confidential, Atlanta, GA

Senior Programmer

Responsibilities:

• Objective of this assignment was identifying the Y2K impacted modules, testing the various business cycles involved in billing and enrollment of the customers, rectifying the errors encountered for the system to be Y2K compliant.
• Tested entire system by aging the data to for leap year. Involved in preparing test plans, test cases by interacting with users and documentation.
• Was involved in testing the Y2K impact programs for various different business cycles with different databases of "YEAR 2000 PROJECT- ATLANTA GAS AND LIGHT, UTILIPRO INC".

Technical Environment: Oracle 8.0/7.3.4, Windows NT 4.0, PL/SQL, SQL PLUS, Developer 2000, SCTBanner, Sun Solaris 5.6, database size: gigabytes, 6 to 8 databases.