• Help write and optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders

• Strong proficiency with SQL and its variation among popular databases
• Database design and develop
• Data warehousing, data modelling and Microsoft BI tools (SSAS, SSRS, SSIS, MDX), delivering dimensional models and BI applications
• Expertise in at least T-SQL and SQL development using stored procedure, developing and supporting ETL processes using MS SQL Server Integrated Services (SSIS) and Azure Data Factory (Azure tools)
• Experience with SQL Server 2008, 2012, 2016 and ideally 2017.
• Skilled at optimizing large complicated SQL statements
• Knowledge of best practices when dealing with relational databases
• Capable of configuring popular database engines and orchestrating clusters as necessary
• Exposure to the Azure platform would be useful.
• Ability to plan resource requirements from high level specifications
• Capable of troubleshooting common database issues
• Familiar with tools that can aid with profiling server resource usage and optimizing it
• Proficient understanding of code versioning tools such as VS TFS

SCIKEY is one of the fastest growing startup company with headquarters in India and offices in Malaysia, USA, UK, Singapore, and Finland. With more than 200 customers across several countries, SCIKEY is fast becoming a well-recognized Market Network brand for talent and business solutions.

We have a work culture focused on innovation and creating lasting value for our clients and employees. The learning opportunities within our organization help you acquire new skills or deepen existing expertise.

We have a diverse, inclusive, meritocratic culture, and our flat, non-hierarchical structure enables you to work with senior partners and directly with clients.

For this position SCIKEY offers benefits that rival the best companies around the world.

We can have following list of benefits:

• Health Insurance Benefit

Each employee and their families are insured for health that provides them with family hospitalization cover right from the day the employee joins team SCIKEY.

• Employee-friendly compensation structure

Our compensation structure ensures that you get maximum money in hand adhering to all the statutory compliances as required by regulations. 

• Paid Maternity / Paternity Leaves

SCIKEY is an equal opportunity employer. We believe that family is most important part of our life and we express that by not only giving fully paid maternity leave as per the regulations but also paternity leave to new fathers of our family. 

• Flexible Work Arrangements (Work from Home)

SCIKEY is highly flexible in giving work location options and also flexible working hours if your team is comfortable with it. You can work from home or any other remote location or work in our fully equipped state of the art office. You decide your flexibility based on your choice till the time your output is not getting affected. 

• Vacations

Work from home does not take away your vacation time. You have five days week and fixed days of vacation that one can utilize in any way. 

• Family-Friendly work culture

We are a team of family loving people. Paternity / maternity leave, and flexible working is added by the culture of a family friendly culture. We love to bring families to work by giving priorities to family members of our employees to fill any open job. We have several high performing and happy couples working for us as a testimony to our family commitment. We never forget to celebrate birthdays of our employees even if they work remotely and get over a video call to wish you along with as many team members as we can collect to wish you happy birthday.

• Free Wellness , health and financial planning programs 

Our HR works behind the scenes to help you plan your life better. We regularly hold health and financial planning sessions to benefit our employees and families.

• Power BI
• SQL
• SQL Server 2008
• SQL Server 2012
• SSAS
• SSIS
• SSRS
• VS Code
• Azure Data factory