Project Overview:
The Senior PostgreSQL Migration & Development Engineer will play a pivotal role in the successful migration of our existing databases to PostgreSQL, ensuring minimal disruption to business operations. This position requires a deep understanding of database architecture and the ability to design and implement efficient migration strategies. The engineer will also be responsible for developing new database solutions that enhance our business services and improve data accessibility. Collaboration with cross-functional teams will be essential to align database functionalities with business needs and to provide ongoing support post-migration.
Ultimately, this role aims to optimize our database performance and reliability, contributing to the overall efficiency of our business operations.
Key Responsibilities:
- Lead the end-to-end migration from legacy SQL systems to PostgreSQL
- Design and implement scalable, high-performance database solutions on Oracle Cloud
- Collaborate with software development teams to integrate PostgreSQL databases with existing applications.
- Optimize data architecture to ensure clean, reliable migration and minimal disruption
- Provide technical support and troubleshooting for database-related issues post-migration.
Success Criteria:
- Complete migration ahead of schedule
- Deliver stable, production-ready PostgreSQL environments
- Ensure zero major issues post-deployment
Required Skills & Experience:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 7+ years of experience in database engineering, including recent PostgreSQL work
- Deep knowledge of PostgreSQL internals, schema design, and performance tuning
- Strong hands-on experience with Oracle Cloud Infrastructure
- Familiarity with Oracle DB and legacy SQL environments
- Proven leadership in large-scale data migration projects
- Solid experience in scripting, automation, and troubleshooting complex database issues
Preferred Qualifications:
- Master's degree in a relevant field.
- Experience with CI/CD pipelines and DevOps practices
- Experience with other database systems such as MySQL or Oracle.
- Familiarity with cloud-based database solutions and services.
- Strong communication and documentation skills
Skills:
The required skills in PostgreSQL development and migration will be utilized daily to ensure that database structures are optimized for performance and reliability. Strong analytical skills will help in diagnosing issues and implementing effective solutions during the migration process. Collaboration skills are essential for working with various teams to align database functionalities with business objectives. Familiarity with cloud technologies will enhance the ability to deploy and manage databases in a scalable environment.
Additionally, problem-solving skills will be crucial for addressing any challenges that arise during and after the migration process.This is a remote position.SmarTek21 stands at the forefront of innovation, leveraging Generative AI to power advanced data ecosystems and industry-leading conversational interfaces that transform customer interactions. Established in 2006, we seamlessly blend human acumen with cutting-edge artificial intelligence to tackle the most complex challenges in digital integration and data governance.
