Associate Senior Associate PL SQL Developer Wealth Management Technology
Posted Updated 5
views
Summary
Database developer on DBS Bank's Wealth Management Technology team in Hyderabad: designs, develops, and maintains Oracle PL/SQL objects (packages, procedures, triggers, views), tunes high-volume SQL queries, troubleshoots production data issues, and handles code reviews and documentation. Core stack: Oracle Database, PL/SQL, Unix/Linux, Git/SVN.
You will design, develop, test, and maintain Oracle PL/SQL database objects. You will optimize SQL queries and database performance, turn business requirements into database solutions, resolve production data issues, participate in code reviews, and prepare technical documentation and knowledge-transfer materials.
Responsibilities
- Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
- Develop and optimize complex SQL queries for high-volume transactional systems.
- Translate business requirements into technical database solutions.
- Tune database performance and optimize queries.
- Create and maintain database objects according to coding standards.
- Troubleshoot production data issues and implement fixes.
- Collaborate with analysts, developers, QA teams, and stakeholders.
- Participate in code reviews and ensure high-quality deliverables.
- Prepare technical documentation and support knowledge transfer.
Requirements
- 3–7 years of Oracle PL/SQL development experience.
- Oracle database development experience in production environments.
- Debugging and troubleshooting capability.
- Oracle Database and PL/SQL development expertise.
- Knowledge of stored procedures, functions, packages, triggers, views, indexes, sequences, and cursors.
- Expertise in complex SQL queries and query tuning.
- Experience with Explain Plans and indexing strategies.
- Knowledge of normalization and relational database design.
- Experience handling large datasets and bulk processing.
- Knowledge of Unix/Linux commands and shell scripting.
- Experience with Git, SVN, or similar version-control tools.