Post Job Free
Sign in

Oracle Sql

Location:
SF, CA
Posted:
November 14, 2012

Contact this candidate

Resume:

Title:Director of Communications

*******@****.***

Document

Source below

NAME:,

ADDRESS:

ADDRESS2:

CITY:

STATE: CA

ZIP:

CANDIDATE ID: 2873756

US CITIZENSHIP:

EDUCATION:

EXPERIENCE: 0

WILL RELOCATE: No -

JOB WANTED:

RATE NEEDED:

TELEPHONE: 415-***-****

EMAIL: *******@****.***

HOMEPAGE:

HOTTEST SKILLS: sql, oracle, database, programming, programmer, cisco, unix, engineer,

os/2, vms, db2, fortran, information systems, pascal, budget, financial, c++, lisp,

mathematica, netware

REVISION: 08-SEP-02

RESUME:

NAME: KENDALL WILLETS

ADDRESS: 625 ASHBURY ST., APT. 10

CITY: SAN FRANCISCO

STATE/PROVINCE: CA

ZIP/POSTAL CODE:

COUNTRY: USA

EMAIL:

PHONE: 415-***-****

CANDIDATE ID: NA

CITIZENSHIP: US

Citizen

EDUCATION: Not Entered

EXPERIENCE: Not Entered

WILL RELOCATE: Not Entered

RELOCATION INFO: Not Entered

JOB WANTED: Any

RATE NEEDED: Not Entered

HOMEPAGE:

COMMENTS:

HOTSKILLS:

KENDALL WILLETS

625 ASHBURY ST., APT. 10

SAN FRANCISCO, CA 941117

^415-***-****

*******@****.***

Voice & Fax 415-***-****

Objective: Creative work in computer systems management and

development.

Skills and Interests: Oracle Database Administration:

Oracle DBA since 1990, experience in multiple environments with table

and index creation, grants, tablespace tuning, monitoring, and

defragmentation, export and import of tables, SQL*NET database links,

performance tuning, software upgrade and installation, hardware

planning, and backup and recovery operations. Oracle Development:

Pro*C and PL/SQL programming for client-server, TP, and data warehouse

environments, performance tuning of SQL statements and routines,

analysis of SQL query plans, index and table design, SQL*Report

programming, SQL*Plus and SQL*Loader scripting, and analysis and

repair of user data problems. CASE-based analysis and user-driven

design. Other relevant experience: Unix, TCP/IP; Mathematical

Analysis; Project Management and Development Methodology; Geographical

Information Systems.

Experience

3/96 to 6/96: Future Presence, Inc.

Client: McKesson Corporation Oracle

Database Programmer/Analyst San

Francisco, CA Oracle 7.2, PL/SQL 2.2, and unix shell scripting on a

data warehouse and production system. Development and tuning of stored

procedures and PL/SQL scripts on a 600-gigabyte, parallel-processing

warehouse with SQL*Net links to multiple production and accounting

systems. Assisting other developers with performance optimization of

long-running processes. Coordinating changes with users, data

administrators, and dba's while maintaining up-to-date design

documentation.

8/92 to 2/96: Advanced Data Concepts, Inc., Ogden

Government Services, Inc. Clients: GSA, U.S. Army Corps of Engineers

Senior Systems Analyst

San Francisco, CA Project leader in developing

a Sybase client-server laboratory test workflow and documentation

system using the IEF CASE tool, Knowledgeware's Objectview, Novell

Netware, and Oracle NLM. Conducted JAD sessions and interviews with

users, developed prototype client screens, and supervised programmer

developing final product. Reverse-engineered an undocumented

Oracle-based project management system using IEF, SQL*Forms, and

Pascal. Developed custom data dictionary using awk, grep, IBM DB2/2,

and REXX to perform source-code analysis of SQL, SQL*Forms and Pascal

source code. Constructed entity-relationship diagram of system and

functional diagrams of program modules. Conducted Division-wide

security accreditation survey of computer systems. Developed District

plan for Geographical Information Systems (GIS) adoption, interviewing

users and managers in Engineering, Construction, Hydrology, Economic

Planning, and Environmental Planning Performed Oracle DBA tasks-

managed storage and fixed data errors for users. Assisted in Oracle v7

transition plan, advising management on upward compatibility issues

and new server acquisition.

3/92 to 8/92: Pace Associates Client: PG&E

Consulting Programmer

San Francisco, CA Oracle database administration

and programming on a project tracking system. Administrated a

departmental database and developed status reports for monthly budget

cycle, using Oracle SQL*Report and low-level printer programming.

Developed budget reallocation facility using Oracle SQL*Forms and

TCP/IP. Installed and tested TCP/IP software for Windows and OS/2.

Diagnosed Oracle software problems and interfaced with Oracle support.

Installed new software patches.

5/91 to 3/92: Barra, Inc. Database

Programmer

Berkeley, CA Assisted in development of a monthly

production database of securities and financial indices, using Sybase

and Unix. Built database interface programs using C, constructed

Sybase triggers and stored procedures, and developed forms using

Sybase APT. Ported Sybase/C Programs to VAX/VMS. Tuned Sybase

Transact-SQL procedures for performance of complex queries, and

advised management of design changes needed for performance

improvement. Supervised contractors performing Sybase/C development.

Evaluated CASE tools and front-end development tools. Assisted users

in retrieving data and researched interface requirements between

Sybase and SAS financial models.

6/90 to 4/91: San Francisco Systems,

Inc

. Client: U.S. Postal Service San Francisco, CA Programmer Part of

a team developing a real time labor-tracking and productivity

management system for use in large postal processing facilities. Used

structured methods to code and test a high-speed transaction processor

in C and embedded SQL (Pro*C) for Oracle 6 on OS/2 and unix platforms.

Served as backup DBA and advised programmers and designers on Oracle

performance tuning and server setup. Developed QA testing database for

detailed functional testing, working with designers using IEW and ADW.

1/88

to 2/90: John Keane and AssociatesProgrammer, Part time

Princeton, NJ VMS and FORTRAN programming for a commercial vendor of

quality management software.

9/88 to 6/89: Rutgers University Teaching

Assistant

Piscataway, NJ Led study sections in pre-Algebra and

Calculus courses, tutored students, and graded tests and quizzes.

8/86

to 9/87

: Sterling Software Real-time Programmer Client: NASA Mountain

View, CA Maintained a 12-site data collection system for use in wind

tunnel testing. Prepared software system for new tests, performed

rapid troubleshooting of running systems, developed fixes for software

problems, and developed enhancements to signal processing

capabilities.

Education Degree: B.S.,1986, Yale University,

Mathematics Special Qualifications: Relevant Training: Motif/X-windows

Programming (1991, 3 days) Oracle v. 6.0 Database Administration

(1991, 1 week) Programming Languages: APL, Assembler, C, FORTRAN,

Lisp, Prolog, Rexx, SQL Relational Database Management Systems: DB2/2

v.2 Administration, C++ and REXX programming Oracle 7.2 DBA, PL/SQL,

Pro*C, SQL*Report Sybase SQL Server dbLib (C) and stored procedure

programming CASE Tools: Texas Instruments IEF, Popkin System Architect

Operating Systems: OS/2, Unix, VMS, DEC RSX-11

Foreign Languages:

French, Chinese (Mandarin), Korean References Available on request.

References



Contact this candidate