Home

Ramadevi - MS SQL DBA

[email protected]

Location: Seneca, Pennsylvania, USA

Relocation: Yes

Visa: H1B

PROFESSIONAL SUMMARY: Having around 9 years of extensive experience as an MS SQL DBA, Azure cloud. Strong experience in migrations from On-Premises to Azure cloud. Have very good experience in migrating the databases from on_prem to Azure cloud using tools like BACKPAC, DACPAC, DMA and Import/Export. Implemented the Backup of Azure SQL DBs in Azure and Automation of SQL DB backups. Experience in working with Azure SQL database import and export service. Configured Azure backups in both Recovery services vault & Azure blob storage. Experience in creation of SQL server databases in Azure PAAS like single database, Elastic Pools and Azure Managed Instance. Configure the alerts using Azure Monitor for resources at different levels and threshold. Establish and maintain security and integrity controls. Generated reports from remedy and performed incident review. Categorized Incidents to High Impact incidents and recurring incidents and analysed the data to understand issue/problem trends, frequency and source. Co-ordinate between multiple teams for effective resolution. Raised problem tickets for all Major and Recurring incidents. Excellent skills in database administration, backup and recovery activities, applying updates, troubleshooting and upgrades. Resolving the Disk space issues and finding the root cause and permanent fixes. Creating and administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options. Disk space management, user profile creation and user rights management, database creation/alteration. Experience in applying the service packs and cumulative packs for servers. Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups, Mirror backup, Split Backup. Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users. Experience in configuring on Always-On, Log shipping, Mirroring, Replication and Clustering. Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history to run the databases efficiently. Ensuring Data consistency in the database through DBCC commands. Experience in Mongo DB installation 4.0, 4.2 and 4.4 version. Knowledge on MongoDB configuration with windows servers through compass. Experience on Data creation and provide access. Experience on backup dump and restore of Mongo DB collections. CERTIFICATIONS: Certified in Microsoft Azure Administrator Associate-AZ104 Certified in Microsoft Azure Database Administrator Associate-DP300 Certified in Microsoft Azure Cloud Services. Professional Development Attended workshops on database security and optimization best practices. Participated in webinars focused on SQL Server advancements and trends. TECHNICAL SKILLS: Azure Services Azure Blob Storage, Azure key vault, Elastic service, Azure Managed Instance, Azure Database etc. Databases Microsoft SQL Server (2008-2019), Azure SQL Database, SQL Managed Instance Data Visualization Tools Power BI, SSIS, SSRS, SSAS Database Management Systems MS SQL DBA, Backup Tools EMC, SQL Safe Operating Systems Windows Ticketing Tools Service Now, CISM, Cherwell Languages T-SQL, PowerShell Clusters Microsoft Cluster Service PROFESSIONAL EXPERIENCE: Client: Verizon July 2023 Present Role: Data Administrator Responsibilities: Experience in migrating the on-prem SQL servers to Azure by using DACPAC & BACPAC, DMA(Data Migration Assistant), Azure Database Migration Service. Implemented data compression techniques in Azure Blob Storage to optimize storage utilization and reduce costs without compromising performance. Assessed existing database environments and recommended future-state architecture, resulting in improved performance and scalability. Configured Azure backups in both Recovery services vault & Azure blob storage. Experience in creation of SQL server databases in Azure PAAS like single database, Elastic Pools and Azure Managed Instance. Managed on-premises and Azure SQL Server databases, ensuring optimal installation, configuration, and upgrades. Analysed and resolved performance issues, implementing effective indexing and query optimization strategies. Experience in applying the latest patches to the SQL server. Maintaining the regular backups for all the user Databases. Handling the disk space issues for all the log files and tempdb issues. Experienced in decommission of servers which are not in use. Developed scripts for routine tasks, increasing efficiency and reducing manual workloads. Provided training and mentorship to junior DBAs and technical staff on best practices and modern database management. Experience in Azure backups in both Recovery services vault & Azure blob storage. Experience in creation of SQL server databases in Azure PAAS like single database, Elastic Pools and Azure Managed Instance. Maintained comprehensive documentation of database systems, configurations, and policies. Co-ordinated between multiple teams for effective resolution. Raised problem tickets for all Major and Recurring incidents. Company: Capgemini, India Client: Willis Towers Watson June 2022 June 2023 Role: Technical Service Manager Responsibilities: Installation & Configuration of 2012/2014/ 2016/2017 and 2019 on Local System and Remote System. Provided 24/7 Production support for the database and application issues. Applying the service packs and cumulative updates. Resolving disk space issues and data base growth issues. Responsible for database heath checks like error log monitoring, blocking, deadlocks, job failures, backup issues /etc. Responsible for Maintenance tasks like index defrag or rebuild on different databases. Have very good experience in migrating the databases to Azure cloud using Backup/Restore with blob container. Configured Azure backups in both Recovery services vault & Azure blob storage. Running the scripts send from development team and troubleshooting any minor issues in the code, solving deadlock issues by discussing with Application team. Created the detailed and highly accurate RCA documentation and coordinate RCA review meetings with internal and client teams, according to the contractual timelines Responsible for database heath checks like error log monitoring, blocking, deadlocks, job failures, backup issues /etc. Responsible for Maintenance tasks like index defrag or rebuild on different databases. Making sure all the database backups are completed for all the production databases. Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support. Hands on experience in High Availability Clustering and always On Monitoring SQL Server alerts at regular intervals Monitoring SQL Server agent jobs/maintenance plans Company: HCL, India Client: Volvo April 2020 May 2022 Role: Senior Specialist Responsibilities: Installation & Configuration of SQL Server 2012/2016/2017 on Local Systems Maintaining of over 130+ servers. Continuously monitoring and updating the Backup & Recovery strategy and monitoring scheduled jobs of backup and restore procedure for database. Maintenance work on different databases. Having experience on database backup and restorations. Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support. Experience in handling the High Availability features like Always on. Identifying/resolving fragmentation resulting in improved performance. Monitoring SQL Server agent jobs/maintenance plans Provided 7 x 24 Production support for the database and application issues. Scanning DB servers, identifying, and fixing the vulnerabilities. Attending CAB meeting Company: Infosys, India Client: Daimler June 2018 April 2020 Role: Senior System Engineer Responsibilities: Daily checking the assigned tickets and resolve the tickets depends on the priority levels. Experience in database migration from lower versions to higher version as per costumer requirement. Daily checking the issues like backup failures, failed logins and resolve the issues. Resolving disk space issues and data base growth issues. Monitoring the temp DB full and transactional log full issues. Changing the recovery models whenever necessary. Database installation and administration of MS SQL Server 2012, 2014, 2016 & 2017 Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. Maintained & Monitored Alerts/Schedule to make smooth process. Performing data refresh activities from production to Dev/Test on need basis. Performance tuning of the database. Developed scripts for routine tasks, increasing efficiency and reducing manual workloads. Resolves database performance issues, database capacity issues and other data issues related to database. Maintain database consistency check using DBCC commands. Migration and up gradation of servers and databases Repetitive issues analysis and proposals for permanent resolutions. Company: Keeno Technologies, India Client: Sony India software centre June2015 May 2018 Role: Senior System Engineer Responsibilities: Doing Weekly Refresh of Database from Production to Test Environment. Executing scripts in prod environment. Good experience in performing the Log Shipping and Mirroring in Production environment. Performed various Database up gradations and server migrations. Good Experience in Applying the DR activities using Backup and restore. Daily checking and resolving the tickets depends on the priority levels. Responsible for performing Database Maintenance activities like rebuilding/reorganizing indexes update statistics, checking database integrity and clean up history on regular intervals. Daily monitoring the Database Space Management parameters, allocating the required space to databases and suitably managing database growth. Enrolling users, controlling and monitoring User Access to the database, and maintaining system security. Experience in working with Azure SQL database import and export service. Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support. Hands on experience in High Availability Clustering and always On Monitoring SQL Server alerts at regular intervals Monitoring SQL Server agent jobs/maintenance plans Provided 24/7 Production support for the database and application issues. Installation & Configuration of 2012/2014/ 2016/2017 and 2019 on Local System and Remote System. Keywords: business intelligence database microsoft Colorado