PRIMARY PURPOSE
Database Developer is responsible for design, development, support, and optimization of ETL solutions and applications using Microsoft SQL Server and Microsoft BI Technology solutions
Database Developer is responsible for design, development, support, and optimization of ETL solutions and applications using Microsoft SQL Server and Microsoft BI Technology solutions
DAILY GRIND
Writing relational and multidimensional database queries and contribute to the full development lifecycle of database, data integration, ETL, cube, and data warehousing solutions.
Writing relational and multidimensional database queries and contribute to the full development lifecycle of database, data integration, ETL, cube, and data warehousing solutions.
CAREER PROGRESSION
Your goal will be to develop high-quality scalable database solutions that are aligned with user needs and business goals and progress into more advanced roles that complement your strengths.
Your goal will be to develop high-quality scalable database solutions that are aligned with user needs and business goals and progress into more advanced roles that complement your strengths.
JOIN US TO EXPERIENCE
- A company which focuses on your career progression
- Exposure to artificial intelligence in research in multiple domains
- First-hand experience on the transformative impact of AI on business insights and market research
- Peek into the minds of leaders of Fortune 500 companies
- Experience work autonomy, ownership and trust
- Cross-functional opportunities in a transparent and collaborative work environment
YOU CAN EXPECT TO
- Design and create appropriate frameworks, functions, scripts, stored procedures and triggers to support application development
- Define database physical structures and functional capabilities, security, backup and recovery specifications
- Develop best practices for database design and development activities
- Assist with schema design, code review, SQL query tuning and unit testing
- Optimise database systems and recommend improvements for performance efficiency
- Ensure data quality and integrity in databases
- Perform data backup and archival on a regular basis
- Develop ways to enhance and carry out automation process more efficiently
- Develop security procedures to protect databases from unauthorised usage
- Provide database support – code utilities, evaluate, integrate and install new releases
- Provide guidance and support to Application Developers
- Prepare clear design specifications and functional documentation that are detailed and understandable
- Servicing and updating databases as required
- Occasionally collate, prepare and present statistical information for internal use.
HARD & SOFT SKILLS
- Bachelor’s degree in Computer Science (Information Technology/Systems) or a related information technology field is preferred
- Ideally 2-4 years of experience in database design, development and deployment
- Database certifications are strongly advantageous
- Experience with SQL Server, data warehousing/ETL and frontend/backend web services technologies
- Possess in-depth understanding of data management (permissions, recovery, security and monitoring)
- Able to easily design and implement a business process into functional and efficient code
- Must be proficient in PL/SQL, C++ or Java
- Is detailed oriented, has strong critical thinking and troubleshooting abilities
- Has great interpersonal and communication skills
- Time management and having the constant desire for improvement will be paramount
- Able to adapt and keep up in a fast-paced environment
- Team player, self-motivated and proactive
- Experience with Azure Data Factory is a plus
- Experience with data visualization tools (Tableau, Power BI, QlikView) is a plus.