Banner Image

All Services

Programming & Development

Database Administration

$40/hr Starting at $25

Tracker II: Responsible for all system updates and maintenance for Tracker II, a construction management system written in VB 6, using SQL Server 7 as back-end database. The database is constructed as an object database overlaid on a relational database. Designed tables and views, wrote triggers and stored procedures and was responsible for database as DBA. I am responsible for system performance and index creation and tuning. I am very familiar with Query Analyzer and Enterprise Manager applications. Wrote many custom interfaces to database for MS Office applications, including Outlook, Excel and Access. Typical application was to retrieve a specific recordset (via RDO or ADO) into an Office application, and then present the data after programmatic manipulation in Excel or Outlook. Air Pressure Control Center Incident Monitoring and Tracking: Designed system for monitoring air pressure incidents within the phone system, and allowing operators of process and dispatch repairs

About

$40/hr Ongoing

Download Resume

Tracker II: Responsible for all system updates and maintenance for Tracker II, a construction management system written in VB 6, using SQL Server 7 as back-end database. The database is constructed as an object database overlaid on a relational database. Designed tables and views, wrote triggers and stored procedures and was responsible for database as DBA. I am responsible for system performance and index creation and tuning. I am very familiar with Query Analyzer and Enterprise Manager applications. Wrote many custom interfaces to database for MS Office applications, including Outlook, Excel and Access. Typical application was to retrieve a specific recordset (via RDO or ADO) into an Office application, and then present the data after programmatic manipulation in Excel or Outlook. Air Pressure Control Center Incident Monitoring and Tracking: Designed system for monitoring air pressure incidents within the phone system, and allowing operators of process and dispatch repairs

Skills & Expertise

AccessAdoAirConstructionConstruction ManagementCustomer SatisfactionExcelManagementMicrosoft SQL ServerMsMs OfficeOutlookProcessingReportsSportsSQLStored ProceduresSurveys

1 Reviews

  • Kevin_Wetherby says,

    Very easy to work with. Quick response, professional approach, and understood what I was asking for. I think he was one of thirty that actually addressed my questions on the initial job posting!

    for Software add-on on Apr 05, 2004