Shire Jobs

The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following standard coding practices and industry best practices. This role develops and maintains solutions for new requests for existing applications. The Developer resolves any issues dealing with performance for all code released to production. This position also assists with impact analyses of any changes made to the database objects. This role develops design documentation and maintains database versions of code with GIT. The position requires participation in the complete system development life cycle including post implementation support. The Developer provides technical expertise to management, business users, and works closely with other developers by writing optimized SQL queries for integration with different applications. Essential Functions Strategy & Planning Work with the business units to identify business requirements for requested projects. Identify the technical requirements of projects. Analyze all aspects of the projects. Provide feasibility and cost/benefit analyses responses for proposed projects. Plan and organize tasks, report on progress, coordinate with additional development teams. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Development & Deployment Perform complex programming assignments requiring an advanced aptitude of established programming standards, methods, and best practices. Design application and database components for development projects. Perform analysis of business models, logical specifications, and/or customer requirements to design and build Internet solutions utilizing multiple technologies. Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) and working familiarity with various databases. Mitigate significant risks associated with projects, which have a high technical complexity and/or involve significant challenges to the business. Guide full stack developer in design approaches and teach them to create performant queries Operational Management Maintain and modify Sher-link applications, make approved changes by amending application documentation, developing detailed programming logic, and coding changes. Provide support for these critical application problems and issues. Analyze existing SQL queries for performance improvements and implement the improvements. Act as a Subject Matter Expert in the discovery and investigation of critical production problems as required. Proactively search for and make improvements on non-performant database programs. Willingness and ability to coordinate the efforts of other developers. Incidental Functions Conduct research into modern technologies, including tools, components, and frameworks. Train and knowledge share with development teams. Mentor and coach developers and/or Professional Apprentices. Project and task management and reporting, as necessary. Make presentations to management, clients, and peer groups as requested. Schedule and lead project and communication meetings. Provide tier 2, on-call support for critical application problems and issues. Analyze program performance and correct deficiencies based on user consultation. Work with manager to prioritize approved list of remediations. Assist with projects required to contribute to efficiency and effectiveness of the work. Attend management meetings on behalf of team. Application server maintena