What You’ll Do
● Customer Communication
o Communicate with technical experts to explain the critical issue(s) and solutions for implementation and break fix related questions
o Drive Customer Satisfaction through timely & quality communication for any critical situation where advanced support is needed
● Troubleshooting Skills
o Troubleshooting of customer reported incidents and system alerts in the areas of Database troubleshooting domain expertise
o Identify, debug and troubleshoot break fix issues for quick resolution
o Provide technical analysis for incidents, resolution, and root cause analysis for the incidents
o Respond and resolve issues within agreed service levels
● Collaboration & Knowledge Sharing
o Publish knowledge articles for the incidents and service requests, prepare technical documents for the standard operating procedures
o Mentor and train other team members with tech solutions
WHAT YOU BRING
● 7-10 years hands-on experience in managing RDBMS like Oracle, MSSQL, MySQL, Postgre
● Extensive hands-on experience in debugging issues with RDBMs
● Knowledge and experience in performance tuning, routine database maintenance activities like rebuilding tables, reorganizing indexes, optimizing indexes and tables for performance tuning
● Extensive knowledge and experience in writing optimized SQL queries and performance tuning
● Experience supporting the design, creation, and testing of databases
● Performing regular maintenance tasks, such as backups, defragmentation, and replication
● Diagnose and fix problems with connectivity, performance, and data integrity.
● Work with network administrators and application developers to resolve complex issues.
● Identify and resolve issues like slow queries, inefficient indexing, or resource contention.
● Optimizing database performance and efficiency, and monitoring usage, response times, and other metrics
● Managing database access and permissions, and ensuring that only authorized users have access to sensitive information
● Developing and maintaining documentation, including data standards, procedures, and definitions
● Supporting Customers by resolving technical issues and troubleshooting queries
● Creating automation for repeating database tasks
● Recommending disaster recovery plans
● Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
● Execute regular database maintenance tasks, including database defragmentation, backups, and database replication.
● Optimize queries, stored procedures to increase server performance
End Point exposure/knowledge:
● Analyse and optimize SQL queries and database performance.
● Identify and resolve query-related bottlenecks and inefficiencies.
● Collaborate with database administrators and developers to improve query performance.
● Implement indexing, partitioning, and other techniques to enhance database efficiency.
● Monitor database performance and provide recommendations for improvements.
● Develop and maintain documentation for query optimization processes and best practices.
● Stay updated with advancements in database technologies and optimization techniques.
● Analyze SQL statements to determine why some are taking too long to run, and provide recommendations to optimize performance.
Preferred skills and qualifications
● Ability to use a scripting language (like Python or Peri) to automate database administration tasks.
● Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA).
● Experience in cloud database technologies, like Amazon RDS or Microsoft Azure.