Published date Posted on Indeed on Jul 01, 2022 (44 d ago)
Remote working opportunity for an experienced DB2 Administrator to join IPS and become a key member on our production maintenance and support project. Ideally you will reside in eastern or central time zone locations, however, candidates within the continental US, who are willing to support east coast clients, will be considered.

Position Description:

As the DB2 Administrator you will:
  • Perform data change requests, migrations, and database maintenance.
  • Monitor and analyze capacity of databases using various automated tools and perform optimization.
  • Provide support for efficient SQL queries and provide updated SQL queries, or indices, to the team.
  • Proactively provide database structure and usability for improvements.
  • Review various data base reports, queries and optimize.
  • Analyze database activities and complete performance tuning.
  • Work with Data Architects and DBAs to request the implementation or modification of Databases in Lower (DEV/ST) and Higher (UAT/STG/PROD) environments.
  • Review data volumetric information on an on-going basis and notify DBAs of any changes.
  • Provide consultation as well as develop new queries and stored procedures.
  • Participate in the creation and maintenance of test data sets to support various test requirements, including but not limited to system tests, performance tests and in-scope user acceptance tests.
  • Provide assistance in the deployment of Database Changes, support the back out of failed changes, maintain data dictionary systems, and document all changes to Databases.

Basic Qualifications:
  • Minimum of 4 years of experience performing DB2 upgrade, administration, deployment, and support activities.
  • Knowledge of handling DB2 Database objects such as tables, table spaces, indexes, views, index spaces, keys, clones, MQTs, sequences, functions, aliases, and partitioning.
  • Experience creating, designing, and tuning IBM DB2 Databases and related objects,
  • Familiar with Linux, Unix, AIX, Windows (DB2 LUW) and AWS Cloud environments.
  • Hands-on DB2 object migration experience, throughout the project life cycle.
  • Experience with IBM Data Studio for DB2, IBM DB2 PureScale, FileNet DB2 instances.
  • Familiar with Database Disaster recovery setup (HA/DR), planning, and implementation.
  • Able to carry out SQL reviews, and performance monitoring and tuning.
  • Knowledge of DB2 utilities, i.e., Load, Unload, Copy, Reorg, Rebuilds, Statistics.
  • Bachelor’s degree, or foreign equivalent, required from an accredited institution. Will also consider three years of progressive, relevant work experience in lieu of every year of education. Candidate's that have completed a Master’s degree program strongly preferred.

Preferred Qualifications:
  • Public Sector project experience within Health and Human Services (HHS).
  • Master’s Degree, or foreign equivalent, from an accredited institution.

The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email, or face to face. Travel may be required as per the job requirements.

IPS strictly complies with U.S. employment verification and anti-discrimination laws. An applicant hired by IPS must be able to establish authorization to work in the U.S. IPS does not sponsor individuals for U.S. work visas, though exceptions may be evaluated on a case-by-case basis, at the sole discretion of the company.

Infosys Public Services is the leader in consulting, technology, and next-generation services. We partner with US and Canadian public sector organizations to help them stay ahead of the innovation curve. Our technology solutions, combined with proven best-practices and execution excellence, enable our clients to renew themselves and build new capabilities to improve mission outcomes.

We are pushing the limit of what is currently possible – towards completely new areas. And then executing these ideas to perfection.

Infosys Public Services is an Equal Opportunity Employer / Minority / Female / Veteran / Disabled / Sexual Orientation / Gender Identity.

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Mediavine is seeking a Support Engineer to join our Support team. Applicants must be based in the United States.About MediavineMediavine is a fast-growing advertising management company representing over 8,000 websites in the food, lifestyle, DIY, and.

Bastian Solutions Software is expanding our software operations team in several of our regional offices. We are seeking eager individuals with strong technical aptitude who want to grow in the software field. This is a full time, entry-level project.

Summary of Responsibilities:Support all operational aspects of the Zelis payment system; inclusive of monitoring the system to ensure accurate file import and exportTroubleshoot files that error out and other Production related issues; escalate time-sensitive.

Piper Companies Piper Companies |
|
3 d ago

Piper Companies is looking for an IT Manager, Data for a leading pharmaceutical organization based in the Philadelphia, PA area.THIS IS A REMOTE OPPORTUNITYResponsibilities for the IT Manager, Data:You will lead developers, data engineers, DevOps, BA’s,.

Get To Know Us!GuideWell and its family of forward-thinking companies are focused on helping people and communities achieve better health and are at the forefront in the transformation of health care. We offer competitive salaries and benefits, work-life.

Description:IntroductionOrigin is focused on modernizing Utility companies (electric, water, natural gas, and beyond) with mission-critical software, services, and managed solutions. We are steadfast in delivering the kind of trusted collaboration that.

Denovo Ventures Denovo Ventures |
Yesterday

Description:Summary:Perform activities related to the day-to-day administration and maintenance of Microsoft SQL databases. Handles installations, upgrades, backups, and configuration. Confer with management regarding problems with, and capabilities.

RogueThink RogueThink |
2 d ago

This position is remote however you must be local to the DC/Virginia/Maryland.Secret clearance required at time of hire. Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access.

Centroid Systems Centroid Systems |
2 d ago

For more than a decade, Centroid has been a leader in technology consulting. We are in the unique position to offer a broad range of services that reflect both our array of industry experience and our past performance solving complex business challenges..

Become ALL IN! as a Integration and Interoperability Engineer IAs a pioneer in digital health our heart beats for the development and implementation of new technologies. For the next level of e-health evolution we are looking for creative minds who enjoy.

More jobs by this company

Infosys is seeking a Senior Microservices Developer with Microservices and Springboot experience. As a Senior Microservices Developer, you will interface with key stakeholders and apply your technical proficiency across different stages of the Software.

Infosys is seeking an experienced Oracle Project Manager to manage AMS, new initiative projects for a US based Apparel chain. This position requires experience in project management area, preferably having knowledge of Retail processesRequired Qualifications:.

Infosys is seeking an experienced Oracle ERP Supply Chain Planning Solution Architect with multiple cloud implementations experience, covering all modules of Oracle Supply Chain Planning Cloud. This position’s primary responsibility will be to interface.

Infosys is seeking a Senior Consultant with experience in Data Governance. The position will primarily be responsible interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle.

Infosys is seeking a Hadoop Administrator who will be responsible for implementation and ongoing administration of Hadoop infrastructure. The candidate will be part of a learning culture, where teamwork and collaboration are encouraged, excellence is.

Infosys is seeking a ETRM (Energy, Trading and Risk Management)Consultant- In the role of techno function, you will be a techno functional professional adding value to a gamut of Software Development lifecycle stages. You will have the opportunity to.

In the role of Teradata Developer you will be a technology professional adding value to a gamut of Software Development lifecycle stages. You will create detailed design artifacts like program specifications, test plans; and independently develop and.

Infosys - IVS – Automation Test Lead – USAs a QA Test Lead you will act as a validation and quality assurance expert and review the functionality of existing systems. You will conduct requirement analysis, define test strategy & design and lead execution.

Infosys is seeking an Oracle PCON- Enterprise Architect with primary responsibility for implementing cross- functional processes on Oracle ERP platforms. The selected candidate should have process knowledge across Supply Chain, Planning, Services and.

Infosys Infosys |
6 d ago

Infosys is seeking a skilled, dedicated and proactive VMWARE Admin professional with strong interpersonal and Technical skills to operate a VMWARE infrastructure deployed. The candidate will support and maintain hardware and software infrastructure according.

Infosys is seeking a Senior Redhat JBPM Developer. As a Senior Redhat JBPM Developer, you will interface with key stakeholders and apply your technical proficiency. You will create detailed design, process artifacts and implement the deployment plan..

Infosys is seeking Senior UI Developer. As part of the Infosys delivery team, the primary role would be to interface with the client for quality assurance, issue resolution and ensuring high customer satisfaction. The chosen candidate will understand.

Infosys is seeking Cloud Engineer specialized in Azure. This role requires close partnership and collaboration with other Data Engineers, Architects and Subject Matter Experts. Essential Job Duties include experience with all data services in Azure..

Infosys is seeking Cloud Architect specialized in Azure. This role requires close partnership and collaboration with other Data Engineers and Subject Matter Experts. Essential Job Duties of Cloud architect is having experience with all data services.

Infosys is seeking a Google Cloud Engineer In the role of Technology Lead, you will take end-to-end responsibility for Google Cloud Platform Engineering. You will be responsible for user story management, definition of done creation, product validation.

Infosys is seeking a Lead BY CATMAN Consultant. As Lead BY CATMAN Consultant, you will be involved in solution design. You will do Fit Gap Analysis, Design, and complete implementation. You will carry out Development/upgrade/support tasks as assigned..

Infosys is seeking a Site Reliability Engineer (SRE) - In the role of Technology Lead, you will take end-to-end responsibility for Site Reliability Engineering. You will be responsible for user story management, definition of done creation, product validation.

Infosys is seeking an SAP ABAP BTP ArchitectThis position will required a key player in engaging with business/functional team in providing best fit technical solutions while conforming to client’s and Infosys development standards. You will also support.

Infosys is seeking a Senior BY WMS consultant. As a Senior BY WMS consultant, you will be required to implementing projects in BY WMS. You will create solution or application architecture experience in large enterprise organizations. You will be expected.

Infosys Infosys |
9 d ago

Infosys is seeking a Test Engineer, you will act as a QA Test Engineer you will act as a validation and quality assurance expert and review the functionality of existing systems. You will conduct requirement analysis, define test strategy & design and.

Infosys is seeking a Technical Project Manager. This role will primarily manage & deliver the client engagement/ projects for Microsoft Azure, SQL product by understanding the customer's requirements and handling subsequent activities of project planning,.

Infosys is seeking Cloud Enterprise Architect. this role will lead the cloud strategy working closely with the IT leaders of the client in creating business value with technology. This role is expected to the well versed with the technology trends across.

Infosys Infosys |
10 d ago

Infosys is seeking a Test Analyst, you will act as a QA Test Analyst you will act as a validation and quality assurance expert and review the functionality of existing systems. You will conduct requirement analysis, define test strategy & design and.

Infosys Infosys |
10 d ago

Infosys is seeking a React JS Developer. This position will primary be responsible to interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation,.

Infosys Infosys |
10 d ago

Infosys is seeking a AWS Developer with experience in native AWS components and Big Data. The position will primarily be responsible interface with key stakeholders and apply your technical proficiency across different stages of the Software Development.

Infosys is seeking a SQL Data Base Administrator to install, monitor, maintain, and performance tune production and non-production SQL databases while ensuring high levels of security and compliance. The DBA is also responsible for planning, design and.

Infosys is seeking Production Support - Java, PL/SQL & UNIX Experience . This role requires close partnership and collaboration with other Support Engineers and Subject Matter Experts.Required Qualifications:Candidate can be located Anywhere in US. This.

Infosys Infosys |
11 d ago

Infosys is seeking DevOps Lead: In the role of Technology Lead, you will interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation, Application.

Infosys is seeking a highly motivated Senior Enterprise Architect. An ideal candidate will demonstrate Strong experience in architectural principles in the areas of cloud-native/hybrid-multi cloud architectures, container orchestration (kubernetes/OpenShift),.

Infosys Infosys |
15 d ago

Infosys is seeking a Java/J2EE Developer. This position’s primary responsibility will be to provide technical expertise and coordinate day-to-day deliverables for the team. The chosen candidate will assist in the technical design of large business systems;.