Create Oracle PL/SQL packages, complex stored procedures, partitioned tables, ad-hoc queries to support development and business needs.
Assist senior database engineers with the day-to-day activities, including databases maintenance such as installation, backup, restore and security control.
Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries.
Troubleshoot production support issues in the application environments.
Support diverse enterprise applications spanning many technology platforms and serving all business units.
Participate in future state data warehouse development and associated conversions of data from acquired facilities.
Responsible for operational stability and tuning / management of developed applications and tools.
Estimate projects and enhancements to existing or new interfaces as part of project portfolio initiation process.
Mentor other developers as required and act as an SME where required.
Support company resources with functional support and modification / enhancement requests.
Respond to service requests in line with established SLAs and turnaround times.
Monitor and recommend upgrades and enhancements to applications and infrastructure components of supported applications.
On-call support for critical applications.
Requirements:
Bachelor's Degree in Computer/Data Science or equivalent
7+ Years of relevant experience designing and developing interactive data driven applications.
Proven track record of developing well-architected solutions that meet or exceed customer expectations.
Experience with all phases of the software development lifecycle (requirements gathering, design, development, testing, deployment, support)
Ability to document concise design, development, and testing processes for assigned projects
Interpreting and implementing business requirements for ETL development
Team player with a can-do approach to solving complex technical problems
Ability to consult with business leaders directly through development of positive working relationships.
High degree of critical thinking along with the ability to be an innovative problem solver who works independently in a fast-paced environment.
Proven track record of developing solutions that meet or exceed customer expectations.
Must have excellent communication skills with ability to deliver timely and responsive service to internal clients.