This job is for a Database Administrator who ensures smooth operation of SQL databases in various environments. You might like this job because it involves working with different teams to deliver efficient database services and utilizing automation tools for optimization.
RM 7K - RM 15K
IOI Boulevard
Full-Time
Few days ago
Job DescriptionServe 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.
Job RequirementsBachelors/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.
SkillsMicrosoft SQL Servers
Company BenefitsWork from Home: Fully work from home to avoid traffic congestion.
Medical & Dental: Medical & Dental benefits provided to all employees.
Birthday Meal: We celebrate employees' birthday as an appreciation of their contributions.
Additional InfoLast active - few minutes ago
Experience Level4 - 7 Years of Experience
Senior Executive
Job SpecialisationSystem & IT Helpdesk / Database Administrator
Company ProfileBitCore Sdn BhdBitCore combines the words " bit " and " core ", two very important words used in technology that are symbolic of what we do. First off, a "bit" is the most basic unit of information in computing and digital communications.
This represents how technology and IT services are essential in most organizations, becoming one of the basic needs of an organization. The "core" is the main part keeping everything running. Without the core, most things would not work. We are that core, we are BitCore.
We aim to leverage our IT expertise to help our customers save money by providing them with an investment in technological solutions that will help them save costs and make more profit.
We are seeking for young Innovative, Aggressive, Highly Motivated and Committed individuals to join our prospective organization.#J-18808-Ljbffr