Unclassified - Dallas, TX
posted about 2 months ago
ViaPlus is a global mobility company specializing in Intelligent Transportation Systems (ITS) and is seeking a skilled Software Developer, Database to join our team in Carrollton, TX. The ideal candidate will have a strong background in designing, developing, and maintaining database systems, with a focus on writing efficient SQL queries and stored procedures. This role is crucial for ensuring the performance, security, and reliability of our databases, and the successful candidate will collaborate with other team members to develop data solutions that align with business objectives. In this position, you will be responsible for developing logical and physical data models that accurately represent the relationships between various data entities, ensuring data integrity and consistency. You will design and implement database structures, including tables, indexes, views, triggers, functions, and stored procedures, based on application requirements and performance considerations. Your expertise in writing and optimizing SQL queries will be essential to improve database performance, minimize execution time, and reduce resource consumption. Additionally, you will provide database support and guidance, collaborating with Application Developers to implement database design, queries, and stored procedures. You will also participate in SQL code reviews, write and deploy SQL patches, and gain a deeper understanding of mirroring and SQL clustering. Continuous evaluation of software components and tools for software applications will be part of your responsibilities, along with making recommendations for system improvements as required. Familiarity with all phases of the Software Development Life Cycle (SDLC) is expected, and experience with cloud-based database services, particularly Azure SQL Database, is highly desirable. Reports development experience is a plus.