Okay, I've searched for Senior Programmer/Analyst roles in New York with a focus on PL/SQL development and web applications. You have 5+ years of experience, and you're looking for full-time positions with a minimum salary of $100,000. I found 157 positions that match your criteria.

Sure. Here's the analysis:

Job Analysis:

The role of Senior Programmer/Analyst at the Fashion Institute of Technology (FIT) primarily revolves around the development and support of custom web applications and PL/SQL systems. This individual is expected to not only deliver high-quality, tested code but also to provide technical leadership and operational support for 3rd party applications, ensuring high uptime and excellent service delivery. Key responsibilities include managing the software development lifecycle (SDLC), resolving system conflicts, and mentoring other team members. Ideal candidates should possess a robust analytical mindset, demonstrating proficiency in managing complex systems in a high-paced environment, particularly within higher education contexts that often feature tight deadlines and the need for quick troubleshooting. For success in this role, candidates will need to blend technical prowess with effective communication and critical thinking skills to align their work with stakeholder needs and operational requirements. Performance expectations should focus on not only code quality and system performance but also customer satisfaction and efficiency in handling service requests, particularly in emergency situations.

Company Analysis:

The Fashion Institute of Technology (FIT) operates within the education sector, specifically focusing on art, design, business, and technology. As part of the State University of New York system, FIT is positioned as a respected institution known for its innovative approach to higher education. This role's environment is likely fast-paced and collaborative, reflecting the urgency and dynamic nature of educational institutions that support a wide array of academic programs. Culture at FIT probably emphasizes creativity, teamwork, and continuous improvement, where the values of diversity and inclusion are prioritized, enhancing the richness of the student and faculty experience. The Senior Programmer/Analyst role sits within the Development, Systems & Support Unit, representing a critical function that interacts heavily with other departments to ensure operational efficiency. Given FIT's commitment to modernization and best practices, this position is strategically aligned to support digital transformation efforts, system improvements, and enhancing user experiences, reflecting the institution's broader educational mission.

Absolutely. Here are some mock interview questions that could come up:

• Tell me about a time when you had to rapidly troubleshoot a critical system failure. What steps did you take to resolve the issue and communicate with stakeholders?
• Describe an experience where you had to collaborate with non-technical stakeholders to understand their needs for a software system. How did you ensure their requirements were properly addressed?
• Can you give an example of how you have contributed to a project during tight deadlines? What strategies did you use to manage your time and workload?
• How would you approach debugging a complex PL/SQL stored procedure that is experiencing performance issues?
• Describe your experience with SDLC processes. How do you ensure all phases are effectively managed?
• What tools and techniques do you prefer for writing APIs and ensuring their performance and security?
• Imagine you're asked to improve the performance of a slow web application. What steps would you take to diagnose the issue and implement improvements?
• Why are you interested in working at the Fashion Institute of Technology specifically, and how do you feel you can contribute to its mission?
• What do you believe are the most important qualities and skills for someone in the Senior Programmer/Analyst role at FIT?
• How do you stay updated on the latest trends and technologies in software development, particularly within the higher education sector?
• What do you perceive are the challenges associated with maintaining and supporting enterprise systems in an academic environment?
• If you were asked to mentor a junior developer on your team, how would you approach this responsibility?
• What improvements or innovations have you implemented in your previous IT support roles that have significantly impacted your team's productivity or efficiency?