Database Architect

Requirements:

• Experience: 10+ Years
• In depth knowledge of modeling/architectural patterns and governance methodologies in SQL Server.
• Perform SQL Server database level maintenance, optimization, integrity checks, recovery, and handling failover of databases.
• Implement and monitor backups of SQL databases using both native functionalities, as well commercial packages.
• Database performance tuning including identifying bottlenecks with suitable workarounds.
• Optimization of exiting database & business logic source code.
• Implement and perform database encryption algorithms.
• Automate and perform database restores/system refreshes of non-Production environments using Production data.
• Recommend and implement best practices for Rest API integration framework/model.
• Understand and translate business requirements into technical specifications and build elegant, efficient, and scalable solutions based on specifications.
• Experience working with industry standards, regulations and guidelines in database warehousing and other relevant systems.
• Experienced in databases like SQL Server, Oracle, MongoDB.

Primary Skills:  

• SQL Server DB Data modelling
• Database programming (Stored Proc , Functions , triggers , etc)
• SSIS, Azure Function, Azure Data Factory
• Exposer in Graph Database

 Qualification:

• Any Graduate