Senior PostgreSQL DBA - AWS Cloud & Performance Tuning

TechDigital Group; St. Louis (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

An established industry player is seeking an experienced PostgreSQL Database Administrator to oversee and optimize their database systems. This role involves managing the performance, availability, and security of critical databases, ensuring they run smoothly and efficiently. The ideal candidate will have extensive experience with PostgreSQL, MySQL, and AWS cloud databases, and will play a vital role in implementing and maintaining robust database solutions. Join a forward-thinking company that values innovation and offers a collaborative environment where your expertise will directly contribute to the success of the organization.

Qualifications

• 8+ years of experience in PostgreSQL and database administration.
• Strong knowledge of AWS cloud database solutions.

Responsibilities

• Manage and maintain PostgreSQL databases ensuring performance and security.
• Implement and configure database systems, including backups and monitoring.

Skills

PostgreSQL

Database Administration

MySQL

AWS Cloud DB

Job description

Oracle Integration Cloud technical architect

The Oracle Integration Cloud Architect is responsible for designing, governing, and delivering enterprise‐grade integrations using Oracle Integration Cloud. The role focuses on scalable, secure, and resilient integration architectures across Oracle SaaS, on‐prem systems, and third‐party platforms.

Architecture & Design

• Define end‐to‐end integration architecture using Oracle Integration Cloud (OIC Gen2)
• Design integration patterns including synchronous/asynchronous, event‐driven, and batch
• Establish canonical data models, transformation standards, and API design principles
• Design hybrid integrations across Oracle SaaS, on‐prem systems, and cloud platforms (Azure/AWS/GCP)

Integration Development Oversight

• Lead development of:
  • App‐Driven Integrations
  • Scheduled Integrations
  • Basic and Publish/Subscribe Integrations
• Define standards for lookup usage, packages, reusable integrations, and adapters
• Guide teams on error handling, fault policies, retries, and compensation logic

• Lead Design, development and implementation of integrations using Oracle Integration Cloud (OIC).
• Build App Driven, Scheduled, and Basic integrations.
• Develop REST/SOAP-based integrations with internal and external systems.
• Configure adapters (ERP Cloud, REST Adapter, FTP Adapter, ServiceNow, etc.).
• Design and implement orchestration, routing, transformations, and enrichment logic.

• Create and maintain data mappings using OIC mapper.
• Handle complex transformations (XSLT, lookups, enrich actions).
• Implement fault-tolerant transformations and null-handling logic.

• Implement end-to-end error handling, fault policies, and retries.
• Configure activity stream, tracking fields, and business identifiers.
• Monitor integrations using OIC Insight/Tracking dashboards.
• Troubleshoot and resolve runtime integration failures.

1. Security & Connectivity

• Configure secure connectivity using OCI Streaming, VPN, or FastConnect (as applicable).
• Manage OIC security artifacts: certificates, OAuth tokens, and integration security policies.
• Ensure integrations comply with enterprise security and compliance standards.

1. File-Based Integrations

• Develop inbound and outbound file-based integrations using OIC FTP adapter.
• Handle large files, batch processing, and scheduling.
• Implement file validation, archival, and purging mechanisms.

1. Testing & Deployment

• Perform unit testing and support SIT/UAT cycles.
• Prepare deployment artifacts and migrate integrations across environments (DEV → TEST → PROD).
• Support deployment activities and post-deployment validation.

1. Documentation & Knowledge Transfer

• Create and maintain technical design documents (TDDs).
• Document integration flows, mappings, endpoints, and error scenarios.
• Provide KT sessions and handover documentation to support teams.

1. Collaboration & Agile Delivery

• Participate in sprint planning, daily stand-ups, and backlog grooming.
• Collaborate with functional teams, ERP teams, and downstream system owners.
• Provide accurate effort estimates and delivery timelines.
• Support release cycles, patches, and OIC upgrades.
• Follow Oracle OIC best practices and enterprise integration standards.
• Ensure reusability of integrations and adherence to naming/versioning standards.
• Participate in design reviews and architecture governance forums.