- Collaborate with cross-functional teams to gather and analyze business requirements, and translate them into effective database designs and solutions.
- Develop, maintain, and optimize complex T-SQL queries, stored procedures, and functions to ensure high-performance data retrieval and manipulation.
- Design and implement ETL processes using SSIS to integrate data from various sources into our SQL Server databases, ensuring accuracy and reliability.
- Create and manage SSRS reports and dashboards that provide actionable insights to stakeholders, utilizing your expertise in SSRS and data visualization best practices.
- Perform database tuning and optimization to enhance system performance, scalability, and reliability.
- Identify and address data-related issues, troubleshoot problems, and collaborate with the team to implement effective solutions.
- Ensure data security and compliance with best practices and regulations by implementing appropriate access controls and encryption mechanisms.
- Keep up-to-date with the latest industry trends, tools, and technologies related to MS SQL Server, SSIS, and SSRS.
- Minimum of 5 years of professional experience in MS SQL Server database development.
- Proficiency in designing and optimizing complex T-SQL queries, stored procedures, and functions.
- Strong experience with SSIS for designing and implementing ETL processes.
- Solid expertise in creating and managing reports using SSRS, including data visualization concepts.
- In-depth understanding of database performance tuning, indexing, and optimization techniques.
- Familiarity with database security best practices and data protection regulations.
- Excellent problem-solving skills and the ability to work effectively in a collaborative team environment.
- Strong communication skills to interact with technical and non-technical stakeholders.
- Relevant Microsoft certifications (e.g., MCSE: Data Management and Analytics) are a plus.
- Experience with other data-related technologies like Power BI or Azure SQL Database is advantageous.
-
Developer
2天前
JNL Consulting Limited Hong Kong, 香港 全职As a Developer, you will be responsible for the following:- · Build data pipeline based on business requirements · Communicate with business users on requirement details to contribute to business enhancement project · Write clean codes to optimize SQL · Assist in data processing ...
-
System Analyst
4天前
Aquis Search Hong Kong, 香港 全职PRINCIPLE DUTIES · Supporting in the day-to-day maintenance and configuration of applications with related customisations and integrations with associated business system. · Responsibility for dealing with escalated 2nd and 3rd line support calls from IT Service Desk. · - Assist ...
-
NLS Hong Kong, 香港 全职Responsibilities: · Create visually appealing and interactive dashboards and reports using Tableau, allowing stakeholders to gain valuable insights. · Collaborate closely with business teams to understand their requirements and transform them into actionable visualizations and re ...
-
Hong Kong Exchanges and Clearing Limited Hong Kong, 香港 全职Company Introduction: · We're home to Asia's most dynamic and vibrant capital markets. · Connecting capital, ideas, inspiration and innovation for deeper, more diverse and liquid global capital markets; providing greater choice and opportunity for our customers, each and every ...
-
Hong Kong Exchanges and Clearing Limited Hong Kong, 香港 全职Company Introduction: · We're home to Asia's most dynamic and vibrant capital markets. · Connecting capital, ideas, inspiration and innovation for deeper, more diverse and liquid global capital markets; providing greater choice and opportunity for our customers, each and every ...
-
Risk Data
1天前
The Bank of East Asia Hong Kong, 香港 全职Responsibilities · Assist in maintaining the risk data warehouse of the bank on user's perspective · Organize and execute BAU Change Request Life cycle of the risk data warehouse · Handle data assessment requests, production issues and ad hoc tasks raised from upstream systems an ...
-
Risk Data
2天前
The Bank of East Asia Hong Kong, 香港 全职Responsibilities · Maintain the risk data warehouse of the bank on user's perspective · Organize and execute BAU Change Request Life cycle of the risk data warehouse · Handle data assessment requests, production issues and ad hoc tasks raised from upstream systems and downstream ...
-
Systems Analyst
1周前
Hong Kong Exchanges and Clearing Limited Hong Kong, 香港 全职Company Introduction: · We're home to Asia's most dynamic and vibrant capital markets. · Connecting capital, ideas, inspiration and innovation for deeper, more diverse and liquid global capital markets; providing greater choice and opportunity for our customers, each and every ...
-
Systems Analyst
4天前
The Bank of East Asia Hong Kong, 香港 全职Responsibilities · Perform system analysis functions · Develop and maintain systems according to standard of the department · Conduct ad-hoc data analysis · Support Risk Data reporting and analysis · Prepare and update documentation for systems · Work with Operations staff to ens ...
-
Aptitude Asia Hong Kong, 香港 全职Job Responsibilities: · Design, develop, test, and maintain software applications to ensure that they are efficient, secure, and reliable · Write high-quality, maintainable, and efficient code that adheres to best practices and industry standards · Troubleshoot and debug software ...
-
System Analyst
1周前
TEKsystems Hong Kong Hong Kong, 香港 全职Responsibilities: Solicit user requirements & analysis · Participate in application design, development and implementation · Provide support and maintenance of applications · Enforce quality standards and procedures throughout the software development lifecycle (SDLC) · Prepare t ...
-
Captiare Limited Hong Kong, 香港 全职Assistant Vice President, Senior System Analyst (Information Technology Department - Application System Group) · Job Duties & Responsibilities: · Responsible for application development on banking process automation · Perform in full Software Development Life Cycle (SDLC) includi ...
-
System Analyst
1周前
ST Partnership Limited Hong Kong, 香港 全职Responsibilities: · Collaborate with cross-functional teams to design, develop, and implement finance and HR systems using .Net and Java technologies. · Participate in the entire software development lifecycle, including requirements gathering, analysis, design, coding, testing, ...
-
Eka Finance Hong Kong, 香港 全职Role:- · A key member of the development team, building and enhancing key components for the systematic desk. · A role with the potential to touch many aspects of electronic and algorithmic trading, backtesting, and data management systems · Working with traders and quants to rol ...
-
Morgan McKinley Hong Kong, 香港 全职A leading insurance firm is looking for a software engineer their dynamic team. Be a part of a hardworking group dedicated to achieving the best engineering results within financial services. · ResponsibilitiesDesign, develop, and maintain software applications using .NET and RP ...
-
Morgan McKinley Hong Kong, 香港 全职A cutting edge fintech company is looking to hire backend developers with Java and Springboot experience to join their innovative and growing team · Responsibilities: Create secure backend services and APIs to facilitate the implementation of new features and enhancements. · Ana ...
-
Omni Group Asia Ltd. Hong Kong, 香港 全职Key Responsibilities: · Analyses user requirements and produce quality system design for multi-tiered .Net applications. · System development and maintenance for Microsoft C# .NET applications covering feasibility study, requirement collection, system design, programming, testing ...
-
System Analyst
4天前
China CITIC Bank International Limited Hong Kong, 香港 全职Responsibilities: · Develop and maintain application systems for Treasury · Perform business and data analysis · Collaborate with the team and vendor on technical design and technical solutions review · Create technical and functional specifications and documentation · Hands on ...
-
China CITIC Bank International Limited Hong Kong, 香港 全职Responsibilities · Ensure the system to work behind the scenes, integrating the application with all required systems and services · Provide clean and easy to use API for the frontend part of the system · Ensure development work follow department standard and guideline · Ensure t ...
-
Amethyst Partners Hong Kong, 香港 全职Key responsibilities · Oversee and manage the firm's IT system and drive the digitization of business applications · Collaborate with the management to design and implement IT projects so to improve the firm's IT system and business applications · Work with external IT partner to ...
MS SQL Developer - Hong Kong, 香港 - Unison Consulting Pte Ltd
描述
We are searching for an experienced Senior MS SQL Developer with a minimum of 5 years of hands-on experience in MS SQL Server database development, along with proficiency in SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services). As a Senior MS SQL Developer, you will be a key member of our development team, responsible for designing, implementing, and maintaining robust database solutions and ETL processes.
Requirements