Database Developer

Duties and Responsibilities:

• Design logical and physical data models along with collaring, preparing and presenting statistical information for both internal and external use.
• Ensure database optimization, integrity, consistency, security and privacy.
• Providing support, guidance and collaborating with Application Developers to implement database design, and review developer’s work to ensure correct implementation & provide 3rd level support.
• Create scripts to build new database objects.
• Develop stored procedures, functions, packages, triggers and views using T-SQL.
• Assist with schema design, code review and SQL query tuning.
• Participate in SQL code reviews, write and deploy SQL patches, and gain a deeper understanding of mirroring and SQL clustering.
• Continually evaluate software components and tools for software applications, making recommendations for system improvements as required.
• Upgrade and improve data and application schema, preparing design documents and functional specifications.
• Able to manage other RDBMS such as oracle, PostgreSQL etc.

Requirements and Qualifications

• 4+ years working as a database developer, database administrator or in a related role.
• Bachelor’s Degree in Engineering or Computer Science.
• 2 or more years of handling a database environment of more than 300GB, with strong data analysis and analytical skills.
• SQL server administration experience, including knowing the basics of running Microsoft SQL Server — users, permission, backups, recovery, monitoring, and more.
• Ability to create SQL reports.
• Database tuning experience, database integration design and implementation, and management of database projects.
• Ability to work with a team in an Agile environment—you can address bugs with QA, plan schemas with engineering, and respond quickly to other business needs.
• Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.
• ETL experience is a plus.
• Highly organized and self-motivated with the ability to prioritize projects, meet deadlines, and make room for emergencies, as needed.
• Knowledge in Azure cloud service
• Knowledge in visualization tool such as Power BI.
• Basic Knowledge in C# is an added advantage.

About Samsotech

Samsotech (www.samsotech-id.com) is a global IT solutions company primarily addressing the hospitality & security sectors. We have 9,630+ installations in 144+ countries globally and are increasing rapidly.

At Samsotech, you can expect:

· An environment where ideas are heard and innovation is encouraged

· Personal/professional growth and development opportunities

· Extensive benefits package with a paid holidays

· Executive level commitment to education, growth, and development

Job Type: Full-time

Pay: AED5,000.00 - AED7,000.00 per month

Education:

• Bachelor's (Preferred)

Experience:

• Database Developer: 2 years (Required)

Location:

• Dubai (Required)