This position is primarily responsible for converting data from specifications and statements of problems to computer code by performing the following duties personally or though subordinates.
ESSENTIAL JOB FUNCTIONS*:
Consults with supervisor, systems analysts, other programmers, and end users to gather information about program intent, functions, features, data requirements, input requirements, output requirements, internal and external checks and controls, hardware and operating system environment, and interfaces with other systems.
Designs or writes program specifications based on consultations with supervisor, systems analysts, other programmers, and end users.
Converts designs and specifications into computer code.
Compiles code into programs and corrects errors detected in compile process.
Creates test transactions and runs tests to find errors and confirm program meets specifications.
Analyzes code to find causes of errors and revises programs. Writes and maintains documentation of changes to computer code, programs, and specifications.
Designs and codes layouts for onscreen user interfaces, printed outputs, and interfaces with other systems.
Reviews user and technical documentation written by others to confirm consistency with program operations.
Provides technical assistance by responding to inquiries regarding errors, problems, or questions with programs.
Revises program for corrections, enhancements, or system environment changes.
Trains end users or technical support staff to use and support program.
Coordinates with other programmers about program revisions.
Develop new products as part of the project team.
Mentor Analysts on technical and functional aspects of the applications.
Attend staff and departmental meetings.
Provide status updates to Supervisor and Manager.
Adherence to pre-defined programming standards.
Provide recommendations regarding further definition of development standards and application architecture principles.
Create documentation using established PMO standards. Perform unit testing and assist in user testing of programming modifications.
Maintain technical knowledge through training or other measures.
Address system problems during off hours with the guidance from other members of the development staff as needed.
Translate high-level requirements into detailed technical designs.
Provide technical estimates.
Lead and facilitate design sessions and code walk-throughs.
Develop and maintain effective partnerships with Client’s product development and business teams in order to understand and anticipate their needs, the business environment, other challenges and opportunities.
Disseminate information on any problems or potential delays.
Coordinate with multiple internal and external groups.
When assigned, build database objects from source, create database release deployment scripts and distribute release notes.
When assigned, develop and maintain documentation on all database build procedures.
Perform other duties as assigned.
*Employees in the position are required to perform the function; removing function would fundamentally change the job.
**The company reserves the right to add or change duties at any time.
SKILLS: Excellent organizational, troubleshooting, and problem solving skills are required. Ability to work on multiple projects concurrently with minimal direction and provide real time, critical support. Ability to keep detailed, accurate records.
Bachelor’s degree in MIS, Computer Science, or related field, or equivalent combination of education and experience required. 5+ years’ experience with SQL Server, e.g. T-SQL stored procedures, functions, views, triggers, indexes, query tuning, and SSIS required. 5+ years database development experience required.
5+ years’ experience with SQL, Transactional SQL, Stored Procedures, RDBMS required.
5+ years’ experience with SQL Server.
5+ years’ experience with ETL tools such as DTS or SSIS (SSIS Preferred).
Extensive experience with designing and documenting relational databases.
Experience with using source control systems such as VSS, CVS or TFS.
Experience with Windows, Linux, Unix and/or iSeries.
Experience with index tuning and query optimization
Experience as a Database Developer in an Application Development environment.
Experience in Enterprise information integration is preferred.
Excellent organizational, troubleshooting, and problem solving skills are required.
Ability to work on multiple projects concurrently with minimal direction and provide real time, critical support.
Ability to keep detailed, accurate records.
Excellent oral and written communication Spanish and English required.
Problem identification and resolution.