Data Oracle

DALJIT SINGH DEOL ***********@*******.***

*** * ********** **

Arlington Heights, IL 60004 847-***-****

Professional Objective: Obtain a position for life cycle database system development, To install and configure

Database Management Systems as well as maintain, enhancing, security and training of the users.

Summary of Qualifications: ORACLE RDBMS 10G DBA, ORACLE ENTERPRISE MANAGER, PL/SQL, MS

SQL,BPEL, ZENOSS, Oracle Forms, Oracle Reports, Oracle Designer, SQL Server, Microsoft Office, Java, “C I.T

experience as Data Base Administrator, System Analyst, Data Base developer. Successful experience in development of

the life cycle software process. Background includes Relational Data Base design and administration. Collaborative team

player with the ability to interact with vendors and customers.

Work History

H M Creative Solutions Bloomingdale, IL April 2011 to Present.

Data Base Administrator

Responsible for assisting in the development and maintaining of databases for Invensys Controls Carol Streams, IL.

Responsible for process analysis, design, mapping, and re-engineering. Full life cycle Oracle 11i implementation upgrade

project completion in a functional role with Oracle Financials.

Built an Oracle database infrastructure from the ground up. Involved in the evaluation, review, and management of

database resources and services across the organization in order to ensure a high level of data quality is reached and

maintained.

US AIR FORCE March 2004 to March 2011

IT SPECIALIST (DATAMGT)

IT Specialist at National Air and Space Intelligence Center, WPAF Base, Ohio. Monitor data base operation, performance

as well as storage requirements of GEOINT production, Development, and Testing databases. Proactive to data base

architecture issues to improve the data base performance. Analyzed the different data base schemas and procedures from

different vendors. Designed ER model for Data warehouse by using ERWIN. Provided 7 x 24 support to upload special

event data within 2 hours.

Supported the data base operation by monitoring the daily nightly back up of production data which can be

used for recovery of data due to disaster.

Supported the data base operation by monitoring the disk space for storage of data files as the database

growth. Controlled growth of disk space on tablespaces.

Provide required Space for the new data by adding new files to the logical tablespaces for the uninterrupted

Data base expansion.

Developed and tested reports using Oracle Reports as well as Oracle Forms for data input.

Maintained correspondence with vendors. Proactive analysis of new database schema tables.

Maintained data base security for moving data as per standard security guidelines.

Maintained data base security by restricting read, writes, and delete privilege to the required data base tables

only for report generation. Created user accounts with password for the individual users.

Monitored SQL Server,data base operation, performance as well as storage requirements of GEOSPATIAL Production,

Development and Testing databases.

Proactive review of data base architecture issues to improve the data base performance.

Analyzed the different data base schemas as well as procedure from different vendors.

Supported the analysis team by loading daily in the morning all incoming flat files format data into the

data base tables using Oracle loader . Developed interfaces using Java and C++ for extracting and loading data into data

base.

Created new data base user accounts with a pass word and assigned them the required privileges and

resources to prepare reports.

Installed and configured BPEL Process Manager Development tool on the TUNGSTON to monitor database

in the GUI environment. Installed and configured GENOSS Infrastructure management tool.

EDUCATION

BS Information Science Northeastern Illinois University, Chicago Il

MS Computer Science 15 Cr Hrs complted Illinois Institute of Technology Chicago, Il

Professional Training

ORACLE DATABASE 10G ADMINISTRATION WORKSHOP II. ORACLE Education Center, Cincinnati.OH

ORACLE DATABASE 10G ADMINISTRATION WORKSHOP I. ORACLE Education Center, Indianapolis, Indiana

ORACLE FINANCIAL FUNCTIONAL FOUNDATION ORACLE Education Center, Chicago, Illinois.

EXTENDED ORACLE APPLICAION Release 11 ORACLE Education Center, Chicago, Illinois

SQL*Forms ORACLE Education Center, Chicago, Illinois.

Contact this candidate