Execute database optimization and scaling initiatives — implement partitioning strategies, sharding schemes, and replication configurations; independently diagnose and fix slow queries across the platform.
Provide 1st and 2nd level operational database support on functions associated with maintenance of Oracle Server databases plus MSSQL/SQLMI/MYSQL/POSTGRES/Mongo cluster/standalone onprem/cloud including administration, performance , security &hardening, back-up,dataguard configuration and maintenance, reporting, and recovery procedures.
Own query performance and latency across Aurora MySQL and PostgreSQL through execution-plan analysis, indexing strategies, and database statistics optimization.
Database Performance & Optimisation: Write, review, and optimise SQL queries; identify long-running or resource-intensive queries and work with engineering teams to resolve them.