Key Responsibilities
· Supports application development projects by leading in the creation of standards and procedures related to database management systems.
· Plan and manage capacity of database management systems.
· Maintain the systems that are instrumental in our business functions.
· Manage a team of Database Admins, builds confidence and respect of others.
· Maintaining detailed technical documentation.
· 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.
· Provide strategic infrastructure improvement, planning, design, and deployment.
· Provide expertise in tuning to improve efficiency and to maximize the availability of
· databases and process automation of software environments and the like.
· Create scripts for monitoring and to automate administrative tasks.
· Provide 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.
· Degree in Information Technology, Computer Science, or other related fields.
· Minimum of 7 years' IT experience.
· Highly experienced in Microsoft SQL Server, 2008, 2012, 2016, 2019 and 2022
· Highly experienced in Always On Availability Group, Failover Clustering, Database
· Mirroring, Backup and Restore, Optimizing Performance and T-SQL.
· Experience in Azure Cloud, SQLMI and SQL Database
· Experience in Oracle, Postgres, NoSQL and MYSQL
· Good Communication and Team skills with the ability to cooperate, present to and participate with peers/team members.
· Good problem solving, analytical and critical thinking skills.
Nice to Have Skills
· Knowledge in MongoDB, Cassandra, GCP
