02 Nov
Oracle SQL / PLSQL Developer
Vacancy expired!
job summary:
Job Description:- Responsible for developing and delivering complex software requirements to accomplish business goals.
- Ensures that software is developed to meet functional, non-functional, and compliance requirements.
- Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces.
- Familiar with development and testing practices of the client.
- Contributes to story refinement/defining requirements.
- Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
- Performs spike/proof of concept as necessary to mitigate risk or implement new ideas.
- Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements Utilizes multiple architectural components (across data, application, business) in design and development of client requirements.
- Assists team with resolving technical complexities involved in realizing story work.
- Contributes to existing test suites (integration, regression, performance);
- Analyzes test reports, identifies any test issues/errors; Triages the underlying cause.
- Documents and communicates required information for deployment, maintenance, support, and business functionality.
- Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.
- Work as a member of a software development team to create and maintain database tables, database relationships, application data, and database links, views, stored procedures.
- Assist end-users and developers in troubleshooting and resolving day-to-day database/data related issues
- Maintain existing databases and data processing pipelines
- Monitor database performance, identify bottlenecks, and implement the necessary changes in data model, schema, tables, data relations, indexes, views,
- Develop and optimize database queries, and assist team members in database related questions and issues
- Contribute to the development of ETL and reports
- Bachelors or master's degree in Computer Science/related field of study or comparable work experience
- 10 years' experience in software development, focusing on ETL or Data support
- 7+ years of direct database design and modeling, coding, and management
- 5 years of PL/SQL in Oracle 12+
- Database Concepts
- Database design knowledge and optimization experienced skills are a must
- Oracle concepts with hands on experience in Stored Procedures, Functions, Indexing, Query performance tuning etc.
- Problem solving skills and ability to think algorithmically
- Analytical and organizational skills
- Database concepts
- Contributes to story refinement/defining requirements.
- Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
- Performs spike/proof of concept as necessary to mitigate risk or implement new ideas.
- Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements Utilizes multiple architectural components (across data, application, business) in design and development of client requirements.
- Assists team with resolving technical complexities involved in realizing story work.
- Contributes to existing test suites (integration, regression, performance);
- Analyzes test reports, identifies any test issues/errors; Triages the underlying cause.
- Experience level: Experienced
- Minimum 5 years of experience
- Education: Bachelors
Vacancy expired!