Support data migrations and refreshes by preparing, running, and validating data loads and reconciling results in collaboration with DBAs.
Validate database objects and data integrity after maintenance activities such as upgrades and migrations.
Write, test, and maintain PL/SQL and PL/pgSQL code, including scripts, procedures, and triggers.
Participate in scrum ceremonies and contribute to sprint planning, estimation, and delivery.
Document changes, procedures, and recurring fixes.
Experience Requirements
5+ years in data engineering, database engineering, or application data support.
Advanced SQL and PL/SQL with working knowledge of PL/pgSQL.
Production experience with both Oracle and Postgres.
Proven experience supporting a live production application, including reconciling and troubleshooting data issues.
Strong data modeling and schema design skills.
Experience with data migration, database refreshes, and data quality validation.
Experience validating database objects after maintenance activities such as upgrades and migrations.
Experience using GitLab CI/CD pipelines to deliver database changes.
Experience working in Agile or scrum teams supporting developers and testers within a sprint cycle.
Ability to explain data findings clearly to developers, testers, and business stakeholders.
Preferred: familiarity with AWS RDS and AWS automation for database support such as AWS Backup and Amazon EventBridge.
Preferred: experience with accounting or financial systems.
Preferred: experience in AWS GovCloud, regulated, or government environments.
Preferred: strong PL/pgSQL.