Administrator Database Ii Mys
Malaysia, Malaysia
Job Description
b'
Basic Job Functions: Provides intermediate level database administration services that includes maintaining, developing and implementing policies and procedures that ensures the security and integrity of First Solar\xe2\x80\x99s database infrastructure. Work with the global teams in implementing, proactively monitoring and supporting the distributed database environments. Implement necessary tool sets and procedures to resolve issues associated with database performance, availability, stability, backup, capacity, and data security issues.
Experience and Education:
- Bachelor\xe2\x80\x99s degree in Information Technology or related discipline with four years of related work experience
- Knowledge around Microsoft SQL Server and database services such as replication, clustering, table partitioning, backup and restore, monitoring, data modeling, security, and server/storage technologies.
- 3+ years of work experience in Microsoft SQL Server database administration.
- 1+ years of experience supporting applications and databases in cloud PaaS and/or IaaS environments preferably in Microsoft\xe2\x80\x99s Azure is highly desirable
- 2+ years of experience administering large, complex and highly available database environments utilizing advanced architectures such as SQL Server Always On clusters.
- Intermediate level knowledge of the best practices and implementation fundamentals for OS support (Windows) is required
- Intermediate level knowledge of the best practices for managing performance, monitoring, and tuning.
- Intermediate level knowledge of disaster recovery management including log shipping, data replication, and backup/restore technologies used to ensure RPO and RTO match customer SLAs and requirements.
- Exposure to compliance frameworks such as SOX
- Intermediate level knowledge with debugging stored procedures and triggers.
- Excellent communication and organizational skills.
- ITIL familiarity a plus.
- Intermediate skills in database performance factors, monitoring tools and tuning procedures.
- Intermediate skills with debugging stored procedures and triggers.
- Solid skills in productivity factors and ability to understand impact of problem on overall database performance.
- Familiarity with automation technologies such as Microsoft Orchestrator is a plus.
- Experience with scripting languages like Power Shell is a strong plus.
- Ability to define physical and logical data structures.
- Intermediate experience with SSIS (SQL Server Integration Services)
- Install SQL Server software and configure SQL instances to support various needs that includes stand alone, and highly available Always On cluster environments.
- Proactively monitor and maintain overall health of database environments to ensure optimal database performance and uptime that conforms with established SLAs
- Implement automation procedures for repeatable tasks.
- Recoverability \xe2\x80\x93 Monitor and correct issues with database backup tasks
- Schedule and perform periodic maintenance activities that includes OS and SQL level patching and upgrades that ensures security and stability of the database environments.
- Define and implement access controls around SQL instances, databases and tables that ensures data security.
- Participate in solution design reviews for applications, servers and networking.
- Responsible for helping define standards for the database management tools and procedures (operations)
- Promotes and supports ITIL processes and ITSM service delivery model.
- Respond to escalated database incidents and provides fault resolution
- Reviews problem investigations to ensure database stability and manageability
- Create documentation and diagrams for use by various team members within IT.
- Will participate in disaster recovery initiatives to ensure business continuity.
- Update and maintain Disaster Recovery Run Books and coordinate table top exercises.
- Use logical approach to troubleshooting and problem mitigation.
- Foster and maintain good business relationships with management and inter/intra departmental teams.
- Adheres to all safety procedures and good housekeeping standards.
- Must be able to server on-call on a periodic rotation basis.
- Performs other assignments as required.
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.
Related Jobs
Job Detail
-
Job IdJD931001
-
IndustryNot mentioned
-
Total Positions1
-
Job Type:Full Time
-
Salary:Not mentioned
-
Employment StatusPermanent
-
Job LocationMalaysia, Malaysia
-
EducationNot mentioned