Purpose The Senior Database Administrator will be responsible to ensure database availability with optimal performance, security and day-to-day production DBA tasks including but not limited to troubleshooting & problem resolution. He will be responsible to ensure defined SOPs, Standards, Best Practices are in-place through change management controls and is willing to work as part of 24/7 Production Support DBA Team.
Key Responsibilities
· Installation, administration, monitoring & support, maintenance, up-gradations of database servers to ensure 24/7 availability.
· Implements standardized solutions to manage database physical structures, functional capabilities, security, backups, replication, archiving/purging etc.
· Maintains quality of service by practicing defined SOPs, organizational standards, compliance requirements & change management process.
· Must possess sound knowledge & expertise on database performance tuning especially SQL query optimization.
· Troubleshoot & resolve production database issues in accurate and timely manner within defined SLAs / OLAs & practice ITIL incident/problem management process.
· Manage database physical & logical structures, access & authorization, maintenance plans, database resources & standard DBA tasks.
· 4+ years of working experience in reputed organizations especially with MySQL/PostgreSQL on Linux and other databases in general SQL Server, Oracle, etc.
· Experience with any NoSQL database or MongoDB especially will be given preference.
· Strong exposure to RDBMS engine internal working, storage & memory optimization, performance tuning & SQL query optimization including hints, etc.
Afiniti Software Solutions Pvt Ltd/p