Sr. DB2 DBA

1 week ago

Kansas City, United States Synergy Technologies Full time

Job Title: Sr. DB2 DBA

Location: Jacksonville, FL (100% Remote)

Duration: Long Term


Only USC/ GC -on W2


Job Description:

Responsibilities:

• Consults on database, architecture and related infrastructure technologies to all areas and levels within IT.

• Consults on exploiting opportunities involving multiple hardware and software systems, issue resolution, providing innovative business solutions, etc. to both internal and external customers and partners.

• Provides technical leadership on the implementation of leading-edge database technologies and the design and implementation of large-scale technical solutions based on business requirements.

• Develops and ensures compliance with all system, disaster recovery and security audit policies.

• Design, implement, and maintain DB2 database architectures that meet business requirements on the z/OS platform.

• Keep up-to-date with the latest trends, technologies, and best practices in DB2 database administration on the z/OS platform.

• Provide technical support and guidance to development teams, system administrators, and other stakeholders on database-related issues, including SQL coding, database design, and performance tuning.

• Develop and implement database maintenance tasks, such as backups, patching, and upgrades, using tools like IEFBR14, IDCAMS, and DFSORT.

• Monitor and optimize database performance, capacity, and availability using various tools and techniques, such as DB2 Utilities, z/OS Unix, and SQL.

• Writes complex programming/scripts.

• Participate in disaster recovery design, testing and execution

• Monitor and evaluate database performance and adjust database configuration as appropriate

• Provide technical leadership to other DBAs

• Design process for database change management issues related to environment migration

• Make highly complex physical changes to current databases, often this requires working after hours

• Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)

• Provide subject matter expertise to corporate projects and initiatives

• Work with users and IT partners to understand requirements for a physical database design

• Provide database consulting expertise to corporate projects and initiatives applying PMM and development life cycle concepts

• Address customer concerns and issues related to database management

• Evaluate database performance and adjust configuration appropriately

• Provide production support for outages, restore/recovery events

• Optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.

• Other duties as assigned


Required:

• 10 or more year’s professional experience as a systems DB2 zOS databases on version 12+. Database Administrator should be very strong working knowledge of application DBA to setup and support IBM DB2 zOS databases on Mainframe systems. Experience of db2 LUW is a plus.

• Bachelor’s degree in an IT related field or equivalent work experience.

• In depth knowledge of the DB2 zOS architecture.

• Experience in configuring and supporting Tier-1 mission critical databases as a systems/infrastructure DBA.

• In-depth knowledge of operating system zOS and hands on working experiences on zOS

• Proven experience in working in a mission critical environment in a multi-terabyte database platform, including analytics workloads.

• Good understanding of data warehouse concepts including data marts and data lakes.

• Creating databases, migrating database objects from non-production to production environment.

• Designing and building data models, schemas, views, and tables to support application requirements

• Extensive experience designing and executing backup and recovery concepts and procedures

• Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning

• Experience in using IBM Monitoring tools (Omegamon & query monitor) and other event management and performance monitoring tools.

• Good understanding of licensing options and optimization.

• Experience with automation tools such as Control-M.

• In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.

• Provide 24 x 7 Support to Critical production systems.

• Knowledge of Project Management Methodologies

• Experience in working closely with the application development teams to resolve any performance related issues and provide application support.

• Db2 tools (DB2 admin, DB2 automation tool, Toad. JCL, performance monitoring tool (Omegamon)


Preferred:

• DB2 zOS Database Administration Certification.

• Added advantage of knowledge of administration of db2 LUW, Netezza and Sailfish

• Health care industry related experience.

  • Database Developer(DBA)/DB2 Developer

    4 weeks ago

    Jersey City, United States Diverse Lynx Full time

    Role: D atabase Developer (DBA) /SQL Developer Location: Jersey City, NJ (Hybrid) Hire Type: Contract Job Summary: 7-10+ years experience as DB2 SQL developer with a strong focus on writing stored procedures. Demonstrable experience with analyzing and optimizing complex stored procedures. Extensive experience with database performance tuning...

  • Database Developer(DBA)/DB2 Developer

    3 weeks ago

    Jersey City, United States Diverse Lynx Full time

    Role: D atabase Developer (DBA) /SQL Developer Location: Jersey City, NJ (Hybrid) Hire Type: Contract Job Summary: 7-10+ years experience as DB2 SQL developer with a strong focus on writing stored procedures. Demonstrable experience with analyzing and optimizing complex stored procedures. Extensive experience with database performance tuning...

  • Database Administrator

    5 days ago

    Jersey City, United States New Millenium Consulting Full time

    Job Title: Database Administrator (DBA)Job Location: Jersey City, New JerseyJob Type: Contract-to-hireMust have: DBA, DB2A global food manufacturing company recognized as #1 in the US is seeking a Database Administration to join their team in their Jersey City, NJ, office. Experience with data warehouse a huge plus.Job Responsibilities and RequirementsDB2,...

  • Database Administrator

    3 days ago

    Jersey City, United States New Millenium Consulting Full time

    Job Title: Database Administrator (DBA)Job Location: Jersey City, New JerseyJob Type: Contract-to-hireMust have: DBA, DB2A global food manufacturing company recognized as #1 in the US is seeking a Database Administration to join their team in their Jersey City, NJ, office. Experience with data warehouse a huge plus.Job Responsibilities and RequirementsDB2,...

  • Dba / database support

    1 month ago

    Carson City, NV, United States KBTS Technologies, Inc. Full time

    Email your resume to mike@kbtstech.com Location: Carson City, NV Duration: 12months 100% on site. W2 Only. IBM DB2 DBA Assisting system administrators with applying patches to and upgrading DB2. Support vendor staff as they continue to work on projects including configuration of DB2, requests for log reviews, assistance with troubleshooting, and service...

  • DB2 Z/OS System Programmer

    2 months ago

    Jersey City, United States GSSR Inc Full time

    Job DescriptionJob DescriptionIn-person interview will be on May 15th!!!Hybrid Schedule: 3 days onsite- Upgrade Db2 to v13 across 150+ z/OSLPARs by building SMP/E packages and applying to production frequently- Consult with Db2 DBAs to perform system performancetuning and enhance automation and alertingThis role requires a wide variety of strengths...

  • DB2 Z/OS System Programmer

    3 weeks ago

    Jersey City, United States GSSR Inc Full time

    Job DescriptionJob DescriptionIn-person interview will be on May 15th!!!Hybrid Schedule: 3 days onsite- Upgrade Db2 to v13 across 150+ z/OSLPARs by building SMP/E packages and applying to production frequently- Consult with Db2 DBAs to perform system performancetuning and enhance automation and alertingThis role requires a wide variety of strengths...

  • Oracle DBA

    4 weeks ago

    Oklahoma City, United States Diverse Lynx Full time

    Position : Oracle DBA with Golden Gate or Data Guard and AWS knowledge Location: Oklahoma City, OK Job Type: Full time Job Description: • Oracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWS • Experience with database migrations to AWS Cloud • Design, deploy and support databases on Ec2, AWS RDS and VMware platform • Candidate...

  • Oracle DBA

    3 weeks ago

    Oklahoma City, United States Diverse Lynx Full time

    Position : Oracle DBA with Golden Gate or Data Guard and AWS knowledge Location: Oklahoma City, OK Job Type: Full time Job Description: • Oracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWS • Experience with database migrations to AWS Cloud • Design, deploy and support databases on Ec2, AWS RDS and VMware platform • Candidate...

  • Systems Administrator/DBA

    5 days ago

    Carson City, Nevada, United States INSPYR Solutions Full time

    Systems Administrator/DBA - Long Term Project - Carson City, NVTitle: Systems Administrator/DBALocation: Carson City, NV (100% Onsite)Duration: 25+ monthsCompensation: $40-50/hr. Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.PROJECT OVERVIEWOur Government client seeks a System Administrator and DBA contractor. We are looking for...

  • Senior Solution Delivery Architect – DB2

    3 weeks ago

    Oklahoma City, Oklahoma, United States Ensono Full time

    Senior Solution Delivery Architect – DB2Remote - United StatesJR010390At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with...

  • 313861 Oracle DBA

    6 days ago

    Oklahoma City, Oklahoma, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionJob Description:Position: Oracle DBALocation: Oklahoma City, OK (Onsite)Duration: Full TimeOracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWSExperience with database migrations to AWS Cloud Design, deploy and support databases on Ec2, AWS RDS and VMware platformCandidate should possess hands-on experience in...

  • 303171 Oracle DBA

    4 weeks ago

    Oklahoma City, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionJob Description:Position: Oracle DBALocation: Oklahoma City, OK (Onsite)Duration: Full Time Job DescriptionOracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWSExperience with database migrations to AWS Cloud Design, deploy and support databases on Ec2, AWS RDS and VMware platformCandidate should possess hands-on...

  • 303171 Oracle DBA

    4 weeks ago

    Oklahoma City, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionJob Description:Position: Oracle DBALocation: Oklahoma City, OK (Onsite)Duration: Full Time Job DescriptionOracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWSExperience with database migrations to AWS Cloud Design, deploy and support databases on Ec2, AWS RDS and VMware platformCandidate should possess hands-on...

  • 313861 Oracle DBA

    4 weeks ago

    Oklahoma City, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionJob Description:Position: Oracle DBALocation: Oklahoma City, OK (Onsite)Duration: Full TimeOracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWSExperience with database migrations to AWS Cloud Design, deploy and support databases on Ec2, AWS RDS and VMware platformCandidate should possess hands-on experience in...

  • 313861 Oracle DBA

    4 weeks ago

    Oklahoma City, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionJob Description:Position: Oracle DBALocation: Oklahoma City, OK (Onsite)Duration: Full TimeOracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWSExperience with database migrations to AWS Cloud Design, deploy and support databases on Ec2, AWS RDS and VMware platformCandidate should possess hands-on experience in...

  • Systems Administrator/DBA

    4 weeks ago

    Carson City, United States INSPYR Solutions Full time

    Systems Administrator/DBA - Long Term Project - Carson City, NVTitle: Systems Administrator/DBALocation: Carson City, NV (100% Onsite)Duration: 25+ monthsCompensation: $40-50/hr. Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.PROJECT OVERVIEWOur Government client seeks a System Administrator and DBA contractor. We are looking for...

  • Systems Administrator/DBA

    3 weeks ago

    Carson City, United States INSPYR Solutions Full time

    Systems Administrator/DBA - Long Term Project - Carson City, NVTitle: Systems Administrator/DBALocation: Carson City, NV (100% Onsite)Duration: 25+ monthsCompensation: $40-50/hr. Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.PROJECT OVERVIEWOur Government client seeks a System Administrator and DBA contractor. We are looking for...

  • SQL Server DBA

    6 days ago

    Texas City, Texas, United States eTeam Full time

    looking for Sr. SQL Server DBA with good exp in performance tuning + AG + Replication experience. Job Description: As a Senior SQL Server Database Administrator, you will play a critical role in ensuring the optimal performance, reliability, and efficiency of our SQL Server environments. Your primary responsibilities will revolve around performance...

  • SQL Server DBA

    5 days ago

    Texas City, United States eTeam Full time

    looking for Sr. SQL Server DBA with good exp in performance tuning + AG + Replication experience. Job Description: As a Senior SQL Server Database Administrator, you will play a critical role in ensuring the optimal performance, reliability, and efficiency of our SQL Server environments. Your primary responsibilities will revolve around performance...