Analytical hands-on database professional having an overall experience of over 25 years in the IT sector with diversified exposure in
databases, their management, administration, data modeling, ETL and testing database solutions in hybrid environments. Have provided a variety of DB services and support to local and international clients under distinct DB roles, domains and environments. Striving to leverage accrued Database skills in contributing towards achieving tangible and intangible organizational objectives.
• Monitoring and managing the different day-to-day aspects of application databases.
• Assisting the development team in DB/Schema design, query optimization, replication and other misc. DB issues.
• Designing Log Dashboards.
Managed, maintained, configured, administered and supported existing setups (servers) of 49 on-prem/cloud-based Microsoft SQL Server/Azure databases running behind HR, Payroll & Financial applications.
• Improved system's health/performance by detecting, analyzing, suggesting and trouble-shooting expensive queries and tuning them.
• Implemented schemas with proper access rights to ensure high levels of database/server accessibility and security.
• Assisted development team by formulating DB and query writing standards, query tuning guidelines and schema refinement.
• Wrote and maintained technical and functional database specification documents and SOPs.
• Performed regular and timely server/database maintenance and assisted in application release/rollout deployment activities.