PMCS SERVICES
Austin, TX
Post Resume to
View Contact Details &
Apply for Job
Job Description :
We are looking for a Full-time/Contract employee for a SQL Server Express Database Consultant.
What it is supposed to do...
  1. Public users submit list of data that are saved into a SQL Server Express DB using a asp/web application
  2. Batch File accesses tables within the database and exports to a csv file output.
  3. Output then is transferred via sftp to an external server.
What it does
  1. It times out after #2 above - the csv file is then incomplete and subsequently does not transfer. 
  2. Gives an error message - ERROR: Problem unloading training info from the CPE database. Error= Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.
  3. Due to staff turnover, we are unclear the location of the source code for the process above. 
What we need....
  1. Evaluate Visual Studio program that times out while accessing SQL Server Express Database. 
  2. After evaluation, if it cannot be determined where error occurs, recreate process for the agency.
  3. Document all of it.
Agency has SMEs on staff to describe process. Agency can provide access to required servers for work and demonstrate processes. 
CANDIDATE SKILLS AND QUALIFICATIONS(Required):
  • Microsoft SQL Express Visual Studio (VB.net, C#, asp.net) Heidi SQL Some DBA experience preferred.
             

Similar Jobs you may be interested in ..