AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF20659
profile image
Oosalan S AXF20659 Active
SQL Server DBA in Dharmapuri
IT professional with over 9 Years of experience in managing large scale databases in production support as SQL Server DBA, in Cloud platform with good technical skills and can work on multiple highly visible projects and Providing 24/7 SQL Server DBA production support experience with Oncall support. Installing, and configuring, SQL 2008, 2008R2, 2012,2014,2016.2017,2019 Experience in upgrading and Migrating databases to SQL Servers 2008, 2008r2 and 2012.2014,2016,2019 2022
Industries : Corporate Management
Share
Hire Oosalan S
Download PDF
Availability
Full-time
Total experience
9 years
Technical skills
SQL Server DBA
9 Years & 1 Months
SQL Server
9 Years & 1 Months
SSIS
6 Years
Cloud Computing
5 Years
microsoft Azure Cloud
5 Years & 1 Months
SSAS
5 Years
SSRS
5 Years
Automation Testing
4 Years & 1 Months
SQL Server and cloud, SQL Server and Cloud, SQL server and cloud , SQL Server DBA , SQL server DBA
Projects
Project 1
June-2021 to December-2023
Description
Having years of experience in SQL Server Database Server DBA in Cloud platform and maintenance support Troubleshooting production issues. Providing SQL Server DBA production support experience with Oncall support. Installing, and configuring SQL Experience in upgrading and Migrating databases to SQL Servers Performing database Backups and scheduling agent jobs monitoring the sql server instances maintenance plans recovery models. Experienced on piecemeal restore and restorations to STOP AT MARK. Implementing Security creating logins with appropriate roles and permissions monitoring and maintaining the user accounts and permissions creation of groups, granting the privileges to users and groups. Checking the consistency of Databases by using Database Console Commands experience in DBCC DMV's. Experience in SQL Error Log, Event Logs Activity Monitor mirror monitor replication monitor and Failover Cluster manager. Identifying and resolving Blocking and DeadlockingLock issues by using Activity Monitor System stored procedures and Profiler. Monitoring and troubleshooting server performance by using Performance Monitor DMV and Perfmon. Experience on configuring and troubleshooting Always On AG in SQL Server. Configuring and troubleshooting snapshot, transactional, merge replication. Experienced applying service packs Hot Fixes Cumulative updates in standalone cluster production environments. Experience on automation using PowerShell. Experience on taking backup and restore using Litespeed and Commvault tool. Comfortable using stored procedures Views TSQL codes queries queries DMVs and DBCC. Creating, rebuilding, and reorganizing different types of indexes. Restoring system databases as they meet corruption and restoring user databases. Good experience in system databases SSMS Memory CPU and Disaster recovery. Follow the SLA's and ITIL process for changes and all tickets Service requests from clients. Experience on Installing and configuring SSAS SSIS and SSRS
Roles and Responsibilities
Having years of experience in SQL Server Database, Server DBA in Cloud platform and maintenance, support, Troubleshooting production issues. Providing SQL Server DBA production support experience with Oncall support. Installing, and configuring, Experience in upgrading and Migrating databases to SQL Servers Performing database Backups and scheduling agent jobs, monitoring the sql server instances, maintenance plans recovery models. Experienced on piecemeal restore and restorations to STOP AT MARK. Implementing Security, creating logins with appropriate roles and permissions, monitoring, and maintaining the user accounts and permissions, creation of groups, granting the privileges to users and groups. Checking the consistency of Databases by using Database Console Commands, experience in DBCC DMV's. Experience in SQL Error Log, Event Logs, Activity Monitor, mirror monitor, replication monitor and Failover Cluster manager. Identifying and resolving Blocking and Deadlocking Lock issues by using Activity Monitor, System stored procedures and Profiler. Monitoring and troubleshooting server performance by using Performance Monitor, DMV's and Perfmon. Experience on configuring and troubleshooting Always On AG in SQL Server. Configuring and troubleshooting snapshot, transactional, merge replication. Experienced applying service packs, Hot Fixes, Cumulative updates in standalone, cluster production environments. Experience on automation using PowerShell. Experience on taking backup and restore using Litespeed and Commvault tool. Comfortable using stored procedures, Views, T-SQL codes, queries, queries DMV and DBCC. Creating rebuilding and reorganizing different types of indexes. Restoring system databases as they meet corruption and restoring user databases. Good experience in system databases SSMS Memory CPU and Disaster recovery. Follow the SLA and ITIL process for changes and all tickets, Service requests from clients. Experience on Installing and configuring SSAS SSIS and SSRS
Technologies: SQL Server and cloud
Industry: Corporate Management
Project 2
October-2020 to June-2021
Description
Design, implement and administer databases on MS SQL Server 2014/2016/2017/2019 platforms for OLTP Migration of SQL Server Instances from 2008 R2/2012/2014 to, 2016/2017/2019. Migrating on-premises SQL Server Database to Azure cloud Implemented new SQL Server features by performing successful POCs Experienced in providing analysis on High availability/Disaster recovery & scalability Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) Experience in managing Very Large databases (VLDB) and troubleshooting problems Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues Use of Query Store feature for monitoring performance of database systems Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc., Have Good understanding experience on different RAID levels
Roles and Responsibilities
Design, implement and administer databases on MS SQL Server 2014/2016/2017/2019 platforms for OLTP Migration of SQL Server Instances from 2008 R2/2012/2014 to, 2016/2017/2019. Migrating on-premises SQL Server Database to Azure cloud Implemented new SQL Server features by performing successful POCs Experienced in providing analysis on High availability/Disaster recovery & scalability Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) Experience in managing Very Large databases (VLDB) and troubleshooting problems Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues Use of Query Store feature for monitoring performance of database systems Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc., Have Good understanding & experience on different RAID levels
Technologies: SQL Server and Cloud
Industry: Corporate Management
Project 3
May-2019 to September-2020
Description
i have over all experience in the cloud and sql server enthronement like cloud and migration tools, Involved on Installing and configuring SSAS, SSIS and SSRS
Roles and Responsibilities
Involved in installing SQL Server Involved installing service pack cumulative updates, and hot fixes. Creating logins and mapping logins to DB and granting permissions at server and object level. Fixing orphaned users through sp help rev login stored procedure. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper. Schedule and maintain routine jobs alerts and maintenance plans. Restoring the backups users and system DBs as needed. Implemented HADR options such as log shipping clustering, mirroring and Always On AG. Configuring and troubleshooting snapshot transactional and merge replication. Creating indexes on tables to improve the performance as per the Dev App team request. Technical troubleshooting gives consultation to development teams. Tracking the locking issues including deadlocks blocking and lock timeouts. Monitoring disk space of all the servers and freeing up the space as per the requirement. Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools. Reviewing SQL Server Error log and Event viewer Performing disaster recovery test on a Quarterly basis. Ensuring process documentation is updated on regular basis Involved on Installing and configuring SSAS SSIS and SSRS
Technologies: SQL server and cloud
Industry: Corporate Management
Project 4
February-2018 to April-2019
Description
Infosys limited Productiva info tech Solution Bengaluru, KA SQL Server DBA and Cloud
Roles and Responsibilities
Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools Maintenance tasks like index defragmentation or rebuild 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. Identifying/resolving fragmentation resulting in improved performance. Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication, clustering and Always ON. Having experience on rebuilding master database during crash situations 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. Working with Transaction replication installation and maintenance. Enrolling users, controlling, and monitoring User Access to the database, and maintaining system Doing Weekly Refresh of Database from Production to Test Environment. Configuring the Transaction replication in production environment. Good experience in performing the Log Shipping and Mirroring in Production environment. Performed various Databases up gradations and server migrations. Good Experience in Applying the DR activities using Backup and restore and log shipping. Participating in on-call rotation and working occasionally after hours or on weekends
Technologies: SQL Server DBA
Industry: Corporate Management
Project 5
June-2015 to August-2017
Description
worked on the insurance and retail in Canada Client and rogers communications
Roles and Responsibilities
Involved in installing SQL Server 2008, 2008R2 and 2012. Involved installing service pack, cumulative updates, and hot fixes. Creation of user databases and ensuring file group creations and ideally placing files Creating logins and mapping logins to DB and granting permissions at server and object level. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper. Schedule and maintain routine jobs, alerts, and maintenance plans. Restoring the backups when it needed. Recovering databases from backup in disaster situation. Implemented high availability option such as log shipping, Database mirroring Always On AG Monitoring and maintaining high availabilities options being used in server such as log shipping, Database mirroring and Always-On AG. Creating indexes on tables to improve the performance as per the Dev App team request. Tuning and monitoring performance of the database. Tracking the locking issues, including deadlocks, blocking and locks. Monitoring disk space of all the servers and freeing up the space as per the requirement.
Technologies: SQL Server DBA
Industry: Corporate Management
Project 6
April-2013 to November-2014
Description
Database support at retail corporation at HP Client
Roles and Responsibilities
Involved in installing SQL Server 2005, 2008, 2008R2 and 2012. Involved installing service pack, cumulative updates, and hot fixes. Creation of user databases and ensuring file group creations and ideally placing files Creating logins and mapping logins to DB and granting permissions at server and object level. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper
Technologies: SQL server DBA
Industry: Corporate Management
Work history
Database Cloud Migration Imp Team Lead • June-2021 to May-2024
Description: Design, implement and administer databases on MS SQL Server 2014 2016 2017 2019 platforms for OLTP Migration of SQL Server Instances from 2008 R2 2012 2014 to, 2016 2017 2019. Migrating on-premises SQL Server Database to Azure cloud Implemented new SQL Server features by performing successful POCs Experienced in providing analysis on High availabilityDisaster recovery scalability Good Understanding Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service IaaS, Platform as a Service PaaS and Software as a Service SaaS Experience in managing Very Large databases VLDB and troubleshooting problems Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues Use of Query Store feature for monitoring performance of database systems Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc., Have Good understanding & experience on different RAID levels Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row-level security Building and integrating information systems to meet the company’s needs. Assessing the systems architecture currently in place and working with technical staff to recommend solutions to improve it. Resolving technical problems as they arise. Providing supervision and guidance to development teams. Continually researching current and emerging technologies and proposing changes where needed. Informing various stakeholders about any problems with the current technical solutions being implemented. Assessing the business impact that certain technical choices have.
Senior database administrator • October-2020 to June-2021
INetFrame Technologies pvt Ltd
Description: Design, implement and administer databases on MS SQL Server 2014 2016 2017 2019 platforms for OLTP Migration of SQL Server Instances from 2008 R2 2012 2014 to, 2016 2017 2019. Migrating on-premises SQL Server Database to Azure cloud Implemented new SQL Server features by performing successful POCs Experienced in providing analysis on High availability Disaster recovery scalability Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service IaaS, Platform as a Service PaaS and Software as a Service SaaS Experience in managing Very Large databases VLDB and troubleshooting problems Implemented Extended Events to replace custom scripts for monitoring troubleshooting issues Use of Query Store feature for monitoring performance of database systems Scripting PowerShell to automate database Server level activities like monitoring disk space, Status of services etc Have Good understanding & experience on different RAID levels Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row level security Building and integrating information systems to meet the company’s needs. Assessing the systems architecture currently in place and working with technical staff to recommend solutions to improve it. Resolving technical problems as they arise. Providing supervision and guidance to development teams. Continually researching current and emerging technologies and proposing changes where needed. Informing various stakeholders about any problems with the current technical solutions being implemented. Assessing the business impact that certain technical choices have.
Senior database administrator • May-2019 to September-2020
Productiva info tech Solution
Description: Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools Maintenance tasks like index defragmentation or rebuild 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. Identifying resolving fragmentation resulting in improved performance. Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication, clustering and Always ON. Having experience on rebuilding master database during crash situations 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. Working with Transaction replication installation and maintenance. Enrolling users, controlling, and monitoring User Access to the database, and maintaining system Doing Weekly Refresh of Database from Production to Test Environment. Configuring the Transaction replication in production environment. Good experience in performing the Log Shipping and Mirroring in Production environment. Performed various Databases up gradations and server migrations. Good Experience in Applying the DR activities using Backup and restore and log shipping. Participating in on-call rotation and working occasionally after hours or on weekends
Microsoft SQL Server DBA • February-2018 to January-2019
Magna info tech and Capgemini
Description: Performance tuning using activity monitor, custom sql codes, SP who and who2 active, sqldiag, DMV's, sql profiler, perfmon, index tuning wizard and query analyzer. Responsible for installation of SQL server instances, and for general database maintenance (creating and modifying in-house written and wizard generated maintenance plans, monitoring the state of databases using DBCC utilities and DMV’s. Set up and supported log shipping, replication transactional and database mirroring that were used for failover and DR purposes. Provided physical database design suggestions, and technical support for the development staff. A major part of this work involved performance tuning, including index design and suggestions on how to recode SQL statements as well as general problem solving of setup and operational issues. Working on various ticketing tools for various clients within the shared support team. Monitoring multiple ticketing queues. Mainly worked for finance and insurance division on this share account. Troubleshooting SQL Server service outages as they occur. Track and resolve database related incidents and alerts within client service levels SLA by following incident management procedures Responding to client email requests. Refreshing of databases based on the client request from PROD to UAT, DEV Test environments. Participating in change management processes including deploying database changes in all environments as requested, following client change management standards and procedures Performing SQL Server installations, upgrades, migrations, and patching Monitoring and tuning SQL Server database performance Mentoring, instructing, and providing guidance to lower-level team members Participating in on-call rotation and working occasionally after hours or on weekends
senior operation professional SQL DBA • June-2015 to August-2017
IBM India Private Limited
Description: Involved in installing SQL Server 2008, 2008R2 and 2012. Involved installing service pack, cumulative updates, and hot fixes. Creation of user databases and ensuring file group creations and ideally placing files Creating logins and mapping logins to DB and granting permissions at server and object level. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper. Schedule and maintain routine jobs, alerts, and maintenance plans. Restoring the backups when it needed. Recovering databases from backup in disaster situation. Implemented high availability option such as log shipping, Database mirroring Always On AG Monitoring and maintaining high availabilities options being used in server such as log shipping, Database mirroring and Always On AG. Creating indexes on tables to improve the performance as per the Dev App team request. Tuning and monitoring performance of the database. Tracking the locking issues, including deadlocks, blocking and locks. Monitoring disk space of all the servers and freeing up the space as per the requirement.
Database support • April-2013 to November-2014
Magna info tech and HP
Description: Involved in installing SQL Server 2005, 2008, 2008R2 and 2012. Involved installing service pack, cumulative updates, and hot fixes. Creation of user databases and ensuring file group creations and ideally placing files Creating logins and mapping logins to DB and granting permissions at server and object level. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper
Certifications
SQL Server DBA by SQL Server 2016
2022
Azure Cloud by SQL Serer and azure cloud DP 300
2023
Education
Masters degree in MBA System and HR
Anna university
2010 to 2012
Language
English - Advanced