The Production Support Specialist is responsible for managing the successful execution of standard programs and scripts for assigned clients.  In this role, the production support specialist will be assigned to, up to four, existing clients and will ensure that all of the standard database update scripts, file conversions, feeds to other systems, and campaign files are produced according to existing service level agreements.  This individual will schedule programs/scripts, initiate non-automated programs/scripts, monitor the execution of all programs, and perform quality control procedures.  A keen eye for detail is required, as well as, the ability to work collaboratively with internal Extraprise team members.   Strong organizational skills and a customer service orientation are required.

The systems that the production support specialist will be responsible for managing are database marketing systems.  Standard programs and scripts:

• Audit incoming feeds
• Standardize data contained within system feeds
• Update the databases used to support campaigns, reports, and analysis
• Produce campaign files

Responsibilities
Key responsibilities include, but are not limited to the following:

• Schedule standard programs / scripts
• Monitor receipt of incoming feeds, perform audits of incoming feeds, identify exceptions, and resolve issues
• Monitor / Execute all database updated programs and scripts
• Perform daily quality control to ensure that database updates were performed accurately
• Monitor / Execute the programs required to produce feeds to other systems and create campaign files and standard reports
• Trouble shoot and resolve production related issues and case

Required Experience
The ideal candidate will have the following experience:

• 2 - 4 years experience with the development and / or support of 
  • Dos/Windows, BAT, and Wscript scripts
  • T-SQL stored procedures in Microsoft SQL Server 2000
  • ETL processes
• Creation and / or fixing of files in different formats, e.g., CSV, Tab delimited, fixed length, XML
• In-depth understanding of Microsoft Windows NT / 2000 / 2003 operating systems
• Use of an issue tracking tool such as Salesforce.com

Key Attributes

• Ability to work independently, juggle multiple priorities, provide superior client service, problem solve, and communicate with all members of the team
• Strong organizational skills required

Experience
2 - 4 years related work experience

Education
Associates Degree, preferable in computer science or information technology