SQL Developer

IDC Technologies; Singapore; On-site; SGD 80,000 - 100,000; Full time

Job summary

A leading technology consulting firm in Singapore is seeking a skilled professional to develop and optimize ETL processes, manage database performance, and create technical documentation. The ideal candidate will possess extensive experience in SQL and data validation. Join a dynamic team focused on efficient data management practices.

Qualifications

• Experience with ETL/ELT processes and data pipelines.
• Proficiency in SQL for complex queries and database management.
• Ability to develop technical documentation.
• Experience in data validation and verification.

Responsibilities

• Develop and maintain ETL/ELT processes to transform and load data.
• Optimize and maintain complex SQL queries and stored procedures.
• Monitor and tune database performance and security.
• Create comprehensive technical documentation.

Job description

Responsibilities

• ETL / Data Pipeline Development
  • Develop and maintain ETL/ELT processes to,transform, and load data from various sources.
  • Implement data integration workflows.
  • Ensure pipelines are efficient, fault-tolerant, and well-documented.
  • Automate data movement and transformation tasks where possible.
• Database Development & Performance Optimization
  • Write, optimize, and maintain complex SQL queries, stored procedures, and scripts.
  • Monitor and tune database performance, indexing,and query execution plans.
  • Manage data versioning, schema evolution, and migrations.
  • Maintain database integrity, security, and backup processes.
• Verification & Validation
  • Perform end-to-end verification & validation.
• Documentation and Knowledge Transfer
  • Develop comprehensive technical documentation including architecture, deployment, and operational guides
  • Create user manuals and administrative procedures