Fazemos o sistema financeiro pulsar!
Senior DBA – Legacy Data Migration
Location
Brazil
Posted
2 days ago
Salary
0
Seniority
Senior
Job Description
Senior DBA – Legacy Data Migration
Sinqia
• Lead the data dimension of the migration for the SAP SQL Anywhere layer (~3.5M rows; 8,946 triggers; 805 stored procedures; 40k+ access points) • Evaluate and deploy a change data capture mechanism to enable coexistence stitching (no managed CDC for SQL Anywhere; dbtran is not CDC) • Ensure single-writer ownership during the dual-run • Protect data integrity and performance of the fiscal ledger system • Maintain the data side of the equivalence harness (production history replay) • Produce masked/synthetic datasets in compliance with Brazil's LGPD • Define the migration and reconciliation plan in waves, avoiding split-brain • Extract and document embedded business logic as reusable artifacts
Job Requirements
- Senior DBA responsible for administration, support, and optimization
- Migration of legacy databases heavily based on triggers/procedures to cloud data platforms
- Sybase / SAP SQL Anywhere (or equivalent engine)
- Change Data Capture (CDC) and replication
- Dual-repository (dual-store) synchronization
- Query tuning and performance at scale
- Data governance and LGPD (Brazilian data protection law)
- Fluent Portuguese; able to read technical documentation in English
Benefits
- N/A
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
ADABAS Data Engineer
USTWe believe in the power of technology to transform businesses and build a better world.
• The ADABAS Data Engineer is responsible for designing, developing, maintaining, and optimizing data solutions built on the ADABAS platform. • Analyze business and technical requirements and translate them into database designs and data models. • Develop and optimize ADABAS queries, utilities, and data extraction processes. • Work with Natural, COBOL, JCL, and other mainframe technologies to support data processing requirements. • Perform data migration, conversion, and integration activities between ADABAS and modern data platforms. • Monitor database performance and implement tuning strategies to improve efficiency and reliability. • Ensure data integrity, backup, recovery, and security procedures are maintained. • Troubleshoot and resolve database-related issues, incidents, and performance bottlenecks. • Collaborate with application developers, architects, business analysts, and infrastructure teams. • Support modernization efforts involving API integration, cloud migration, and data warehousing initiatives.
BIOVIA OneLab and Pipeline Pilot Developer
Redolent, IncERM - Rina María Cabrera / Capgemini | North América External Resource Manager Tel.: +1 888 229 2961 Email: rina.cabrera@capgemini.com
Role Description - Design and develop PLP solutions in Biovia OneLab. - Collaborate with customer and other stakeholders to determine functional and technical requirements. - Develop high-level product specifications with attention to system integration and feasibility. - Define all aspects of development from appropriate technology and workflow as per standards. - Successfully communicate all concepts and guidelines to development team. - Ensure software meets all requirements of quality, security, modifiability, extensibility, etc. Qualifications - BIOVIA OneLab Solution Expert with strong experience in BIOVIA Pipeline Pilot. - Strong knowledge of JavaScript and jQuery. - Experience in working with various BIOVIA components like Pipeline Pilot, Compose, CISPro, OneLab, ELN, etc. - Experience in BIOVIA configuration and customization on latest versions. - Knowledge of SQL, Oracle, Azure Cloud services. - Knowledge on implementation of DevOps and CI/CD. - Experience in API development for integrating various software components.
Data Engineer
Navtech, Inc.NAVTECH INC 1600 Golf Road. Suite 1200, Rolling Meadows, IL 60008 Ph: (224) 348-1340 Email: alex@navtechusa.com Website: www.navtechusa.com E-Verified Company
Role Description We are seeking a skilled Data Engineer with Python and JSON to design, develop, and maintain scalable data pipelines. The ideal candidate will work with structured and unstructured data, ensuring efficient data processing, transformation, and storage. - Develop and optimize data pipelines using Python. - Process, parse, and transform data using JSON and other formats. - Integrate data from various sources, including APIs and databases. - Ensure data integrity, performance, and security in ETL processes. - Collaborate with data scientists and engineers to build scalable solutions. Qualifications - Experience in Python. - Experience working with JSON for data transformation. - Hands-on experience with ETL processes and data pipeline development. - Knowledge of databases (SQL/NoSQL) and cloud platforms (AWS, GCP, or Azure). Company Description NAVTECH INC is an E-Verified Company located at 1600 Golf Road, Suite 1200, Rolling Meadows, IL 60008. Contact: (224) 348-1340 | Email: Alex@navtechusa.com Website: www.Navtechusa.com
Data Modeler / Data Engineer
Navtech, Inc.NAVTECH INC 1600 Golf Road. Suite 1200, Rolling Meadows, IL 60008 Ph: (224) 348-1340 Email: alex@navtechusa.com Website: www.navtechusa.com E-Verified Company
Role Description I have an opportunity for a "Data Modeler / Data Engineer" - (Chicago, IL - 100% Remote). Strong Data Modeling background is a must, with experience transforming logical models into physical database designs using best practices to ensure high data quality, reduce redundancy, and optimize performance. - Strong experience with Data Modeling to build complex enterprise data models. - Optimize, update, and maintain logical and physical data models, source to target mappings to support new and existing projects. - Work with the Application Development team to implement data strategies, build data flows, and develop conceptual data models. - Experience in designing multi-phased cloud data strategies, including designing multi-phased implementation roadmaps. - Design and develop scalable data ingestion frameworks to transform a variety of datasets. - Deep experience with designing and deploying end-to-end solutions with a cloud platform's analytic services including storage, permissions, private cloud, database services, virtual machines, and parallel processing technologies. - Experience analyzing, architecting, designing, and developing cloud data solutions, preferably with technologies such as Databricks, Snowflake. - Expert in working with business and understanding requirements to build multi-dimensional models to support business and reporting needs. - Expert in SQL, with the ability to write and debug complex SQL and stored procedures. - Exposure to programming language, preferably Python. - Overall background in data modeling, metadata management, data warehousing concepts, ETL development, and data quality. - Strong communications skills (verbal and written) and the ability to effectively communicate design recommendations to a varied audience. Qualifications - Strong Data Modeling background. - Experience with Data Modeling to build complex enterprise data models. - Experience in designing multi-phased cloud data strategies. - Expert in SQL. - Exposure to programming language, preferably Python. Requirements - Ability to transform logical models into physical database designs. - Experience optimizing, updating, and maintaining data models. - Experience with data ingestion frameworks. - Experience with cloud data solutions, preferably Databricks, Snowflake. - Strong communication skills. Benefits - 100% Remote work. - 12 Months Contract.

