SQL Server Production DBA

Kuala Lumpur
Tetap
Sepenuh masa

2 bulan lepas

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. This role with other team members to ensure 100% uptime, plan future capacity requirements, maintain security, and apply updates. As DBA, you will solve exciting technical challenges by analysing, troubleshooting, and designing vital services, platforms, and infrastructure while always thinking about 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.
Work closely with Application Developers to design, test, implement, perfect and maintain efficient transactional and analytical data models. Participates in SQL codereviews for the application teams to enforce SQL coding standards.
Lead/engage in tuning, upgrade, and configuration projects to enhance performance and ensure stability.Supply Ad Hoc data reporting and data pulls for Analytics teams
Perform various ad-hoc data loading and data manipulation tasks. Help support architecture and process flow diagrams for data systems
Participates in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies.
Setup Test, Dev, Staging and Production Environments. (Installing SQL Server) Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)
From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)

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 and communication skills and coordination skills and able to work efficiently under pressure.
Experience with MS Azure and MS Azure managed instance databases. Documented hands-on expertise managing high-volume instances of MS SQL setups featuring high availability.
Experience with CI/CD in cloud environments and container technology, Docker and Kubernetes, Docker Swarm.
Experience in telecommunication and networking environment is an asset, Postgres SQL management.

KRISV Consulting

Memohon