• Design, develop, and maintain database code objects, including stored procedures and views, in Sybase Adaptive Server Enterprise and SQL Server environments.
• Collaborate with full-stack developers to design, develop, and maintain database code objects, ensuring adherence to database standards and best practices.
• Create and maintain database code scripts to validate or manage data external to the application.
• Manage and conduct detailed testing of database objects and scripts; perform code reviews.
• Write and maintain clear specifications and documentation for database objects and scripts.
• Contribute to the design and enhancement of data models for application modifications.
• Identify and resolve SQL code performance issues; optimize SQL code for improved efficiency.
• Participate in designing data models for new applications and improving existing ones.
• Collaborate with established development teams to code SQL-stored procedures and scripts.
• Occasionally support critical systems outside of regular working hours, as needed.
• Communicate regularly with the team lead regarding tasks, system issues, and project statuses.
• Maintain and expand knowledge of general database design principles and application capabilities.
Additional Requirements
• Satisfactory criminal background check required
• Bachelor’s degree with IT major and at least 4 years of IT experience with analysis, design, and programming of database objects in overall application support.
• Extensive experience in client-server application development using T-SQL for coding stored procedures and database scripts with a good understanding of relational database concepts.
• Advanced working knowledge of SAP (formerly Sybase) Adaptive Server Enterprise
Bachelor's degree