PostgreSQL DBA

Description

Position Summary: We are seeking a DBA (ETL) to ensure data stability, optimize database structures, and lead the extraction, transformation, and coexistence of data between legacy systems (Informix) and PostgreSQL. Key Highlights: 1. Experience with PostgreSQL and Informix for data migration and optimization 2. Proficiency in designing transactional schemas and financial models 3. Expertise in OpenShift and Kubernetes architectures IDS Comercial is a 100% Mexican IT company with 40 years of experience and presence in Mexico, Latin America, and the USA. We are accredited at CMMI Level 5 (Capability Maturity Model Integration), a quality framework established by the Software Engineering Institute (SEI). We are ISO certified under ISO/IEC 27001:2013\. We hold the Socially Responsible Enterprise (ESR) distinction. WE ARE LOOKING FOR YOU!! **DBA (ETL)** **Work Arrangement: Hybrid (2 days per week onsite)** **Address:** Avenida Patriotismo 266, San Pedro de los Pinos, Benito Juárez, 03800 Ciudad de México, CDMX. **Project Duration: 4 Months** **Experience:** 3–5 years in a similar role **Key Responsibilities or Objectives of the Role:** * Ensure data stability, structural optimization, and lead the technical execution of data extraction, transformation, and coexistence between legacy systems (Informix) and the new architecture (PostgreSQL) * ETL Design and Data Cleansing: Define and apply strict data sanitization rules, including handling null values, trimming whitespace, and standardizing character encodings * Integrity Assurance: Validate foreign keys and ensure no orphaned records exist during migrations * Manage complex structures, such as transactional tables with more than 20 fields, handling pointers (OIDs) and indexes * Synchronization and Coexistence (Real\-Time): Implement change capture mechanisms (Triggers or CDC) to maintain dual, bidirectional operational continuity between the legacy and new systems, resolving simultaneous update conflicts and avoiding "infinite loops" * Performance Tuning: Continuously optimize SQL queries and create indexes to improve response times and accelerate system reporting * Specialized Maintenance: Provide specialized database structure maintenance to ensure operational continuity of critical financial processes * Database Engine Technical Specifications: Advanced experience with PostgreSQL (target database) and Informix (source database) * Data Architecture: Proficiency in designing transactional schemas and catalogs, as well as understanding financial models (policies, receipts, collections, settlements) * Cloud/Container Environments: Operational understanding of OpenShift and Kubernetes architectures to collaborate with infrastructure teams, ensuring database operations do not overconsume cluster resources (CPU/Memory) **WE OFFER:** * Career development plan * Hybrid work arrangement (primarily remote, with occasional office visits) * Statutory benefits and additional perks