*** *. ***** ***. #****

Los Angeles, CA *****

213-***-****

accrjt@r.postjobfree.com

joel safirstEIN

PROFILE 17 years experience on the iSeries (AS400) as DB2 DBA/Analyst, CL and

•

SQL programmer including 3 years as iSeries System Administrator.

4 years MS SQL Server Administrator.

•

3 years MS SSRS (Reporting Services) Report Writer

•

3 years as an Oracle 8i DBA on a Windows NT environment.

•

Project lead experience and former Army Flight Officer.

•

OBJECTIVE Work as an MS SQL, DB2 DBA/Analyst and report writer or entry level C# and

•

ASP.NET programmer.

Develop and manage teams as a project leader eventually moving into a

•

management position.

SKILLS & Databases: MS SQL 2008, DB2 400 (iSeries), Oracle 8i (Windows NT), MS Access

ABILITIES

Programming languages: SQL, Control Language AS400 (CL), entry level C# &

Java, HTML

Operating systems: OS 400, Windows NT, Windows XP, 7, 8, 8.1

Software: MS SQL Server 2008, MS SQL Reporting Services, MS Visual Studio C#

2010 & 2013, NextGen (medical software), ERWin, IBM Operations Navigator, Oracle

Enterprise Manager, Kronos, MS Office Professional, Visio, Business Planning &

Control System (BPCS), Sylvon Change Management Control, Query 400, Query

Manager 400, NGS Query, Synon, Fast Fax 400, PVCS Tracker, Heat, Veritas, Quest

Toad.

Hardware: IBM AS400 (I Series), Dell, HP, Compaq Servers & PC, Apple, Kronos

Ethernet Clocks

EXPERIENCE MS SQL ADMINISTRATOR AND DEVELOPER, EISNER PEDIATRIC FAMILY

PRACTICE MEDICAL CENTER

JAN 2011 – JAN 2014

Database administrator responsible for installation, maintenance, security, backup,

recovery and training on MS SQL Server 2008.

SQL and C# developer for NextGen Medical Software.

Created stand alone database and C# application for Dental department integration.

Tested data migration from HealthPort EHR to NextGen.

Supported clinical staff test and QA during data migration and implementation.

Developed and tested migration scripts from NextGen to home built dental database.

Stored procedures, functions and trigger programming.

SSRS Report developer for federal, state and city grants along with clinical data

dashboards.

Created reporting dashboards for Finance, Pharmacy and Executive Staff.

SQL performance tuning and index maintenance.

Help desk supervisor.

Assist CIO with major projects.

ISERIES (AS400) DB2 DBA AND CONTROL LANGUAGE DEVELOPER, UNITED

HEALTH GROUP

MAR 2009 –SEP 2010

Lead database administrator for IBM's iSeries (System i / AS400).

Responsible for the operation, performance tuning, security, administration and

maintenance of a multimillion dollar production database.

Support Application Developers with SQL tuning and explain plans to optimize

application performance.

Train application developers in SQL coding, SQL tuning, explain plans, journaling

(transaction logs) and IBM iSeries tools.

Project lead for upgrading the database component for an iSeries operating system

installation.

Lead troubleshooter for SQL performance and disk space problems.

Lead automation developer for monthly Explanation of Benefits (EoB) processes.

Page 2

Develop database utility programs for iSeries non conversant personnel.

Conform and establish service level agreements (SLA) for users regarding

responsibilities and services provided by the DB2 database administrator.

Lead index strategy developer.

Develop SQL scripts for monthly iSeries metrics.

Ad hoc SQL queries for departmental reporting needs.

ISERIES ADMINISTRATOR, FRONT PORCH JAN 2008 –

JUN 2008

iSeries administrator responsible for security, backup and recovery.

Kronos administrator responsible for installation, configuration and troubleshooting.

Messenger Plus (PMlus) administrator responsible for installation, configuration and

troubleshooting.

Assist supervisor with major projects.

Technical support for help desk and users.

Daily status reports.

DB2 DATABASE ADMINISTRATOR, MATTEL, INC FEB 2004 – NOV

2007

Designed C# database production applications connecting to a DB2 database on an

AS/400 (iSeries) platform providing emergency database recovery, metrics and a

myriad of tools.

Designed C# applications for developers to refresh data on development and test DB2

databases, FTP data from production to development and myriad of developer tools.

Designed C# applications on a Citrix server used as a portal to the AS/400 for remote

access.

Taught myself C# and was enrolled in C# courses at UCLA.

Responsible for the operation, performance tuning, security, administration, and

maintenance of a multi million dollar production database on an IBM AS/400 DB2

midrange computer.

Page 3

Support Application Developers with SQL tuning and explain plans to optimize

application performance.

Train application developers in SQL coding, SQL tuning, explain plans, journaling and

IBM iSeries tools.

Establish service level agreements (SLA) for users regarding responsibilities and

services provided by the DB2 database administrator.

Establish "Best Practices" procedures for DB2 disaster recovery, maintenance,

support & administration.

Provide monthly and quarterly metrics for growth, system and database utilization.

Participated in decommissioning and migration of our enterprise application from an

OS390 to AS400.

Responsible for connectivity between DB2 Gateway in a Unix environment, ODBC

and JDBC drivers running MS Access and Excel to DB2 on an AS400.

Responsible for multi national support on AS400 partitions for Mattel's international

interests.

Database Administrator, Delta Dental PMI NOV 1999 – JAN

2004

Responsible for the development, operation, performance tuning, security,

administration, and maintenance of a $122 million production database on an Oracle

8i Windows NT platform and on an IBM AS/400 DB2 midrange computer.

Responsible for the development, operation and maintenance of a web based

electronic eligibility MS SQL database.

Responsible for the operation, security, administration, and maintenance of PVCS

Tracker and Heat support systems on both an Oracle and MS SQL databases.

Wrote several database utility programs to aid database administrators, developers

and QA testers improve efficiency in their respective tasks.

Wrote and published standard operating procedures, system documentation, help text

and training materials for database operations, change management control

procedures, disaster recovery and backup operations.

Developed and maintained data model and data dictionary using ERWin.

Page 4

Developed change management control policies and procedures for monthly system

upgrades.

Developed programs, criteria and procedures to archive and purge obsolete data from

the production database to a data warehouse by interfacing with end users and

application developers.

Troubleshoot and implement solutions for technical issues.

Database Administrator, Pan American Underwriters JAN 1998 – OCT

1999

Responsible for the operation, administration, maintenance and security of a $120

million database on the IBM AS/400 midrange computer. Provide data models for

system analysts.

Implement electronic commerce and Internet connections to our database.

Implemented, trained and operated our new change management control software.

Provide technical support and training for vendor products.

Publish system documentation, help text and training materials.

DB2 Database Administrator, Republic Indemnity Co. MAR 1995 – JAN

1998

Responsible for the operation, administration, maintenance and security of a $200

million database on the IBM AS/400 midrange computer. Provide data models for

system analysts.

Implement electronic commerce and Internet connections to our database.

Implemented, trained and operated our new change management control software.

Provide technical support and training for vendor products.

Publish system documentation, help text and training materials.

Create tables in SQL, DDS and HTML, and programming in CL and HTML.

Page 5

Information Systems Manager, Project & Marketing Manager Phillips Industries.

SEP 1992 – MAR

1995

Project Manager in charge of installing, training and implementing new computer

system and manufacturing software from an IBM System36 to an IBM AS/400.

Chief Information Officer for a $40 million manufacturing company.

Responsible for systems administration over the IBM AS/400 midrange computer and

Business Planning and Control System (BPCS) software, including; electronic data

interchange (EDI), Token Ring administration, security, bar coding, communications

and training.

Responsible for all aspects regarding the management, training, acquisition,

installation, connection and software for all personal computers and scanners.

U.S. Army Aviator, Operations Security & Public Affairs Office

DEC 1986 FEB

1992

D Company, 1 501st Aviation Regiment, Seoul Airbase, Korea

C Company, 3 159th Aviation Regiment, Ft. Irwin, CA

UH 1H "Huey" pilot in general support and air assault aviation units. Responsible for

the safe, timely and professional aviation support for U.S. forces, United Nations

Command and visiting dignitaries.

Developed and maintained operations security programs for units lacking information

protection. Arranged and conducted quarterly security briefing and instruction classes.

Directly responsible for obtaining professional media coverage, both television and

newspaper. Wrote articles for the Army's Korean newspaper.

UC IRVINE, MICROSOFT CERTIFIED SQL SERVER COURSES

EDUCATION

Maintaining a MS SQL Server 2008 DB (MS Course 6231A)

Implementing MS SQL Server 2008 Database (MS Course 6232A)

Implement & Maintain MS SQL Server 2008 Reporting Services (MS Course

6236A)

Page 6

Implement & Maintain MS SQL Server 2008 Integration Services (MS Course

6235A)

Implement & Maintain MS SQL Analytic Service (MS Course 6234A)

Writing Queries Using MS SQL Server 2008 (MS Course 2778A)

C# Design Patterns (MS Course 2359)

UNIVERSITY OF SOUTHERN CALIFORNIA, MASTERS OF SCIENCE SYSTEMS

MANAGEMENT

UNIVERSITY OF FLORIDA, BACHELOR OF ARTS ENGLISH

ORACLE UNIVERSITY, SAN DIEGO EDUCATION CENTER

UCLA EXTENSION, CERTIFICATE IN FILM AND TELEVISION

ARMY HELICOPTER FLIGHT SCHOOL & WARRANT OFFICER ENTRY COURSE,

FT RUCKER, AL

ARMY BASIC TRAINING, FT JACKSON, SC

MISCELLANEO Web DevelopmentConversational Spanish, working knowledge of German and

US SKILLS Hebrew. Airplane and Helicopter pilot licenses: (Airplane; single engine, commercial

rating. Helicopter; single turbine engine, instrument commercial ratings.)

AWARDS Army Commendation Medal, National Defense Service Medal, Good Conduct Medal,

Army Service Ribbon, Overseas Ribbon, Expert Marksman Badge.

HOBBIES & Screenwriting, Martial Arts, Fitness, Aviation and Harley Davidson motorcycles.

INTERESTS

AVAILABLE UPON REQUEST.

REFERENCES

Page 7

Contact this candidate