• 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.
• Document system designs, database schemas, configuration settings, and operational procedures.
  
  

Technical Skills & Qualifications:

• 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.