Database Developer (SQL)

Location: Remote

Company

hirify.global rebuilds vertical software businesses and launches AI-native products, including legal technology solutions within its portfolio.

What you will do

• Analyze relational and legacy source database schemas, including table structures, relationships, constraints, data types, dependencies, and data quality issues.
• Map source data to PostgreSQL and legacy target schemas and translate business requirements into transformation rules.
• Develop and maintain SQL queries, Python scripts, ETL processes, staging workflows, and reusable migration utilities.
• Implement data profiling, validation, reconciliation, error handling, logging, and post-migration verification.
• Troubleshoot migration failures, performance issues, data discrepancies, and conversion errors while optimizing processes for large datasets.
• Collaborate with implementation, engineering, and database teams; document mappings, scripts, assumptions, validation procedures, and standardized migration solutions.

Requirements

• 4–7 years of hands-on experience in database development, data migration, ETL, or data integration.
• Strong SQL proficiency, including complex joins, subqueries, stored procedures, and query optimization.
• Practical PostgreSQL experience and experience with at least two other database systems, such as SQL Server, MySQL, Oracle, DB2, or legacy relational databases.
• Experience analyzing unfamiliar database schemas and identifying relationships between tables.
• Hands-on experience developing data transformation and migration scripts using Python and SQL.
• Experience handling large datasets, data quality issues, and complex business transformation rules.
• Familiarity with ETL concepts, data validation, reconciliation, and migration best practices.
• Experience using AI-assisted coding tools such as ChatGPT, Claude, GitHub Copilot, or similar tools, with the ability to independently evaluate and correct generated SQL and scripts.
• Strong troubleshooting, analytical, problem-solving, written communication, and technical documentation skills; ability to work independently in a remote environment and collaborate with distributed teams.

Nice to have

• Familiarity with Advantage Database Server (ADS).
• Experience with SQL-based staging databases and intermediate data transformation processes.
• Experience building reusable ETL frameworks or automated migration utilities.
• Familiarity with ODBC and JDBC.
• Experience with AI-assisted workflow automation and scripting.
• Knowledge of PostgreSQL performance tuning, indexing, and bulk-loading techniques.

Culture & Benefits

• Remote work with collaboration across a diverse, global team.
• Competitive salary based on experience.
• Opportunities for career advancement and professional development.
• Work on AI-enabled software and real customer workflows.