Sr. Oracle DBA OCP

••••• Working status: U.S. Citizen
••••• •••••
Sr. Oracle Database Administrator (•••••)•••••
Enterprise Data Architect


Objectives: To work as a Sr. Oracle Database Administrator/ Architect in an organization that regards the quality of work, and good communications among its top priorities.

HIGHLIGHTS
Oracle Database Administrator, Analyst and Architect (for ••••• years)
Experienced database programmer (PL/SQL Stored Procedures)
Fluent in French, English and Arabic
Oracle Certified Professional (OCP) with Oracle University test score of %•••••
Regular columnist for JO-Amman Oracle magazine
Quick to understand new ideas
Self-directed and effective


Apps:
Oracle •••••g, •••••g, 9iR2, 8i, 8; MS SQL Server 7; CASE tools (ErWIN), Oracle Designer, Toad

Platforms:
Windows •••••; Linux Red Hat Enterprise ••••• •••••bit; HP-UX •••••; Solaris •••••; NT SP 4, AIX Unix.
•••••
Depends on Oracle version available at given period of time; %••••• of all the work I done include:
Oracle Database Administration: Installing the Oracle Database Software; Creating Database; Managing the Oracle Instance; monitor the database alert log and dynamic performance views; Managing Database Storage Structures; Administering User Security; Managing Schema Objects; Managing Data and Concurrency; Managing Undo Data; Implementing Database Security and Enforcement; Configuring the Oracle Network Environment; Proactive Maintenance; Performance Management; Performing Backup; Performing Flashback; Moving Data via different methods; Configuring Recovery Manager; Performing Database Recovery ;Recovering from User Errors; Dealing with Database Corruption; Flashback Database; Using Recovery Manager; Recovering from Critical Losses including recovering from loss of all control files; Monitoring and Managing Storage; Automatic Storage Management (ASM); Monitoring and Managing Memory; Using Globalization Support Objectives; DBVERIFY etc. and
Managing Resources; Automating Tasks with the Scheduler.
Oracle RAC Administration including: RAC Installation; Database Creation: RAC DB Administration; Backup and Recover a RAC DB; RAC DB Monitoring and Tuning; RAC environment Services configure and manage
Cluster Management including: Oracle Clusterware Installation, administration/diagnosing the Oracle Clusterware components and node addition/removal.

WORK HISTORY

Medical Data & Imaging Systems (M2S), West Lebanon, NH
Oracle DBA/ Architect
Aug ••••• Jan •••••
M2S dose not have an Oracle production database, I am helping in setting up and configuring the Oracle Clinical Application (OC) for a Clinical Trial Registry. And to help the with the introduction to the Oracle as a new product in their environment.
I configured Oracle Backup and Recovery System. helped the QA testing the new OC.
I helped the developers to move the data and the programs from PostgreSQL Database into the Oracle database format.


Demoulas Market Basket Supermarkets, Inc. Tewksbury, MA
Oracle Database Administrator/ Architect
March ••••• •••••
Duties included installation, configuration, tuning, and administration of Oracle 8i production and development. UNIX administration on HP-UX •••••i server of production and development servers Other duties. Database Administration for live production Oracle OLTP / DSS systems Optimization, including optimization for mixed OLTP/DSS systems. Upgrade of Oracle8i to Oracle9i then to Oracle•••••g and Oracle database server software using OFA methodology.
Physical and logical database design and configuration; data modeling using CASE tools (ErWIN) and Toad; business analysis of data collected in databases, for business development support; reporting on historical data archived Legacy system into Oracle database using external tables.
Databases monitoring the Tuning the databases with Enterprise Manager
Scheduled jobs for scripts by setting up Unix cron jobs using crontab.
Wrote complex PL/SQL Stored procedures for OLTP/DSS database
The enterprise databases handles large amount online transactions from ••••• large supermarkets concurrently, I monitor, tune and keep up to the minuet with all the databases on the day-to-day and hour to hour bases. I handle all the life-cycle and care of the all issues of the production databases.
I make myself available ••••• hours as the nature of this line of work expects for the DBA.
And I kept good communication with my supervisor.

EDS NASD, Openwave, Onesource, Deloitte. : Small database contracts
Oracle Database, general
Feb ••••• March •••••
Duties included installation, configuration, administration and tuning of a multiinstance Oracle environment, including interpretation of user requirements to provide appropriate database solutions. I was also responsible for Oracle server upgrades; configuration and administration of NLS environment for multilingual databases; troubleshooting and resolution of database problems and bugs. Duties also included assisting developers and technical consultants with relational database design and with implementation, including query optimization and writing stored procedures. In addition, I created the DBAdmin tools, written in Perl and PL/SQL, to facilitate textbased administration of multiple concurrent Oracle instances.

Environment: HA, Oracle9i, Oracle•••••g, NT, HP-UX, RAC, SAS, BI

Hewlett-Packard ( Boston, MA )
Oracle DBA/ Architect
March ••••• February •••••
Production administration for live Oracle systems simultaneously hosting several OLTP and DSS applications, with wide variations in load Designed, created and maintain highly complex ETL / data reconciliation packages to carry out mixed load and reconciliation of data from several heterogeneous data sources into central financial database. , Normalization and entity relationship mapping for the inter transportable data between the data warehousing and the OLTP databases, Extensive work with backend database tables of PeopleSoft Upgraded production and development systems from 8i to 9iR2 Optimization, including optimization for mixed OLTP/DSS systems
Tuning: I/O, memory usage, SQL optimization, rollback segment configuration and optimization; database init & configuration parameters; etc.
Designed schema for inventory application in Oracle Designer, including data model; designed and created ETL from static and warehouse sources for same SQL optimization for both OLTP and DSS applications Physical database design and configuration, including server configuration and future capacity planning Database backup and restore, including media recovery Coordinate and arrange crossbusinessunit data flow with IT peers in other business units.

EMC Corporation (Boston, MA)
Regional Software Support Specialist II
July ••••• March •••••
Carry out all DBA duties for EMC clients onsite, to best perform with EMCs EDM, worked with Symmetrix Operations. Database RMAN tuning; administration of production instances; Oracle upgrades and patches in conjunction with EMC products; data modeling and application design; installation and configuration; developer support; etc. for Oracle ••••• •••••, and 9iR2 •••••g on Red Hat Linux, AIX etc.
Served as level one, technical support and disaster recovery specialist for Oracle database in conjunction to EMC products where I traveled nationally and internationally to the clients site to resolve complex Oracle database tuning and backup/recovery issues.

TCP, Burlington, MA
Oracle DBA/ Architect
March ••••• July •••••
Designed and implemented complex Backup and Recovery architecture for multiple databases.
Implemented Disaster recovery system for HP-UX systems and the databases they host.

Bostongas Eastern Enterprises, Boston MA
Senior Oracle DBA
February ••••• March •••••
As a DBA, fully responsible for ••••• Production Databases on 9 Servers from A to Z.
Solved all issues of Performance Tuning, upgrades, back ups, recovery.
Wrote Backup, Recovery scripts for Database, Monitoring Transaction Concurrency, Consistency, Auditing the Database, Monitoring Users etc.

Massachusetts Institute of Technology , Cambridge, MA
Senior Oracle DBA
August ••••• February •••••
Installed Oracle Databases on ••••• servers for MIT.
Creating Databases, Monitored, Tuned Multiple databases.
Managed development Process, Transaction Concurrency and Consistency.
Did Storage Allocation, Rollback Segments, Resource Usage, Database Access, Database Audit, Database Security, Networking and finally, Backup, Recovery.

State Street Bank / Unisys, Boston, MA
Oracle DBA
May ••••• August •••••
Installed, Configured Oracle on UNIX system.
Created production Database for new application that they purchased.
Giving quota to users, implemented Backup and recovery scripts.
Taught permanent Sybase DBA staff to become Oracle DBA.

Oracle Corporation, Boston, MA
Senior Technical Consultant
January ••••• April •••••
Traveled through out U.S. to rescue critical production databases.
Built, installed Oracle Parallel Servers (OPS), in addition to Tuning, Backup, Recovery, Database Warehousing.

Harvard Medical School, Boston MA
Oracle DBA
February ••••• January •••••
Carry out all DBA duties, Performance Tuning, Backup and Recovery; Shell scripting.

Budget Bureau, State House, Boston, MA
DBA Programmer
January ••••• December •••••
Work one RDBMS with ERD and data modeling.
Created, maintained Databases, Designed Physical and Logical layouts.

Metropolitan Boston Housing Partnership Inc. Boston MA
Oracle DBA
December ••••• December •••••
Introduced, installed Oracle, created, maintained database, perform all DBA responsibilities.
Migrated other applications to Oracles PL/SQL.
I was the primary contact with all maintenance support issues with the hardware and software providers

Public Facilities Department, Boston MA
Sr. Programmers/Systems Analyst
July ••••• December •••••
Designed, coded, and implemented unique customized financial/fiscal management computer programs which performed all financial tracking and generated reports from simplest to most complex report requirements.
Wrote technical and user manuals for all programs, created self-running demo for presentations.
Used Oracle on Unix platform, did administration task.


Blackpool Strategic Software Planning Corporation, Tampa, FL
Management Information System Developer
April •••••July •••••
Replaced manual system with complete customized RDBMS management network system, which kept track of all aspects of business.

Education:
St. Petersburg Jr. College, Clearwater FL •••••
Batchelor of Science (C.S.) DLHU •••••
Certified Oracle OCA and OCP •••••, Oracle University