Senior PL/SQL Developer

Connvertex Technologies•Durham, NC

15h

About The Position

Strategic Advisors Technology (SAT) is looking for a Principal Software Engineer who has strong understanding of database technologies and experience building enterprise cloud enabled distributed systems. We are looking for individuals who continually strive to advance engineering excellence and technology innovation. The Expertise We're Looking For Expertise writing Oracle SQL and PLSQL code, performing data analysis, data modelling, designing and implementation of data APIs and performance tuning. Expertise writing and maintaining batch jobs with technologies like ETL/Informatica and Autosys Understanding of fundamental design principles for building a scalable application Interest in writing clean, testable, readable, easily maintainable, and performant code. Knowledge in mid-tier technologies like Java, messaging technologies, web container and understanding how they interact with data. Comfortable working in an Agile software delivery environment, with exposure to continuous integration and continuous delivery tools. Ability to translate storyboards and use cases into applications that give Fidelity a strategic edge with critical thinking and strong problem-solving abilities. Understanding of CI / CD processes & tools and are passionate about delivering high quality software. Providing leadership guidance, mentorship to empower team members to their optimum performance levels and career potential.

Requirements

100% hands-on PL/SQL Developers.
Offer valuable solutions to day-to-day problems during the interview and showcase solid hands-on PL/SQL development.
Core Oracle PL/SQL Engineering.
Advanced SQL Analytics & Data Manipulation.
Database Performance Tuning.
Primary Oracle SQL/PLSQL developer.
Strong understanding of database technologies.
Experience building enterprise cloud enabled distributed systems.
Expertise writing Oracle SQL and PLSQL code.
Performing data analysis.
Data modelling.
Designing and implementation of data APIs.
Performance tuning.
Expertise writing and maintaining batch jobs with technologies like ETL/Informatica and Autosys.
Understanding of fundamental design principles for building a scalable application.
Interest in writing clean, testable, readable, easily maintainable, and performant code.
Knowledge in mid-tier technologies like Java, messaging technologies, web container and understanding how they interact with data.
Comfortable working in an Agile software delivery environment, with exposure to continuous integration and continuous delivery tools.
Ability to translate storyboards and use cases into applications that give Fidelity a strategic edge with critical thinking and strong problem-solving abilities.
Understanding of CI / CD processes & tools.
Passionate about delivering high quality software.

Responsibilities

Development of complex stored procedures, packages, database business logic, custom data types, and transactional data modeling.
Analytical and windowing functions, complex joins, aggregation pipelines, set operators, and subquery optimization.
Query optimization, reading execution plans, database diagnostics, PGA memory tuning, and partitioning strategies.
Writing and maintaining batch jobs with technologies like ETL/Informatica and Autosys.
Designing and implementation of data APIs.
Providing leadership guidance and mentorship to empower team members to their optimum performance levels and career potential.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume