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 environment 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.
Collaborative 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