Senior Software Development Engineer - IBMi/AS400

CVS Health•Richardson, TX

About The Position

At CVS Health, we’re building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care. As the nation’s leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day. Position Summary Join CVS Health as a technical advisor and role model to peers and clients in IBMi application development. This role sits in a dynamic and very visible claims adjudication team where 10 million scripts a day are going through these systems. You will make a difference in the lives of the customers we serve. Within the IBM i application development area you will: Partner with teams and serve as subject matter expert to provide bench-marked solutions to multiple, complex technical projects/initiatives using multiple interlocking technologies. Establish and collaborate on execution of technical direction, standards, guidelines, and methodology for use of specified technologies. Solve highly technical and complex problems for multiple projects or teams. Educate technical staff on new and emerging technologies. Collaborate on strategic and enterprise-wide technical direction. Create or revise operating procedures relating to specific technologies or IS processes. Collaborate on Database Modernization efforts Collaborate on Application Modernization efforts Mentor and train Developers and other team members on Best Practices, New features, and Enhancements on IBM i platform Provide Database and Architecture related services in a technical advisory role and work closely with teams to provide solutions.

Requirements

5+ years of experience and a demonstrated deep understanding of IBMi technology and application development including the following:
5+ years of experience with IBM i, iSeries, System i, AS400, AS/400 platform, i5/OS knowledge
3+ years of experience leading concurrent technical projects on IBMi
5+ years of application development experience in ILE RPG, RPG IV, CL, and DB2 for i SQL knowledge.
5+ years of X-analysis, ALDON, or Hawkeye Experience or similar
Deep understanding of IBMi ILE concepts and implementations.
Maintain, Enhance, and Develop IBM DB2 for i databases.
Develop and manage standards and best practices for SQL and DB2
Experience with iDoctor Job Watcher, PEX, DBMON and other performance tools
Strong relational database design experience
Strong knowledge of IBM Access Client Solutions (ACS) for RUN SQL Scripts and SQL Performance Center.
Able to assist project teams using Visual Explain charts for optimization of SQL statements used in application development solutions and SQL Production Change Requests (PCR) reviews
Strong knowledge of IBM Rational Developer for i (RDi) for application development, system management, including RDi Install support and upgrades.
Strong knowledge of IBMi Operating System, commands, and System APIs, with a proven record of optimizing application programs to maximize the usage of these system services.
Able to understand application code and write SQL statements for data conditioning and replace native file IO with SQL Set based processing.

Nice To Haves

10 + years of IBMi development and tuning experience
Demonstrated successful completion of several medium to large scope projects; proficiency working on all phases of SDLC and with problem determination and resolution through research and fact finding.
Experience with RxClaim or other PBM Adjudication system
Knowledge of HA software and Replication Tools (DB2 Mirror, MIMIX, iTera, OMS, etc.)
Synon experience
Maintain, Enhance, and Develop IBM DB2 for i databases, as well as develop and manage standards and best practices for SQL and DB2

Responsibilities

Partner with teams and serve as subject matter expert to provide bench-marked solutions to multiple, complex technical projects/initiatives using multiple interlocking technologies.
Establish and collaborate on execution of technical direction, standards, guidelines, and methodology for use of specified technologies.
Solve highly technical and complex problems for multiple projects or teams.
Educate technical staff on new and emerging technologies.
Collaborate on strategic and enterprise-wide technical direction.
Create or revise operating procedures relating to specific technologies or IS processes.
Collaborate on Database Modernization efforts
Collaborate on Application Modernization efforts
Mentor and train Developers and other team members on Best Practices, New features, and Enhancements on IBM i platform
Provide Database and Architecture related services in a technical advisory role and work closely with teams to provide solutions.

Benefits

Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.
For more information, visit https://jobs.cvshealth.com/us/en/benefits

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume