IT Specialist x2

Responsibilities:

• Architect and implement scalable enterprise applications utilizing PowerBuilder, PL/SQL, and T-SQL.
• Revitalize legacy platforms by integrating performance optimizations and current development practices.
• Partner with front-end and UX teams to ensure seamless interface enhancements align with user expectations and business goals.
• Spearhead planning and feasibility studies for upgrading aging application ecosystems.
• Execute version upgrades, ensuring legacy applications align with newer releases of PowerBuilder and SQL Server.
• Restructure outdated PowerBuilder code into modular and maintainable components aligned with best practices.
• Collaborate with stakeholders to capture and refine technical and business requirements.
• Translate business logic into clear and actionable technical documents such as Functional and Technical Design Specifications (FRDs & TSDs).
• Develop prototypes and UI mockups to confirm functionality alignment with business needs.
• Design and execute robust unit tests and collaborate in broader system and integration testing cycles.
• Support QA teams during regression testing and pre-deployment validation phases.
• Manage deployment processes across UAT and production, ensuring successful releases with minimal disruption.
• Investigate and resolve production-level incidents within agreed SLAs, delivering high system reliability.
• Perform in-depth RCA (Root Cause Analysis) to identify underlying issues and implement long-term solutions.
• Leverage logs and performance monitoring tools to track system health and preempt potential issues.
• Actively participate in Agile practices, including daily stand-ups, sprint planning, reviews, and retrospectives.
• Break development tasks into well-defined story points and maintain status updates in JIRA.
• Coordinate effectively with testing, database, and project management teams for smooth delivery.
• Maintain detailed and up-to-date technical documentation covering code structure, APIs, and process flows.
• Conduct peer reviews, walkthroughs, and handover sessions to promote knowledge sharing and alignment.
• Draft release notes, SOPs, and deployment manuals for seamless support transitions.
• Guide and mentor junior developers in PowerBuilder best practices, debugging, and legacy system comprehension.
• Provide code review feedback and ensure adherence to coding standards and guidelines.
• Serve as the main technical interface for external stakeholders and distributed/offshore development teams.

Requirements:

• Proficient in multiple versions of PowerBuilder (6.5, 8.0, 12.5, R3 2017) with demonstrated success in production environments.
• Advanced expertise in SQL, PL/SQL, and T-SQL development and optimization.
• In-depth experience working with Oracle (11g) and SQL Server (2000 to 2008) ncluding compatibility migrations.
• Proficient with database tools such as TOAD, Oracle SQL Developer, and SSMS.
• Skilled in using PowerBuilder IDE, version control systems, and deployment frameworks.
• Strong background in legacy system modernization, including hands-on migration of PowerBuilder apps to R3 2017.
• Experience migrating and optimizing databases during compatibility level transitions (e.g., level 65 to 80/100).
• Proven ability to lead complete migration projects: assessment, reverse engineering, transformation, and performance tuning.
• Familiar with Agile delivery methods, including daily stand-ups, retrospectives, and Kanban-based progress tracking via JIRA.
• Working knowledge of ITSM platforms such as Remedy for handling incidents, problems, and change requests.