Database Architect

22 hours ago


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

Crescens 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 environments
  • Assist in the deprecation of legacy DB2 databases
  • Troubleshoot and resolve DB2 job and database issues
  • Plan and implement DB2 upgrades and patches
  • Support the export and load of production data
  • Provide support for batch jobs on zOS, including job scheduling, monitoring, and troubleshooting
  • Offer DBA support for applications running on AIX, zOS, and Linux platforms
  • Support Java-based applications using JDBC and SQLJ
  • Create and manage JCL jobs to automate database and system tasks
  • Design, create, implement, maintain, tune, and support DB2/UDB databases on AIX and z/OS platforms
  • Manage tables and indexes
  • Promote changes to various subsystems including production
  • Provide on-call coverage for OLTP applications on the zOS platform
  • 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
  • Develop ETL routines using DB2 load/unload utilities, DB2 Connect, and other data warehousing tools
  • Provide ongoing technical assistance and education to application developers and business analysts for DB2, COBOL, JCL, and SQL
  • Conduct performance analysis and identify tuning opportunities to enhance database performance
  • Implement and manage recovery strategies using RMAN
  • Provide schema development and system configuration support for application developers
  • Work with developers to diagnose and resolve database-related application issues
  • Support 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
  • Identifying the scope and complexity of a project
  • Assigning segments of a project to others
  • 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 Architect

    22 hours ago


    Salem, Oregon, United States Syntricate Technologies Full time

    Job 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 database systems, ensuring data integrity and security, and providing technical support to our development team.Key...


  • Salem, Oregon, United States ACL Digital Full time

    Database Architect IIJob SummaryWe are seeking a skilled Database Architect II to design and build relational databases for data storage and processing. The ideal candidate will have a strong understanding of database concepts and experience in implementing data warehouses.Key ResponsibilitiesDesign and develop relational databases for data storage and...


  • 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 relational databases for data storage and processing.Key Responsibilities:Develop strategies for warehouse implementation, data acquisition, and archive recovery.Clean and maintain the database by removing and deleting old data.Evaluate new data sources for...


  • Salem, Oregon, United States Della Infotech Full time

    Della Infotech is seeking a skilled professional to fill the role of Database Architect II. Below are the key responsibilities and requirements for this position.**Job Summary**As a Database Architect II, you will be responsible for designing and building relational databases for data storage or processing. This will involve developing strategies for...


  • Salem, Oregon, United States Della Infotech Full time

    Job DescriptionPosition: Database Architect IILocation: RemoteDuration: OngoingDescription:We are seeking a skilled Database Architect II to join our team at Della Infotech. As a key member of our data management team, you will be responsible for designing and building relational databases for data storage and processing.Your primary focus will be on...


  • Salem, Oregon, United States Syntricate Technologies Full time

    Job Title - Database Administrator IVLocation - RemoteDuration - 4 HOURS A DAY 8 am to 12 PM (Remote)Req ID -Job Summary:We are seeking a highly skilled Database Administrator IV to join our team at Syntricate Technologies. As a key member of our Mainframe Modernization project, you will be responsible for managing IBM DB2 databases on Unix and Mainframe...


  • Salem, Oregon, United States Crescens Full time

    Job Title: Technical Solutions Architect Location: Remote Duration: 3 MonthsJob Overview: Crescens is currently engaged in the transformative phase of enhancing their core application, specifically the juvenile justice information system, utilized by a significant number of end users across various jurisdictions.The existing application operates on an...


  • Salem, Oregon, United States Generis Tek Inc Full time

    Solution Architect- Remote-Salem ORGeneris Tek Inc is seeking an experienced Solution Architect to join our team on a 3+ month contract basis. The ideal candidate will have a strong background in technical project oversight and guidance, with expertise in DevOps, full-stack development, and cloud architecture.Key Responsibilities:Provide technical project...


  • Salem, Oregon, United States Autodesk Full time

    Cloud Development Solutions EngineerAutodesk is seeking a highly skilled Cloud Development Solutions Engineer to join our team. As a key member of our Enterprise Systems and Experience technology modernization initiative, you will play a critical role in developing solutions that will be utilized across the wider organization.Key Responsibilities:Design and...


  • Salem, Oregon, United States HexaQuEST Global, Inc. Full time

    HexaQuEST Global, Inc. is seeking a seasoned **Solution Architect IV** to lead the technical implementation of our JJIS Modernization Services project. The ideal candidate will have extensive experience in Oracle and PostgreSQL database management, as well as expertise in DevOps, full-stack web development, and Azure services. Key responsibilities include...

  • Big Data Engineer

    4 days ago


    Salem, Oregon, United States Stellar Professionals Full time

    Job Title: Big Data EngineerWe are seeking a highly skilled Big Data Engineer to join our team at Stellar Professionals. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.Key Responsibilities:Develop applications using...

  • Informatica Developer

    3 weeks ago


    Salem, Oregon, United States Stellar Professionals Full time

    Job DescriptionJob Title: Informatica DeveloperWork Arrangement: OnsiteJob Summary:We are seeking a skilled Informatica Developer to join our team at Stellar Professionals. As an Informatica Developer, you will play a critical role in designing, coding, and modifying ETL processes using Informatica PowerCenter 10.x.Key Responsibilities:ETL Design and...


  • Salem, Oregon, United States Integrated Resources Full time

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


  • Salem, Oregon, United States Generis Tek Inc Full time

    Job Title: Technical Specialist IVWe are seeking a highly skilled Technical Specialist IV to join our team at Generis Tek Inc. As a Technical Specialist IV, you will be responsible for analyzing and designing solutions to complex networking issues, providing technical support to other departments, and troubleshooting, diagnosing, and solving issues with both...


  • Salem, Oregon, United States Careers Integrated Resources Inc Full time

    Job Title: Business System AnalystJob Location: RemoteJob Duration: 24+ Months assignmentJob Description:This role will support the implementation of a new Time & Attendance System for our client. The successful candidate will work closely with business stakeholders to analyze, design, and implement effective systems that enhance operational efficiency and...


  • Salem, Oregon, United States ACL Digital Full time

    Job DescriptionACL Digital is seeking a highly skilled Technical Specialist IV to join our team. As a key member of our Information Systems Branch, Enterprise Application Services, you will be responsible for analyzing and designing solutions to complex networking issues, providing technical support to other departments, and troubleshooting, diagnosing, and...


  • Salem, Oregon, United States Lorven Technologies Full time

    Job Title: Technical Specialist IVLocation: RemoteDuration: 6+ Months (Contract)Job Description:Key Responsibilities:Analyze and design solutions to networking issues, providing technical support to other departments, as well as troubleshooting, diagnosing and solving issues with both hardware and software.May require a bachelor's degree and at least 9 years...


  • Salem, Oregon, United States ACL Digital Full time

    Job SummaryWe are seeking a highly skilled and experienced Technical Specialist to join our team at ACL Digital. As a Technical Specialist, you will be responsible for analyzing and designing solutions to complex networking issues, providing technical support to other departments, and troubleshooting, diagnosing, and solving issues with both hardware and...


  • Salem, Oregon, United States ACL Digital Full time

    Job Title: Technical Specialist IVACL Digital is seeking a highly skilled Technical Specialist IV to join our team. As a key member of our Enterprise Application Services team, you will be responsible for analyzing and designing solutions to complex networking issues, providing technical support to other departments, and troubleshooting, diagnosing, and...


  • Salem, Oregon, United States Generis Tek Inc Full time

    Job DescriptionJob Title: Technical Solutions SpecialistJob Summary:We are seeking a highly skilled Technical Solutions Specialist to join our team at Generis Tek Inc. As a Technical Solutions Specialist, you will be responsible for analyzing and designing solutions to complex networking issues, providing technical support to other departments, and...