Senior Mainframe Systems Programmer - DB2 Physical

1 month ago
Full-time
Senior
DevOps and Infrastructure
Ensono

Ensono

Ensono provides comprehensive hybrid IT solutions and governance, enabling businesses to navigate complexity and modernize their technology infrastructure, from cloud services to mainframe systems, tailored to each client's unique journey.

IT Services
1K-5K
Founded 1969

Description

  • Perform DB2 mainframe software upgrades and work with vendor personnel to resolve database problems.
  • Provide day-to-day database maintenance including backups, restores, monitoring file extent growth, and scheduling reorganizations.
  • Create and maintain disaster recovery (DR) procedures and execute DR tasks in cooperation with Disaster Recovery Services.
  • Monitor and tune DB2 performance, including buffer pool tuning, SQL review, and general reporting/analysis of database configuration.
  • Fulfill customer service orders (CSOs) and provide primary support for reported problems related to DB2 tablespaces.
  • Support customer migrations and new-customer transitions, assisting project managers to resolve technical hurdles and meet migration targets.
  • Respond to and troubleshoot production database issues and evaluate change requests for impact to assigned clients.
  • Provide security-related DB2 support, review DB2 security for potential risks, and implement related policies and procedures.
  • Participate in on-call rotations and provide 24x7x365 support across multiple time zones.
  • Follow ITSM change control procedures and adhere to schedules that efficiently manage resources for timely implementations.

Requirements

  • Bachelor’s degree required and/or equivalent work experience.
  • 10+ years of professional DB2 Systems Programming support experience (including IDAA); experience with CA and IBM DB2 tools is a plus.
  • Experience configuring and managing DB2 in a Parallel Sysplex environment and SMP/e experience.
  • Demonstrated experience establishing policies and procedures for database management, DR, security, maintenance, and utilization.
  • Experience reviewing new DB2 versions for functionality and advising on client benefits.
  • Experience with reorganization of application data, tuning internal DB2 buffer pools, and reviewing SQL performance.
  • Ability to evaluate change requests, troubleshoot and resolve production database issues, and respond quickly to multiple client requests.
  • Experience supporting DB2 security requests and reviewing DB2 security to identify potential risks.
  • Knowledge of best practices for software management, maintenance and documentation and the ability to develop strategies/processes/best practices.
  • Strong communication skills, ability to multi-task, work independently and as part of a team, and participate in after-hours on-call support.

Benefits

  • Estimated pay range $85,000 to $148,000 annually (placement varies by skills and experience) plus eligibility for an annual bonus.
  • Equity grant under the Associate Equity Appreciation Program (depending on eligibility).
  • Unlimited paid days off and flexible work schedule with remote/work-from-office options when not required on client site.
  • Three health plan options and eligibility for dental, vision, short- and long-term disability, life and AD&D coverage, and flexible spending accounts.
  • 401(k) with company match.
  • Family forming benefit including fertility coverage and adoption/surrogacy reimbursement, plus paid childbearing and parental leave.
  • Education reimbursement, student loan assistance or 529 college funding, and sabbatical leave.
  • Wellness program.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

PostgreSQL Database Administrator

Ivanti 1K-5K Internet Software & Services

Ivanti is hiring a Database Administrator to join its growing DBA team to ensure the reliability, deployment, performance, and continuous operation of Ivanti Cloud database services across cloud platforms.

AWS Azure MySQL PostgreSQL
1 month ago

PostgreSQL Database Administrator

Ivanti 1K-5K Internet Software & Services

Ivanti is hiring a Database Administrator to join its growing DBA team to ensure the reliability, deployment, and continuous operation of Ivanti Cloud services while improving database performance and efficiency.

AWS Azure MySQL PostgreSQL
1 month ago

Database Administrator - Remote US

Smile Digital Health 251-1K IT Services

Database Administrator at Smile Digital Health (remote, US) responsible for maintaining and optimizing company and client data stores and data management practices to ensure reliable, high-performing data operations for the Smile FHIR-based health platform.

ActiveMQ AWS Azure Kafka MongoDB NetSuite Oracle PostgreSQL Snowflake SQL SQL Server
1 month ago

Engineering Manager - Data and Infrastructure

Istari 11-50 Aerospace & Defense

Istari Digital is hiring an Engineering Manager, Data & Infrastructure to lead the team responsible for the core data layer and operational foundation of the Istari platform, delivering secure, reliable, and scalable data and infrastructure for self-hosted and restricted environments.

Argo CD AWS CI/CD Cybersecurity Helm Kubernetes PostgreSQL Terraform
1 month ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers