Fit Pioneer Resources Hiring! Full Time SQL DBA - Database Administrator in Selangor - Ricebowl

Key Responsibilities

• Manage SQL Server production environments, ensuring high availability and security.
• Serve as a Subject Matter Expert (SME) for Microsoft SQL Server, PostgreSQL, and other database technologies.
• Develop, maintain, and optimize software solutions based on product specifications.
• Build and manage CI/CD pipelines for database deployments and software delivery.
• Implement and maintain backup and disaster recovery (DR) strategies for SQL Server environments.
• Perform database migrations, upgrades, and patching.
• Troubleshoot and resolve database performance, connectivity, and security issues.
• Implement replication, mirroring, and clustering for high availability solutions.
• Monitor, optimize, and maintain SSIS packages for ETL operations and data import/export.
• Work with development teams to support application and database changes.
• Follow Agile/SCRUM development practices and software engineering best practices.
• Lead tuning, upgrade, and configuration projects to enhance database performance and ensure stability.
• Generate and maintain reports using SSRS, and support data reporting requests for analytics teams.
• Perform various ad-hoc data loading and manipulation tasks.
• Diagnose and troubleshoot technical issues, ensuring database reliability, scalability, and performance.
• Participate in architecture and process flow design for data systems.
• Set up, monitor, and recover databases from backups in Test, Dev, Staging, and Production environments.
• Actively participate in database code reviews to enforce SQL coding standards.

Required Skills:

• Programming: Strong proficiency in T-SQL and SQL query optimization.
• Frameworks & Technologies: SSIS, SSRS, Always On Availability Groups, log shipping, database clustering, high availability, performance tuning.
• Database: SQL Server 2016 and above, PostgreSQL, and experience with backup & disaster recovery strategies.
• Experience: Minimum 4-7 years of experience in managing SQL Server production environments.
• Additional Knowledge: Familiarity with Windows Server administration, PowerShell scripting, and MS Azure managed instance databases.
• Troubleshooting Skills: Expertise in resolving performance, connectivity, and security issues within SQL Server and PostgreSQL environments.
• Communication & Coordination: Strong organizational and communication skills with the ability to work efficiently under pressure.