Find Jobs Find Talent
DB2 Developer
Minneapolis, Minnesota  |  Remote, Onsite
Contract Position
It appears that you have already applied to this job.
Applied on September 30, 2022
Job Id #59313 Posted September 16, 2022


Description:

  • 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.

Essential Responsibilities

  • Assist with migration from an IBM Netezza (Mako) PureData appliance to an IBM DB2 Sailfish environment.
  • Responsible for converting and moving existing data infrastructure and ETL jobs to new environment.
  • Responsible for developing, updating, and testing production code.
  • Consistently creates optimal design adhering to architectural best practices; considers scalability, reliability and performance of systems.
  • Makes sound design/coding decisions keeping customer experience in the forefront.
  • Takes feedback from code review and apply changes to meet standards. Conducts code reviews to provide guidance on engineering best practices and compliance with development procedures.

Required Skills/Experience

  • 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
  • Strong communication skills, Strong analytical skills, and ability to write technical specifications - minimum 5+ years of experience working in DB2 Databases.

Preferred Skills/Experience

  • Good knowledge of best practices for database design and development.
  • Ability to work well with Business Analysts, software engineers, and quality assurance personnel.
  • Ability to multi-task and adhere to prioritized needs.
  • Ability to communicate effectively with business users, understand their needs and develop sound solutions to complete work as requested.

Education

  • Bachelor's degree
  • 5-6 years of relevant experience

Ideal Background:

  • Ideally someone that has actually done a Mako to Sailfish migration or something similar.

Team and Team size:

  • 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.

Top Responsibilities:

  • 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

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity?

What is your Veteran / U.S. Military Status?

Do you identify with one or more of the classifications of protected veterans below?

If yes, please indicate by checking the appropriate box below

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm