Gopal Samy

Background

About Gopal Samy

Skills: Database : MSSQL, DB2 Platform: Linux, AIX, Windows, Tools: Jira, AUTO TASK, Service Now, Spotlight Languages: SQL, Shell Scripting beginning level *Having 6+ years of Experience in SQL SERVER Database Administration.* Installing, configuring, and managing of SQL Server 2019,2017,2016, 2014, 2012.* Configuring Instances and Memory Settings.*Managing SQL user Logins, Database User Accounts, Server Roles, Database Roles, and its Permissions.* Managing Database Backups and Restore activities.* As a DBA professional having a troubleshooting experience in SQL Server database, gathering and analyzing business requirement.* Troubleshoot performance problems, fine-tuning of databases and index Analysis.*Working knowledge in Integration Services (SSIS), reporting services (SSRS).* Experience on 64-bit SQL Server 2019,2017,2016,2014 SQL Server systems and Configurations.* Responsible to configure backup’s jobs and troubleshoot backup issue.* Hands on experience on high availability solutions like Always On, Log Shipping, Database Mirroring.* Experience on Views, Indexes, Stored Procedures, Functions and Triggers. DB2: Install DB2, create instance and build new DB Backup and recovery Export, Import and Load Extend tablespace whenever required Perform online and offline reorg, runstats Create shell scripts for automating basic database administration activities DB2 version upgrade and fixpack updates Automation of repetitive tasks using shell scripting. Day to day monitoring activities and support. Monitoring weekend maintenance jobs and analysing.