RASU PERIASAMY

Client : Singhealth

• Install, configure, and migrate Oracle and SQL database Servers.
• Upgraded Oracle 10g to 12c and 11g to 19c.
• Handling backup and recovery strategies using RMAN, Datapump, EXP/IMP utilities.
• Creation of Standby databases (Oracle Data guard), monitoring standby sync status with primary.
• Administration & Implementation of physical standby Data Guard for disaster recovery.
• Applying Oracle patches (RU & PSU) periodically during maintenance window.
• Responsible for Database support, troubleshooting, planning ,migration and Patching
• Upgraded Sql Server 2008/2012 to Sql Server 2016/2017 and 2019 versions.
• Monitoring of database size and disk space in Production, Staging & Development environments
• Design, setup and enhance backup policies and tape retention strategy using Data Domain and NetBackup
• Implement TDE encryption in SQL servers.
• Patch database servers periodically during monthly maintenance cycle
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Configured DR techniques like AOAG and FCI
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2008R2/2012/2014/2016/2017/2019.
• Knowledge of using SSRS (SQL Server Reporting Services).
• Updating with latest service packs and security patches.
• Database Activities à Writing Stored Procedures, Functions, Triggers, Views
• Access Rights with multiple roles
• Performed Production support and on Call duties.
• Created monitoring scripts to alert for production issues.
• Job Scheduling and Understanding business thoroughly
• Handled 24/7 Production Issues.

Client : Singtel

• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Created and updated database designs and data models.
• Modified databases to meet needs and goals determined during planning process.
• Install, configure, and migrate SQL database Servers
• Responsible for Database support, troubleshooting, planning and migration.
• Upgraded Sql Server 2008/2008R2 to Sql Server 2012/2014 versions
• Monitoring of database size and disk space in Production, Staging & Development environments
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2008R2.
• Knowledge of using SSRS (SQL Server Reporting Services).
• Updating with latest service packs and security patches.
• Database Activities - Writing Stored Procedures, Functions, Triggers, Views
• Access Rights with multiple roles
• Performed Production support and on Call duties.
• Created monitoring scripts to alert for production issues.
• Job Scheduling and Understanding a business thoroughly
• Interface Modules were covered through Stored Procedures
• Assembly Functions using a DLL for Mail & SMS concepts were handled.
• Handled 24/7 Production Issues.

Client : Daikin

• Performed server installation and configurations for SQL Server 2008 and SQL Server 2012..
• Scheduled Full and Transactional log backups for user created and system databases in production environment using Database Maintenance Plan Wizard.
• Created transactional replication for reporting applications.
• Implemented disaster recovery solution at remote site for production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update index statistics on production databases.
• Used System monitor to find bottlenecks in CPU, Disk I/O and memory devices and improved database server performance
• Used SQL Server Profiler to monitor and record database activities of particular users and applications
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Database Activities- Writing Stored Procedures, Functions, Triggers, Views
• Access Rights with multiple roles
• Assembly Functions using a DLL for Mail & SMS concepts were handled.
• Master data processing provided by client and Checking quality and correctness of data and finally pulled data into respected tables by using stored procedures
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Created and updated database designs and data models.
• Modified databases to meet needs and goals determined during planning process.

Client : Diversified Air Systems

• Technologies : SQL Server 2008R2/2012, Responsible for installation , configuring, migration, upgradation, maintenance, and daily operation of MSSQL Server
• Roles & Responsibilities
• Performed server installation and configurations for SQL Server 2008 and SQL Server 2012.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Scheduled Full and Transactional log backups for user created and system databases in production environment using Database Maintenance Plan Wizard
• Created transactional replication for reporting applications
• Implemented disaster recovery solution at remote site for production databases using Log Shipping
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update index statistics on production databases
• Used System monitor to find bottlenecks in CPU, Disk I/O and memory devices and improved database server performance
• Used SQL Server Profiler to monitor and record database activities of particular users and applications
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance
• Implemented trigger and stored procedures and enforced business rules via checks and constraints
• Database Activities Writing Stored Procedures, Functions, Triggers, Views
• Access Rights with multiple roles
• Assembly Functions using a DLL for Mail & SMS concepts were handled
• Master data processing provided by client and Checking quality and correctness of data and finally pulled data into respected tables by using stored procedures.
• Built databases and table structures for web applications.
• Set up and controlled user access levels across databases to protect important data.
• Developed scripts and processes for data integration and maintenance.