Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.
Summary:
DB2 Database Administrator (DBA) with proven experience supporting DB2 v12 (or higher) on an IBM z/OS platform. Primary responsibilities include working with application development teams to install and migrate releases, support execution of data fixes, define new and execute databases recovery functions, definition and execution of standard database tuning procedures (e.g., run stats, reorgs). The target systems for which support is required are the Payroll Management System (PMS), the Pension Payroll Management System (PPMS) and the Financial Management System (FMS).
Primary Responsibilities:
• Ensure that all installation, configuration, and tuning of DB2 databases are completed efficiently
• Author and validate procedures for all database processes
• Identify potential issues and deliver modifications / updates for DB2 programs
• Communicate with and deliver to Tech Support all elements to be migrated with specific instructions to be performed during the production migration
• Assist Systems areas with tool upgrades and participate in Disaster Recovery drills.
• Define and execute databases recovery functions, definition and execution of standard database tuning procedures (e.g., runstats, reorgs).
• Monitor the health of the key database operations (backup / recovery processes, logging, system response times, etc)
• Open and manage tickets logged with IBM to resolution.
• Work with application development teams to install and migrate software releases (DB2 tasks) and support execution of data fixes (backups, packaging for production, etc)
• Perform DB2 DB troubleshooting of online and batch programs during production, user acceptance
• testing, integrated system testing, performance testing and development phases of the work effort.
• Design and execute technical tests to ensure that vendor and Client software deliveries address the business and technical problems in a manner consistent with Client standards for quality and completeness.
• Perform all system administration activities for the IBM InfoSphere Data Replication product. High availability of the product is required as it is a critical part of the City's Financial Management System.
Required Skills:
• Experience with IBM DB2 V12 or higher.
• Candidate must have demonstrated experience working with application teams to build and maintain data propagation solutions - using “IBM InfoSphere Replication Server”
• Experience with CICS transaction server.
• Ability to author REXX scripts.
• Ability to troubleshoot assembler code.
• Installation, configuration, and tuning of new DB2 databases.
• Ability to troubleshoot issues with DB2 embedded within COBOL programs
• Ability to perform all database admin duties (backup/recovery, reorgs, DB trouble shooting).
• Performance tuning at a DB2 system level or individual SQL statements/procedures.
Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
Candidate Privacy Policy
Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:
- What information we collect during our application and recruitment process and why we collect it;
- How we handle that information; and
- How to access and update that information.
Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.
Skills Required
- Experience with IBM DB2 version 12 or higher
- Experience working with application teams to build and maintain data propagation solutions using IBM InfoSphere Replication Server
- Experience with CICS Transaction Server
- Ability to author REXX scripts
- Ability to troubleshoot assembler code
- Experience installing, configuring, and tuning new DB2 databases
- Ability to troubleshoot DB2 embedded within COBOL programs
- Ability to perform database administration duties, including backup, recovery, reorganizations, and troubleshooting
- Experience with DB2 system-level and individual SQL statement or procedure performance tuning
Orion Innovation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Orion Innovation and has not been reviewed or approved by Orion Innovation.
-
Flexible Benefits — Flexibility, remote or hybrid work options, and wellness initiatives are described as available in many locations. Feedback suggests scheduling flexibility and wellness support are notable parts of the package.
-
Wellbeing & Lifestyle Benefits — Wellness resources, mindfulness programs, and fitness or sports benefits are mentioned in several regions. Feedback suggests these offerings add non-cash value to the overall package.
-
Retirement Support — 401(k) plans with potential company match are referenced in U.S.-oriented listings. Feedback suggests retirement options exist, though the strength of matching varies.
Orion Innovation Insights
What We Do
Orion is a leading digital transformation and product development services firm. Headquartered in Edison, NJ, we have a global team of 6,200+ associates, with engineers in 14 major delivery centers across North America, Europe, Asia Pacific and Latin America. For over 25 years, Orion has been solving complex business problems for our clients. Our transformative business solutions are rooted in digital strategy, experience design, and engineering, empowering our clients to operate with agility at scale. Our mission is to serve as an agile and trusted partner for business transformation initiatives, providing deep emerging technology, experience design, and domain expertise. Our business has more than tripled over the last three years. We have grown aggressively both organically and inorganically, adding new clients, complementary skills, domain expertise, and strengthening our global footprint.
