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.
Advantages (Nice to Have)
- Experience with CI/CD in cloud environments and container technology
- Experience in telecommunication and networking environment is an asset.
- Postgres SQL management.
Working Conditions
- Working Hours: Standard Working Hours
- Work Arrangement: Fully On-Site
- Location: Petaling Jaya
