SQL Server Production DBA

Krisvconsulting Services Pte Ltd; Kuala Lumpur; On-site; MYR 90,000 - 155,000; Full time

Job summary

A leading consulting firm is seeking a skilled SQL Server Production DBA to manage and optimize their database environments. The role involves ensuring high availability, implementing disaster recovery strategies, and collaborating with development teams to enhance data management processes. Ideal candidates will have 7-9 years of experience and proven expertise in Microsoft SQL Server and performance optimization.

Qualifications

• 7-9 years of experience as a SQL Server DBA in a production environment.
• Expertise in SQL Server 2016 and above.
• Strong experience with SSIS, SSRS, and data import/export processes.

Responsibilities

• Manage SQL Server production environments ensuring high availability and security.
• Implement and maintain backup and disaster recovery strategies.
• Optimize query performance through tuning and indexing.

Skills

Database Performance Tuning

Troubleshooting

Performance Optimization

Disaster Recovery Strategies

Data Migration

Job description

We are seeking an experienced SQL Server Production DBA with Postgres SQL knowledge who will be responsible for ensuring the availability, security, and performance of our databases. This role involves handling production DBA responsibilities, disaster recovery (DR), data migration, SSIS, SSRS, and import/export processes. You will collaborate with other team members to ensure 100% uptime, plan future capacity requirements, maintain security, and apply updates. As a DBA, you will solve technical challenges by analyzing, troubleshooting, and designing vital services, platforms, and infrastructure, always considering reliability, scalability, resilience, security, and performance.

Responsibilities:

• Manage SQL Server production environments, ensuring high availability and security.
• Serve as SME (subject matter expert) for Microsoft SQL Server, PostgreSQL, and other database technologies. Implement and maintain backup and disaster recovery (DR) strategies.
• Perform database migrations, upgrades, and patching. Optimize query performance, indexing, and database tuning.
• Develop and maintain SSIS packages for ETL operations and data import/export. Generate and maintain reports using SSRS.
• Troubleshoot and resolve database performance, connectivity, and security issues. Implement replication, mirroring, and clustering for high availability.
• Work with development teams to support application and database changes. Perform capacity planning, monitoring, and proactive maintenance.
• Collaborate with Application Developers to design, test, implement, and maintain efficient transactional and analytical data models. Participate in SQL code reviews to enforce standards.
• Lead or participate in tuning, upgrade, and configuration projects to enhance performance and stability. Provide ad hoc data reports and data pulls for Analytics teams.
• Perform ad hoc data loading and manipulation tasks. Support architecture and process flow diagrams for data systems.
• Participate in the evaluation, design, implementation, maintenance, support, and enhancement of database systems and technologies.
• Set up Test, Dev, Staging, and Production environments, including installing SQL Server. Manage database backups and monitor their regular execution (SQL Server Agent).
• Recover databases to specific points in time as needed, based on backup and recovery procedures.

Requirements:

• 7-9 years of experience as a SQL Server DBA in a production environment. Expertise in SQL Server 2016 and above.
• Strong experience with SSIS, SSRS, and data import/export processes. Knowledge of database security, backup, and disaster recovery (DR) strategies.
• Experience with high availability solutions (clustering, mirroring, log shipping, Always On Availability Groups). Strong knowledge of T-SQL, query optimization, and performance tuning.
• Experience with database migrations and upgrades. Familiarity with Windows Server administration and PowerShell scripting is a plus.
• Familiarity with Data lake is a plus. Excellent troubleshooting and problem-solving skills. Strong organizational, communication, and coordination skills, with the ability to work efficiently under pressure.
• Experience with MS Azure and managed instance databases. Proven expertise managing high-volume MS SQL setups with high availability.
• Experience with CI/CD in cloud environments and container technology, including Docker and Kubernetes (Docker Swarm).
• Experience in telecommunication and networking environments is an asset, especially with Postgres SQL management.