At a Glance
- Tasks: Lead Oracle to PostgreSQL database migrations and ensure data integrity.
- Company: Dynamic tech firm focused on innovative database solutions.
- Benefits: Flexible remote work, competitive salary, and professional growth opportunities.
- Other info: Collaborative environment with exciting challenges and career advancement.
- Why this job: Join a cutting-edge team and make a real impact in database technology.
- Qualifications: 5+ years as a Database Engineer with strong Oracle and PostgreSQL skills.
The predicted salary is between 51750 - 63250 £ per year.
We are seeking an experienced Database Engineer with strong expertise in Oracle and PostgreSQL to support enterprise database migration and modernization initiatives. The successful candidate will drive data migration between Oracle and PostgreSQL databases, develop automated validation and data integrity checks, and ensure seamless, secure, and high-quality database migration.
Key Responsibilities
- Design, execute, and support Oracle to PostgreSQL database migration activities.
- Develop and automate data validation, reconciliation, and integrity checks at the database level.
- Create migration scripts and ETL processes using Python, Perl, or similar scripting languages.
- Analyze Oracle database objects, including schemas, PL/SQL, stored procedures, triggers, functions, and constraints, and migrate them to PostgreSQL.
- Convert and optimize PL/SQL code to PL/pg-SQL where required.
- Utilize migration tools such as Ora2Pg, pg/Loader, and other database migration utilities.
- Identify, troubleshoot, and resolve migration issues, data inconsistencies, and performance bottlenecks.
- Perform data quality checks, eliminate duplicates, and ensure successful migration outcomes.
- Collaborate with application, infrastructure, and testing teams throughout the migration lifecycle.
- Document migration processes, technical designs, and best practices.
Required Skills & Experience
- 5+ years of experience as a Database Engineer/DBA with Oracle and PostgreSQL.
- Strong knowledge of Oracle Database, including schemas, data types, PL/SQL, stored procedures, triggers, packages, and constraints.
- Strong experience with PostgreSQL, including schemas, PL/pg SQL, functions, extensions, indexing, and performance tuning.
- Hands-on experience with Oracle to PostgreSQL migration projects.
- Experience using migration tools such as Ora2Pg, pg Loader, or equivalent.
- Proficiency in SQL and scripting using Python, Perl, or Shell.
- Strong troubleshooting skills with experience resolving migration errors, compatibility issues, and data quality challenges.
- Good understanding of database performance tuning, backup, recovery, and security best practices.
Senior Database Engineer in Sheffield employer: CSI GLOBAL LTD
As a Senior Business Analyst at our London office, you will thrive in a dynamic and collaborative work culture that values innovation and continuous improvement. We offer a hybrid working model, competitive benefits, and ample opportunities for professional growth, ensuring that you can make a meaningful impact while advancing your career in the financial services sector. Join us to be part of a forward-thinking team that champions effective communication and fosters strong relationships across various stakeholders.
