Will handle database design and performance optimization to support backend systems for multiple transit agencies.
Design, develop, and maintain backend applications and services using C++ and C# for multiple transit agencies.
Collaborate with system architects and analysts to design robust database schemas and backend logic supporting transaction processing, card management, and reporting systems.
Perform database administration tasks including database design, optimization, tuning, maintenance, backup, and recovery for relational database systems (e.g., SQL Server, Oracle).
Optimize SQL queries, stored procedures, and indexing strategies to ensure high system performance and scalability.
Implement data integrity, security, and privacy controls in accordance with transit agencies operational and regulatory requirements.
Troubleshoot application, database, and integration issues, ensuring high availability and reliability of backend systems.
Work closely with QA teams to develop test plans and support integration, system, and performance testing.
Document system designs, database schemas, configuration settings, and operational procedures.
Bachelor’s Degree in Computer Science, Software Engineering, Information Systems, or related field.
3-5 years of professional experience in C++ and C# application development, preferably in transaction processing or card-based systems.
Solid experience with relational database management systems (RDBMS), particularly SQL Server.
Strong understanding of database design principles, normalization, indexing, partitioning, and query optimization.
Proficient in writing complex SQL queries, stored procedures, triggers, and database functions.
Experience with database performance tuning and troubleshooting tools (e.g., SQL Profiler).
Familiarity with database security concepts including encryption, auditing, access control, and compliance standards.
Health and Welfare Benefits: Our health and welfare benefits can be tailored to fit you and your family's needs and start on the first day of employment.
Retirement Savings: We will support you as you save for your future.
Employee Discounts: We offer you access to a vast selection of global, national, and local discounts on merchandise, services, travel, and more.
Career Growth Opportunities: We help you thrive, so together, we can grow. We provide opportunities to advance your career with a vast portfolio of businesses and a global footprint.
Paid time off: We provide attractive paid time off packages designed for you to enjoy your life away from work.