Rukmini S

About Rukmini S

Microsoft Certified Professional and an accomplished SQL Server Database Administrator…

Experience

1. Sql Database Administrator

   State of Illinois

   Dec 2021 — Present

   Worked as a DB2 UDB V8.x, 9.7, 10.1 Database administrator on UNIX, LINUX and Windows platforms, with expertise in online transaction processing and multi-user systems involving large and distributed databases.• Installation and configuration of SQL Server 2014, 2012, 2008, and 2005.• Installation and configuration of SSIS, SSRS, and SSAS.• Migration of database from SQL server 2005 and 2008 to SQL Server 2012.• Migrate SQL Server Databases to Microsoft Azure-hosted DBs, Managed instances. Configured High Availability Solutions, troubleshooting, optimization, and maintenance.• Implementation of high availably and disaster recovery solutions including clustering, mirroring, log shipping, and Always on Availability Groups.• Performed Database Migration from On-Premises SQL environment to Azure Database in cloud Managed database security and users in Active Directory, ensured Database Integrity, and setup maintenance plans via SQL Agent. Stored Procedures, Enterprise Resource Planning (ERP)• Performance monitoring, analysis, and tuning of relational databases with T-SQL, profiler, tuning advisor, indexes, statistics, and query plan analysis.• Creation and reviewing of database objects including tables, triggers, views, stored procedures, indexes, defaults, and rule.• Implementing transactional replication and merge replication for high availability of the databases.• Troubleshooting and resolving database integrity issues.• Implementing Always on Availability Groups and the clustered environment.• Recovering databases from backup in disasters and implementing Point-In-Time Recovery solutions.• Maintenance plans for backups, history clean-up tasks, and rebuilding indexes.• Engaging in the suggestion and implementation of Backup Strategies