Senior PostgreSQL Migration & Development Engineer
Job Summary:
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 a remote position for the US only
Who We are...
SmarTek21, founded in 2006, is an innovative digital transformation leader dedicated to empowering organizations through design-led, data-centric solutions. We believe that exceptional user experiences and intelligent data-driven insights are pivotal in shaping the future of business. At the heart of our approach is Design-Led Engineering, where we combine strategic design principles with cutting-edge technology to create tailored solutions that deliver significant business outcomes. Our commitment to accelerating digital transformation includes specialized expertise in Agile DevOps, Data Engineering and analytics, Testing Automation and support, and comprehensive Managed Application and Infrastructure Services. We’ve evolved from our consulting and development roots into a full-spectrum service provider, integrating advanced technologies like Generative AI (GenAI) to facilitate our clients' seamless, transformative digital journeys. A passion unites our dynamic team of technology visionaries and business strategists for innovation and excellence. At SmarTek21, you'll join a collaborative environment dedicated to shaping the digital landscape and driving impactful results for organizations worldwide.
SmarTek21 is committed to fostering a diverse and inclusive environment. We encourage applications from individuals of all backgrounds and experiences.