Database Systems Specialist

4 weeks ago

Salem, Oregon, United States Crescens Full time
Job Title: Database Administrator

Location: Remote

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 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.

Requirements:

  • 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.
  • Business systems and organizational structures.
  • Trends, technological changes, and developments in IS.
  • Operations and business of the organization.
  • 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.

  • Database Systems Specialist

    4 weeks ago

    Salem, Oregon, United States Saxon Global Full time

    Job 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...

  • Database Systems Engineer

    4 weeks ago

    Salem, Oregon, United States ACL Digital Full time

    Database Architect IIAt ACL Digital, we're seeking a skilled Database Architect II to design and build robust relational databases for data storage and processing.The ideal candidate will develop strategies for warehouse implementation, data acquisition, and archive recovery, ensuring seamless integration with our existing systems.Responsibilities...

  • Database Architect

    4 weeks ago

    Salem, Oregon, United States Syntricate Technologies Full time

    Job 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 Architect

    3 weeks ago

    Salem, Oregon, United States Syntricate Technologies Full time

    Job Title: Database ArchitectAt Syntricate Technologies, we are seeking a highly skilled Database Architect to join our team. As a key member of our team, you will be responsible for managing both IBM DB2 databases for Unix and Mainframe operating systems.Your primary responsibilities will include:Managing data refreshes in development, test, and UAT...

  • Database Architect

    4 weeks ago

    Salem, Oregon, United States Syntricate Technologies Full time

    Job 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...

  • Information Systems Specialist 8

    3 weeks ago

    Salem, Oregon, United States State of Oregon Full time

    Job Title: Information Systems Specialist 8Job Summary:We are seeking an experienced Application Developer to serve as a System Architect for the JJIS Application Development team. As we embark on migrating our primary juvenile justice information system (JJIS) to a Low Code platform, your expertise will be instrumental in shaping the future of JJIS as a...

  • Information Systems Specialist 8

    4 weeks ago

    Salem, Oregon, United States State of Oregon Full time

    Job Title: Information Systems Specialist 8Job Summary:We are seeking a highly skilled Information Systems Specialist 8 to join our team as an Application Developer. As a key member of the JJIS Application Development team, you will play a crucial role in shaping the future of our juvenile justice information system.Main Responsibilities:Design and develop...

  • Senior DB2 Database Administrator

    4 weeks ago

    Salem, Oregon, United States ACL Digital Full time

    Job 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,...

  • Electrical Systems Specialist

    6 days ago

    Salem, Oregon, United States Jet Industries Full time

    Electrical Systems Specialist Job DescriptionAt Jet Industries, we're seeking an experienced Electrical Systems Specialist to join our team. As an Electrical Systems Specialist, you will be responsible for installing, maintaining, and repairing electrical systems in commercial and industrial settings.Key Responsibilities:Install and maintain electrical...

  • Electrical Systems Specialist

    4 weeks ago

    Salem, Oregon, United States Oregon State Gov Full time

    Electrical Systems SpecialistAt Oregon State Government, we're seeking a skilled Electrical Systems Specialist to join our team. As an Electrician, you'll be responsible for maintaining and repairing electrical distribution systems, including transformers, switch cabinets, and primary/secondary power lines. You'll also plan, design, and install primary and...

  • Computer Systems Specialist

    4 weeks ago

    Salem, Oregon, United States CapLeo Global Full time

    Job Title: Systems SpecialistLocation: RemoteDuration: Contract (With a possible extension)Job Description:As a Computer Systems Specialist at CapLeo Global, you will provide technical guidance for the development and troubleshooting of computer systems. You will identify system data, hardware or software components required to meet user needs. You will also...

  • Technical Systems Specialist

    3 weeks ago

    Salem, Oregon, United States Global Pharma Tek Full time

    Job Title: Systems SpecialistLocation: RemoteDuration: Contract (With a possible extension)Job Description:As a Computer Systems Specialist at Global Pharma Tek, you will provide technical guidance for the development and troubleshooting of computer systems. You will identify system data, hardware or software components required to meet user needs. You will...

  • Electrical Systems Specialist

    4 weeks ago

    Salem, Oregon, United States nVent Full time

    Electrical Systems SpecialistWe're seeking a skilled Electrical Systems Specialist to join our team at nVent. As a key member of our team, you will be responsible for installing, maintaining, and repairing electrical systems in our industrial and commercial facilities.Key Responsibilities:Install and terminate electrical wiring and fixturesApply knowledge of...

  • EVV System Support Specialist

    4 weeks ago

    Salem, Oregon, United States Advantage Home Care Full time

    **Advantage Home Care's EVV Support Specialist Role**We are seeking a skilled EVV Support Specialist to join our team at Advantage Home Care. As an EVV Support Specialist, you will be responsible for providing technical assistance and support to our caregivers and staff members in utilizing the EVV system effectively.**Key Responsibilities:**Provide...

  • Information Systems Specialist 4

    4 weeks ago

    Salem, Oregon, United States State of Oregon Full time

    Job SummaryWe are seeking a highly skilled Information Systems Specialist 4 - Wildlife GIS Analyst to join our team at the Oregon Department of Fish and Wildlife. As a key member of our GIS team, you will provide technical assistance and support to our staff, focusing on the needs of the Wildlife Division. Your expertise in GIS and spatial analysis will be...

  • Computer Systems Specialist

    3 weeks ago

    Salem, Oregon, United States ACL Digital Full time

    Job Title: System Specialist IVJob Summary:ACL Digital is seeking a skilled System Specialist IV to join our team. As a key member of our technical team, you will provide technical guidance for the development and troubleshooting of computer systems.Key Responsibilities:- Provide consultations and solution recommendations for ODOT's Enterprise Content...

  • Mainframe Software Development Specialist

    4 weeks ago

    Salem, Oregon, United States HCL Global Systems Full time

    Mainframe Software Development SpecialistAt HCL Global Systems, we are seeking a highly skilled Mainframe Software Development Specialist to join our team. The ideal candidate will have experience in developing and troubleshooting computer systems, identifying system data, hardware, or software components required to meet user needs, and developing...

  • Software Development Specialist

    4 weeks ago

    Salem, Oregon, United States InterSources Full time

    Job Summary:We are seeking an experienced Software Development Specialist to join our team at InterSources Inc. As a key member of our software development team, you will be responsible for designing, developing, and implementing C#/.Net applications utilizing ASP.NET Core, Visual Studio (2019 or later), Azure DevOps, and Azure PaaS technologies.The ideal...

  • Application Specialist

    4 weeks ago

    Salem, Oregon, United States State of Oregon Full time

    Job Title: Application SpecialistThe State of Oregon is seeking a highly skilled Application Specialist to join our team. As an Application Specialist, you will play a critical role in the development, implementation, and maintenance of our enterprise applications.Key Responsibilities:Develop and implement large-scale applications to support complex business...

  • Mainframe Software Development Specialist

    3 weeks ago

    Salem, Oregon, United States HCL Global Systems Full time

    Mainframe Software Development SpecialistHCL Global Systems is seeking a highly skilled Mainframe Software Development Specialist to join our team. As a key member of our Commerce & Compliance Application Development (CCAD) team, you will be responsible for providing technical guidance for the development and troubleshooting of computer systems.Key...