
Mohanraj Senthamizhselvan
Engineering / Architecture
About Mohanraj Senthamizhselvan:
MS SQL Database administrator with 7+ years of professional experience in managing various versions of SQL server databases as a DBA and around 2 years of experience in server operations of total 9+ years in the IT industry. Outstanding knowledge on process related matrix - manages SQL Server databases through multiple product lifecycle environments, from development to critical production systems. Solid work experience in managing large databases, backup/ recovery, configuring and managing HA solutions, managing reports using SSRS, deploying ETL packages in SSIS, Performance tuning & optimizing, configuring the SQL standalone & cluster environments.
Cloud / Azure experience includes Azure services which create SQL server on windows Virtual machine in the Azure portal, migrate SQL databases from premises to Azure SQL database using Microsoft Data migration assistant, setup development and test environment on Azure
Experience
- Technical skills & Summary:
Expertise in installation/migration/up-gradation on SQL Server versions (2008/2008R2/2012/2016/2017)
SQL server Capacity planning & performance management understanding the existing hardware and software platform to meet the business needs
Configuring & troubleshooting in SQL server High Availability & disaster recovery solutions like Log shipping, Replication, Clustering (Active/Active & Active/Passive), Always ON.
Good knowledge on SQL performance tuning – Slow running queries using DMV’s, Extended events, SQL profiler, Database tuning advisor, Blockings, CPU, Memory utilization, Indexing
Experience in latest features like Query store, Automatic performance in SQL 2017 versions.
Migration : Upgrade SQL Server from legacy to latest versions, In-place & side by side migrating the databases, applying latest patches to SQL server
Manage backup & planning larger databases to restore in SQL Clustering & Always on availability group servers
Install and configure the TDP backups and outstanding knowledge on managing Backup & Restore methods using IBM Tivoli TDPSQL Backup tools (Scripts & GUI)
Expertise knowledge in configuring the TDE (Transparent Data encryption) at HA databases, SSL encryption at network layers for Payment Card Industry Data security. Backup and restore encrypted databases by creating master key & encryption certificates from one server to another.
Vast experience in client / server connectivity (checks TLS, telnet status, TCP/IP , LAN, SPN registration) and windows / network troubleshooting issues
Cloud/Azure : Good exposure and knowledge on Azure cloud services, creating new VM on Azure and deploying SQL, migrating from SQL server on VM to Azure SQL database using DMA tool and other methods
ETL\SSDT\Reporting: Install and configure SSRS, SSIS, Power BI report server. Integrate SSRS reports with Power BI, SQL server reporting services(SSIS) and deploying Integration service packages (SSIS)
Knowledge in creating SSIS ETL packages, SSRS reports through visual studio and worked along with application team to configure in production servers
Monitoring & Ticketing tools : Service now ( Changes /Incidents /RITM/) , SCOM & Solarwinds
Education
Bachelor of Engineering in Computer science
Professionals in the same Engineering / Architecture sector as Mohanraj Senthamizhselvan
Professionals from different sectors near Mississauga, Ontario
Jobs near Mississauga, Ontario
-
Database Administrator
1 day ago
CloudVital TorontoWe are looking for an experienced DataOps/Cloud Engineer to join our team. · We need someone with expertise in designing and developing data/database CI/CD pipelines, · designing logical and physical data models using Sybase Power Designer, · and provisioning data in cloud enviro ...
-
Database Administrator
3 weeks ago
Insight Global TorontoInsight Global is looking for a Database Administrator to join a leading Courier and Logistics customer in Mississauga. · ...
-
Database Administrator
1 week ago
Russell Tobin TorontoWe are seeking a Senior Oracle DBA to manage and support Oracle database environments ensuring high availability performance security. · Administer Oracle DB environments including 12c/19c/21c+ RAC Exadata GoldenGate and multitenant architecture. · Perform database upgrades patch ...