Sr Database Administrator(immediate To 15 days joiners)

Responsibilities:

• Database Performance Optimization: o Analyze, optimize, and enhance Database Server workloads to ensure optimal performance and efficiency. o Address complex performance issues and implement solutions to improve database responsiveness. o
• Utilize advanced techniques to optimize SQL queries, including index tuning, query plan analysis, and performance troubleshooting. o Optimize SQL queries and database and storage configurations to improve performance and resource utilization. o Maintain a deep understanding of SQL Server 2022 and Oracle 19c features and apply them effectively.
• Database Internals: o 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.
• 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 Ensure the performance, integrity, and security of databases.
• Work with developers on database development, design principles, query optimization, and index management o Develop and implement database automation strategies using PowerShell, Terraform, and Linux scripting.
• Generate report on environment performance for upper management presentation. o Support Global database environment.
• 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.
• Consult with internal clients to determine requirements for reporting; meeting to discuss data, report format, distribution of reports.