Senior Database Engineer SQL Performance / Data Platforms

Senior Database Engineer – SQL Performance / Data Platforms / ETL/ELT / Cloud Modernization

About the Role

The Senior Database Engineer is responsible for designing, optimizing, modernizing, and supporting enterprise database and data platform environments. The role requires strong hands-on expertise in database performance engineering, SQL optimization, ETL/ELT, data warehousing, cloud data platforms, database migration, and automation.

The successful candidate will have extensive experience with Microsoft SQL Server, PostgreSQL and/or Oracle, with particular strength in query performance tuning, index optimization, database troubleshooting, data migration, and automation. Experience with Microsoft Azure and enterprise data platform modernization is highly desirable.Key Responsibilities

Design, develop, and optimize scalable ETL/ELT pipelines and enterprise data integration solutions.

Analyze and troubleshoot complex database and SQL performance issues.

Perform SQL query tuning, execution-plan analysis, index analysis, and index optimization.

Identify inefficient queries, missing or redundant indexes, blocking, deadlocks, and resource bottlenecks.

Design and implement database performance monitoring and optimization frameworks.

Support database modernization and migration initiatives across PostgreSQL, Oracle, SQL Server, and cloud data platforms.

Support Oracle-to-PostgreSQL, on-premises-to-cloud, and legacy platform modernization initiatives.

Design and optimize data warehouses, data marts, lakehouses, and enterprise data platforms.

Establish and maintain automated database maintenance and operational processes.

Implement automation using Azure services, PowerShell, SQL Server Agent, Python, scripting, and related technologies.

Ensure high standards of data quality, security, governance, compliance, availability, and operational resilience.

Develop data validation, reconciliation, monitoring, and exception-management frameworks.

Work with business and technology stakeholders to translate functional and reporting requirements into scalable technical solutions.

Support financial, regulatory, risk, treasury, operational, and management reporting requirements where applicable.

Perform database capacity planning, performance monitoring, and continuous optimization.

Contribute to technical project delivery, risk identification, dependency management, and stakeholder communication.

Promote engineering standards, coding practices, documentation, automation, and deployment best practices.

Conduct technical reviews and recommend improvements across database and data engineering environments.

Provide technical guidance and mentoring to junior and mid-level engineers where required.Qualifications and Experience

7+ years of experience in Database Engineering, Database Administration, Data Engineering, ETL Development, or Data Platform Engineering.

Strong hands-on expertise with Microsoft SQL Server, PostgreSQL and/or Oracle.

Advanced SQL / T-SQL development and troubleshooting skills.

Strong experience in SQL query optimization, query performance debugging, execution-plan analysis, index design and optimization, and database performance tuning.

Experience analyzing blocking, deadlocks, statistics, query-plan management, CPU, memory, I/O, and wait statistics.

Strong knowledge of ETL/ELT development and enterprise data integration.

Experience with data warehousing and data modeling.

Experience delivering complex database and data migration projects.

Experience with cloud-based data platforms, particularly Microsoft Azure.

Knowledge of Azure SQL, Azure automation, monitoring, and related cloud services.

Experience implementing automated database maintenance processes.

Understanding of data governance, metadata management, data lineage, and data quality frameworks.

Experience working with large-scale and business-critical production databases.

Strong analytical, troubleshooting, and problem-solving capabilities.

Strong stakeholder communication and requirements-management skills.

Ability to work independently on complex technical issues and provide senior-level technical recommendations.

A bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field is desirable.

Relevant certifications in Microsoft Azure, Data Engineering, Database Administration, PostgreSQL, Oracle, SQL Server, or cloud technologies are an advantage.Technical Skills

Database Technologies: Microsoft SQL Server, PostgreSQL, Oracle Database.

SQL Development: T-SQL, PL/SQL, PostgreSQL SQL.

Cloud Data Platforms: Azure SQL Database, Azure SQL Managed Instance, Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, Databricks, Azure Data Lake.

ETL/ELT and Data Engineering: SSIS or comparable ETL technologies, data integration, data warehousing, data modeling, lakehouse architectures.

Performance Engineering: SQL query optimization, execution-plan analysis, index tuning, blocking and deadlock analysis, statistics management, resource and wait-statistics analysis.

Automation and Monitoring: SQL Server Agent, Azure Automation, Runbooks, Azure Monitor, Log Analytics, PowerShell, Python, and scripting.

Database Operations: Database maintenance, backup and recovery, high availability, disaster recovery, capacity planning, and production support.

DevOps and Delivery: CI/CD, DevOps practices, deployment automation, documentation, and engineering standards.

Data Governance and Quality: Metadata management, data lineage, data validation, reconciliation, monitoring, and data quality frameworks.Skills and Competencies

Strong database engineering, SQL performance tuning, and troubleshooting skills.

Excellent understanding of relational database architecture, data modeling, and enterprise data platforms.

Strong analytical and problem-solving abilities, particularly when investigating complex performance issues.

Ability to design scalable, reliable, secure, and maintainable database and data integration solutions.

Strong knowledge of database performance monitoring, optimization, and automated maintenance.

Ability to assess technical risks, identify dependencies, and recommend appropriate solutions.

Strong understanding of data quality, security, governance, compliance, availability, and operational resilience.

Ability to translate business, financial, regulatory, and reporting requirements into practical technical solutions.

Excellent communication and stakeholder management skills.

Ability to work independently and collaboratively with cross-functional teams.

Ability to provide technical guidance, conduct technical reviews, and mentor database and data engineering professionals.

Proactive approach to continuous improvement, automation, modernization, and engineering best practices.

Strong attention to detail and commitment to maintaining high standards across business-critical production environments.Preferred Experience

Experience delivering enterprise data platform, data warehouse, or lakehouse solutions.

Experience in Banking, Financial Services, Treasury, Risk, Regulatory Reporting, or Management Reporting.

Experience with Oracle-to-PostgreSQL, SQL Server modernization, or similar database migration initiatives.

Experience contributing to enterprise-scale data modernization programs.

Experience with Microsoft Azure data services, cloud automation, monitoring, and operational management.

Relevant certifications in Microsoft Azure, Data Engineering, Database Administration, PostgreSQL, Oracle, SQL Server, or cloud technologies.What We Offer

Competitive salary package

Medical insurance cover

Exposure to multiple projects and clients (local and overseas)

Opportunity to work with modern technologies and software development practices

Work-life balance

Employee Referral Program

Office holidays in Dec/Jan

Team building and Welfare activities