Database Reliability Engineer
The Qualys SaaS platform is database centric and relies heavily on Oracle/Elasticsearch/kafka/Redis/Cassandra to deliver 24x7 service to our customers worldwide. This individual is primarily responsible for keeping the Oracle/Elasticsearch/kafka/Redis/Cassandra systems running across our many worldwide platforms. DBRE will be working closely with Development/Engineering, Networking, Support teams and Worldwide Customers to provide 24x7 Support for Qualys production applications to improve the service through database optimizations.
DUTIES AND RESPONSIBILITIES:
Perform Oracle/Elasticsearch/kafka/Redis/Cassandra installation, configuration, performance tuning in multi DC environment.
Add/Remove nodes in the clusters without downtime.
Perform troubleshooting in Elasticsearch related issues.
Good at data-modeling.
Oracle Database Administration.
Identifying the bottle-necks 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
Minimum 5 years of extensive experience managing Oracle databases.
Minimum 2 years of extensive experience managing nosql databases like Elasticsearch/kafka/Redis/Cassandra etc.
Extensive experience with Oracle 19c,12c.
Extensive experience with Oracle technologies like RAC,ASM,Dataguard,RMAN etc.
Should have extensive knowledge of Oracle diagnostic, monitoring and troubleshooting tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance.
Extensive experience in database support in performance tuning, database troubleshooting, RDBMS patching and locks detection.
Knowledge of Oracle DBA best practices (e.g., schema management, index optimization, and use of hints).
Solid knowledge in Oracle security practices.
Knowledge of operating interrelationships between database, business applications and operating systems.
Problem-solving and good analytical skills.
Must be able to work with multiple groups to resolve data issues.
Must have experience of working in mid to large size production environment.
Must be able to work in a 24x7 on-call customer facing environment.
Must have exceptional verbal, written, interpersonal and presentation skills.
Must be able to work in a cross cultural environment.
Experience in OCI is a big plus.
Experience on nosql databases like Elasticsearch/kafka/Redis/Cassandra etc is a big plus.
Experience on Terraform/Ansible/Prometheus/Grafana/Alert manager is a big plus.