No. of Resource:- 01
Availability:- Immediate
Location:- Dubai
Industry:- Finance
Email:- hr@staffconnect.ae
WhatsApp:- +971 529421270
Job Role
The DB Developer will be responsible for developing and maintaining PL/SQL-based database solutions to support the company’s software development efforts. The role is pivotal in ensuring the stability, scalability, and performance of the applications’ database layers. The developer will work closely with software developers, database administrator, and business analysts to optimize database queries, ensure data integrity, and support the back-end processes that drive software applications. This role ensures that the software development division can deliver high-quality, data-driven solutions that meet the evolving needs of the business.
Job Description
- Database Development: Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers to support application development.
- Query Optimization: Analyze and optimize existing SQL queries and PL/SQL code to ensure the best possible performance of applications.
- Data Integrity: Ensure data accuracy and consistency by writing and maintaining scripts that manage data migrations, transformations, and validations.
- Troubleshooting: Debug and troubleshoot issues related to database performance, including slow-running queries, locking problems, and application-specific database issues.
- Collaboration: Work closely with software developers, testers, and business analysts to integrate database components with front-end and middleware applications.
- Performance Tuning: Perform database tuning, indexing strategies, and provide recommendations for optimizing database performance.
- Documentation: Maintain clear documentation of code, processes, and database architecture for both current and future development.
- Compliance & Security: Adhere to company policies on data privacy, security, and compliance, ensuring all database developments meet these standards.
- Version Control: Utilize version control systems to manage changes and updates to database code.
- Support: Provide ongoing support for database-related issues, including bug fixes, enhancements, and performance monitoring.
- Innovation: Proactively suggest improvements in database procedures, and technologies to support the evolving needs of the software development division.
Key Performances Indicators
- Timeliness and quality of PL/SQL deliverables.
- Performance and stability of database operations.
- Successful collaboration with software developers and cross-functional teams.
- Accuracy and consistency of data within supported applications.
Skills, Knowledge & Behaviour
- Behavioural Competencies
- Effective Communications
- Strategic & Analytical thinking
- Team work
- Customer Focus
- Technical Competencies
- Experience with Oracle 12c/19c.
- Familiarity with Agile or Scrum development methodologies.
- Experience in developing database solutions for enterprise-level applications.
- Knowledge of other programming language .NET is a plus.
Qualification & Experiences
- Bachelor’s degree in computer science, engineering, or related field.
- 5 to 7 years of hands on experience
- Proven experience in PL/SQL development with strong knowledge of Oracle databases.
- Proficiency in writing complex SQL queries and optimizing database performance.
- Experience with database design, data modeling, and schema management.
- Strong problem-solving skills and the ability to work under pressure to meet deadlines.
- Knowledge of version control systems like Git.
- Excellent communication and teamwork skills.
Certifications
- OCA Oracle Developer