<p>We are seeking an experienced Senior PostgreSQL Database Developer to design, develop, and optimize complex database systems. The ideal candidate will have deep expertise in PostgreSQL, with a proven track record of building scalable, high-performance database solutions to support enterprise-level applications.</p><p><br></p><p>Key Responsibilities</p><p><br></p><p>Design, develop, and maintain PostgreSQL database schemas, ensuring optimal performance, scalability, and reliability.</p><p><br></p><p>Write and optimize complex SQL queries, stored procedures, triggers, and functions to support business applications.</p><p><br></p><p>Implement advanced PostgreSQL features, including indexing strategies (e.g., B-tree, GIN, GiST), partitioning, and full-text search.</p><p><br></p><p>Ensure data integrity, security, and compliance with industry standards (e.g., GDPR, HIPAA) through robust access controls and encryption.</p><p><br></p><p>Perform database performance tuning, query optimization, and monitoring to minimize latency and maximize throughput.</p><p><br></p><p>Design and implement high-availability solutions, including replication (logical and physical), failover, and clustering.</p><p><br></p><p>Collaborate with software engineers, data architects, and DevOps teams to integrate databases with application ecosystems.</p><p><br></p><p>Develop and maintain ETL pipelines for data migration and integration with external systems.</p><p><br></p><p>Troubleshoot and resolve database-related issues, including performance bottlenecks and data inconsistencies.</p><p><br></p><p>Mentor junior developers and provide technical guidance on PostgreSQL best practices.</p><p><br></p><p><br></p>
<p>We are looking for an experienced ETL Migration Developer/SAP Success Factors specialist to join our team for a 7 month contract role with potential for contract to hire. Must be able to work onsite 3 days a week. </p><p><br></p><p>This role focuses on supporting HR and IT teams in the manufacturing industry by leading data migration activities, including testing, cleansing, and population efforts. As a long-term contract position, it offers the opportunity to contribute to key HRIS implementation projects while collaborating across global teams.</p><p><br></p><p>Responsibilities:</p><p>• Lead and execute data migration processes, including testing, data cleansing, and population, to ensure seamless integration with HRIS systems.</p><p>• Collaborate closely with HR and IT teams to identify and resolve migration defects and ensure data accuracy.</p><p>• Analyze pre-load and post-load data files to validate successful migration and address discrepancies.</p><p>• Facilitate discussions with global HR teams to address missing or incorrect data and ensure all requirements are met.</p><p>• Coordinate with offshore data migration teams to align technical efforts with business objectives.</p><p>• Utilize advanced Excel skills, including VLOOKUP, to manage and analyze large data sets efficiently.</p><p>• Support mock cutovers and production cutover cycles to ensure smooth transitions during implementation.</p><p>• Provide insights and recommendations based on data analysis to improve migration processes.</p><p>• Work cross-functionally with HR operational teams and collaborate across regions to meet project timelines.</p><p>• Maintain effective communication with stakeholders, including executives and external customers, to ensure project alignment.</p>
