Database Performance Optimization:
Analyze, optimize, and enhance Database Server workloads to ensure optimal performance and efficiency.
Address complex performance issues and implement solutions to improve database responsiveness.
Utilize advanced techniques to optimize SQL queries, including index tuning, query plan analysis, and performance troubleshooting.
Optimize SQL queries and database and storage configurations to improve performance and resource utilization.
Maintain a deep understanding of SQL Server 2022 and Oracle 19c features and apply them effectively.

Database Internals:
Leverage in-depth knowledge of MS SQL Server and Oracle internals to understand and resolve performance bottlenecks and inefficiencies.
Monitor database performance and proactively identify and resolve performance bottlenecks. o Identify performance baseline and report/alert on deviation
Participate in investigation, identification, and resolution of key performance bottlenecks related to databases for enterprise applications of various architectures,



including multi-tier web o Document level 1 and 2 performance analysis steps o Ensure the performance, integrity, and security of databases.
Work with developers on database development, design principles, query optimization, and index management
Develop and implement database automation strategies using PowerShell, Terraform, and Linux scripting.
Generate report on setting performance for upper management presentation.
Support Global database workplace.
Hyper monitoring for proactive/reactive monitoring during global Month-end workload.
Use development and analytical skills to reduce resource consumption of applications and minimize request latency to improve customer experience.

Cooperative Development :
Work closely with cross-functional teams, including developers, architects, and system administrators, to address performance issues and implement improvements. o Consult with internal clients

📌 Sr Database Administrator Bengaluru (India)
🏢 Tech SMC Square
📍 India