Lead Engineer - DBRE

This individual is primarily responsible for keeping productions systems running across our many worldwide platforms single and multi-tenant.

DBRE will be working closely with Development/Engineering, SRE, Infra, Networking, Support teams and Worldwide Customers to provide 24x7 Support for Saviynt production applications to improve the service through database optimizations. This position will report to Manager DBRE.

WHAT YOU WILL BE DOING

• Perform installation, configuration, performance tuning of Oracle/Elasticsearch/Cassandra/Kafka/Redis/Ceph in multi-DC environment.
• Identifying the bottlenecks and performance tuning.
• Responsible for integrity and security of the database.
• Monitoring performance and managing configuration parameters to provide fast query responses to front-end users.
• Installation and testing of new databases as well as patching of existing live databases.
• Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly.
• Go extra-mile in understanding business application and suggest / perform necessary database or architecture changes.

WHAT YOU BRING

• Minimum 6-12 years of extensive experience managing SQL & No-Sql technologies like Kafka, Cassandra, Opensearch, Redis, Ceph and some experience in oracle RAC.
• Should have extensive knowledge of diagnostic, monitoring and troubleshooting tools to identify performance bottlenecks, and take appropriate corrective actions to improve database performance.
• Knowledge of operating interrelationships between database, business applications and operating systems.
• Understand backup and recovery scenarios.
• Familiarity with real time data synchronization.
• Problem-solving and good analytical skills.
• Working knowledge on Oracle Cloud Infrastructure is a plus.
• Must be able to work with multiple groups to resolve data issues.
• Must have experience of working in mid to large size production environment
• Should have working knowledge on ansible/terraform/Jenkins/git/grafana