Job Description
SUMMARY
Guided by the unit manager, the Database Reporting Development Lead will lead a team of Database Reporting Developers, providing them with guidance and support to ensure the seamless delivery of reporting solutions. Responsibilities also include conducting comprehensive code reviews for database developments, tuning database code for optimal performance on both Oracle and MSSQL platforms, and preparing documentation and guidelines for databases and processes.
The responsibilities also encompass active engagement in crucial elements of the report development processes, such as database design, physical data modeling, process flow analysis, benchmark analysis, performance tuning, and capacity planning. In addition, the role requires providing technical support to the Application Administrator, aiding in the maintenance of test and production environments for the reporting system.
Responsibilities :
ESSENTIAL DUTIES include the following. Other duties may be assigned.
• Implement robust database code optimization strategies for both Oracle and MSSQL platforms to enhance performance, scalability, and efficiency.
• Perform thorough code reviews for database code developed by Database Reporting Developers, ensuring adherence to the accepted coding standards, best practices, and overall code quality.
• Act as a primary point of contact for resolving complex technical issues related to database reporting, collaborating with the team to implement effective solutions promptly.
• Provide guidance, mentorship, and training to Database Reporting Developers, fostering professional growth and ensuring the team is equipped with the necessary skills to excel in their roles.
• Prepare and maintain detailed documentation and guidelines for development processes, establishing a standardized framework for the team to follow.
• Develop and maintain a comprehensive Data Dictionary documentation, providing a centralized and clear reference for data definitions, relationships, and structures within the databases.
• Identify opportunities for process enhancements and actively contribute to the continuous improvement of database reporting development methodologies.
• Implement and enforce data security measures and compliance standards in collaboration with relevant stakeholders, safeguarding sensitive information within the reporting environment.
• Keep up-to-date with the latest developments in database technologies, reporting tools, and industry best practices, incorporating relevant advancements into the team's workflow.
• Other duties and special projects as assigned.
SUPERVISORY RESPONSIBILITY
• Manage the daily work of database developers and ensure the quality of their service.
• Assess qualification levels of the team members and provide their pre-evaluations and evaluations on regular basis.
• Guide and monitor a professional development of the team members.
COMPETENCIES
• Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality.
• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
• Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed.
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
• Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals. Completes tasks on time or notifies appropriate person with an alternate plan.
• Safety and Security - Observes safety and security procedures; Determines appropriate action beyond guidelines; Reports potentially unsafe conditions; Uses equipment and materials properly.
Requirements :
QUALIFICATIONS
• Expertise in Oracle and MSSQL database development and tuning, leveraging in-depth knowledge to drive efficient and optimized database solutions.
• Demonstrate mastery in database query optimization, employing efficient techniques to enhance the retrieval and processing of data for improved system responsiveness.
• Proficient in conducting thorough code reviews, providing constructive and professional feedback to team members, thereby fostering a collaborative and growth-oriented development environment.
• Proven ability to troubleshoot and resolve complex database-related issues using analytical thinking and strategic optimization methodologies to ensure timely and effective solutions.
• Experience in preparing detailed documentation, including development guidelines, process documentation, diagrams, and data dictionary documentation.
• Experience in providing mentorship and training to team members.
• Basic knowledge of accounting, banking, and microfinance.
• Good organisational skills with ability to prioritise and meet deadlines under pressure.
• Strong verbal and written communication skills.
• Attention to details and analytical thinker.
Education & Experience
• Degree in Information Technology or Computer Sciences is advantageous.
• More than five years of hands-on experience in Oracle and MSSQL database development and optimization
• Any certificate in the field of SQL, T-SQL, and PL/SQL programming is a plus.
• Experience in managing and leading database development teams is a plus.
Language Skills
• Fluency in Azeri is required.
• Advanced technical writing and speaking in English is required.
• Speaking in Russian is preferred.
KEY DELIVERABLES
• Perform thorough code reviews for database scripts developed by Database Reporting Developers, ensuring adherence to the accepted coding standards, best practices, and overall code quality.
• Implement robust database code optimization strategies for both Oracle and MSSQL platforms to enhance performance, scalability, and efficiency.
• Provide guidance, mentorship, and training to Database Reporting Developers, fostering professional growth and ensuring the team is equipped with the necessary skills to excel in their roles.
• Prepare detailed documentation, including development guidelines, process documentation, diagrams, and data dictionary documentation.
KEY RELATIONSHIPS
• This position will work with all departments, including IT department.
TRAVEL REQUIREMENTS
• Although no regular travel required, some training related travels within and/or outside the country may be in place.