Database Architect

4 weeks ago

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

Job Title - Database Architect
Location - 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.
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 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 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 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...

  • Senior Technical Solutions Architect

    3 weeks ago

    Salem, Oregon, United States Generis Tek Inc Full time

    Job Title: Senior Technical Solutions ArchitectJob Description:Generis Tek Inc is seeking an experienced Senior Technical Solutions Architect to assist our Development Team with Technical Project Oversight and Guidance. The ideal candidate will have expertise in modernizing core applications, DevOps, and Full stack development.Key Responsibilities:Provide...

  • Senior Infrastructure Architect

    3 weeks ago

    Salem, Oregon, United States Highmark Health Full time

    Job DescriptionJob Title: Principal Infrastructure ArchitectCompany: Highmark HealthJob Summary:The Principal Infrastructure Architect will serve as a senior infrastructure architect and technology futurist at Highmark Health. This role will have a direct impact on the strategy, architecture, and innovation agenda for infrastructure and our interconnected...

  • Senior Software Developer/Software Architect

    3 weeks ago

    Salem, Oregon, United States Oracle Full time

    The telecommunications industry is undergoing a significant transformation, driven by the adoption of intelligent networks, virtualized network functions, and cloud deployments as Software as a Service (SaaS).Oracle Communications is at the forefront of this technological innovation, leveraging its extensive footprint in communications software, Oracle Cloud...

  • Senior Network Solutions Analyst

    3 weeks ago

    Salem, Oregon, United States Lorven Technologies Full time

    Job Title: Technical Specialist IVLocation: RemoteDuration: ContractRemote JobJob DescriptionAs a Technical Specialist IV at Lorven Technologies, you will be responsible 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 and...

  • Senior Estimator

    4 weeks ago

    Salem, Oregon, United States Pence Construction Full time

    Job SummaryThe Senior Estimator is responsible for leading and managing the estimating department at Pence Construction. This role requires strong leadership and management skills, as well as the ability to build and maintain relationships with clients, architects, engineers, and subcontractors. The ideal candidate will have a strong understanding of...

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

  • Senior Estimator

    4 weeks ago

    Salem, Oregon, United States Pence Construction Full time

    Senior Estimator Job DescriptionThe Senior Estimator is a key leadership position at Pence Construction, responsible for overseeing the estimating department and ensuring timely, accurate, and complete services. This role requires strong leadership and management skills, as well as the ability to build and maintain positive relationships with clients,...

  • Data Administrator III

    3 weeks ago

    Salem, Oregon, United States ACL Digital Full time

    Job Title: Data Administrator III - IT Asset Management SpecialistJob Summary:ACL Digital is seeking an experienced Data Administrator III to join our team. As a Data Administrator III, you will be responsible for managing and maintaining IT asset management data in a CA/Broadcom APM environment. Your primary focus will be on ensuring data quality,...

  • Business System Analyst

    4 weeks ago

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

    Job Title:Business System AnalystJob Location:Remote OpportunityJob Duration:24+ Months assignmentJob Description:This Role will be supporting the implementation of a Client's New Time & Attendance System. The nature of the work is focused on analysing, designing, and implementing effective systems to enhance operational efficiency and support organizational...

  • Senior Network Solutions Analyst

    4 weeks ago

    Salem, Oregon, United States ACL Digital Full time

    Job SummaryWe are seeking a highly skilled ColdFusion Application Migration Specialist to join our team at ACL Digital. The ideal candidate will have a strong background in network solutions, ColdFusion application migration, and technical architecture.Key ResponsibilitiesAnalyze and evaluate ColdFusion application software code to determine features that...

  • Database Architect

    3 weeks ago

    Winston-Salem, North Carolina, United States The Clearing House Full time

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

  • Database Architect II

    4 months ago

    Salem, United States ACL Digital Full time

    Designs and builds relational databases for data storage or processing. Develops strategies for warehouse implementation, data acquisition, and archive recovery. Cleans and maintains the database by removing and deleting old data. May evaluate new data sources for adherence to the organization's quality standards and ease of integration. May require a...

  • Cloud Architect

    4 weeks ago

    Winston-Salem, North Carolina, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job Title:Cloud ArchitectJob ID:Location:US-NC-Winston SalemPermanent HireRole:Architect (Azure, .NET applications)Location :Winston Salem, NC (Day 1 onsite)Role Description:The architect should have experience in different Azure PaaS services like Azure Functions, Logic Apps, Azure Web Apps, Azure SQL Database, Application Insights, ACR, and security...

  • SFMC Sr. Solution Architect

    4 days ago

    Winston Salem, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...

  • SFMC Sr. Solution Architect

    3 days ago

    Winston-Salem, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...

  • SFMC Sr. Solution Architect

    4 days ago

    Winston Salem, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...

  • SFMC Sr. Solution Architect

    3 days ago

    Winston Salem, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...

  • SFMC Sr. Solution Architect

    3 days ago

    Winston Salem, NC, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...

  • Information Systems Specialist 8

    6 months ago

    Salem, United States State of Oregon Full time

    Job Description: OREGON YOUTH AUTHORITYINFORMATION SYSTEMS SPECIALIST 8 - Application DeveloperSalem - OYA Equitable Building - Information Systems DepartmentJoin the Oregon Youth Authority (OYA) as an Application Developer to serve as a System Architect for the JJIS Application Development team. As we embark on migrating our primary juvenile justice...

  • Data Administrator III

    4 months ago

    Salem, United States ACL Digital Full time

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

  • DevOps Engineer Lead

    4 weeks ago

    Winston-Salem, North Carolina, United States CoolSnail Full time

    Job Title: DevOps Engineer LeadAt CoolSnail, we're seeking a highly skilled DevOps Engineer Lead to join our team. As a key member of our infrastructure team, you will be responsible for managing automation and infrastructure related to Development Operations, resource alignment, and workload.Key Responsibilities:Design and manage CI/CD pipelines that...

  • Security Infrastructure Engineer

    1 month ago

    Winston-Salem, United States Techtriad Team - T3 Full time

    Position summary:The Security Infrastructure Engineer role will be responsible for architecting, implementing, and the day-to-day administration activities respective to the Enterprise Security & Infrastructure Systems portfolio of applications and tools within Operations and Technology, also providing oversight and governance for key systems administration...

  • Senior React UI AWS Developer

    4 months ago

    Winston-Salem, United States Innovative Development Full time

    Senior Software Engineer (Cloud) Role This development positions supports the business processes, both with ongoing migration to the cloud for new and existing applications. The individual who fills this position will be knowledgeable in both React front-end development as well as AWS cloud concepts such as deployments, storage, high availability,...

  • API Developer

    3 days ago

    Winston-Salem, United States Truliant Federal Credit Union Full time

    Truliant's mission is to improve lives by putting our members first, providing great service and straightforward financial solutions. Our core values of Member Focus, Service, Guidance, Relationships, and Community define how we interact with members to fulfill our mission of improving lives and providing a foundation on which we conduct ourselves. Our...

  • Api Developer

    4 days ago

    Winston-Salem, United States Truliant Federal Credit Union Full time

    Truliant‘s mission is to improve lives by putting our members first, providing great service and straightforward financial solutions. Our core values of Member Focus, Service, Guidance, Relationships, and Community define how we interact with members to fulfill our mission of improving lives and providing a foundation on which we conduct ourselves.Our...