Sql Server Database Administrator

VIVEK REDDY ****************@*****.*** 219-***-****

SUMMARY

Experienced SQL Server Database Administrator with 4 years of experience, focusing on Azure-based databases, performance optimization, and query tuning. Proficient in disaster recovery, automation, and SQL installations. Strong commitment to documentation, knowledge sharing, and leveraging tools for efficient database management.

KEY COMPETENCIES & SKILLS

•Integration Services (SSIS) Deployment and Management

•Database Architecture, Design, and Implementation

•Azure SQL Database Expertise

•Scripting Languages (T-SQL, Powershell, Azure CLI)

•ETL Process Development and Support

•Small Team Collaboration

•Agile Methodologies

•Performance Tuning and Optimization

•Installation, Configuration, Maintenance, and Administration

•Backup, Restore, and Disaster Recovery Planning

•Database Security Management

•SQL Server Analysis Services (SSAS)

•Job Creation and Alerting

•SQL Server Internals, Replication

•SSRS, and Database Security

•DMS(Azure database migration service)

•Azure SQL data sync

•Azure Database Migration assistant

WORK EXPERIENCE

SQL Server Database Administrator Mindtree Bengaluru, India January 2019-December 2021

•Successfully implemented and managed SQL Server databases in Azure cloud environments, leveraging AKS for container orchestration and management

•Orchestrated Azure-based SQL Server databases using AKS for container management.

•Successfully migrated on-premises databases to Microsoft Azure using Azure Database Migration Service (DMS), ensuring a seamless and efficient transition.

•Designed and documented database structures, including stored procedures, tables, views, and functions.

•Diagnosed performance bottlenecks and optimized queries to enhance system efficiency.

•Led Disaster Recovery activities, including data center migrations and DR drills.

•Automated health checks, backups, disk space monitoring, and performance reporting.

•Managed 24x7 SQL Server environments for a global banking client, ensuring seamless operations.

•Installed and configured SQL Server, SSRS, SSIS, and SSAS, and executed database migrations.

•Implemented high availability solutions like transactional replication and Change Data Capture (CDC).

•Utilized tools such as Service Now, ITSM, Confluence, and CDM Site for streamlined database management.

•Maintained detailed database logs and runbooks, delivering training to team members.

•Experienced in designing and documenting database structures (stored procedures, configuration files, tables, views, and functions), while adeptly troubleshooting performance issues and optimizing queries.

•Participated in Disaster Recovery activity, like data center migration to DR, working on DR drill from customer.

•Conducted automation tasks for health checks, backups, disk-space, and performance reporting. Participated in disaster recovery activities and handled Microsoft updates and patches.

•Managed 24x7 SQL Server database environment for global banking client, ensuring smooth operations.

•Supported SQL installation, SSRS, SSIS, and SSAS, and performed database migrations.

Implemented high availability solutions like transactional replication and Change data capture (CDC) based database refresh.

•Utilized various tools like Service Now, ITSM, Mwatch, Confluence, and CDM Site for efficient management.

•Managed and documented database logs, run books, and provided training to teammates.

University Project Valparaiso University Valparaiso, Indiana May 2022 - May2023

•Led a year-long university project focusing on database design and management.

•Executed the migration of student data to Databricks, optimizing data accessibility and enhancing system efficiency.

•Demonstrated a moderate understanding of Databricks, including a basic understanding of GCP and GCP BigQuery, in conjunction with SQL development.

CERTIFICATIONS

•Microsoft Certified: Azure Fundementals (AZ-900)

•Microsoft Certified: Azure Data Engineer Associate(DP-203)

•Databricks: Academy Accrediation - Generative AI Fundementals (Credential ID 79182929)

•ITIL Foundation Certificate in IT Service

EDUCATION

Master of Science in Information Technology Valparaiso University, Valparaiso, IN May 2023

AWARDS

•Successfully attained an early promotion within 18 months, advancing from L1 to L2 engineer

•Achieved Hat's Off Award for the project in the Year 2019 for efficient contribution during DR activity.

•Achieved A-TEAM award as the best team player in the years of 2019,2020 at Mindtree.

Contact this candidate