Jayakumar R.

With over 25 years of seasoned expertise in database administration, my proficiency spans the full spectrum of SQL Server, from Version 7.0 to the latest SQL Server 2022. I excel in implementing, monitoring, and managing SQL Governance, ensuring adherence to CIS Recommendations and Best Practices. My skills extend to installation, configuration, backup, recovery, and troubleshooting, maintaining robust database security aligned with Critical Infrastructure Protection (CIP) policies. Adept at coordinating deliverables across departments, I collaborate seamlessly with End Users, Development, Server, Network, Cyber Security, and Project teams. My responsibilities encompass change control process management for DB-related tasks and overseeing updates, upgrades, and patches. I specialize in planning, implementing, and troubleshooting High Availability solutions, such as AAG, replication, mirroring, and log shipping, as well as Disaster Recovery and Security Management operations. In the development realm, my expertise shines through T-SQL proficiency, encompassing the creation of stored procedures, triggers, and functions. I am well-versed in Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS), with additional strength in Power BI for robust data analysis and reporting. My experience extends to clustering, server consolidation, SQL Server upgrades, and migrations. Beyond technical prowess, I bring leadership qualities to the table, mentoring team members and crafting comprehensive documentation. Grounded in a disciplined Software Development Life Cycle (SDLC) process, I possess excellent analytical, programming, and problem-solving skills. Comfortable in fast-paced environments, I excel both as a team player and independently. Additional competencies include Enterprise Application Architecture design and development in the Microsoft.NET Framework, proficiency in Team Foundation Server (2012/2015/2018) and DevOps Administration, Windows Server Administration (2012, 2016, 2019), and familiarity with other databases like MS-Access, MySQL, Oracle, and Linux. Notably, I bring extensive experience in providing 24x7 production database on-call support. Overall, my multifaceted skill set positions me as a valuable asset for optimizing and managing complex database environments with a commitment to excellence and best practices.