Serve as SQL Server DBA providing core database administrative, innovation, support, database infrastructure and architecture design. Position requires the ability to provide on-call, after-hours/weekend support, when necessary.-Install, configure, monitor, upgrade and maintain MSSQL databases in production and nonproduction environments.-Work closely with other Infrastructure operations and engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA's and performance target set.-Implementation/Support of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.-Database administration for applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call.-Regular database capacity planning and archival solution related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.-Participate in the evaluation, selection and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.-Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.-Write/maintain PowerShell scripts for DB automation and application maintenance.-Advance experience with automation of managerial and repetitive DBA task [Apply now at https://my.hiredly.com/jobs/jobs-malaysia-bitcore-sdn-bhd-job-database-administrator]
-Bachelors/Degree in Computer Science or other technology field is a must.-Minimum of 4 years of DBA experience with Microsoft SQL Server.-Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas: SSMS, SQL clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory.-Sound knowledge of all windows and SQL utilities; strong PowerShell knowledge and experience is a plus.-Solid understanding of network, storage, tiered application environments and security.-Solid knowledge in database replication technologies (Always-On) and strong architectural/engineering skills to design systems that meet applications High Availability and Disaster Recovery requirements.-Solid knowledge in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. (knowledge of indexes, index management, and statistics)-Demonstrate ability to write complex SQL queries with MS SQL related technologies including T-SQL, stored procedures and database design-Demonstrate ability to solve complex systems and database environment issues.-A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team.