David
Freeman, DBA
757
Natoma Street, San Francisco, CA 94103; (415) 505-8682;
[email protected]
Career Objective: To obtain a production and/or
development database administrator position to utilize my experience
and skills with the Oracle and Microsoft database management systems.
EXPERIENCE
Database
Administrator,
Stellent, Inc., San Francisco (3/00
- 11/02)
-
Responsible for the
administration and maintenance of three Oracle production databases,
and
production (24X7) and development Unix Sun Solaris 7/8 database
servers, for J2EE Internet application Kinecta.net;
administered
and maintained production (24X7) and development Unix Sun Solaris 7/8
Stronghold and Apache web servers.
-
Created all new data structures and physical structures for
the Production Database Servers: Tables, Indexes, Triggers,
Sequences, Views, Tablespaces, Datafiles, cross-platform Database
Links.
-
Managed user Security and Resource allocation for Production
Database Servers. Created users and Granted user permissions.
-
Upgraded from Oracle 8.1.5 to 8.1.7 and migrated data
structures
- Interacted
with Oracle Support to resolve emergency data recovery problem
resulting from user error. Created and Managed TAR requests through
Oracle Technet.
-
Acted as sole Datacenter, Webserver and Network Administrator
for Unix (Solaris, Linux) and Windows (NT, 2000 Server) production
servers. This included Firewall (Firewall-1 for Nokia), Router
(Cisco), HTTP server (Stronghold Apache), Application Server (JRun,
Weblogic) and Sendmail administration, as well as managing TCP-IP
addresses and routing internally and for NAT (Network Address
Translation) and packed filtering for outside world. Managed DNS
servers (both Production and Internal)
-
Well versed in using vi editor and “ed” editor to modify
configuration files and documents from the terminal. Used shells
CSH, KSH Bourne Shell and BASH. Used X1186 Server through SSH for
remote use of graphical interface to monitor databse and internet
traffic for production services.
-
Performed billable consulting services for customers using
Oracle and legacy databases (Oracle Parallel Server, Replication).
-
Identified and resolved performance bottlenecks within the
production database server and on their Operating Systems (Solaris,
Linux).
-
Performed program
database-related Java for JDBC-enabled, J2EE-compliant, and
Information Content Exchange (ICE) standards-compliant Enterprise
Java application (Stellent
Connection Server);
wrote and tuned the application's queries to support Oracle SQL,
Sybase T-SQL, Microsoft T-SQL, and MySQL SQL.
-
Wrote stored procedures for
Oracle, Microsoft SQLServer, and Sybase SQLServer, including
procedures for dynamically creating database objects via a Java
program; created a Visual Basic for Applications module for upgrade
scripts shipping in product to enable compatibility with Microsoft
Access; worked as part of a team to design a database adapter for
exposing legacy content repositories to a syndication server.
-
Independently developed and administered an intranet Oracle
backend database application for internal bug tracking and workflow
collaboration using Avensoft PerfectTracker server and PerfectScript
for front end; created a specialized backup and recovery plan to meet
the needs of business management.
- Systems
Integration Consultant, Programmer, Required Technologies, San
Francisco (3/99 - 3/00)
-
Created a collaboration
application for Microsoft Exchange Server using Visual Basic and
Visual Basic Script to enable LotusNotes functionality not otherwise
provided by MS Exchange; designed custom Microsoft Word templates and
styles for clients migrating from WordPerfect; developed a
database-driven process engine application using Visual Basic and
Microsoft SQLServer.
-
Technical lead for project
developing a custom automated document assembly application for law
firm client using Visual Basic and Microsoft Word; wrote HotDocs
(markup and scripting) templates for integration with ProLaw
docketing software and Sybase SQLAnywhere.
SKILLS
Database
- Oracle,
Oracle OCP, Sybase SQLServer, Microsoft SQLServer, MySQL, Microsoft
Access, ANSI SQL, ERStudio, ERWin, ChyfoPro, J2EE, ssh, ssl,
PerfectTracker, data migration, backup & recovery, import/export,
performance tuning
Internet
& Server Software
- Weblogic
Application Server 6.0/6.2/7.0, Oracle 11i Application Server, JRun,
JBoss, Apache, VNC, Nokia Firewall, Firewall1, Stronghold, Tape
backup, Veritas
- Networking
Protocols and Filesystems
- TCP-IP,
Net8, SQLNet, SMTP, POP3, HTTP, XFS, NFS, SMBFS
Operating
Systems
- Solaris
7/8/9, RedHat Linux (6.4/7.0/7.2/8.0/9.0/Fedora), SuSE Linux,
FreeBSD, Windows 2000 Server, Windows NT, telnet, sh/csh/bash/tsh/ksh
shell scripting, ssh, scp, tar, rsh, ftp
Programming
- Java
language API, JDBC, CVS, ODBC, Oracle RMan TCL, Visual Basic, Visual
Basic Script, Visual Basic for Applications, HTML, DHTML, Javascript,
XML, ICE, PerfectScript, J2EE Web Application, Perl, PHP, software
internationalization
Workplace
- Values
user feedback; willing to provide software training to employees and
clients; proven team player; excellent verbal and written
communication skills
EDUCATION
University
of Michigan
Major:
Philosophy (plus Greek, Latin, French, Russian, Hungarian) (9/87 -
5/91)
Oracle
University
Program:
Oracle Database Administration Training (8/00
- 3/01)