SQL Developer

US Citizens or Permanent Residents only (NO Vendors) Location: Mechanicsburg, PAHybrid, Role: The candidate must work on-site for six weeks before being eligible for 2 remote days per week.Contract Length: Long-term contract (6 months Right to Hire)Position Overview:The SQL Database Developer is responsible for the proper and efficient business use of the organization's data stores, maximizing the productivity of the data's end users. Responsibilities include the planning, design, development, and testing of software products for the UJS portal and other web-based applications, while also ensuring data integrity is maintainedRequired SkillBS Degree and at least 4 years of IT experience with analysis, design, and programming of database objects in overall application supportExtensive experience in client-server application development using T-SQL for coding stored procedures and database scripts with a good understanding of relational database conceptsAdvanced working knowledge of SAP (formerly Sybase) Adaptive Server EnterpriseDuties:Design, develop, and maintain database code objects, including stored procedures and views, in Sybase Adaptive Server Enterprise and SQL Server environmentsCollaborate with full-stack developers to design, develop, and maintain database code objects, ensuring adherence to database standards and best practiceCreate and maintain database code scripts to validate or manage data external to the applicationManage and conduct detailed testing of database objects and scripts; perform code reviewWrite and maintain clear specifications and documentation for database objects and scriptContribute to the design and enhancement of data models for application modificationIdentify and resolve SQL code performance issues; optimize SQL code for improved efficiencyParticipate in designing data models for new applications and improving existing oneCollaborate with established development teams to code SQL-stored procedures and scriptOccasionally support critical systems outside of regular working hours, as neededCommunicate regularly with the team lead regarding tasks, system issues, and project statussMaintain and expand knowledge of general database design principles and application capabilities

Created: 2025-02-21