Kerja Sepenuh Masa, Database Administrator - Microsoft SQL di Fit Pioneer Resources Selangor - Maukerja

Job description:

We are seeking an experienced SQL Server Production DBA with Postgres SQL knowledge to manage database availability, security, and performance. Responsibilities include writing complex SPs and T-SQL queries, disaster recovery, data migration, SSIS, SSRS, and import/export processes. You will ensure 100% uptime, plan capacity, maintain security, and collaborate on infrastructure design with a focus on reliability, scalability, and performance.

Key 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 code-reviews 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)

Qualifications & Skills:

• 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.

Nice-to-have:

• 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.