SQL Developer

SQL Developer

OxyData Software Sdn Bhd
Kuala Lumpur
4-12 years
Not Specified

Job Description

JOB DESCRIPTIONS
• 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
REQUIREMENTS
• 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

Oxydata Software Sdn Bhd is a local Malaysian MSC status company established since 2006. Our core competencies are in digital software solutions, analytics, software development services and IT managed services. We help our clients to realize their results by increasing revenue, improve customer service and lowering the cost of IT projects through our innovative IT services and software solutions.

As part of the expansion plan, we invite talented and experienced professionals to be part of our dynamic team. If you got the fire, passion and a burning desire for success then write to us.

Please email your CV to suganiya@oxydata.my

Similar Jobs

Career Advice to Find Better