![Buzzclan](https://media.trabajo.org/img/noimg.jpg)
Database Administrator IV
4 weeks ago
***Please note that this is a part-time role lasting for a full year.
The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.
Scope of Work:As part of the Office of Information Services (OIS), Technology Platform Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2 environment. This position will focus on providing expert consultation to management, DRM staff, technical, and business stakeholders.
The Key Person will participate in the Mainframe Modernization project by applying their skills and experience to manage both IBM DB2 databases for Unix and Mainframe operating systems.
The Key Person will perform data refreshes in development, test, and UAT environments, assist in the deprecation of legacy DB2 databases, and troubleshoot and resolve DB2 job and database issues. They will plan and implement DB2 upgrades and patches, support the export and load of production data, and provide support for batch jobs on zOS, including job scheduling, monitoring, and troubleshooting. The Key Person will also offer DBA support for applications running on AIX, zOS, and Linux platforms, support Java-based applications using JDBC and SQLJ, and create and manage JCL jobs to automate database and system tasks.
Additionally, the Key Person will design, create, implement, maintain, tune, and support DB2/UDB databases on AIX and z/OS platforms. They will manage tables and indexes, promote changes to various subsystems including production, and provide on-call coverage for OLTP applications on the zOS platform. The Key Person will develop and maintain UNIX shell scripts to monitor table space usage and buffer pool usage, work with ETL tools to extract DB2 data from zOS to staging tables on distributed platforms and develop ETL routines using DB2 load/unload utilities, DB2 Connect, and other data warehousing tools.
Finally, the Key Person will provide ongoing technical assistance and education to application developers and business analysts for DB2, COBOL, JCL, and SQL. They will conduct performance analysis and identify tuning opportunities to enhance database performance, implement and manage recovery strategies using RMAN, and provide schema development and system configuration support for application developers. The Key Person will also work with developers to diagnose and resolve database-related application issues, supporting schema maintenance and data distribution.
Tasks:Data Operations:
Diagnoses and resolves complex problems for critical state systems, often requiring high-level coordination with IS staff and multiple vendors, including conflict resolution.
Provides expertise to other IS staff, assisting with major system crashes and establishing procedures for problem diagnosis and resolution.
Communicates effectively with customers in both oral and written forms, and coordinates training for assigned infrastructure functions within a diverse and dynamic system environment.
Data Construction:
Ensures daily operations run smoothly by managing tasks such as installation, performance monitoring, access, security, back-ups, scheduling, inventory management, and order processing, within a diverse environment with multiple vendors and sites.
Plans and schedules installations of new or significantly updated products, analyzes system performance, resolves resource competition issues, and recommends system configurations based on costs, specifications, and organizational policies.
Communicates effectively with IT counterparts, addressing performance problems and maintaining relational database integrity while considering constraints, linked tables, consistency, and data-level security.
Planning:
Oversees high-level strategic planning, addressing resource utilization, acquisition planning, new technologies, disaster planning, overall system performance, and security. Assesses and integrates new technologies, establishes standards, and recommends operational changes to optimize resource use.
Manages data-related decisions, including data sharing, location, usage, security, integrity, flexibility, and resource allocation. Establishes and enforces metadata standards, reviews and approves logical data models, and conducts training in data modeling and design.
Navigates a diverse and dynamic planning environment with multiple remote locations and varied standards, integrating multiple systems from public and private organizations.
Required Skills:
Extensive Knowledge:
Theories, principles and practices of Information Systems Technology.
Project administration methods, principles, techniques and practices.
Information systems architecture.
Methods and procedures for designing, developing, monitoring and maintaining databases.
Tools for constructing database structures.
Automation products that support a variety of data management environments.
General Knowledge:
Business systems and organizational structures.
Trends, technological changes and developments in IS.
Operations and business of the organization.
Skills:
Administering and managing comprehensive, multi-system projects including directing and motivating internal staff, contractors and other participants.
Identifying the scope and complexity of a project and assigning segments of that project to others.
Assigning and reviewing the work of others to determine accuracy and adequacy of identified conditions, criteria, recommendations and supporting materials.
Developing long and short-range plans to meet established goals.
Developing policies and procedures.
Analyzing organizational needs and implementing cost-effective solutions.
Determining efficient design of data structures and software applications.
Assessing new technology developments.
Specific DBMS Skills:
Extensive knowledge of DB2 on z/OS and AIX.
Knowledge of SQL construction and optimization.
Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.
Extensive knowledge of z/OS, OMVS, CICS basics, utilities, RACF and dataset and Access Control.
AIX security, scripting and monitoring experience.
Please make sure resumes submitted CLEARLY reflect the required skills and experience. Resumes that do not reflect the required skills -- supported by experience -- will be rejected, regardless of how you respond to the Qualifications section.
Covendis Rate Card Description for Database Administration IV:
Provides technical support for the development, implementation, and maintenance of an internal database. Maintains policies and procedures for ensuring database's security and integrity. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. Relies on knowledge and professional discretion to plan and achieve goals. Works under general supervision and usually reports to a supervisor, though some ingenuity and flexibility is required. May require a bachelor's degree in a related area and 2 4 years of relevant experience.
Covendis Rate Card for Database Administrator IV:
Minimum -
Maximum -
Our primary criteria are the qualifications and experience of the proposed key person. Please propose your strongest candidate, at a rate less than or equal to the maximum.
Interviews will be conducted via MS Teams. Interview times will reflect Pacific Standard Time.
Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate.
This position is approved for remote work.
Remote onboarding will be required for the first day.
The selected key person can telecommute, as agreed to between the Agency Authorized Representative and the key person.
Telecommuting will be contingent upon the Agency providing an adequate computer, monitor(s), Internet connection, and telephone, and candidate should be readily available during normal working hours via phone, email or instant message. Access to Agency systems will be provided via VPN or similar software. No hardware or additional software will be provided at the key person's home site or his/her PC.
Location RequirementsCandidate must be local or willing to commute or relocate.
No preferenceAdditional Location Details (City, State) :
Remote work/Telecommuting will be contingent upon the key person providing their own adequate office equipment and connectivity.
Requisition Custom Selections.
Please upload the required document to the comment section of the proposal
Examples of prior work product
Relevant to the Services and Deliverables described in this Opportunity (maximum five pages).
Summary of Key Person(s) qualifications and experience
providing the requested or similar services. If Key Person(s) are the Proposer's sub-contractors, identify the sub-contracting firm and the percentage of work that will be sub-contracted out.
YesDescription of Supplier's (organization) experience
of relevant functional business areas or programs and processes as cited in the description of this program/work in Oregon, or similar programs and process knowledge from other states.
Resumes of Key Person(s)
proposed to perform work as described in this Opportunity, including their education and work experience.
Yes(3) Supplier (Organization) References
References must be clients for whom your organization has performed similar work within the last three (3) years. Where possible, clients listed for reference should be state or local Oregon government agencies or health and human services organizations in other states. Include the client's company name, address, and contact person with telephone and email address for the contact person. The contact person must be someone who was directly involved in the work and is qualified to evaluate Proposer's performance.
(3) References for each proposed Key Person
References must be for similar work performed within the last three (3) years. Where possible, clients listed for reference should be state or local Oregon government agencies or health and human services organizations in other states. Include the client's company name, address, and contact person with telephone and email address for the contact person. The contact person must be someone who was directly involved in the work and is qualified to evaluate the performance of the Key Person(s).
Background VerificationMinimum Verification Requirements
Please have the candidate complete the required form upon selection. The form is located on the dashboard.
TypeCategoryQualificationDescriptionCompetencyRequiredSkillsDatabaseData WarehousingProficient (4-6 Years)YesSkillsDatabaseDB2Expert (10+ Years)YesSkillsDatabaseDBAExpert (10+ Years)YesSkillsDatabaseIBM DB2 UDBExpert (10+ Years)YesSkillsLanguagesCOBOLAdvanced (7-9 Years)YesSkillsOperating SystemsHP-UXProficient (4-6 Years)YesSkillsOperating SystemsLinuxAdvanced (7-9 Years)YesSkillsOperating SystemsShellAdvanced (7-9 Years)YesSkillsOthersBackup and recoveryExpert (10+ Years)YesSkillsOthersCommunication skills both verbal and writtenExpert (10+ Years)YesSkillsOthersLearning abilityProficient (4-6 Years)YesSkillsOthersPresentation skillsProficient (4-6 Years)YesSkillsOthersTeam workProficient (4-6 Years)Yes-
Database Administrator IV at OR
4 weeks ago
Salem, United States Elite WorkForce Inc Full timeJob DescriptionJob DescriptionPosition: Database Administrator IV Location: Salem, OR 97302 Duration: 12+ Months Job Type: Part-Time Interview: Video Local Candidate OnlyRequired Skills:Extensive experience with IBM DB2 on z/OS and AIX, including performance tuning and optimization.Proficiency in SQL construction and optimization, with a strong understanding...
-
Database Administrator IV
4 weeks ago
Salem, United States InnovitUSA Full timeJob DescriptionJob DescriptionDatabase Administrator IVSalem, Oregon RemoteTax Terms: C2C,W2 And 1099. Scope of Work:As part of the Office of Information Services (OIS), Technology Platform Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2...
-
Database Administrator IV
4 weeks ago
Salem, United States V R Della Infotech Inc Full timeJob DescriptionJob Description***Please note that this is a part-time role lasting for a full year.The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency...
-
Database Administrator IV
4 weeks ago
Salem, United States Software Technology Inc Full timeJob DescriptionJob Description***Please note that this is a part-time role lasting for a full year.The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency...
-
DB2 Database Administrator IV
4 weeks ago
Salem, United States Ark Solutions Full timeArk Solutions Inc is looking for DB2 Database Administrator IV (Part-time)!Position: DB2 Database Administrator IV (Part-time) Location: REMOTE Duration: 12 Months and possibility of extension Description: As part of the Technology Platform - Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with...
-
Database Administrator IV
4 weeks ago
Salem, United States Amtex Systems Inc Full timeJob DescriptionJob DescriptionData Operations: Diagnoses and resolves complex problems for critical state systems, often requiring high-level coordination with IS staff and multiple vendors, including conflict resolution. Provides expertise to other IS staff, assisting with major system crashes and establishing procedures for problem diagnosis and...
-
Database Administrator
4 weeks ago
Salem, United States Software Technology Inc. Full timeTitle: DB2 Database Administrator IVLocation: Salem OR(Remote)Duration: 12+ Months***Please note that this is a part-time role lasting for a full year. 4 hrs a Day from 8 AM to 12 PM PST***Scope of Work:As part of the Office of Information Services (OIS), Technology Platform – Data Resources Management Team (DRM) is searching for an experienced senior DB2...
-
DB2 Database Administrator
4 weeks ago
Salem, United States InnovitUSA Full timeJob DescriptionJob DescriptionDB2 Database Administrator Salem, Oregon RemoteTax Terms: C2C,W2 And 1099. Scope of Work:As part of the Office of Information Services (OIS), Technology Platform Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2...
-
Sr. DB2 Database Administrator
1 week ago
Salem, United States Mavensoft Technologies Full timeJob Title: Sr. DB2 Database Administrator Duration: 6 Months (contract on W2) Location: Salem, OR (Remote) Description: Seeking a highly experienced Senior DB2 Database Administrator for a part-time role. Client provides critical technology systems and services to over 18,000 agency staff across the state, supporting essential functions such as client...
-
Database Administrator
4 weeks ago
Salem, United States BayOne Solutions Full timeTitle: Database Administrator (DB2)Specific DBMS Skills:· Extensive knowledge of DB2 on z/OS and AIX.· Knowledge of SQL construction and optimization.· Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.· Extensive knowledge of z/OS, OMVS, CICS basics,...
-
Database Administrator
4 weeks ago
Salem, United States BayOne Solutions Full timeTitle: Database Administrator (DB2)Specific DBMS Skills:· Extensive knowledge of DB2 on z/OS and AIX.· Knowledge of SQL construction and optimization.· Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.· Extensive knowledge of z/OS, OMVS, CICS basics,...
-
IV Registered Nurse, IV Therapy
1 month ago
Salem, United States Salem Health Full timeIV Registered Nurse, IV Therapy-(3288579) Description The Registered Nurse managesall aspects of the nursing process and the delivery of patient and familycentered care. The Registered Nurse has the responsibility and authority torequest and use governing and administrative resources, technological and supportsystems, and multidisciplinary clinical...
-
Technical Specialist IV at OR
2 weeks ago
Salem, United States Elite WorkForce Inc Part timeJob DescriptionJob DescriptionPosition: Technical Specialist IV Location: Salem, OR 97301 Duration: 12+ Months Job Type: Part-Time Interview: TBD Local Candidates OnlyRequired Skills:Extensive experience with ColdFusion, including application upgrades and code analysis.Proficient in SQL and advanced database management.Strong understanding of Azure DevOps...
-
Database Developer
4 weeks ago
Winston-Salem, United States Techtriad Team Inc Full timeJob DescriptionJob DescriptionThis database development position supports transaction processing and analytics for high-volume payment products (Wire, ACH, etc.). Primary responsibilities include the design, development, and modernization of core database applications. The position requires significant experience developing high-performing applications on...
-
Technical Specialist IV
2 weeks ago
Salem, United States Lorven technologies Full timeJob DescriptionJob DescriptionJob Title: Technical Specialist IV Location: Salem,Oregon,97301 (Remote) Duration: 6+ Months (Contract) Remote JobJob DescriptionResponsible for analyzing and designing solutions to networking issues, providing technical support to other departments, as well as troubleshooting, diagnosing and solving issues with both hardware...
-
Technical Specialist IV
1 day ago
Salem, United States Integrated Resources Full timeJob Title: Technical Specialist IV Location: Salem, OR Duration: 12 Months Role: Part-TimeThis Is Part Time For 1 Year Schedule Will Be Negotiated When SelectedJob Description: Responsible for analyzing and designing solutions to networking issues, providing technical support to other departments, as well as troubleshooting, diagnosing and solving issues...
-
ColdFusion Technical Specialist IV
1 week ago
Salem, United States Software Technology Inc Part timeJob DescriptionJob DescriptionHi ,Title: Technical Specialist IV- ColdFusionLocation: Salem, OR- REMOTEDuration: 1 YearTHIS IS PART TIME (4 hours) PST Time Zone FOR 1 YEAR SCHEDULE WILL BE NEGOTIATED WHEN SELECTEDJob Description:Analyze and evaluate ColdFusion application software code to determine features that will be retired, removed, deprecated, or...
-
Technical Specialist IV
9 hours ago
Salem, Oregon, United States Integrated Resources Full timeJob Title: Technical Specialist IVLocation: RemoteDuration: 12 MonthsRole: Part-TimeThis is a part-time position for 1 year. The schedule will be negotiated when selected.Job Description:Key Responsibilities:Analyze and Design Solutions: Responsible for analyzing and designing solutions to networking issues, providing technical support to other departments,...
-
Business Systems and Reporting Administrator
4 days ago
Salem, Oregon, United States State of Oregon Full timeJob SummaryWe are seeking a highly skilled Business Systems and Reporting Administrator to join our team at the State of Oregon. This is a critical role that will involve managing the design, implementation, and administration of a customized Customer Relations Management (CRM) platform for our Disaster Recovery & Resilience section.Key...
-
Data Administrator III
1 month ago
Salem, United States ACL Digital Full timeThe Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Client (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client...