Current position is under ALMT IT FO team scope to contribute in individual capacity as an Database Developer.
Responsibilities
Direct Responsibilities
Design and develop database procedural programming solutions when the solutions demand,
Included Application designing / development / testing / support / enhancements / bug-fixing.
Should be able to write queries using complex joins, filter criteria, type cast when required
Should be able to write procedural constructs like procedure, functions, triggers.
Design and develop SQL queries for the interfacing solutions required
Write Database code using the best practices whenever possible and help in tuning and refactoring legacy database code
Should be able to debug issues in SQL queries or any of the database constructs
Should carry out detailed unit testing based on the scenarios provided
Should be comfortable to work using Database development tools
Should create technical documentation such as the entity relationship diagrams, unit-testing documentation and technical design specifications for the deliverables
Prepare test plans and conduct Unit, Integration, Regression, Performance and Functional Testing
Interact with functional and technical representatives of project teams in order to understand business functionalities, technical modules, integration mechanism and data sources
Ensure that the project and organization standards followed during various phases of software development lifecycle and day-to-day development work
Estimate efforts and schedules for various modules and meet deadlines
Deployment of system components - Application, Shell Scripts and Databases
Acquire skills in relevant technologies and take up higher responsibilities
To ensure that application is of good quality, ensure any issues fixed on priority
Contributing Responsibilities
- Contribute towards innovation, suggest new technical practices to be investigated
- Contribute towards initiatives to improve processes and delivery
- Contribute towards recruitment efforts - both for the team as well as for the organization
Technical Behavioral Competencies
Mandatory Skills:
- Strong knowledge on Sybase ASE / Oracle PL-Sql / Sql Server-Tsql Database
- Strong in knowledge of writing complex SQL queries with multiple joins, Stored Procedures, Triggers, Views, Cursors, Indexes, Performance Tuning knowledge
- Basic Knowledge on Linux/Unix environment (basic commands, basics of shell scripting, etc.)
- Thorough understanding of complete Software Development Lifecycle
- Self-motivated, good interpersonal skills and inclination to constantly upgrade on new technologies and frameworks.
- Good communication and co-ordination activities.
Nice to have Skills:
- Good knowledge on Performance Tuning
- Knowledge of version control tools
- Exposure to financial domain
Specific Qualifications (if required)
Skills Referential
Behavioural Skills : (Please select up to 4 skills)
Client focused
Attention to detail / rigor
Ability to collaborate / Teamwork
Adaptability
Transversal Skills:
Analytical Ability
Ability to anticipate business / strategic evolution
Ability to understand, explain and support change
Ability to manage / facilitate a meeting, seminar, committee, training
Education Level:
Bachelor Degree or equivalent