Key Responsibilities:
Provide day to day end-user support.
Own, initiate and involve in various major tasks and projects.
Perform technical support, troubleshoot and provide Root Cause Analysis on complex issues effectively and efficiently in line with the SLA required by the business.
Provide emergency on-site support and coordination, and on-call support as required.
Resolve and manage complex service requests in adherence with service level agreements.
Review and Assess environments using tools, logs, and log analysis and respond to alerts by following procedures or escalating them.
Assess existing document procedures, records and inventory.
Assess and define operating procedures used for day-to-day support, installation guides, housekeeping procedures, etc.
Perform complex ad-hoc requests.
Provides recommendations regarding new technologies to keep infrastructure up-to-date.
Provides disaster recovery and high availability solution.
Provide expertise in complex database software installation and configuration
Provide expertise in complex database administration and monitoring.
Provide expertise and leads in major tasks activities including disaster recovery.
Provides strategic infrastructure improvement, planning, design and deployment.
Provide expertise in tuning to improve the efficiency and to maximize the availability of databases and process automation of software environments and the like.
Creates scripts for monitoring and to automate administrative tasks.
Provides data protection and enforce security standard procedures
Ensure that information security policy is considered and always followed, recommends any changes to policy and approved policy changes are documented.
Assist superiors and other engineers on other tasks and projects as needed.
Train, KT and delegate tasks to trainees and associates
Role Specific Technical Competencies:
Knowledgeable in computer concepts and functionalities.
Proficient in Microsoft office.
Good understanding of computer concepts in Windows and Linux.
Good understanding of Network topologies and platforms.
Ability to perform and lead complex functional analysis and investigation on database related issues.
Ability to perform and lead complex troubleshooting to resolve database related issues.
Ability to perform daily health checks and monitoring activities on database services.
Ability to perform advanced database operational tasks in both Windows and Linux environment.
Ability to create, improve and review database security standards.
Ability to create advance and complex database design and architecture.
Ability to create solution to streamline and improve database operational tasks.
Ability to create and modify intermediate Shell Scripts.
Ability to review and propose improvements in database design and architecture.
Ability to handle and lead multiple database buildups.
Advanced Knowledge and experience in MySQL, SQL Server or Oracle, RMAN, Azure SQL DB and Database performance tuning.