
IT-Sr Systems Mgmt Analyst/28/TEC156
Software Technology · United States
Weak hiring record · median 372 days open
- First seen
- 12 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- Open 372 days
- 99% of this employer's openings are over 60 days old
In its favour
- Still listed on the employer's own board
What is the specific title of the position? DB2 Developer
Work location? Telecommute
Work hours? 8-5CST
Migrating from an IBM Netezza (Mako) PureData environment to an IBM DB2 Sailfish appliance. Work would include migrating and updating to DB2 compliance existing infrastructure, data, ETL jobs to new environment.
Please describe the team the candidate will be working with - how many members? Approx. 5 immediate team members, 2 DBAs and 2 ETL developers, one contractor familiar with Sailfish. Broader team includes functional areas of Campaign, Reporting and Analytic personnel ~8 people.
What are the top 5-10 responsibilities for this position (please be detailed as to what the candidate is expected to do or complete on a daily basis)?
- Ability to analyze existing code and modify w.r.t db2 with strong background in database programming using DB2/SQL (i.e., stored procedures, functions, triggers, and packages).
- Ability to demonstrate understanding of database concepts (i.e., normalizations/de-normalizations, schemas, table spaces, temporary tables, views, indexes, sequences, partitioning, UDF and Triggers etc).
- Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool.
- IBM DB2 Stored Procedures - Research, gather and analyze information.
- PL/SQL Programming (IBM DB2), Unix.
- Working experience in database security, primarily on encryption and decryption concepts is plus.
- Strong experience with performance tuning for PLSQL coding.
- Ability to translate business requirements into technical design documents.
- Good knowledge of UDF's/UDA's, cursors, functions, views, materialized views indexes, collections, triggers
What does the ideal candidate background look like
Ideally someone that has actually done a Mako to Sailfish migration or something similar.
What skills/attributes are required - See attachment. Need someone that can demonstrate they have done similar work.
What will the interview process look like? Phone interview. How many rounds? 1-2 rounds or a panel interview.
How technical will the interviews be? Very technical
Required Skills
15. Top 3 requirements? 1. Ideally someone that has actually done a Mako to Sailfish migration or something similar 2. Ability to analyze existing code and modify w.r.t db2 with strong background in database programming using DB2/SQL (i.e., stored procedures, functions, triggers, and packages). 3. Ability to demonstrate understanding of database concepts (i.e., normalizations/de-normalizations, schemas, table spaces, temporary tables, views, indexes, sequences, partitioning, UDF and Triggers etc). 4. Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool. 5. IBM DB2 Stored Procedures - Research, gather and analyze information. 6. PL/SQL Programming (IBM DB2), Unix. 7. Working experience in database security, primarily on encryption and decryption concepts is plus. 8. Strong experience with performance tuning for PLSQL coding. 9. Ability to translate business requirements into technical design documents. 10. Good knowledge of UDF's/UDA's, cursors, functions, views, materialized views indexes, collections, triggers
Basic Qualification
Additional Skills
Background Check
Yes
Drug Screen
Yes
Notes
Qual is this Thursday at 11am - Need to present the best 3 Interview process (how many rounds, who is involved?
)
One round with the hiring manager and a follow up with the manger and senior leader.
Selling points for candidate
Project Verification Info
Exclusive to Apex
No
Face to face interview required
No
Candidate must be local
No
Candidate must be authorized to work without sponsorship ::No
Interview times set
Yes
Type of project
Assessment/Analysis
Master Job Title
Misc
Non-Technical
Branch Code
Minneapolis
More jobs at Software Technology
All 8,015- F&B - Network Engineer 2Software Technology · United Statestoday
- Treasury - Help Desk AnalystSoftware Technology · Pennsylvania · United States · USD 20–23/hr2d ago
- AI Engineer – Azure AI Foundry & PythonSoftware Technology · Texas · United States · USD 70/hr3d ago
- IT - SCDMV - Programmer - Project Lead - M365 SharePoint Online EngineerSoftware Technology · Blythewood, SC, United States · USD 5/hr3d ago
- AI EngineerSoftware Technology · Minneapolis, MN, United States · USD 75/hr6d ago
Similar roles
- IT Asset Mgmt AnalystSAIC · Quantico, VA, United States2d ago
- Sr. Manager, Data Analyst - Risk Mgmt ProductCapital One · Chicago, IL, United States · McLean, VA, United States · Richmond, VA, United States · USD 200,700–229,100/yr3mo ago
- Cyber Posture & Vulnerability Mgmt Analyst IJackson · Lansing, MI10d ago
- Identity & Access Mgmt Analyst - IT Security - Full TimeGuthrie · United States1mo ago
- VULNERABILITY MGMT ANALYSTArete · Falls Church, VA, United States · USD 90,000–120,000/yr2mo ago
- Info Mgmt. Analyst & DATA MODELING EXP.Fallon Health · Worcester, MA, United States · USD 130,000–145,000/yr2d ago