Senior Mainframe Systems Programmer - DB2 Physical

1 month, 3 weeks 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

Senior Manager, Software Engineering (Data & Storage Services)

Affirm 1K-5K Diversified Financial Services

Affirm is seeking an experienced Engineering Leader to lead its Online Storage team within the Data and Storage Services organization, driving scalable storage strategy and execution for critical data systems that support new products and business needs.

CockroachDB DynamoDB Memcached MySQL PostgreSQL Redis
1 hour ago

Associate Director, Data Management

Apogee Therapeutics 1-10 Biotechnology

Apogee Therapeutics is hiring an Associate Director, Data Management to lead clinical trial data management activities across multiple programs at a clinical-stage biotechnology company.

GCP
1 hour, 45 minutes ago

Principal Database Engineer, Data Engineering

GitLab 1K-5K Internet Software & Services

GitLab is hiring a Principal Database Engineer to shape and operate the PostgreSQL platform behind GitLab.com and self-managed deployments, with the goal of improving reliability, scalability, and cost efficiency at global scale.

GitOps Microservices PostgreSQL
2 hours, 30 minutes ago

Database Engineer

Tucows 251-1K Diversified Telecommunication Services

Wavelo, part of Tucows, is hiring a Database Reliability Engineer to design and operate PostgreSQL infrastructure for large-scale, mission-critical telecom systems in a remote-first Canada-based role.

Ansible Bash Datadog Encryption Go Grafana HAProxy Kafka Linux Load Balancing PostgreSQL Prometheus Python SaltStack SQL Terraform Traefik
2 hours, 45 minutes 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