Nishan Kath
Summary
12 years 1 month of experience as a Database Administrator in Oracle and MS SQL Server. Extensive experience in relational database design, analysis, development, administration, implementation, performance tuning and troubleshooting. AWS Certified Solution Architect Experience in managing databases on Amazon cloud e.g. EC2 and RDS instances. Extensive experience in database migrations from on-premise to AWS cloud environments. Streamline database related tasks for smooth database operations and proactively monitoring performance degrading queries. Automating database related tasks using Shell Scripting. Get-it-done personality.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Cloud Database Administrator
ION Trading India Pvt Ltd
02.2015 - Current
- Cloud database migrations: Handling multiple homogenous and heterogeneous migrations for client databases from 3rd party infra vendor to Amazon and Azure cloud
- The work involves resolving major migration challenges during go-live e.g
- Making the Go Live possible in a minimum downtime window
- Installation/Upgradation/Patching: Setting up new Oracle and MSSQL databases for new clients
- Planning database upgrades and regular patching to secure databases from vulnerabilities on EC2 and RDS instances
- Implementing/Managing Disaster Recovery: Setting up Disaster Recovery Solutions for Oracle and Sql Server databases using Dataguard, Logshipping, Always On High Availability, BAG etc
- Periodically carry out DR test activity with customers making sure that RTO and RPO are met
- Backup and Recovery: Creating a backup strategy for Oracle and SQL Server databases
- Using various tools like RMAN, Data Pump, Sql server jobs, RDS snapshots, mysqldump to take backups
- Periodically restoring random old database backups to check the validity of the backups
- Performance Tuning: Resolving Oracle performance cases using database internal views
- Making use of Oracle utilities like AWR, ASH, SQLTRPT, Sql Monitor Report, etc to look for issues
- Fixing bad sql execution plans using Sql Profile and Baselines for better query execution
- Diagnosing Sql Server performance issues using Query Store
- Proactive analysis of Oracle plan changes by creating a monitoring job
- Miscellaneous Tasks: Keeping the business up and running by resolving run-time database-level issues
- Performing database restores in Oracle, MySql and MSSQL using RMAN, Data Pump, RDS Snapshot restore, SSMS and mysqldump
- Performing capacity planning as per future database growth
- Setting up maintenance jobs on all database platforms
- Setting up alerting in Oracle, MSSQL and Aurora MySql databases to monitor database jobs
- Managing database security by keeping user authorization in check
- Creating SOP’s, RCA guides and other important documents
- Automating various database tasks by creating Shell Scripts.
Senior Analyst
HCL Technologies
06.2012 - 02.2015
- Handling 3000+ databases running on London, New York and Frankfurt servers
- RMAN-Managed Backup and Recovery
- Online/Offline backup and Exports/Imports of the data
- Creating and analyzing AWR Reports
- Using Auditing Session & Access Auditing, Auditing by User
- Maintaining user Accounts, profiles and security privileges (user creation grant & revoking roles, permissions)
- Refresh through Export/Import utilities
- GCM: Global Change Management was generally used for critical production changes which required several businesses, technology and implementer approvals for implementing changes
- SR: Service Requests used to carry changes on development databases DB Symphony: A tool that shows auto alerts generated by TIVOLI
- Auto alerts were worked upon using the tickets generated by the TIVOLI tool
- Trackers: Certain trackers were being maintained to keep track of various data and backup mount point-related issues so as overcome the low space availability.
Education
Bachelor of Technology -
Lovely Professional University
05.2012
Skills
- SQL Performance Tuning
- Cloud Database Migrations
- Oracle Database Administration
- Microsoft SQL Server Database Administration
- Team Management
- AWS Solutions Architect
- Database Upgrades and Patching
- Cloud Database Administration
- Capacity Planning
- Automation via Scripting
- Database Cloning
Certification
- AWS Certified Solutions Architect
- Oracle Certified Associate
Custom
- A new client project was being set up on the SQL Server database. Having zero knowledge of SQL Server, I architected and created SQL Server database from scratch keeping client and application needs in check. I was quick to learn the new database technology and was able to support business needs. I also worked on new DR methodologies and successfully implemented them.
- Have received praise from the company CTO for resolving a business-critical performance issue for one of the biggest OpenLink client.
Timeline
Cloud Database Administrator
ION Trading India Pvt Ltd
02.2015 - Current
Senior Analyst
HCL Technologies
06.2012 - 02.2015
Bachelor of Technology -
Lovely Professional University
Similar Profiles
Mithlesh KumarMithlesh Kumar
Senior DevOps Engineer at ION Trading India Pvt. LtdSenior DevOps Engineer at ION Trading India Pvt. Ltd
Sachin RajSachin Raj
Senior IT Specialist at ION Trading India Pvt. LtdSenior IT Specialist at ION Trading India Pvt. Ltd
Naveen BaghelNaveen Baghel
Consultant at ION Trading India Pvt LtdConsultant at ION Trading India Pvt Ltd