The Senior Database Administrator has the responsibility of administrating, monitoring, and troubleshooting a 24x7 production environment database servers and associated infrastructure. This role will (with other team members) ensure 100% uptime, plan future capacity requirements, maintain security, upgrade SQL servers, apply updates and performance tuning.
Responsible for day-to-day activities regarding the upkeep and availability of all database servers in all environments including lower environments.
Serve as SME (subject matter expert) for Microsoft SQL Server and other database technologies.
Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.
Responsible for Monitoring of SQL Servers using tools like Stoplight and scripts.
Upgrade SQL servers from lower version to higher versions.
MS SQL production database level performance tuning.
Participates in SQL code-reviews for the application teams to enforce SQL coding standards.
Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
Assist in the technical analysis and design for current and future projects.
Participate in MS SQL migration to Cloud (OCI).
Experience in writing Automation Scripts, Knowledge of administrating Power BI and Power BI Report Servers will be an added advantage
Qualifications
5+ years of experience as a SQL Server DBA in 24*7 production environments
2+ years of experience with SQL Server Performance Tuning and Optimization
2+ years of hands on experience in upgrading SQL Servers
Skills : Microsoft SQL Server , Stoplight, Performance tuning,Cloud (OCI), Power BI