Database Administrator
RM 7,000 - RM 15,000 / Per Mon
Apply on
Original
Simplified
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
- -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.
Similar Jobs