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.
What We Do
Saviynt’s Enterprise Identity Cloud helps modern enterprises scale cloud initiatives and solve the toughest security and compliance challenges in record time. The company brings together identity governance (IGA), granular application access, cloud security, and privileged access to secure the entire business ecosystem and provide a frictionless user experience.
