Sql Server Database Administrator

Sai Priyatham Dasari, Phone No: 314-***-**** Email: *********@*****.*** LinkedIn: linkedin.com/in/sai-priyatham-dasari-82146a152

EDUCATIONAL BACKGROUND

Master of Science in Computer Science Aug 2021 – May 2023

Saint Louis University, Saint Louis, Missouri.

Coursework: Database Management System, Database Security, Big Data, Software Development, DevOps, Machine Learning, Algorithms, Web Technologies, Distributed Computing.

Bachelor of Computer Science Aug 2017 – May 2021

Sathyabama Institute of Science and Technology, Chennai, India.

Coursework: Data structures, Data Warehousing and Mining, C, Data Analytics, Object-oriented programming, Java, Python, Algorithms, Database Management System.

CAREER OVERVIEW

Results-driven Database Administrator with over three years of comprehensive experience in database management, performance tuning, and client engagement.

Proficient in SQL Server Management Studio (SSMS), activity monitor, and various backup and recovery tools, with a proven track record of enhancing system reliability and performance.

Demonstrated expertise in managing database migrations, resolving blocking issues, and implementing security best practices.

Adept at collaborating with cross-functional teams to optimize database architecture and adhere to industry data standards.

Committed to delivering high-quality solutions that meet organizational goals and client satisfaction.

SKILLS MATRIX

Operating Systems

Windows XP, Windows Server2008/2008r2/2012/2016

Languages

SQL, Windows PowerShell, T-SQL

Databases

Microsoft SQL Server (2008,2008r2,2012, 2014, 2016,2019)

Tools

SQL Server Management Studio (SSMS), 22Activity Monitor, Control-M, SQL Profiler, Database Tuning Advisor.

Ticketing Tools

JIRA, ServiceNow

Cloud

AWS, Azure, GCP

Other Skills

Data Migration, Performance Tuning, Database Security, Disaster Recovery, Data Governance

PROFESSIONAL EXPERIENCE

Database Administrator, Vitosha Inc. July 2023 to Present

Conducted daily client meetings via Zoom and Microsoft Teams, providing status updates and performance reports on database operations, improving client satisfaction ratings by 15%.

Scheduled and monitored regular database backups and maintenance jobs using SQL Server Management Studio (SSMS) and automated scripts, fulfilling ad-hoc backup requests through nCycle, achieving a 99.9% backup success rate.

Identified and resolved blocking and deadlock issues using activity monitor for real-time performance monitoring, resulting in a 20% reduction in system downtime.

Developed and scheduled user jobs in SQL Server Agent, executing SSIS packages and T-SQL scripts that improved process efficiency by 30%.

Addressed Database as a Service (DBaaS) consultancy requests, delivering detailed reports on database health and performance metrics that adhered to industry data standards.

Actively participated in quarterly disaster recovery drills and maintenance activities, including Windows patching, which strengthened system resilience and ensured compliance with disaster recovery protocols.

Executed weekly database refresh tasks and additional client requests, maintaining data accuracy, and meeting SLAs, enhancing data reliability. Created logins and assigned privileges, resolving connectivity and security issues while ensuring compliance with data governance and security protocols.

Managed database migrations between servers, addressing orphan user issues and ensuring data integrity, leading to zero data loss incidents. Monitored disk space and system performance across production and non-production environments using SQL Sentry and SolarWinds, proactively addressing issues and maintaining optimal performance.

Collaborated with development and architecture teams to optimize database designs, ensuring seamless integration and adherence to data standards.

Maintained comprehensive documentation of database processes and configurations, facilitating future audits, and improving team knowledge sharing.

Implemented security best practices by configuring Database Mail for alerts on backup and job failures, regularly reviewing access permissions to ensure compliance with data protection regulations.

Engaged in team discussions on improving database performance and reliability, utilizing cross-functional insights that led to actionable enhancements in database operations.

Technical Environment: Microsoft SQL server 2008/2012/2014/2016/2019

Junior Database Admin, Power Soft Global Solutions June 2020 to June 2021

Conducted daily status meetings in Microsoft Teams, ensuring timely updates on database performance, and contributing to an increase in customer retention.

Scheduled and monitored database backups and maintenance jobs using SQL Server Management Studio (SSMS) and SQL Server Agent, ensuring compliance with scheduled maintenance tasks.

Identified and resolved blocking and deadlock issues using Dynamic Management Views (DMVs) and SQL Profiler, reducing query response time by 25%.

Managed log shipping processes in SQL Server, facilitating effective disaster recovery strategies and ensuring data availability with a recovery time objective (RTO) of less than one hour.

Created and scheduled jobs in SQL Server Agent to run SSIS packages and T-SQL scripts, streamlining workflows and improving operational efficiency.

Performed routine database refresh tasks and utilized SSMS for managing data accuracy in client-requested updates, achieving a 100% success rate on data refresh requests.

Established user logins and assigned privileges, effectively addressing connectivity issues, and ensuring secure access while adhering to least privilege principles.

Developed and optimized clustered and non-clustered indexes to enhance overall database performance and reduce query execution times.

Managed database migrations using backup and restore techniques, ensuring data integrity and fixing orphan user problems, achieving a zero-downtime migration.

Provided 24/7 on-call support for database incidents, utilizing monitoring tools like SolarWinds and Redgate, resulting in a decrease in incident resolution time.

Technical Environment: Microsoft SQL server 2008/2012/2014/2016

INTERNSHIP EXPERIENCE

Database Admin Intern, Neptune Information Solutions Ltd. May 2019 to Dec 2019

Assisted in designing and optimizing database schemas in compliance with best practices for performance and scalability for application data models.

Implemented normalization and indexing strategies, improving query performance, and reducing storage requirements.

Monitored daily backups and conducted restoration tests to validate data recovery processes, achieving a successful recovery rate.

Utilized database monitoring tools such as SQL Sentry to track system health, identifying and resolving performance bottlenecks effectively.

Established user roles and permissions based on least privilege principles, enhancing security and access management in line with data governance standards.

Developed comprehensive documentation detailing database configurations, changes, and operational procedures, improving team onboarding efficiency.

Set up user roles and permissions based on least privilege principles.

Technical Environment: Microsoft SQL server 2008/2012/2014

Contact this candidate