Senior Cloud Data Engineer — PostgreSQL & Migration Lead

Wi-Tronix; Bolingbrook (IL); Hybrid; USD 122,000 - 157,000; Full time

Job summary

Wi‑Tronix is seeking a Senior Database Engineer to ensure performance, reliability, security, and scalability of our enterprise data platforms during a migration to AWS Aurora PostgreSQL. This role emphasizes data modeling, query optimization, and advanced analytics, transitioning from routine DBA tasks to cloud data infrastructure and administration.

You will collaborate with DevOps, Product, Engineering, and IT to deliver scalable solutions, lead the MSSQL-to-PostgreSQL migration, and support

Qualifications

• 6+ years of database engineering experience or equivalent senior software development experience with deep SQL.
• Strong expertise with PostgreSQL, SQL Server (2016–2022), and relational database design.
• Proven success with performance tuning, indexing strategies, and T-SQL/PL-pgSQL optimization.
• Experience with AWS Aurora, AWS RDS, Redis, and virtualized environments.
• Experience with database migrations, ideally MSSQL to PostgreSQL.
• Familiarity with Python, .NET, C++, and third‑party SQL tooling.
• Excellent communication, teamwork, and organizational skills.
• Agile mindset; able to work iteratively and adapt quickly.
• Technology enthusiast who stays current with new tools and trends.

Responsibilities

• Optimize and secure data across MSSQL, PostgreSQL, Redis, time‑series, and managed database services (AWS Aurora, RDS)
• Troubleshoot performance issues and optimize queries, indexes, functions, and stored procedures
• Lead and support the migration from MSSQL to PostgreSQL, and contribute to broader modernization efforts
• Design efficient, scalable data models and partner with developers to define standards and best practices
• Manage and tune managed database services, including configuration, monitoring, and cost/performance optimization
• Build dashboards, reports, and data integrations, and help enable advanced analytics
• Contribute to data architecture decisions across products and internal systems
• Provide guidance on database best practices and emerging technologies
• Participate in on‑call rotation

Skills

PostgreSQL

SQL Server

T-SQL/PL-pgSQL

AWS Aurora

AWS RDS

Redis

Python

C++

.NET

Agile

Communication

Education

Bachelor's degree in Computer Science/Information Systems

Master's degree a plus

Tools

AWS Aurora

AWS RDS

Redis

SQL tooling

Job description

Wi‑Tronix is seeking a Senior Database Engineer to ensure performance, reliability, security, and scalability of our enterprise data platforms during a migration to AWS Aurora PostgreSQL. This role emphasizes data modeling, query optimization, and advanced analytics, transitioning from routine DBA tasks to cloud data infrastructure and administration.

You will collaborate with DevOps, Product, Engineering, and IT to deliver scalable solutions, lead the MSSQL-to-PostgreSQL migration, and support