Software Engineer - LAMP

Title: Software Engineer - LAMP

Location: San Francisco, CA - Hybrid

Duration: Full-Time

Description:

Excellent technical and in-depth knowledge of:

• LAMP stack (Linux, Apache, PHP and MySQL)
• Angular JS
• LAMP-oriented Frameworks and open-source libraries
• Git source control
• MySQL databases and reporting systems
• Strong acumen in database maintenance and management.
• Experience with data integration via API s (e.g. maintaining feeds from external systems and databases), integration with external commercial systems (accounting systems).
• Strong SQL skills in creating stored procedures, functions, views, SQL scripts,
• API technologies.
• Mandarin language proficiency is a plus, but not required.

Essential Job Responsibilities:

• Define strategic technical direction for applications, architectures, and development processes based on current best practices.
• Work with management and end users to determine system and reporting needs, create and maintain development roadmap, and prioritize development.
• Manage the design, development, and release of complex technical products through complete life cycle (ideation through deployment).
• Report status and progress to management on a regular basis.
• Develop software using current, best practice methodologies (e.g. Agile, Scrum).
• Develop and maintain systems to be utilized by both internal and external users.
• Collaborate with a team of department heads and other IT staff to create and enhance business solution requirements.
• Define coding, documentation and development standards in line with modern, best practices.
• Participate in hands-on development as needed.
• Incorporate current, secure coding practices into the development process.
• Establish and manage software support function, including support desk, defect reporting and resolution, off-hours support and follow up analysis.
• Work with managers and inter-departmental teams to design, develop, modify and generate reports using data stored in multiple proprietary and commercial applications - some of which store data in SQL databases.
• Provide support as required to ensure the availability and maintenance of existing, developed reports and dashboards for both external and internal users.
• Design and implement best practices and guidelines for report generation - canned and ad-hoc reports.
• Performance tuning of reporting queries for best performance.
• Develop and maintain system enhancements as needed.
• Prepare and deliver ad-hoc development requests in an accurate and timely fashion.
• Look for ways to improve the timeliness, usefulness and accuracy of systems.
• Follow Company policies and procedures.
• Perform other duties as assigned.