Database Administrator

1 week ago

Jefferson City MO United States Wipro Full time
Job Description

The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development. Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling activities. As a DBA administrator, you will be responsible for administering, testing, and implementing databases, applying knowledge of database management systems.

Roles & responsibilities:
Support development teams with technical and physical design, development, and maintenance of z/OS DB2 databases; including data analysis and modeling, programming, implementation, performance monitoring, tuning, cloning/refreshing, planning, problem resolution, and data dictionary administration.
Install, upgrade, and patch database software, agents, utilities, and options.
Collaborate with development teams on use of standard practices for the design and implementation of databases to meet user application requirements.
Maintain test tools for managing data base objects and diagnosing problems. Evaluate and test new versions, as well as third party vendor utilities and reporting tools.
Execute test and audit strategies for backup, security, and disaster recovery of Databases and other systems
Position requires 24/7 support rotation for oncall support.

Qualification:
Bachelor's or advanced degree in Computer Science Engineering, computer information systems, management information systems, or a closely related field

Experience & Skills:
Experience must include creating/evaluating/documenting logical and physical data models, developing stored procedures/triggers/scripts/SQL and optimizing/tuning SQL in production and development/test environments.
7 years' experience in logical design and physical design,
Experience with data modeling using ERSTUDIO
7 years demonstrated experience leading efficiency improvements and implementation of DB policies and procedures.
7 years experience in DB2 z/OS database administration tasks including database object creation, security, performance tuning, utilities, and backup and recovery.
MAINFRAME SKILLS DESIRED
3 years application design and 3 years COBOL, DB2, SQL, and JCL programming experience
3 years experience with CA DB2 Tools
3 years of VSAM File structure processing.
3 years of TSO/ISPF/SDSF or equivalent products. One year can be supplemented with an equivalent editor.
Proficient in Microsoft Office; specifically Excel, Word, or related products
CICS, SAS, Syncsort, IBM Utilities, Easytrieve.
Strong Knowledge of Agile methodology
Strong Proactively collaborate with team members to design and implement elegant technical solutions.
Testing programs or databases, correcting errors, and making necessary modifications
Modifying existing databases and database management systems or directing programmers and analysts to make changes
Planning, coordinating, and implementing security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure
Working as part of an IT project team to coordinate database development and determine project scope and limitations
Writing and coding logical and physical database descriptions and specifying identifiers of database to management system or directing others in coding descriptions

Job Type: Full-time

Pay: From $78,554.00 per year

Application Question(s):
Will you now or in future require sponsorship from the employer (Eg- H1B, H2EAD. L2EAD, Opt-EAD)

Experience:
COBOL, DB2, SQL, and JCL programming: 3 years (Required)
VSAM File structure processing: 3 years (Required)
data modeling using ERSTUDIO: 3 years (Required)
DB2 z/OS database administration tasks: 7 years (Required)
Database administration: 1 year (Required)

Ability to Commute:
Jefferson City, MO (Required)

Ability to Relocate:
Jefferson City, MO: Relocate before starting work (Required)

Work Location: In person

  • Database Administrator

    2 days ago

    Jefferson City, MO, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles...

  • Database Administrator

    1 week ago

    Jefferson City, MO, United States Wipro Full time

    *Job Description*The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...

  • Database Administrator

    1 week ago

    Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...

  • Database Administrator

    1 week ago

    Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...

  • Database Administrator

    2 days ago

    Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...

  • Database Administrator

    20 hours ago

    Jefferson City, United States Wipro Full time

    Job Description The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...

  • Database Administrator

    4 days ago

    Jefferson City, United States Wipro Full time

    *Job Description*The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and...

  • Database Administrator

    3 days ago

    Jefferson City, United States Wipro Full time $78,554

    *Job Description*Scroll down for a complete overview of what this job will require Are you the right candidate for this opportunityThe Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management...

  • Mainframe Database Administrator

    2 weeks ago

    Jefferson City, United States Wipro Full time

    The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various...

  • Database Administrator

    3 days ago

    Jefferson City, United States Wipro Digital Operations and Platforms Full time

    The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various...

  • Database Administrator

    4 days ago

    Jefferson City, United States Wipro Digital Operations and Platforms Full time

    The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various...

  • Mainframe Database Administrator

    2 weeks ago

    Jefferson City, United States Wipro Full time

    The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various...

  • Mainframe Database Administrator

    2 weeks ago

    Jefferson City, United States Wipro Full time

    The Mainframe Database Administrator (DBA) leads the planning, analysis, design, implementation, maintenance, and control of the organization's mainframe databases. The Mainframe DBA consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various...

  • Database Administrator,

    2 weeks ago

    Cottleville, MO, United States St. Charles Community College Full time

    St. Charles Community College is located just west of St. Louis, nestled in the heart of growing St. Charles County. Established in 1986, SCC is a public, comprehensive two-year community college offering associate degrees and certificate programs in the arts, business, sciences and career-technical fields. SCC also provides workforce training and...

  • Database Architect

    2 days ago

    Jefferson City, Missouri, United States Wipro Digital Operations and Platforms Full time

    Job Description**Job Title:** Database Administrator**Company:** Wipro Digital Operations and Platforms**Job Summary:** We are seeking an experienced Database Administrator to join our team. The successful candidate will be responsible for designing, implementing, and maintaining our mainframe databases.Key Responsibilities:Database Design and...

  • Database Administrator

    2 days ago

    Alexander City, United States augmentjobs Full time

    Overview: We are seeking a skilled and detailoriented Database Administrator (DBA) to join our team. As a DBA you will be responsible for the performance integrity and security of our databases. You will work closely with development teams system administrators and other stakeholders to ensure efficient database operations and data management. This role...

  • Membership Database Administrator

    2 weeks ago

    Kansas City, MO, United States Wholesale & Specialty Insurance Association Full time

    MEMBERSHIP DATABASE ADMINISTRATOR   The primary goals of this position are to maintain functions associated with the WSIA member database, support Assistant Director of Technology Operations with any system upgrades or improvements and manage day-to-day IT operations for WSIA staff. Under the management of the Assistant Director of Technical Operations,...

  • Database Administrator

    5 days ago

    Elizabeth City, North Carolina, United States OBXtek Full time

    Job SummaryOBXtek is seeking a skilled Database Specialist to support our team in Elizabeth City, North Carolina. As a Database Specialist, you will play a critical role in the development and implementation of database systems, ensuring the security and integrity of our data.Key Responsibilities:Design and implement database systems, ensuring data security...

  • Database Administrator

    1 day ago

    Alexander City, Alabama, United States Chelsoft Solutions Co Full time

    Job Summary:Chelsoft Solutions Co is seeking a skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for ensuring the smooth operation of our database systems.Key Responsibilities:Assist with Sybase database administration, including Unix background running and developing CRON jobs with command line...

  • Database Administrator

    16 hours ago

    Alexander City, Alabama, United States Trispoke managed services Full time

    Job DescriptionDatabase AdministratorWe are seeking a highly skilled Database Administrator to join our team at Trispoke managed services. As a Database Administrator, you will be responsible for the installation, upgrade, patching, and support of Oracle databases.Key ResponsibilitiesInstall, upgrade, patch, and support Oracle databasesEnsure the smooth...