$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Srilakshmi Mohan
,
Experience
Other titles
Skills
I'm offering
Markets
United Kingdom
Language
English
Fluently
Ready for
My experience
2016 - ?
job
Senior MSSQL Database Administrator
Nationstar Mortgage.
Azure experience:
• Worked on Microsoft Azure (Public) cloud and provided PaaS support.
• Handled creation and maintenance of Storage Accounts in Azure Portal, configured backup and restore from / to Storage accounts.
• Involved in optimizing code and improving efficiency in databases.
• Performed Database management, code optimization, troubleshooting IP issues and collaborated with support teams.
• Performed Data migration from On-prem to Cloud using DMA, storage explorer and data tier application, also transferred data using Azure Data Factory
• Hands on experience in working with Load balancer and Availability set.
Key Responsibilities:
• Implemented various types of Database backup and restoration activities, performed Capacity planning and growth analysis (reduced disk space issues by 25%)
• Maintaining 1000+ Databases and 100+ Instances. Identified the Unused databases and drop those databases which saved the resource utilization.
• Automated the monitoring of server backups via SSIS packages which helped to reduce DB outage and maintain DB backups up to date.
• Automated execution of stored procedures through batch job in SQL Azure which had significantly reduced the overall execution time
• Implemented and ensured the security of Databases (Logins, Roles, permissions)
• Involved in trouble shooting SQL server database related issues, replication issues, always on and performance tuning (both server level and query level)
• Responsible for scheduling Jobs, Tasks, Alerts and Maintenance Plans, Index defragmentation on tables and index tuning.
Preceding Assignments
• Worked on Microsoft Azure (Public) cloud and provided PaaS support.
• Handled creation and maintenance of Storage Accounts in Azure Portal, configured backup and restore from / to Storage accounts.
• Involved in optimizing code and improving efficiency in databases.
• Performed Database management, code optimization, troubleshooting IP issues and collaborated with support teams.
• Performed Data migration from On-prem to Cloud using DMA, storage explorer and data tier application, also transferred data using Azure Data Factory
• Hands on experience in working with Load balancer and Availability set.
Key Responsibilities:
• Implemented various types of Database backup and restoration activities, performed Capacity planning and growth analysis (reduced disk space issues by 25%)
• Maintaining 1000+ Databases and 100+ Instances. Identified the Unused databases and drop those databases which saved the resource utilization.
• Automated the monitoring of server backups via SSIS packages which helped to reduce DB outage and maintain DB backups up to date.
• Automated execution of stored procedures through batch job in SQL Azure which had significantly reduced the overall execution time
• Implemented and ensured the security of Databases (Logins, Roles, permissions)
• Involved in trouble shooting SQL server database related issues, replication issues, always on and performance tuning (both server level and query level)
• Responsible for scheduling Jobs, Tasks, Alerts and Maintenance Plans, Index defragmentation on tables and index tuning.
Preceding Assignments
Security, UP, Portal, Tuning, Administrator, Storage, Server, Backup, Monitoring, Support, Growth, Sql, Ssis, Stored procedures, Management, Cloud, Database, MSSQL, Microsoft azure, Azure, SQL Server
2014 - 2015
job
Senior MSSQL Database Administrator
Cognizant Technology Solutions.
Key Responsibilities:
• Installation and maintenance of SQL Server database systems, ensuring successful backups, resolving system issues, opening cases with technical support for resolving issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Maintained database systems by reviewing, planning, testing and installing database security patches and service packs.
• Performed application and database tuning, migration of Databases from SQL Server 2005 to SQL Server 2008.
• Monitored Database Health by using DBCC Commands and DMVS, improved performance using execution plans and Index tuning.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi- Production Servers and handling maintenance Jobs.
• Responsible of routine DBA jobs like Backups and Restores.
• Minimized the production outages by stepping deeper into performance issues and fixing it
Preceding Assignments
• Installation and maintenance of SQL Server database systems, ensuring successful backups, resolving system issues, opening cases with technical support for resolving issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Maintained database systems by reviewing, planning, testing and installing database security patches and service packs.
• Performed application and database tuning, migration of Databases from SQL Server 2005 to SQL Server 2008.
• Monitored Database Health by using DBCC Commands and DMVS, improved performance using execution plans and Index tuning.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi- Production Servers and handling maintenance Jobs.
• Responsible of routine DBA jobs like Backups and Restores.
• Minimized the production outages by stepping deeper into performance issues and fixing it
Preceding Assignments
Testing, SQL Server 2005, Sql server 2008, Tuning, Production, Administrator, Server, Health, Monitoring, Sql, Support, It, Security, Service, Database, MSSQL, SQL Server
2011 - 2013
job
Senior Engineer
Mindtree Limited.
Key Responsibilities:
• Maintained and Administered SQL Server 2000, 2005 and 2008 Databases.
• Performed Installation and Configured Instances of SQL Server and SQL services.
• Involved in troubleshooting various database issues and T-SQL queries, Log Shipping, Mirroring and Cluster related issues
• Managed and maintained data distribution in all production and non-production databases servers, allocation of Space requirement for Data and Log files
• Designed Backup and Restore Policies, identified and Resolved Abnormal Database Status
• Responsible for Resolving Data Transfer related queries, Monitoring of SQL Server Jobs, configuration and troubleshooting of TDPSQL related issues
• Aided with resolving user queries
Preceding Assignments
• Maintained and Administered SQL Server 2000, 2005 and 2008 Databases.
• Performed Installation and Configured Instances of SQL Server and SQL services.
• Involved in troubleshooting various database issues and T-SQL queries, Log Shipping, Mirroring and Cluster related issues
• Managed and maintained data distribution in all production and non-production databases servers, allocation of Space requirement for Data and Log files
• Designed Backup and Restore Policies, identified and Resolved Abnormal Database Status
• Responsible for Resolving Data Transfer related queries, Monitoring of SQL Server Jobs, configuration and troubleshooting of TDPSQL related issues
• Aided with resolving user queries
Preceding Assignments
Sql, SQL Server, Database, T-SQL, Monitoring, Backup, Shipping, Server, Production
2008 - 2011
job
Project Engineer
Wipro Technologies.
Key Responsibilities:
• Addressed problematic queries to identify the root cause and resolve them.
• Monitored the execution of Transact-SQL statements which cause issues and saved traces to replicate the problem on test servers for analysis
• Monitored the performance of SQL Server to tune workloads
• Reviewed Security, Audit logs and T-SQL logs in MS-SQL server 2005, 2008
• Performed daily activities based on Process Control Manual.
• Generate & reconcile the user related activities with appropriate justifications from concerned team and track them for closure.
• Addressed problematic queries to identify the root cause and resolve them.
• Monitored the execution of Transact-SQL statements which cause issues and saved traces to replicate the problem on test servers for analysis
• Monitored the performance of SQL Server to tune workloads
• Reviewed Security, Audit logs and T-SQL logs in MS-SQL server 2005, 2008
• Performed daily activities based on Process Control Manual.
• Generate & reconcile the user related activities with appropriate justifications from concerned team and track them for closure.
Sql, SQL Server, Audit, Test, T-SQL, Security, Server, Audit, SQL Server 2005
My education
?
-
2011
Bharathidasan University
Masters, Computer Application
Masters, Computer Application
?
-
2008
Bharathiyar University
Bachelors, Computer Application
Bachelors, Computer Application
Srilakshmi's reviews
Srilakshmi has not received any reviews on Worksome.
Contact Srilakshmi Mohan
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Srilakshmi directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark