Database Administrator - MS SQL Server & PostgreSQL

Krisvconsulting Services Pte Ltd; Singapore; Hybrid; SGD 90,000 - 130,000; Full time

Job summary

Krisvconsulting Services Pte Ltd in Singapore is seeking an experienced Database Administrator to manage MS SQL Server and PostgreSQL databases, ensuring high availability, performance, and security in cloud and hybrid environments.

You will implement disaster recovery, automate maintenance, and design data warehousing and ETL processes using SSIS, AWS RDS, and related tools, with opportunities to advance your career.

Qualifications

• 3 to 4 years of hands-on experience managing MS SQL Server and PostgreSQL databases.
• Experience in hybrid cloud (AWS/Azure) and AWS RDS environments.
• Strong knowledge of Always On Availability Groups (AAG) and backup/recovery strategies.
• Experience with database performance tuning and optimization.
• Familiarity with data warehousing, SSIS, and ETL processes.

Responsibilities

• Administer, optimize, and maintain MS SQL Server and PostgreSQL databases for high availability and performance.
• Manage databases in hybrid cloud environments (AWS/Azure) and AWS RDS, ensuring smooth operation and integration.
• Implement Always On Availability Groups (AAG) and develop disaster recovery strategies to ensure database uptime and integrity.
• Monitor, analyze, and fine-tune database performance. Automate routine database maintenance tasks to improve efficiency.
• Design and maintain data warehousing solutions, SSIS packages, and ETL processes for data integration and reporting.

Skills

MS SQL Server

PostgreSQL

Hybrid Cloud (AWS/Azure)

AWS RDS

Always On AG

Tools

SSIS

Tableau

JasperReports

Redgate Tools

Job description

About the job Database Administrator - MS SQL Server & PostgreSQL

We are seeking an experienced Database Administrator to manage and optimize MS SQL Server and PostgreSQL databases, ensuring high availability, performance, and security. In this role, you'll work with cloud and hybrid environments (AWS/Azure), implement disaster recovery strategies, and automate database maintenance tasks. You'll also design and manage data warehousing solutions and ETL processes. If you have strong experience in database administration and cloud management, this is a great opportunity to advance your career.

Key Responsibilities:

• Administer, optimize, and maintain MS SQL Server and PostgreSQL databases for high availability and performance.
• Manage databases in hybrid cloud environments (AWS/Azure) and AWS RDS, ensuring smooth operation and integration.
• Implement Always On Availability Groups (AAG) and develop disaster recovery strategies to ensure database uptime and integrity.
• Monitor, analyze, and fine-tune database performance. Automate routine database maintenance tasks to improve efficiency.
• Design and maintain data warehousing solutions, SSIS packages, and ETL processes for data integration and reporting.

Experience & Skills Required:

• 3 to 4 years of hands-on experience managing MS SQL Server and PostgreSQL databases
• Expertise in hybrid cloud (AWS/Azure) and AWS RDS environments.
• Strong knowledge of Always On Availability Groups (AAG) and backup/recovery strategies
• Experience with database performance tuning and optimization.
• Familiarity with data warehousing, SSIS, and ETL processes.

Preferred Skills:

Experience with cloud-based database migrations and DevOps practices.

Familiarity with Redgate tools, SQL Compare, and BI tools like Tableau and Jasper.