Database Developer, SQL

Embrace Software Inc

. Analyze source database schemas across relational and legacy database systems .

Posted 10/27/2026full-timeRemote • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in database development and data migration, with strong proficiency in SQL and experience in PostgreSQL and other database systems. Capable of translating business requirements into technical mapping and transformation rules while ensuring data quality and optimizing migration processes.

Highest-signal resume keywords

SQL ProficiencyPostgreSQL ExperienceData Migration ExpertiseETL Process DevelopmentAI-Assisted Coding Tools

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonData Transformation ScriptsETL ProcessesDatabase Schema AnalysisData ValidationQuery OptimizationTroubleshootingData ProfilingMigration Utilities

Soft Skills

Analytical SkillsProblem-Solving SkillsWritten CommunicationCollaboration

Tools & Technologies

PostgreSQLSQL ServerMySQLOracleDB2Advantage Database ServerGitHub CopilotChatGPTClaudeODBC

Industry Keywords

Data MigrationETLData IntegrationData QualityDatabase DevelopmentLegacy Database SystemsAutomated Migration UtilitiesPerformance TuningIndexingBulk-Loading Techniques

Tech Stack

Tools & technologies

ETLMySQLOraclePostgresPythonSQL

About the role

Key responsibilities & impact

Analyze source database schemas across relational and legacy database systems
Understand table structures, relationships, constraints, data types, and dependencies
Map source data structures to target schemas, including PostgreSQL and legacy platforms
Identify data inconsistencies, missing values, duplicates, and migration challenges
Translate business requirements into technical mapping and transformation rules
Develop and maintain SQL queries, scripts, and ETL processes for data migration
Build reusable transformation scripts and migration utilities using SQL, Python, or other technologies
Implement data validation, reconciliation, error handling, and logging
Troubleshoot migration failures, performance issues, and data discrepancies
Optimize migration processes for large datasets and complex database structures
Leverage AI coding assistants for schema analysis, SQL generation, scripting, debugging, and documentation
Review, validate, and optimize AI-generated code
Identify and automate repetitive mapping, validation, and migration activities
Perform data profiling and quality assessments before migration
Support test migrations, production migrations, and post-migration verification
Document mappings, transformation logic, scripts, assumptions, and validation procedures
Collaborate with customer-facing implementation, engineering, and database teams
Maintain reusable migration scripts and technical documentation in version control

Requirements

What you’ll need

4–7 years of hands-on experience in database development, data migration, ETL, or data integration
Strong proficiency in SQL, including complex joins, subqueries, stored procedures, and query optimization
Practical experience with PostgreSQL
Experience working 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
Ability to independently evaluate and correct AI-generated SQL and scripts
Strong troubleshooting, analytical, and problem-solving skills
Good written communication and technical documentation skills
Ability to work independently in a remote environment and collaborate 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

Comp & perks

Competitive salary commensurate with experience
Opportunities for career advancement and professional development
Experience collaborating with a diverse, global team within a remote work setting