Kaushik Sankaran

About Kaushik Sankaran

Senior Systems Engineer with 10+ yrs of expertise in technical and well as managerial work with clients from across various geographies. Happy to work together on technology challenges, designs and improvements.Have been a part of the transition for the entire project from end to end. Earned certificates of excellence/accolade awards for my performance in my team.Experienced in working as an Oracle Database Administrator and Cloud DBA focused on key aspect of Database Administration of the Client\'s databases. It\'s a challenging role has given me immense responsibility and learning experience.A passionate Football enthusiast. Always eager to explore new technologies and optimize data management strategies. I’m always interested in hearing from former colleagues, managers, or just interesting creative folk, so feel free to connect.

Experience

1. Senior Database Administrator

   TIAA

   Mar 2023 — Present · Mumbai, IN

   Oracle:• Monitoring and troubleshooting OEM alerts.• Administering Exadata machines, raising SRs, and coordinating patching with Oracle.• Monitoring and troubleshooting daily backups and exports.• Performing DB installation, upgrades, patching, and restoration.• Performance monitoring, tuning, and optimization.• Implementing TDE encryption on databases (prod and non-prod).• Managing Data Guard databases, performing switchover and failover via SQL and DGMGRL.• Managing tablespaces (adding, resizing, and removing data files).• Performing cloning and restoration of database through Delphix. Performing Roll back and Roll forward of database when required.• Cloning and restoring databases with Delphix.• Automating tasks with shell scripting.• Monitoring long-running queries, blocking, and locking sessions to resolve performance issues. • Identifying poor performing sqls and pinning best plan, and implementing solutions from tuning advisor.• User administration, including creation, deletion, password management, and locking.• Proactive administration of databases.• Refreshing schemas/tables from production using export/import utilities.Hadoop (CDH/CDP):• Managing Hadoop production and non-production clusters.• Handling user management and permission issues.• Raising Support tickets with vendor and coordinating with them for issue resolution.• Migrating production databases to DR clusters, coordinating with the app team for permissions and scripts.AWS Cloud:• Managing EC2 instances, performing health checks, and restarting instances on failure.• Deploying Aurora DB, and DynamoDB via Terraform and Ansible.• Performing cluster checks, deploying NAS mount points from on-prem to cloud and fixing permissions.• Identity access management.• Deploying Autosys and Electric Flow agents, managing tasks for app teams.• Developing Lambda scripts for cloud automations.• Working with AWS services including S3, IAM, Lambda, EC2, VPC, RDS, Aurora, DynamoDB

Education

• Amrita Vishwa Vidyapeetham

  Bachelor of Computer Application (BCA), Computer Science

  2008 — 2011

Skills

• Leadership
• Pl/Sql
• Hp Business Service Management
• Oracle Enterprise Manager
• Oracle
• Microsoft Excel
• Powerpoint
• Process Improvement
• Microsoft Office
• Sql
• Linux
• Unix
• Microsoft Sql Server
• Oracle Database
• Itil V3 Foundations Certified
• Operations Management