SQL Specialist / Database Developer

About the Opportunity We are partnering with a leading global insurer to recruit an experienced SQL Specialist / Database Developer on an initial 12-month contract basis. Working closely with the IT leadership and applications engineering teams, you will play a critical role in developing, optimizing, and maintaining backend database architecture, complex stored procedures, and automated batch workflows supporting enterprise insurance platforms.

Key Responsibilities

1. Design, develop, and maintain high-performance complex SQL queries, Stored Procedures, Triggers, and User-Defined Functions (UDFs) .
2. Conduct comprehensive database tuning, execution plan analysis, index optimization, and bottleneck remediation to ensure system performance across high-volume transactions.
3. Build, automate, and monitor data extraction, transformation, and loading (ETL/ELT) pipelines and backend batch processing jobs.
4. Support data migration, database schema modifications, and synchronization between legacy core systems and modern data platforms.
5. Collaborate with business analysts, solution architects, and application developers to validate data models and deliver backend requirements.
6. Maintain rigorous documentation for database design, version-control scripts, and operational procedures.

Requirements

1. Degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
2. 4+ years of hands-on database development experience with MS SQL Server, Oracle (PL/SQL), or PostgreSQL .
3. Expert-level command of writing and optimizing complex Stored Procedures , query profiling, and index strategies.
4. Solid experience with ETL tools (e.g., SSIS, Informatica, or Python-based pipelines) and scheduled batch scripting.
5. Prior technical experience within the insurance, banking, or financial services domain is highly advantageous.
6. Strong troubleshooting instincts, attention to data accuracy, and the ability to operate independently in a project-driven environment.
7. Fluency in English and Cantonese. Immediate or short-notice availability is strongly preferred.