Sr. Database Architect/Sr. Programmer Analyst

Under general guidance, plans, designs and implements complex to highly complex new or enhanced data processing systems in support of business requirements. 

Essential Duties and Responsibilities include the following. Other duties may be assigned.

1. Evaluate current system workflow processes and identify areas for improved automation to increase efficiencies and improve the external and internal customer experience.
2. Assist the Sr. Manager, IT Applications in managing and leading outsourced development resources for development of IBM iSeries/ERP database structures and programs.
3. Manage, architect, and design programming for our main systems that interact with external 3^rd party systems such as EPCIS serialization and Laser etching systems.
4. Lead, design, and recommend programming designs to establish the best approach in terms of gained efficiencies, system architecture, and cost.
5. Manage and monitor data integrations that integrate data from iSeries and between various applications.
6. Improve the data architecture of source data for use in reporting through target database design and program development to gain efficiencies and improved data transformation.
7. Confers with user departments to identify computerization needs and determine how the desired results can be achieved.  Analyze existing systems and programs and develop or recommends new systems or modifications to existing systems. 
8. Reviews and analyzes system specifications to determine whether all required elements have been included.  Consults with clients to gather information about program needs, objectives, functions, features, and input and output requirements. 
9. Analyzes, defines, and documents requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs. 
10. Uses programming languages to code computer instructions from the systems documentation. Utilizes various special programming techniques necessary to achieve the most effective program. 
11. Tests and debugs computer programs. 
12. Modifies existing programs to conform to system changes or to make improvements in the existing program.
13. Advises and works with user departments to resolve specific problems or make changes in programs, computer applications, capabilities, alternative programming approaches, limitations, etc. 
14. Trains personnel in user departments in any specific procedures necessary to enter data into terminals for computer processing. 
15. Writes and maintains technical documentation to describe program development, logic, coding, testing, changes, and corrections. 
16. Monitors performance of programs after implementation and provides user training and follow up support.

Additional Duties and Responsibilities include the following. Other duties may be assigned.

1. Assist in design of special forms as needed. 

1. Other duties as assigned.

Supervisory Responsibilities

This position has no supervisory responsibilities.

Education and/or Experience 

Bachelor’s Degree from a 4-year college or university in Computer Science or related field with five years of related experience; or equivalent combination of education and experience. 

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the described functions.

Language Skills 

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, employees, clients, customers, and the general public. 

Mathematical Skills 

Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. 

Computer Skills

Ability to work with data processing, programming, systems design, problem analysis, and hardware.

Experience with database design management and code development in RPG.

Experience programming on the IBM (Iseries, AS/400)

Experience in securing access to IBMi through security protocols

Knowledge of SQL Server Administration and programming (stored procedures, triggers and views.)

Preferred experience in Python, JSON, XML, Rest API

Preferred experience in ERP Infor LX, BPICs

Certificates, Licenses, Registrations

None required.

Knowledge, Skills, and Abilities 

Knowledge of medical device manufacturing or related field.

Ability to be recognized as a technical expert in company systems.

Ability to meet deadlines.

Ability to establish and maintain moderately complex documentation systems.

Ability to communicate effectively, orally and in writing, with employees of various disciplines within various departments, and all other internal and external contacts.

Ability to accurately perform detail-oriented work.

Ability to be flexible in changing daily workload priorities as directed.

Ability to maintain accuracy, consistency, and quality in a fast-paced, multi-task environment.

Ability to coordinate and synchronize multiple projects.

Ability to function in a controlled environment regulated by FDA GMPs and handle confidential data.

Ability to use MSWord, Excel, and various office machines such as personal computer, FAX, copier, and telephone.

Physical Demands and Work Environment  

The physical demands and work environment characteristics described here are representative of those that must be met 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 the job, the employee is regularly required to stand; walk; talk and hear; sit; use hands to finger, handle or feel; use one or both hands repetitively; grasp simply and lightly; grasp using one or both hands; stoop, kneel, bend, or crouch; to climb or balance including use of stairs; and to lift and/or move up to 10 lbs.  The employee is occasionally required to push and/or pull; use one or both hands with fine dexterity; use extended and overhead reach with hands and arms; work around equipment and machinery; walk between buildings; and to lift and/or move up to 25 lbs.  Normal vision (with corrective lenses, if necessary) is required for the job.  The work environment is usually moderate to quiet.

The posted range for this position is $85,000-$145,000 annually which is the expected starting base salary range for an employee who is new to the role to fully proficient in the role. Many factors go into determining employee pay within the posted range including education, prior experience, training, current skills, certifications, location/labor market, internal equity, etc.

The posted range for this position is $85,000-$145,000 annually which is the expected starting base salary range for an employee who is new to the role to fully proficient in the role. Many factors go into determining employee pay within the posted range including education, prior experience, training, current skills, certifications, location/labor market, internal equity, etc.

DenMat offers a complete benefits package, including Medical/Dental/Vision/Rx, Company Paid and Optional Life Insurance, 401(k) with matching contribution, Vacation, Sick Pay 10 paid company Holidays (or Float Days), Bereavement, Jury Duty Pay, Employee Assistance Program and employee discounts.

DenMat participates in E-Verify.

DenMat Holdings, LLC is an Equal Opportunity/Affirmative Action Employer; employment with DenMat is governed on the basis of merit, competence and qualifications and will not be influenced in any manner by race, color, religion, creed, national origin/ethnicity, veteran status, disability that can be reasonably accommodated without undue hardship, sex, sexual orientation, gender identity, age, citizenship, marital status, or any other legally protected status.