- Expert skills in PostgreSQL/ MariaDB/ SQL Server/ NoSQL databases for Windows and Linux platforms
- Writing performant queries and procedures using PSQL/t-SQL,
- Query performance tuning & optimization and index tuning
- Profiling of database
- Very good understanding of Database schema, and handling & preparation of data correction scripts
- Troubleshoot database usage issues, malfunctions and performance bottlenecks
- Database Server and database monitoring and daily health checks
- Manage the operations for both development and production databases
- Demonstrated experience in documenting database installation guide, tuning, backup, and restore procedures.
- Install, configure, patch and upgrade database software (PostgreSQL, MariaDB, MySQL, MySQL cluster, Cassandra and Couchbase) – this is good to have
- Experience of working in a fast-paced agile team with fully integrated CI/CD
- Experience on Linux/Unix Scripting
- Optimize and maintain legacy systems
- Liaise with developers to improve applications and establish best practices
- Provide data management support to users
- Research and suggest new database products, services and protocols
- Hands-on on Incident management process and JIRA processes
- Awareness of Kafka, event-driven architecture.