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)
; Requirements:-
-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.