Passionate Ms SQL DBA with 5 + years of experience in the IT industry.Looking for an opportunity to contribute my professional knowledge at the right place and enhance my skills for further growth and betterment.
Efficiently handled Database Administration responsibilities for diverse environments like Production, QA, UAT, and DEV.
Ensured smooth operation and optimization of SQL Server 2019 Always On AG Clusters and SQL Failover Cluster Environments.
Spearheaded initiatives for SQL server migration, upgradation, database migration as well as executing tasks such as SQL server installation and user access management.
Ensured timely application of Windows and SQL patches on stand-alone servers as well as HA-configured servers.
Managed installation analysis of Analysis Services, as well as the creation and restoration of cube databases. Oversaw migration of cubes while also ensuring proper role access at the database level.
Implemented gateway upgrades on both Prod and Test environments for On-premise Power BI.
Provided support for Power BI-related tasks by configuring new workspaces and establishing data source gateway connections in both on-premises and Azure environments.
Efficiently handled access management for Power BI servers, folders, and subscriptions in line with user needs.
Delivered exceptional project support as the sole resource within technology services, meeting all project deadlines effectively.
Associate Software Engineer
Project-BMW (ACCENTURE PRIVATE LIMITED SOLUTIONS)
Hyderabad
07.2019 - 08.2023
Contributed to Database administration by supporting tasks like configuration management, backup/recovery, space management, and performance optimization
Facilitated efficient database deployments and offered assistance with application releases
Supported developers with troubleshooting MS SQL Server problems and inquiries
Provided support and problem-solving expertise to resolve complex technical problems within applications and database systems through close cooperation with the development, network, virtualization, storage and system operations teams.
Maintained availability, security, and integrity of designated databases.
Spearheads login and user account management, encompassing allocation of database object permissions and additional privileges
Migrated SQL server databases from one version to another version.
Implemented regular index rebuilding and monitoring to optimize performance
Executed disaster recovery processes to restore databases from backups
Met or exceeded business SLAs by promptly addressing and resolving system issues/problems.
Collaborated closely with senior executives from both business and technology sectors
Skilled in overseeing database software maintenance activities, specifically related to patch and version management
Administered and monitored applications and systems, while developing automated alerts to warn of failures
Provided after-hours support on an on-call rotation for critical production database issues.
Maintained database backups and was able to recover databases to a point in time when necessary.
Maintained database monitoring tools and monitored performance under varying workloads.
Supported customers by answering questions and guiding end-use.
Reported on common sources of technical issues or questions and made recommendations to product team.
Education
Bachelor of Engineering and Technology -
Vidya Vikas Institute of Engineering and Technology, Mysore
Skills
Operating Systems: Windows Server 2012,2014,2016,2019,2022