Database Administrator IV
2 months ago
Location - Salem, OR Remote
Duration - 4 HOURS A DAY 8 am to 12 PM (Remote)
Req ID - 11119-24
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.
• Analysing 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.
-
Database Administrator IV
4 weeks ago
Salem, Oregon, United States Generis Tek Inc Full timeJob Title: Database Administrator IVWe are seeking an experienced Database Administrator IV to join our team at Generis Tek Inc. As a key member of our IT staff, you will be responsible for the administration and maintenance of our enterprise DB2 environment.Job Summary:The successful candidate will have extensive knowledge of DB2 on z/OS and AIX, as well as...
-
Database Administrator IV
2 months ago
Salem, United States ACL Digital Full time***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 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...
-
Database Architect
4 weeks ago
Salem, Oregon, United States Syntricate Technologies Full timeJob Title: Database Administrator IVJob Summary:We are seeking a highly skilled Database Administrator IV to join our team at Syntricate Technologies. The successful candidate will be responsible for managing and maintaining our mainframe databases, ensuring optimal performance and security.Key Responsibilities:Manage and maintain DB2 databases on z/OS and...
-
Database Architect
3 weeks ago
Salem, Oregon, United States Syntricate Technologies Full timeJob Title: Database Administrator IVLocation: RemoteDuration: 4 hours a day, 8 am to 12 pmReq ID: 11119-24Job SummaryWe are seeking a highly skilled Database Administrator IV to join our team at Syntricate Technologies. The successful candidate will be responsible for managing IBM DB2 databases on Unix and Mainframe operating systems, performing data...
-
Database Administrator
2 months ago
Salem, United States Crescens Full timeJob Title: Database Administrator Location: Salem, Oregon Duration: 12+months Type: Contract***Remote work/Telecommuting will be contingent upon the key person providing their own adequate office equipment and connectivity. *** ***Please note that this is a part-time role lasting for a full year. *** ***This is 4 hours /per day ***Job Description: The Key...
-
Database Administrator
3 weeks ago
Salem, Oregon, United States State of Wisconsin Full timeJob SummaryWe are seeking a highly skilled Database Administrator to join our team in the Division of Employment and Training at the State of Wisconsin. As a key member of our team, you will be responsible for the development and maintenance of our databases and data warehouses, ensuring compliance with federal-state cooperative programs and Workforce...
-
Senior DB2 Database Administrator
2 months ago
Salem, Oregon, United States Expedite Technology Solutions LLC Full timeJob Title: Senior DB2 Database AdministratorWe are seeking an experienced Senior DB2 Database Administrator to join our team at Expedite Technology Solutions LLC. As a key member of our Data Resources Management Team, you will be responsible for the administration of our enterprise DB2 environment.Key Responsibilities:Provide expert consultation to...
-
Senior DB2 Database Administrator
2 weeks ago
Salem, Oregon, United States ACL Digital Full timeJob Title: Senior DB2 Database AdministratorACL Digital is seeking a highly skilled Senior DB2 Database Administrator to join our team. As a key member of our database management team, you will be responsible for the administration, maintenance, and optimization of our enterprise DB2 environment.Key Responsibilities:Provide expert consultation to management,...
-
Oracle Database Administrator
2 weeks ago
Winston-Salem, North Carolina, United States TechnoGen Full timeJob SummaryTechnoGen is seeking an experienced Oracle Database Administrator to join our team. As a key member of our database team, you will be responsible for the design, implementation, and maintenance of Oracle databases to support our business applications.Key Responsibilities Provide 24/7 support for Oracle databases, including troubleshooting and...
-
Oracle Database Administrator
1 month ago
Winston-Salem, North Carolina, United States TechnoGen Full timeJob Title: Oracle DBAAt TechnoGen, we are seeking an experienced Oracle DBA to join our team. As an Oracle DBA, you will be responsible for the administration and maintenance of our Oracle E-Business Suite and Non-ERP databases.Key Responsibilities:Provide 24/7 support for Oracle E-Business Suite, Oracle production, test, and development instances.Meet...
-
Solution Architect IV
3 weeks ago
Salem, Oregon, United States Generis Tek Inc Full timeJob Title: Solution Architect IVWe are seeking an experienced Solution Architect IV to join our team at Generis Tek Inc. as a Technical Project Lead for a 3+ month contract in Salem, OR.The ideal candidate will have a strong background in cloud architecture, DevOps, and full-stack development, with expertise in Azure services and Agile methodology.The...
-
Technical Specialist IV
2 months ago
Salem, Oregon, United States Integrated Resources Full timeIntegrated Resources is seeking a highly skilled Technical Specialist IV to join our team. The ideal candidate will have a strong background in networking and software development, with expertise in ColdFusion solutions and Azure DevOps. The Technical Specialist IV will be responsible for analyzing and designing solutions to networking issues, providing...
-
Database Architect
1 month ago
Salem, Oregon, United States Crescens Full timeJob Title: Database AdministratorCrescens 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:Perform data refreshes in development, test, and UAT environmentsAssist in the deprecation of legacy DB2...
-
Database Systems Specialist
2 weeks ago
Salem, Oregon, United States Saxon Global Full timeJob SummaryAs a Database Systems Specialist at Saxon Global, you will be responsible for planning, designing, and implementing database systems to meet the needs of our clients. This includes maintaining responsibility for planning, design, installation, tuning, maintenance, troubleshooting, and repair of county-owned databases and related support tools. You...
-
Application Systems Analyst/Programmer IV
1 month ago
Salem, Oregon, United States Generis Tek Inc Full timeJob SummaryWe are seeking a highly skilled Application Systems Analyst/Programmer IV to join our team at Generis Tek Inc. The ideal candidate will have expertise in COBOL, DB2, CICS, TSO, JCL, and CA Debugger, with a strong background in database administration and system analysis.Key ResponsibilitiesActively engage in multiple discussions with system and...
-
Oracle Apps DBA
7 days ago
Winston-Salem, North Carolina, United States Syntricate Technologies Full timeJob Summary:As a seasoned Oracle Apps DBA at Syntricate Technologies, you will be responsible for the administration of Oracle E-Business Suite and Non-ERP databases. This includes managing large Oracle RAC based environments, providing shift and non-shift support, troubleshooting and tuning Oracle databases, and implementing disaster recovery plans....
-
Database Systems Engineer
1 month ago
Salem, Oregon, United States Della Infotech Full timeJob Title: Database Architect IIAt Della Infotech, we are seeking a highly skilled Database Architect II to join our team. As a key member of our database team, you will be responsible for designing and building relational databases for data storage or processing.Key Responsibilities:Develop strategies for warehouse implementation, data acquisition, and...
-
Database Systems Specialist
3 weeks ago
Salem, Oregon, United States Crescens Full timeJob Title: Database AdministratorLocation: RemoteDuration: 12+ monthsType: Contract***Remote work/Telecommuting will be contingent upon the key person providing their own adequate office equipment and connectivity.******Please note that this is a part-time role lasting for a full year.******This is 4 hours /per day.***Job Description:The Key Person will...
-
Database Architect
3 weeks ago
Salem, Oregon, United States Syntricate Technologies Full timeJob Title: Database ArchitectJob Title - Database ArchitectLocation - RemoteDuration - 4 HOURS A DAY 8 am to 12 PM (Remote)Req ID - 11119-24The 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...
-
Database Architect
2 weeks ago
Winston-Salem, North Carolina, United States The Clearing House Full timeDatabase Development Position SummaryThis role supports high-volume payment products at The Clearing House, focusing on transaction processing and analytics. Key responsibilities include designing, developing, and modernizing core database applications. The ideal candidate will have extensive experience in Microsoft database development, particularly with...