SQL, Pl/SQL,advance Pl/SQL - Pune, India - Zensar Technologies

Zensar Technologies

Verified Company

Pune, India

2 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

SQL, PL/SQL,ADVANCE PL/SQL

-

(

0095732

)

Description
Reporting Lines

Reports to:
Delivery Lead

Works closely with:
Product Owner and other Engineering team members

Direct reports:
Not applicable

Overview

The Senior Developer that we require should have a core strength in Oracle RDS to be able to support the existing Oracle dbase.

The Senior Developer also focuses on the translation of designs, User Stories and non-functional requirements into maintainable and performant software solutions.

The Senior Developer is also responsible for providing technical guidance to other members of the team, ensuring technical procedures are followed, correct tools are used and code is of high quality and fit for purpose.

The Senior Developer is responsible for:

Developing highquality code with good test coverage
Actively participating in estimation and technical design discussions
Reviewing the code produced by others
Providing supports to business operations.
Keeping abreast of software technology change
High Oracle SkillsKey Areas of Responsibility

The following are general areas of responsibility for the Senior Software Engineer. From time to time these will vary and additional responsibilities added.

General Responsibility

The Senior Software Engineer will:

Build and maintain positive ongoing cooperative relationships with internal stakeholders
Undertake professional development and research to maintain currency in Software Development
Demonstrate a commitment to teamwork and the maintenance of a collaborative and supportive work environment
Undertake the duties normally associated with your roleSystem Knowledge
The Senior Software Engineer will:
Develop and maintain a comprehensive understanding of the system
Communicate and support operation and engineering team members on the underlying system
Have a deep knowledge of at least Oracle 19C
Have a high level of understanding in Oracle statement tuning
Have a high level of understanding of Oracle objects / items such as
Tables
Indexes and all types
Normal views & Materialized views
Sequences
Packages
Triggers
Pipeline functions
Synonyms
DDL and DML
Have a high level of knowledge in plsql
Arrays
Functions
Procedures
Pragmas
Bulk processing
cursors
Have moderate knowledge of
Scripting languages eg perl, python
Have a sound understanding of working with Oracle in an AWS environmentReporting
The Senior Software Engineer will provide timely feedback of issues to the Delivery Lead and Technical Lead as appropriate.

Engineering

The Senior Software Engineer will:

Ensure appropriate unit testing is applied to new or changed code with coverage of 70%+ attained and maintained
Ensure that stories/defects are created soundly
Monitor scheduled jobs and notifications
Produce relative complexity estimates for User Stories in collaboration with their team
Review the merge requests of other team members for bugs or code quality improvement opportunities
Ensure that technical documentation is written and kept up to date
Ensure that accessibility is considered for any product change
Ensure that performance testing and tuning occurs as required
Provide support, troubleshooting and incident resolution
Assist QA/PO as required for acceptance tests
Identify and suggest processes and procedures that promote better and faster results
Identify and suggest new tools and technologies that improve results for end users, developer happiness and productivity
Take steps to improve the maintainability of the product codebase Specific Expertise
Qualifications:
Tertiary degree qualification in IT or Computer ScienceExperience
At least 3 year commercial experience in the role of Senior Software Engineer, with prior experience as a software engineerTechnical Expertise
Oracle DBASE advantageous
Scripting Language eg perl, python advantageous advantageous
Github or similar
JavaScript advantageous
Good Linux command line skills
Amazon Web Services (EC2, S3, CloudFront, RDS, Route53) advantageous
Kubernetes and Docker advantageous
Test Driven Development
Design Patterns
Domain Driven Design
Web and API security (OWASP)
Primary Location: India-MaharashtraPune