
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
-
SQL Server Database Administrator Specialist
1 month ago
RBC Toronto, OntarioRBC is looking for an experienced SQL server DBA specialist with minimum of 10+ years of working experience. · Lead in the support of database and transaction management technology and it's deployment and usage standards. · ...
-
database administrator
1 week ago
SOFTLINE TECHNOLOGY Toronto, ONThe position involves delivering successful delivery and completion of internal initiatives, OPS Plan FY 25-26 projects, incident management, problem management, change management. · ...
-
Database Administrator
1 month ago
Apptoza Inc. Toronto, OntarioWe have a job opening for a Database Administrator role in Toronto. · ...