SQL Developer for Puresoftware, Malaysia

 PureSoftware is one of the fastest growing software products and services companies that delivers a differentiated customer experience, accelerates cycle times and helps customers achieve business outcomes through the adoption of new-age digital technologies and integrating them with their existing systems.

We deliver digital excellence driven by next-gen solutions and strong partnerships globally

PureSoftware is proud to partner with leading global organizations that share our passion for innovation and building a resilient, technologically-enabled world. We work together with business leaders to build incredible things powered by the latest technology

Roles and Responsibilities

• 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

Desired Candidate Profile

• 4 to 5 years
• Strong proficiency with SQL and its variation among popular databases
• 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

Email: jadhav.shweta@puresoftware.com