Database Developer, SQL

This is a fully remote position, open to applicants in United States.

📋 Description

• Analyze database schemas from various relational and legacy systems.

• Comprehend table structures, relationships, constraints, data types, and dependencies.

• Map data structures from the source to target schemas, including PostgreSQL and legacy systems.

• Identify inconsistencies in data, missing values, duplicates, and challenges related to migration.

• Convert business requirements into technical mapping and transformation specifications.

• Create and sustain SQL queries, scripts, and ETL processes for the purpose of data migration.

• Develop reusable transformation scripts and migration tools using SQL, Python, or other technologies.

• Implement data validation, reconciliation, error handling, and logging processes.

• Address issues related to migration failures, performance, and data discrepancies.

• Enhance migration processes for extensive datasets and complex database architectures.

• Utilize AI coding assistants for schema analysis, SQL generation, scripting, debugging, and documentation.

• Review, validate, and optimize code generated by AI.

• Recognize and automate repetitive activities related to mapping, validation, and migration.

• Conduct data profiling and quality assessments prior to migration.

• Assist with test migrations, production migrations, and post-migration validation.

• Document mappings, transformation logic, scripts, assumptions, and validation processes.

• Collaborate with implementation teams, engineering, and database personnel who interact with customers.

• Maintain reusable migration scripts and technical documentation within version control.

⛳️ Requirements

• 4–7 years of practical experience in database development, data migration, ETL, or data integration.

• Strong expertise in SQL, including complex joins, subqueries, stored procedures, and optimization techniques.

• Practical experience with PostgreSQL.

• Experience with at least two additional database systems, such as SQL Server, MySQL, Oracle, DB2, or legacy relational databases.

• Proficient in analyzing unfamiliar database schemas and determining relationships among tables.

• Hands-on experience in developing data transformation and migration scripts using Python and SQL.

• Experience managing large datasets, addressing data quality issues, and navigating complex business transformation rules.

• Familiarity with ETL concepts, validation, reconciliation, and best practices for migration.

• Experience utilizing AI-assisted coding tools like ChatGPT, Claude, GitHub Copilot, or similar technologies.

• Capability to independently assess and rectify AI-generated SQL and scripts.

• Strong skills in troubleshooting, analysis, and problem-solving.

• Competent written communication and technical documentation abilities.

• Ability to work autonomously in a remote environment while collaborating with distributed teams.

• Preferred: Familiarity with Advantage Database Server (ADS), SQL-based staging databases, reusable ETL frameworks, automated migration utilities, ODBC, JDBC, AI-assisted workflow automation, PostgreSQL performance tuning, indexing, and bulk-loading techniques.

🏝️ Benefits

• Competitive salary reflective of experience.

• Opportunities for career growth and professional development.

• Experience working with a diverse, global team in a remote work environment.