Senior Data Engineer

Purpose of Position

The Senior Database Engineer is responsible for reviewing, analyzing, modifying, and developing applications for production Enterprise Resource Planning (ERP) and supporting applications.

Tasks and Responsibilities

• Client/server application development, customization, and end-user support for all MRP/ERP, document management, and other miscellaneous database systems
• Interfacing with appropriate personnel to determine and maintain database, server, and application backup and disaster recovery schemes and procedures
• Maintenance of database and MRP/ERP software licensing and administration of program distribution, including the following items: software revision synchronization software licensing maintenance, renewal, and purchasing, and research for software upgrades, automation, and alternative/additional software solutions
• Authoring of process/procedural documentation, which may include the following: application-specific tutorials, training documentation, step-by-step procedural outlines, FAQs, how-to's, and best practices outlines
• Interfacing with appropriate governing groups to ascertain database application and customization needs
• Assists in the specification and maintenance of records for user access regarding access level and available data for each relevant database
• Reviews computer system capabilities, workflow, and scheduling limitations to determine if the requested program or program change is possible within the existing system
• Confers with personnel of organizational units to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be summarized, and formats for reports
• Plans and prepares technical reports, memoranda, and instructional manuals as documentation of process development; assists in preparing training materials for end-user training classes
• Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs
• Assists in studies of existing systems to evaluate effectiveness; develop proposals for new systems or modifications needed to existing systems to improve production or workflow as required
• Prepares workflow charts and diagrams to detail the operations to be performed by equipment, computer programs, and personnel in the system
• Prepares training materials and leads end-user training classes for MRP/ERP system and supporting applications
• Accountable for the control and distribution of documents and equipment subject to export control restrictions and the security of FSI materials, projects, and business information regarding the methods and techniques used in the production and usage of FSI products
• Accountable and responsible for the accuracy and completeness of assigned work and results
• Prioritize and manage workload and communicate issues clearly
• Complete other tasks as required
• Travel when required

Minimum Education

• Bachelor's degree from an accredited institution or equivalent industry experience

Minimum Experience

• 5+ years of experience administrating and customizing SQL Server databases with their associated toolsets in a production or support environment

Knowledge, Skills, Abilities

• In-depth experience developing client/server applications and GUIs utilizing programming languages and tools in a Windows environment. Specifically, Microsoft SQL Server T-SQL programming language, Visual Basic .Net, SQL Server Reporting Services, Crystal Reports, VB Scripting, Microsoft C#, SQL Server Integration Services, ODBC, and ADO.NET
• Strong working knowledge of Windows OS, Microsoft Office, and other Windows-based programs
• Knowledge of UNIX is a plus
• Proficient Windows usage skills
• Required specific application experience customizing, administrating, and supporting the following programs: SQL Server and Syteline or Symix
• Uses experience and sound judgment to plan and accomplish goals. Performs various complicated tasks in a fast-paced, production-critical support environment. A certain degree of creativity and latitude is expected
• Strong written and verbal communications skills
• Excellent organizational skills, including the ability to multi-task and prioritize workload

Physical Demands and Work Environment

The physical demands and work environment described here are representative of those that must be met and/or encountered by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and communicate. The employee may be required to stand, walk, and sit. Specific vision abilities required by this job include the ability to view monitors, technical documents, and reference material. The noise level in the work environment is usually low to moderate.