DBA/Java Developer
Omniva Policy Systems (formerly
Disappearing Inc.) - San Francisco, California 08/99 to present
-
Sole DBA for Sybase installation, maintenance tuning servers company wide
(RH 6.1 & Solaris 2.7)
-
Write bash scripts to install, monitor and maintain databases and database
servers
-
Write java/jdbc interface between proprietary keyserver and sybase database
-
Write tsql stored procedures called by jdbc interface CallableStatements
-
Write java/jdbc utilities to fill databases with test data for load testing
purposes
-
Write servlets (.jsp, .html, javascript) to allow installation of windows
based Policy Mail client
-
Write migration scripts between old and new schema
-
Implement Microsoft Passport page for corporate website
-
Installed Oracle 8i for Linux
Web Programmer
iSyndicate - San Francisco,
California 04/99 to 08/99
-
Wrote Perl cgi programs to allow custom searches in MySQL server (through
DBI)
-
Wrote Perl scripts to generate static html pages for corporate website
DBA
Buydirect.com - San Francisco,
California 12/98 to 04/99
-
Upgrade Sybase SQL Server from version 11.0.3 to 11.9.2 in Sun Solaris
2.6.
-
Upgrade production SQL Backtrack from version 3.0.1 to 4.0.50. Schedule
all production db backups.
-
Author stored procedures to create customer email address lists and daily
site sales figures based on Open Market Transact 4.0 db schema.
-
Author shell scripts to perform backup, restore, and montoring tasks.
-
Monitor db performance and space requirements using DBGeneral and Sybase
SSM.
-
Author Perl5 object oriented process controller to schedule and monitor
end of day data warehousing jobs.
System Administrator
Narrowline - San Francisco,
California 12/97 to 12/98
-
Narrowline's primary Sybase db administrator and technical support contact.
Install and administer Sybase SQL Servers (11.0.2, 11.5) in Sun Solaris
(2.5,2.6) environment.
-
Schedule dbcc and other integrity checks. Troubleshoot and patch Sybase
servers.
-
Create custom datatype and stored procedures.
-
Write and maintain triggers for data warehousing.
-
Schedule and implement dumps, loads, and backups.
-
Map data to new dbs. Optimize tempdb and application queries
-
Ensure PC connectivity through ODBC
-
Author and update Perl5 scripts and packages to maintain and monitor Unix
hosts, monitor filesystems and services such as DNS and ad server processes,
archive source code, and support 24/7 web commerce operation.
-
Configure and install Apache webservers, sshd, CVS, named, and other Unix
daemons and services. Manage user accounts, mail service, etc.
-
Completed Sybase "Advanced SQL Server Administration" course, at Sybase
in Emeryville CA, 01/98.
