Sql Server Database
Resume:
Manohar Rayala
SQL SERVER DATABASE ADMINISTRATOR
ad5wq4@r.postjobfree.com
Professional Summary
Database Engineer with over 8 years of experience specializing in SQL Server system resolutions, Azure SQL Database provisioning, and endpoint security management. Proficient in conducting vulnerability scans with Nessus and adept at database schema design, ensuring meticulous attention to detail in monitoring system health and database performance. Eager to leverage extensive technical skills in a dynamic environment to drive efficiency and enhance database security protocols.
Employment history
Capital One SQL DBA
Sep 2022 - Present
•Installed, Configured, and maintained SQL server from 2016,2017,2019 and 2022.
•Production Support of MSSQL Systems 24*7.
•Supported Database Administration and Engineering in the architecture, design, development, deployment, and management of Microsoft SQL database environments.
•Helped the Application team in gather requirements and provide recommendations for database standards.
•Experience in Azure Environments IAAS, PAAS, and Mange instance platform models.
•Experience in Azure SQL Server migrations On-Prem to PAAS, PAAS to PAAS, On-Prem-IAAS.
•Designing, developing, and maintaining cloud-based database systems.
•Installed, configured, monitored, upgraded, and maintained MSSQL databases in production and non-production environments.
•Provided technical expertise to design the most efficient and cost-effective solutions for Microsoft SQL Servers.
•Monitoring disk space, SQL through Zabbix.
•Designed, built, installed, configured, and supported Database servers.
•Proficient in setting up and maintaining Windows servers to ensure optimal performance and reliability.
•Utilized the following ideas and characteristics: Database management, SQL programming, database security, requirements analysis, data maintenance, database performance tuning, and large clustered system implementation.
•Installed, maintained, and patched MSSQL servers.
•Created, moved, upgraded, and deleted databases and established backup and recovery procedures.
•Executed regular database maintenance, used Performance Monitor, SQL Server Profiler, and Dynamic Management Views to monitor and optimize databases.
•Managing and monitoring production servers along with development and test servers. Many of them support high availability.
•Installing SQL Server on the server and client machines, providing connections, and managing databases.
•Worked closely with other Infrastructure operations and engineering, product development, business operations, and technical operations to ensure the delivery of database services within the SLAs and performance target set.
•Provided technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.
•Implemented/Supported databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
•Supported and maintained Microsoft SQL Server database technology and infrastructure, adhering to the architectural guidelines and policies.
•Helped in database capacity planning and archival solutions related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.
•Supported for enterprise monitoring, backup, alerting, and security compliance solutions for SQL servers.
•Helped in improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.
•Proactively performed on performance analysis, monitoring, troubleshooting, and resolution of database issues.
•Helped in writing PowerShell scripts for DB automation and application maintenance.
•Experience with automation of managerial and repetitive DBA tasks.
•Pioneered cloud-based database solutions, increasing data accessibility and collaboration.
•Ensured 99.9% uptime for critical databases by implementing robust monitoring and maintenance protocols.
•Led SQL Server migration projects, achieving 100% target completion within deadlines.
•Pioneered the adoption of Azure cloud solutions, elevating database scalability and reliability.
•Facilitated cross-team collaboration, ensuring seamless database integration with application development.
•Managed 24*7 production support, maintaining high availability and minimal downtime.
•Pioneered Azure SQL migrations, optimizing cloud-based database solutions.
Zoetis USA SQL DBA Infosys
Mar 2019 - Jul 2022
•Resolved SQL server system issues and user issues using the ServiceNow tool.
•Provision and configure Azure SQL Databases.
•Created change requests for database creation, database decommissioning, and instance decommissioning.
•Experienced in installing and managing endpoint protection solutions to safeguard network endpoints from security threats.
•Skilled in configuring Nessus for conducting comprehensive vulnerability scans and analyzing scan results to address security vulnerabilities proactively.
•Planning and scheduling backups and developing recovery procedures.
•Performed daily health checks for errors on Production as well as Standby Servers.
•SQL Server Installation, patching, and migration of databases.
•Creating logins and roles with the appropriate permissions.
•Monitoring the utilization of free space in the database.
•Resolving issues of customers through the ticketing mechanism.
•Providing connectivity and troubleshooting of connectivity problems.
•Providing support to the Application developers on the application databases.
•Worked on server post-build activities and performed checkouts during maintenance activity.
•Monitored and resolved alerts in the Splunk monitoring tool for issues such as log files, temp db, disk space, blocking, backup, and job failures.
•Performed backup and restoration, user creation, permission granting, linked server creation, database migration, and fragmentation level checks on databases.
•Demonstrated ability to configure and maintain various types of servers, including application servers, web servers, file servers, and FTP servers, to support organizational needs effectively.
•Monitored and troubleshot various application-related jobs.
•Migrated on-premise SQL databases to AZURE.
•Created SQL Database on Azure on based on DTU as per client's requirements.
•Monitored Azure databases weekly to cut costs on a DTU basis.
•Handled outage notifications and followed production maintenance/production down issue procedures.
•Worked on database refresh and point-in-time recovery as per user requests.
•Identifying and implementing automation of Database administration tasks to reduce manual interactions.
•Analyzing production issues, finding out the root cause, and implementing the solutions.
•Documenting database-related processes, reviewing with the customer, and demonstrating them to the team members.
Globus IT India PVT Ltd Jr SQL DBA
Sep 2016 - Mar 2019
•Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
•Used the query store and Execution Plan to improve the optimization of the T-SQL code.
•Performance tuning of SQL queries and stored procedures using query store and extended events and Index Tuning Wizard
•Provided 24 x 7 Production support for the database and application issues.
•Environment: SQL Server 2019/2017/2016/2014/2012/2008 R2, SQL extended events, Clustering, Always on, Log Shipping, Windows 2008 R2/2003/2000, Commvault, IDERA mgmt.
Education
Saint Louis University Master’s in Computer and Information Sciences
Skills
•Database Security Measures
•Performance Analysis and Optimization
•High-Availability Solutions
•Disaster Recovery Planning
•Data Migration
•Query Tuning
•Backup and Recovery Strategies
•PowerShell Scripting for Automation
•Troubleshooting and Maintenance
•SQL Server Installation and Migration
Links
Contact this candidate