Design, develop, and maintain backend applications and services using C++ and C# for the SEPTA CARD system.
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 SEPTA CARD 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.
Technical Skills & Qualifications:
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).
See details and apply
C++/C# Developer with DBA Skills - Hybrid