What are the responsibilities and job description for the Programmer position at ITS Traffic Systems, Inc?
**Overview:**
We are seeking a versatile and skilled professional to join our team in a hybrid role encompassing development, SQL expertise, hardware management, and IT support. This position is crucial for maintaining and enhancing our technological infrastructure and ensuring smooth operations across various domains.
**Key Responsibilities:**
- Design, develop, and maintain software applications and solutions.
- Collaborate with cross-functional teams to define requirements and implement new features.
- Troubleshoot and debug applications to ensure optimal performance and usability.
- Stay updated with industry trends and technologies to recommend improvements.
- Design, optimize, and maintain complex SQL databases and queries.
- Develop efficient data models and schema designs.
- Perform data analysis and generate insightful reports for customers.
- Ensure data integrity, security, and compliance with best practices.
- Manage hardware assets including servers, workstations, and networking equipment.
- Install, configure, and maintain hardware components and peripherals.
- Troubleshoot hardware issues and coordinate repairs or replacements as needed.
- Implement and enforce IT policies regarding hardware usage and maintenance.
- Provide technical support and troubleshooting for software and hardware issues.
- Respond to IT helpdesk tickets and escalate issues as necessary.
- Maintain documentation related to IT systems, procedures, and configurations.
- Assist in IT infrastructure planning and implementation projects.
**Skills and Qualifications:**
- Bachelor’s degree in Computer Science, Information Technology, or a related field preferred.
- Proven experience in software development using languages such as VB, VB.net, C#, etc.
- Expertise in SQL programming, database design, and optimization (SQL Server, Oracle, MySQL, etc.).
- Strong understanding of hardware components, networking protocols, and system administration.
- Hands-on experience with IT support, including troubleshooting software and hardware issues.
- Excellent problem-solving skills and ability to work effectively in a team environment.
- Strong communication skills and ability to interact with stakeholders at all levels.
**Preferred Qualifications:**
- Certifications in relevant technologies (e.g., Microsoft Certified Professional, CompTIA A ).
- Experience with cloud platforms (AWS, Azure, Google Cloud).
- Familiarity with agile development methodologies.
**Benefits:**
- Competitive salary commensurate with experience.
- Comprehensive benefits package including health insurance and retirement plans.
- Opportunities for professional development and growth within the company.
- Flexible work schedule and hybrid work environment.
Job Type: Full-time
Pay: $60,000.00 - $75,000.00 per year
Salary : $60,000 - $75,000