Postgres SQL / SSIS Technical Lead

Location:

Role Overview:

Key Responsibilities

• Lead end-to-end design and implementation of

  ETL pipelines

   using

  SSIS

   and custom scripting solutions.
• Architect and execute

  Postgres database migrations

   from SQL Server, Oracle, or legacy platforms to cloud-hosted Postgres environments (AWS RDS/Aurora, GCP Cloud SQL, Azure Database).
• Develop, optimize, and maintain complex

  T-SQL

   and

  PL/pgSQL

   routines, functions, views, and stored procedures for large datasets.
• Define robust

  data models

  , table schemas, indexing strategies, and partitioning approaches to meet performance SLAs.
• Establish frameworks for

  data validation

  , reconciliation, and error handling to ensure data accuracy and integrity during migrations.
• Collaborate with DevOps to build

  CI/CD pipelines

   for database code using Git, Jenkins, TeamCity, Flyway/FlywayDB, or Liquibase.
• Implement monitoring and alerting using tools such as

  Grafana, Prometheus, CloudWatch, Azure Monitor

  , etc.
• Mentor junior data engineers, conduct architecture and code reviews, and drive engineering best practices.
• Work closely with security and compliance teams to implement

  data encryption (at rest/in transit)

  , masking, and audit logging controls.
• Troubleshoot production incidents, lead root-cause analysis, and drive long-term reliability improvements.
• Work within

  Agile teams

   to deliver prioritized features and technical capabilities.

Required Skills (Mandatory)

• PostgreSQL

• Dimensional Data Modeling

• PostgreSQL Migration

   (on-prem to cloud)

• PostgreSQL Database Administration

• AR/VR/MR

  (as specified in requirements)
• Strong understanding of ETL design, SQL optimization, and database architecture

Additional Strengths

• Experience with SSIS, legacy DB migrations, and cloud-managed database services
• Proficiency in scripting (Python, Shell, PowerShell)
• Familiarity with Agile methodologies and DevOps practices
• Strong analytical, problem-solving, and leadership skills
• Excellent communication and stakeholder collaboration abilities