Abinas Roy

About Abinas Roy

Highly experienced Senior Oracle DB/Mongo/Python/AWS/GCP/Ali Cloud/Vertica/Cockroach…

Experience

1. Senior Db Engineer Sre

   Apple

   Sep 2013 — Present

   Oracle Database /AWS RDS/Kubernetes/mongo/Mysql/Vertica/SRE/DevOps NoSQL Certified professional (OCP) • AWS/GCP Cloud DB migration, Expert skills in Oracle RDBMS (21C/19C)/ASM/OCFS/CFS Installation, RAC Database Creation, Performance Monitoring & tuning and Database maintenance procedures using PL/SQL programming, VERITAS Cluster and Shell scripts.\\\\n\\\\n• Managing and maintaining Mongo DB/NO SQL DBS on AWS EC2/Kube EKS across multiple environments. Implement and maintain MMS (MongoDB Management Services).Monitor deployments for capacity and performance.In-depth understanding of MongoDB HA strategies, including replica sets and sharding. Deep knowledge of DB performance/scaling concepts and tuning best practices\\\\n\\\\n. Experience in working with Oracle Exadata and DNFS Oracle RAC clusters.\\\\n• Experience in Building 12c/11g/10g Oracle RAC databases clusters in the production environment.\\\\n• Experience in Building Flash Cache-based database using Fusion-IO • Experience in Building 16 nodes ORACLE RAC Cluster with ASM file System, RDS, InfiniBand, EMC multipath, Linux Device Mapper-Multipath.\\\\n• Good understanding of oracle internal stacks like Cache Layer, Transaction Layer, Data Layer, etc.\\\\n• Good understanding of Netapp/EMC snapshot • Good understanding of ASM internal stacks like physical metadata and virtual metadata\\\\n• Experience with OEM 12C Grid/agent configuration to monitor Oracle database.\\\\n• Expert skills in Oracle RDBMS (11g/10g)/ASM/OCFS/CFS Installation, RAC Database Creation, Performance Monitoring & tuning, and Database maintenance procedures using PL/SQL programming, VERITAS Cluster, and Shell scripts.\\\\n• Experience in working with high availability Database using MC/Service guard, VERITAS cluster environment\\\\n• Oracle Golden gate/Stream for table and Schema level replication\\\\n• Extensive knowledge of Oracle functionality & internals.Strong analytical and debugging skills.TDE, Advanced Compression & Dataguard\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n

Skills

• Disaster Recovery
• Itil
• Replication
• Operating Systems
• Etl
• IT Service Management
• Performance Tuning
• Shell Scripting
• High Availability
• Soa
• Oracle Asm
• Oracle Sql
• Requirements Analysis
• Hp-UX
• Unix Shell Scripting
• Oracle Rac
• Linux
• Itil Certified
• Database Administration
• Sdlc
• Healthcare
• Enterprise Architecture
• Red Hat Linux
• Pl/Sql
• Informatica
• Oracle Enterprise Manager
• Data Modeling
• Oracle Applications
• Hadoop
• Unix
• Databases
• Data Migration
• Microsoft Sql Server
• Data Warehousing
• Data Integration
• Oracle
• Cluster
• Ssis
• Business Intelligence
• Solution Architecture