Database Architect

24 hours ago

Salem, Oregon, United States Syntricate Technologies Full time
Job Title: Database Administrator IV

Location: Remote

Duration: 4 hours a day, 8 am to 12 pm

Req ID: 11119-24


Job 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 IBM DB2 databases on Unix and Mainframe operating systems, performing data refreshes, and troubleshooting database issues.


Key Responsibilities
  • Manage DB2 databases on Unix and Mainframe operating systems
  • Perform data refreshes in development, test, and UAT environments
  • 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, supporting schema maintenance and data distribution


Requirements
  • Extensive knowledge of DB2 on z/OS and AIX
  • Knowledge of SQL construction and optimization
  • Understanding of database 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


What We Offer

We offer a competitive salary and benefits package, as well as opportunities for professional growth and development.


How to Apply

If you are a motivated and experienced Database Administrator IV looking for a new challenge, please submit your application, including your resume and a cover letter, to [insert contact information].

  • Database Architect

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

  • Database Architect

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

  • Database Architect

    3 weeks ago

    Salem, Oregon, United States Crescens Full time

    Job 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

    3 weeks ago

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

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

  • Database Systems Engineer

    9 hours 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 Systems Engineer

    1 week ago

    Salem, Oregon, United States ACL Digital Full time

    Database Architect IIAt ACL Digital, we're seeking a skilled Database Architect II to join our team. As a key member of our data management 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 archive...

  • Database Systems Engineer

    2 weeks ago

    Salem, Oregon, United States Della Infotech Full time

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

    4 weeks ago

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

  • Database Systems Engineer

    2 weeks ago

    Salem, Oregon, United States Della Infotech Full time

    Job Title: Database Architect IIAbout the Role:At Della Infotech, we're seeking a skilled Database Architect II to join our team. As a key member of our data management team, you will be responsible for designing and building relational databases for data storage and processing.Key Responsibilities:• Develop strategies for warehouse implementation, data...

  • Database Systems Engineer

    3 weeks ago

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

  • Database Systems Engineer

    6 days ago

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

  • Senior Solution Architect

    1 week ago

    Salem, Oregon, United States Generis Tek Inc Full time

    Job Title: Solution Architect IVWe are seeking an experienced Solution Architect to join our team at Generis Tek Inc. as a Solution Architect IV. The successful candidate will be responsible for providing technical project oversight and guidance to our development team.About the Role:The Solution Architect will work closely with our development team to...

  • Solution Architect IV

    2 days ago

    Salem, Oregon, United States Generis Tek Inc Full time

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

  • Senior Solution Architect

    3 weeks ago

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

  • Senior Technical Lead

    4 weeks ago

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

  • Senior Technical Lead

    2 weeks ago

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

    Job Title: Solution Architect IVWe are seeking an experienced Solution Architect to join our team at HexaQuEST Global, Inc. as a key member of our Development Team. The successful candidate will provide technical project oversight and guidance, leveraging their expertise in cloud-based solutions, DevOps, and full-stack development.Key...

  • Senior Technical Project Manager

    3 weeks ago

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

    Job Title: Solution Architect IVHexaQuEST Global, Inc. is seeking an experienced Solution Architect IV to join our team. As a key member of our Development Team, you will provide technical project oversight and guidance, leveraging your expertise in DevOps, full stack web development, and Azure services.Key Responsibilities:Provide technical project...

  • Big Data Engineer

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