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

• 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

• 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

• 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

• 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

• 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)