What are the responsibilities and job description for the SQL Database Developer - Contract position at Global IT Resources, Inc.?
Description
The IT Web Design and Development team is seeking a SQL Database Developer 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 maintained.
Typical Duties:
· 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. (completed by Client)
· 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.
Job Types: Full-time, Contract
Pay: $35.00 - $45.00 per hour
Expected hours: 40 per week
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Compensation Package:
- Hourly pay
Schedule:
- 8 hour shift
Education:
- Bachelor's (Required)
Experience:
- analysis, design, and programming of database objects: 4 years (Required)
- T-SQL: 4 years (Required)
- Data warehouse/SAP/Sybase: 4 years (Preferred)
Experience:
- analysis, design, and programming of database objects: 4 years (Required)
- T-SQL: 4 years (Required)
- Data warehouse/SAP/Sybase: 4 years (Preferred)
Experience:
- analysis, design, and programming of database objects: 4 years (Required)
- T-SQL: 4 years (Required)
- Data warehouse/SAP/Sybase: 4 years (Preferred)
Ability to Commute:
- Mechanicsburg, PA 17055 (Required)
Ability to Relocate:
- Mechanicsburg, PA 17055: Relocate before starting work (Required)
Work Location: In person
Salary : $35 - $45