Database Architect - SQL Server / PostgreSQL

Role : Database Architect

Position Overview :

We are seeking a full-fledged Database Architect to design and develop complex database projects while leading a critical migration from SQL Server to PostgreSQL.

This role requires expertise in designing enterprise-scale database solutions, strong development skills across multiple database platforms, and proven experience in project ownership and client management.

Key Responsibilities :

• Design and execute comprehensive SQL Server to PostgreSQL migration strategy.
• Quickly initiate and design database models for both RDBMS and NoSQL projects.
• Provide swift support to development teams with database-related requirements and troubleshooting.
• Expert-level development of stored procedures, functions, triggers, and complex database objects across multiple platforms.
• Performance tuning and optimization query optimization, indexing strategies, and database performance enhancement.
• Migrate stored procedures, functions, and jobs from T-SQL to PL / pgSQL.
• Architect scalable, high-performance database solutions for PostgreSQL and other platforms.
• Take full project ownership including timeline, deliverables, and client communication.
• Develop migration tools and data validation frameworks.

Required Qualifications :

Preferred Qualifications :

(ref : hirist.tech)