Sr. Database Architect/Sr. Programmer Analyst

$85,000 - $145,000/Yr

Denmat Holdings - Lompoc, CA

Full-time - Mid Level

Lompoc, CA

Miscellaneous Manufacturing

About the position

The Sr. Database Architect/Sr. Programmer Analyst position is a full-time role that requires a strong background in database design management and programming, specifically in RPG and on the IBM iSeries/AS/400 platform. The individual will work under general guidance to plan, design, and implement complex data processing systems that align with business requirements. This role is critical in evaluating current system workflows, identifying areas for automation, and enhancing both internal and external customer experiences. The successful candidate will assist the Sr. Manager of IT Applications in managing outsourced development resources, ensuring the effective development of database structures and programs for the IBM iSeries/ERP systems. In this position, the architect will manage and design programming for main systems that interact with third-party systems, such as EPCIS serialization and Laser etching systems. The role involves leading the design and recommending programming approaches that optimize efficiency, system architecture, and cost-effectiveness. The architect will also be responsible for monitoring data integrations and improving the data architecture for reporting purposes. This includes conferring with user departments to identify computerization needs, analyzing existing systems, and developing or recommending modifications to enhance functionality. The position requires a thorough understanding of programming languages to code computer instructions based on system documentation, as well as testing and debugging programs. The architect will also be responsible for training personnel in data entry procedures and maintaining technical documentation related to program development and changes. Post-implementation, the architect will monitor program performance and provide user training and support. This role does not have supervisory responsibilities but requires a collaborative approach to work with various departments and stakeholders.

Responsibilities

• Evaluate current system workflow processes and identify areas for improved automation to increase efficiencies and improve the external and internal customer experience.
• Assist the Sr. Manager, IT Applications in managing and leading outsourced development resources for development of IBM iSeries/ERP database structures and programs.
• Manage, architect, and design programming for main systems that interact with external 3rd party systems such as EPCIS serialization and Laser etching systems.
• Lead, design, and recommend programming designs to establish the best approach in terms of gained efficiencies, system architecture, and cost.
• Manage and monitor data integrations that integrate data from iSeries and between various applications.
• 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.
• Confer with user departments to identify computerization needs and determine how the desired results can be achieved.
• Analyze existing systems and programs and develop or recommend new systems or modifications to existing systems.
• Review and analyze system specifications to determine whether all required elements have been included.
• Consult with clients to gather information about program needs, objectives, functions, features, and input and output requirements.
• Analyze, define, and document requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs.
• Use programming languages to code computer instructions from the systems documentation.
• Utilize various special programming techniques necessary to achieve the most effective program.
• Test and debug computer programs.
• Modify existing programs to conform to system changes or to make improvements in the existing program.
• Advise and work with user departments to resolve specific problems or make changes in programs, computer applications, capabilities, alternative programming approaches, limitations, etc.
• Train personnel in user departments in any specific procedures necessary to enter data into terminals for computer processing.
• Write and maintain technical documentation to describe program development, logic, coding, testing, changes, and corrections.
• Monitor performance of programs after implementation and provide user training and follow-up support.

Requirements

• 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.
• 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).
• 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.
• Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry.

Nice-to-haves

• Preferred experience in Python, JSON, XML, Rest API.
• Preferred experience in ERP Infor LX, BPICs.

Benefits

• 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
• Employee discounts