Senior Data Engineer - DevOps

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

At Wi‑Tronix, we\'re transforming rail safety, performance, and operations through real-time insights and intelligent digital products. We\'re seeking a Senior Database Engineer to ensure the performance, reliability, security, and scalability of our enterprise data platforms.

As we migrate to AWS Aurora PostgreSQL, much of the traditional database administration burden (patching, backups, failover, scaling) shifts to the managed service, so this role focuses less on routine DBA operations and more on data modeling, query and performance optimization, and enabling advanced analytics.

This makes it a strong fit for an experienced database professional, or a senior software developer with deep SQL and performance‑tuning expertise who wants to expand into cloud data infrastructure and administration. You\'ll support product development, lead key initiatives such as our MSSQL-to-PostgreSQL migration, modernize our cloud data infrastructure, and help enable advanced analytics. Working closely with DevOps, Product, Engineering, and IT teams, you\'ll play a key role in delivering scalable, high-quality solutions that power the future of rail technology.

Core Functions

• 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

Position Qualifications

• Bachelor\'s degree in Computer Science, Information Systems, or a related field (Master\'s a plus)
• 6+ years of database engineering experience, or equivalent senior software development experience with deep SQL expertise
• 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

Work Environment

• Hybrid schedule: Tuesday–Thursday in our Bolingbrook, IL office
• Must be able to board a locomotive for field research
• Domestic and international travel may be required

READY TO HELP SCALE THE COMMERCIAL ENGINE BEHIND A GROWING TECHNOLOGY COMPANY?

If you enjoy bringing order to complexity, improving processes, and helping cross‑functional teams work more effectively together, we\'d like to meet you. Bring your curiosity, attention to detail, and passion for continuous improvement. We\'ll provide the mission, the technology, and the opportunity to make a visible impact.

Equal Opportunity Employer

Applicants must be legally authorized to work in the United States.

This position does not offer employer‑based visa sponsorship now or in the future.

This position\'s anticipated base salary range is $122,000 to $157,000.

Final compensation will be based on experience, qualifications, and location.

Wi‑Tronix is proud to be an Equal Opportunity, Aff…​?

All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, physical or mental disability, age, or veteran status or any other basis protected by federal, state, or local law.

If you need reasonable accommodation for any part of the application process due to disability, please inform us at michele.hughes@wi‑tronix.com so that we can discuss the appropriate alternatives available.

Wi‑Tronix does not review unsolicited resumes from recruiters or search firms.