Senior Software Engineer
Core
Lead application development for the HMS-AAD platform, building secure Oracle APEX web applications, APIs, and integrations while performing full software development lifecycle tasks.
Role type
Senior Software Engineer (Oracle APEX/Database)
Builds
Oracle APEX web applications, reports, APIs, web services, and integrations for the HMS-AAD platform
Domain
Higher Education Technology / Enterprise Software
Deliverable
production ML models | product features
Required skills
Oracle PL/SQL, Oracle APEX, Java, JavaScript, relational databases, web frameworks, test-driven development, performance tuning, dynamic SQL, architectural guidance
Preferred skills
Harvard IT Academy foundational courses, Agile and Lean development methodologies, higher education fundraising experience
Technologies
Oracle APEX, Oracle Database, Java, JavaScript
Responsibilities
Lead application development efforts and follow software development lifecycle best practices; Develop Oracle PL/SQL stored procedures, functions, packages, triggers, and supporting database objects; Build secure, user-focused Oracle APEX web applications, reports, APIs, web services, and integrations; Apply performance tuning, dynamic SQL, ref cursors, bulk collection, explain plans, and materialized views; Troubleshoot critical production issues and provide timely resolution; Provide architectural guidance on software development practices, user interface frameworks, server-side development, integrations, and messaging solutions; Evaluate the Oracle APEX roadmap and emerging technologies for potential use by the HMS-AAD platform; Collaborate with consultants, vendors, and internal technology partners on code reviews, security reviews, integrations, and best practices; Serve as a technical liaison, mentor junior staff, and research new technologies and software products
Seniority
Senior, hands-on IC with mentorship responsibilities