Abe Elzarad

**** ***** **

Lone Tree Co *****

Cell - 970-***-****

ad2aex@r.postjobfree.com

Objective

Sr. Oracle dba, SQL server database administrator

Summary

Goal oriented successful and adaptable technologist with proven business IT experience. Demonstrated ability to execute and deliver key initiatives. Possess excellent communications and people skills, with deep understanding of major technologies in relational database management systems.

Education

B.S., Computer Science, Mesa State College, Grand Junction, Colorado, 1988

Professional Experience

City of Fort Collins (10/2007- Present)

Sr. Database Administrator - Oracle,SQL Server

General Oracle / SQL server database administration procedures including installation of the databases, schema changes, backup and recovery using RMAN. Support of JDE Enterprise one and GIS and other applications. Ensuring database availability, performance, and continuance monitoring of the database backup and recovery processes implementing performance optimization techniques of Oracle and SQL Server databases. Install, patch and maintain all Oracle software. Tune all Oracle instance components including SQL and PL/SQL. Approve all production schema changes. Control all migrations of Oracle schema objects. Plan growth and changes (capacity planning). Do general technical trouble shooting and give consultation to development teams. Interface with Oracle Corporation for technical support. Database administration involving management of multiple SQL databases in a highly dynamic environment. Performance tuning on MS SQL Server data integrity, data retention, data analysis, and data input / output processing and improving SQL code performance efficiency. Support of JDE, GIS,Sire and Fleet management system software.

ODA – RAC 12C,Exadata 18c.

SIEMENS Power Generation Inc. (3/2006-10/2007)

Sr. Database Administrator - Oracle,SQL Server

General Oracle database administration procedures including installation of the database, schema

changes, backup and recovery. Support of Auto time software generates report for HR and Accounting.

Support the users need installing and upgrading the software. AutoTime support, configuration and

report generation . Support of the SQL server 2005 database and applications.

DexMedia (11/2005-3/2006)

Database Administrator (DBA) (Consultant)

General Oracle (versions 8i, 9i,10g) Database Administration procedures including installation, schema changes, table space management, user security management, memory, and disk space management. Database tuning. Monitoring backup using Rman and sql-backtrack

Ciber (7/2004-9/2005)

Database Administrator (DBA) (Consultant)

General Oracle (versions 9i) Database Administration procedures including installation, schema changes, tablespace management, user security management, memory, and disk space management. Database tuning using statspack created a detail report to Disney to tune the data warehouse database, table partitioning.Xerox capital support of the oracle 9i database for the data warehouse project using oracle enterprise manager.Design and building a data mart for the billing system using Informatica.

Responsible gathering user requirement to build the data mart.Wrinting reports based on users requirements .Creating new tables and views as needed for the developer.Backup of the database using sql-back track Creating and managing users and oracle schemas.Import and export of the tables and schemas using OEM.

American Management Association Saranac Lake NY (3/2004-7/2004)

Database Administrator (DBA) (Consultant)

General Oracle (versions 8iand 9i) Database Administration procedures including installation, schema changes, backup and recovery, tablespace management, user security management, memory, and disk space management. Administrator on Oracle APPS 11.0.28 and installation and support of 9ias 10g.

Supporting Oracle apps 11.0.28 concurrent manager errors.Clean up pending CM process.

Responsible for moving and compiling packages and sql and forms from test to production.

Start and stop all oracle process.Using statspack I was able to improve the performances of the production database and test.Move Production database to Test and reconfigure the apps profile.

Maintain support for oracle apps in training and development and refresh from Production.Responsible for support of AMA data warehouse Epiphany.Recovery and backup of the database using RMAN and Sql-Backtrack.Database security and conectivety on Defferent servers.

Great West Life, Greenwood Village, Colorado (6/2000 2003)

Database Administrator (DBA) & Unix Solaris System Administrator

· General Oracle (versions 7.3 and 8i) Database Administration procedures including installation, schema changes, backup and recovery, tablespace management, user security management, memory, and disk space management.

· On call duty 24x7 throughout the year.

· Managed 8 production databases and 3 development databases on Sun Solaris UNIX using Oracle Enterprise Manager and TOAD.

- Configuration of disk raw devices in UNIX sun Solaris for installation of Oracle

· Responsible for maintaining Oracle Forms 6i and Apache Web Servers.

-Supporting Oracle apps 11.0.28 concurrent manager errors.

-Clean up pending CM process.

-Responsible for moving and compiling packages and sql and forms from test to production.

-Start and stop all oracle process.

· Dealt directly with programmers and users to ensure optimal performance of production packages and procedures.

· Created SQL scripts to automate repetitive tasks such as backup, recovery, import/export, SQL loader, creation of synonyms, tables, indexes, and other objects.

· Administered medium and large scale databases between 20 to 100 Gigabytes.

· Performed data migration (import, export, load) using Oracle SQL Loader.

· Produced stable production environment; monitored and conducted performance-tuning tasks.

· Performed comprehensive Solaris system administration duties including monitoring the operation system, allocating disk space/Veritas, hardware upgrades and user administration.

Denver Water, Denver Colorado (7/1995 - 6/2000)

Oracle Database Administrator (DBA) / Senior Analyst

· Database Administrator for development and support of Oracle 8.05 and 7.3.

· Managed 16 production databases in a Microsoft NT 4.0 environment, responsibilities included: database installation, development, backup, recovery, and database integrity.

· JD Edwards Software support activities: problem resolution at the client/server levels, system and database performance tuning, modifications, and software installations.

· Managed database utilizing Oracle Enterprise Manager 2.4.

· Gathered business requirements and conducted assessments in support of data warehouse.

· Conducted data quality studies focusing on data cleansing, transformations, and utilized Informatica Power mart ETL tools.

· Developed and administered Denver Water data warehouse.

· Designed and created internet/intranet for Denver Water with MS FrontPage 98; Used MS Visual InterDev to add database connectivity in developing the Intranet.

· Administered and maintained all security aspects of MS IIS 4.0 on NT 4.0 server.

· Designed and developed several key applications using Microsoft Access 7.0.

Administered and maintained SQL server for six months include the installation and configuration.

METRO Transit System, Seattle Washington (4/1992 1/1995)

Information Systems and Business Process Analyst

· Responsible for support, maintenance, and enhancement of the Timetable and Bus Stop Systems (utilizing Ingres Windows 4GL).

· Converted APC system from Interact/EXEC to TSO/REXX

· Knowledge of Transit business processes and architecture; Conducted needs assessments and recommended solutions to provide efficient manual and automated work flow.

· Designed, developed, and tested appropriate program solutions; evaluated and recommended computer tools for client and analyst use.

Prairie State Life Insurance Company, Seattle, Washington (4/1989 3/1992)

Computer Operator / Programmer

· Computer Operator for Wang VS/7310. Duties included periodic backup and restoration of data files, generating and running batch files. Responsible for troubleshooting and installing printers, terminals, and personal computers

· Developed business programs in COBOL. Provided modification and maintenance support for agent claims system, user menus, billing, new business, and cancellation systems

.

Recent Professional Training

· Developing Oracle 8i PL/SQL Program Units; Oracle10g SQL and PL/SQL.

· Oracle8i Administration; Oracle10g Performance Tuning; Oracle8i Backup and Recovery.

· Fundamentals of Data Warehousing.

· Solaris UNIX System Administration.

- Operating Systems: Unix Sun Solaris 8, Windows NT, MS Windows, ODA,Linux,VMS.

- Databases : ORACLE 11g, ORACLE 12C ODA-RAC, SQL server 20012 - 20016 .

GUI : Developer 2000, Oracle Apps 11

Languages : SQL, PL/SQL, Korn Shell Scripting,COBOL, JavaScript.

DBMS : Visual Basic Web Server : Oracle 9iAS, Oracle 9iAS 10G.

Personal

Ø United States Citizen.

Ø References Available Upon Request.

Contact this candidate