Mainframe Database Administrator DB2/IMS

2 weeks ago


Hartford, United States Avance Consulting Full time
Job DescriptionJob Description

Job Title

Mainframe Database Administrator

(Application DBA and System DBA)

DB2, IMS, Datacom

Relevant Experience(in yrs)

5+

Work Location (State, City and Zip)

Hartford, Connecticut

Technical/Functional Skills

Experience in Mainframe Db2 v11 & v12 and IMS v13, v15 Database System-Administration on z/OS

DB2, IMS internals, installation, upgrade, patching, configuration and operations

Proficiency in DB2, Datacom, IMS Systems Performance Tuning and Capacity Planning

Experience in Data Sharing setup in Parallel Sysplex environment

Knowledge in RACF, CICS v5.5, Mainframe MQ v9

Experience in SMPE and ISV tools installation and migration

Create and maintain database entities, including instances, databases, table spaces and tables

Database DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertise

Experience with Database ISV Tools and Products like OmegaMon and AdminTool

Application related performance tuning; Write, modify, and debug database specific SQL queries

DBA related utilities like Unload, Load, DSNJU003, DSNJU004, Reorg, Runstats, image copy

REXX, CLIST, JCL, JES and Assembler knowledge

Perform daily system monitoring tasks using SYSVIEW and Datacom utilities

Create and maintain DQRY users.

Create, alter and maintain area tables for access through CA-IDEAL, CA-DQRY.

Roles & Responsibilities

Manage BAU (Business As Usual) Service Delivery for Mainframe DB in a Technical Capacity

This is for a pure Technical Hands-On role and not for a Team Lead Position

Work on MI (Major Incidents) / P1 (Priority-1) and lesser Tickets as a part of BAU Support

Provide Business hours support and then On-Call support as is the norm in BAU Service Delivery Role.

Ensure Mainframe System Availability @ 99.99% and work towards meeting agreed SLAs

Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements

Recommend operating system and database performance monitoring, tuning and configuration changes

Experience with database physical and logical design, query analysis and optimization

Provide technical assistance and subject matter expertise to applications groups

Provide database storage management and capacity management recommendations

Define and manage database security and access permissions in consultation with customer

Ensure completion of authorized Service Requests, Changes, Problem tickets

Manage escalations and track Service Delivery and ensure SLA compliance including with vendors

Review and update the SOP documents on regular basis

Support on all in-flight and upcoming project activities

Recommend and perform customer-approved database replication procedures



  • Hartford, United States Smart IMS Full time

    ** Provide server and related infrastructure support to the Connecticut Department of Public Health State Laboratory, which is implementing new laboratory information management systems and a new high-performance computing device for genomic sequencing work •Installing, configuring, and maintaining server hardware and operating systems •dministration and...


  • Hartford, United States SUNRISE ACCOUNTING & TAXATION SERVICES LLC Full time

    Job DescriptionJob DescriptionJob Title: Administrative AssistantOverview: As an Administrative Assistant, you will play a crucial role in ensuring the smooth operation of the office environment. You will provide administrative support to ensure efficient office management, handle clerical tasks, and assist with various organizational responsibilities. Your...

  • Church Administrator

    2 weeks ago


    Hartford, United States Immanuel Congregational Church Full time

    Job DescriptionJob DescriptionCHURCH ADMINISTRATOR, HARTFORD, CTPOSITION DESCRIPTION  (Full time/Exempt)STARTING SALARY – 60K to 70K with medical, dental and retirement benefitsResponsibilities:·       Assist the Sr. Pastor with management of the operations of the church office, support for worship services/programs and church...


  • Hartford, United States Suncaptech Full time

    Job Description Hybrid Role, No location preference, ( USC or GC,H1 allowed ) The Business Analyst will analyze the current state of data management operations relative to Race, Ethnicity, and Language Data Collection. To perform this analysis the incumbent will analyze three patient data systems managed by the Office of Health Strategy and other systems...


  • Hartford, United States Suncaptech Full time

    Job Description Hybrid Role- Local to CT candidates only Look for a Candidate with Mule API Client needs the service of a mid to Senior level Salesforce Admin. The candidate will serve in the capacity of a Lead administrator participating in various SDLC processes including requirements verification, design and development, testing, maintenance, and support...


  • Hartford, United States Staples Full time

    Job DescriptionStaples is business to business. You're what binds us together. Our digital solutions team is more than a traditional IT organization. We are a team of passionate, collaborative, agile, inventive, customer-centric, results-oriented problem solvers. We are intellectually curious, love advancements in technology and seek to adapt technologies to...

  • Salesforce Developer

    3 weeks ago


    Hartford, United States Talent Groups Full time

    Hybrid Details: 2 days/week onsiteDuration: 2 months to startPay: $56/hr W2 or $67- 70/hr CTCPosition Description:The Connecticut Bureau of Information Technology Services under the Department of Administrative Services (DAS-BITS) is looking for Salesforce Developers. The developers will be assigned to support hands-on development efforts on projects for the...

  • Erp specialist

    2 weeks ago


    Hartford, United States HCL Technologies Full time

    To be responsible for the installation, technical administration, tuning, and monitoring of the ERP application and supporting the functional teams while meeting consistent quality requirements and timelines. To administer ERP in production environment To manage database optimization, back-up and recovery To monitor occurrences of new software releases,...


  • Hartford, United States Hartford HealthCare Full time

    Description Job Schedule: Per Diem Standard Hours: 1 Job Shift: Shift 1 Shift Details: Work where every moment matters. Every day, almost 30,000 Hartford HealthCare employees come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive healthcare...


  • Hartford, United States Ppac Full time

    The purpose of this classification is to assist with the planning, coordination, and performance of responsible work related to the District's procurement programs and operations. Work involves procurement related support activities for District purchases in accordance with laws, ordinances, rules, regulations, and other requirements governing procurement....


  • Hartford, United States Trinity College Full time

    Trinity College seeks a staff that reflects the changing demographics of our student body. Our student body is diverse, representing forty-one states and seventy countries, with 21 percent U.S. students of color and 50 percent who identify as women. More than 90 percent of students live on campus. Trinity is a highly selective, independent, nonsectarian...

  • Loan Officer

    Found in: Talent US C2 - 3 weeks ago


    Hartford, United States Caliver Beach Mortgage, LLC Full time

    Do you have strong relationship building skills? Have you built your business largely on referrals? Are you an entrepreneur at heart and interested in growing a team? If so, then we have an exciting opportunity for you. Become your own boss at Caliver Beach Mortgage!!Description:· Run your business remotely on a P&L basis under the umbrella of Caliver Beach...

  • Program Assistant

    2 weeks ago


    Hartford, United States Leadership Greater Hartford Full time

    Job DescriptionJob DescriptionLeadership Greater Hartford (LGH) is a high-energy, mission-driven, nonprofit organization that is passionate about our work. We support and strengthen the local community by training and connecting aspiring and established leaders. We believe that the potential for leadership resides within everyone and that it can grow if...

  • Benefits Specialist

    2 weeks ago


    Hartford, United States CareerBuilder Full time

    Benefits Program Manager Onsite daily (Monday-Friday) in Farmington, CT Contract for 3+ months with permanent potential Must Have: *Bachelors degree in Human Resources or related field preferred *Minimum of 5 years of benefits experience *Microsoft Office proficiency required Under administrative direction from the Senior Manager, analyzes designs, plans,...

  • Program Support Assistant

    Found in: Talent US 2 C2 - 2 weeks ago


    Hartford, United States Veterans Health Administration Full time

    Summary This Program Support Assistant position is located within the Geriatrics and Extended Care service at the White River Junction VA Healthcare Center located at White River Junction, Vermont. This position is full-time at 40 hours per week. Duties The Program Support Assistant independently manages the administrative functions of staff and...

  • Benefits Coordinator

    Found in: Talent US C2 - 2 weeks ago


    Hartford, United States Trinity College-Hartford Full time

    Posting Details Position Information Title Benefits Coordinator Department Human Resources Regular or Temporary Regular Hours Per Week 40 FLSA Determination Non-Exempt Weeks Per Year 52 Open Date 03/12/2024 Open Until Filled Yes Full or Part Time Full Time Position Summary Trinity College seeks a staff that reflects the changing demographics of our...

  • Donor Relations Coordinator

    Found in: Talent US C2 - 2 weeks ago


    Hartford, United States Trinity College-Hartford Full time

    Posting Details Position Information Title Donor Relations Coordinator Department Donor Relations Regular or Temporary Regular Hours Per Week 40 FLSA Determination Non-Exempt Weeks Per Year 52 Open Date 03/25/2024 Open Until Filled Yes Full or Part Time Full Time Position Summary Trinity College seeks a staff that reflects the changing demographics of...


  • West Hartford, United States Connecticut REAP Full time

    Job Description: As an administrative assistant, your primary role is to provide administrative support to the administrators of Ben Bronz Academy and help school operations run smoothly. Job duties include: * Assist with new student enrollment * Schedules in person and virtual meetings, PPTs, parent meetings, written service plan meetings, and...

  • Rental Associate

    2 days ago


    Hartford, United States Connecticut Landmarks Full time

    Applicants should submit a letter of interest, resume, and at least three references to Robert Brock, Interim Executive Director at robert.brock@ctlandmarks.org with the subject line: Rental Associate. References will not be contacted without the applicants consent. Applications will be accepted until May 10, 2024. Connecticut Landmarks seeks a Rental...

  • Program Manager

    5 days ago


    Hartford, United States EVERSOURCE Full time

    This is a hybrid role. The first three months are fulltime in the office. The #1 energy efficiency provider in the nation, Eversource is empowering a carbon-neutral future for the Northeast, with nationally recognized energy efficiency solutions and successful programs to integrate new clean energy resources like solar, offshore wind, electric vehicles, and...