Target is US based retail organisation. Working as Lead in Oracle Database Build & Engineering Team - Scrum & Agile methodology working model, escalation handling, mentoring. Building high performing, highly available databases on commodity and Exadata Hardware. Maintaining & supporting mission critical database environment. Planning, consultations & performing POC/SOP and driving projects.New application on-boarding - OLTP and DataWarehouse Databases - physical model, schema design… Show more Target is US based retail organisation. Working as Lead in Oracle Database Build & Engineering Team - Scrum & Agile methodology working model, escalation handling, mentoring. Building high performing, highly available databases on commodity and Exadata Hardware. Maintaining & supporting mission critical database environment. Planning, consultations & performing POC/SOP and driving projects.New application on-boarding - OLTP and DataWarehouse Databases - physical model, schema design. compression, partition & purging strategy. Capacity planning - Compute Hardware and Storage.Performance tuning - Instance/SQL tuning, AWR, ASH, SQLMonitor. Planning database Life Cycle Management roadmaps - install/upgrades/migrations.Programming/Automation - SQL, Shell Script, Python, Flask, REST API, Chef cookbook. Web tool creation using Python-Flask as backend and Javascript/React as front end. Version Control - Git, GitHub. Deployment with Docker Containers.Monitoring & Alerting setup for DB & Exadata environment using Oracle Enterprise Manger and shell scripting that sends ticket to Service Now tool. Creating reports using OEM BI Publisher interface. Show less

Provide technical support to global customers through Service Requests(SR) as part of the Global Customer Support(GCS) organisation. Have worked in RAC, Security and SQLNET team. Oracle RAC performance tuning - Global Hanganalyze, System State dump, Enques/Deadlocks, GC wait event, AWR & ASH report, sqltrace & tkprof analysis. Oracle RAC, Grid Infrastructure - installation, patching, upgrade, Node/Instance evictions and cluster log analysis. Shared Storage Configuration with… Show more Provide technical support to global customers through Service Requests(SR) as part of the Global Customer Support(GCS) organisation. Have worked in RAC, Security and SQLNET team. Oracle RAC performance tuning - Global Hanganalyze, System State dump, Enques/Deadlocks, GC wait event, AWR & ASH report, sqltrace & tkprof analysis. Oracle RAC, Grid Infrastructure - installation, patching, upgrade, Node/Instance evictions and cluster log analysis. Shared Storage Configuration with ASM, ASMLib and rawdevice.Oracle Security - Authentication with SSL, Kerberos and Radius. Oracle Wallet Management (OWM) - PKCS12, PKCS11(Hardware Module), mkstore, orapki. Enterprise User Security with Active Directory and Oracle Internet Directory. TDE, Database Vault and Audit Vault.Oracle Net - tnsnames/ldap, listener configuration. TAF, FAN and Load Balancing/Failover configuration. SQLNET trace analysis, tcpdump network packet analysis, Dataguard configuration.Have played Knowledge Base lead role for database security domain. Creating and maintaining articles and keep it updated, participate in community forum discussions, conduct in-depth technical sessions.Technical Session Conducted: Introduction to TCP/IP. Analysing Network Packets with Packet sniffer software. Introduction to IPv6. Oracle Advanced Security Options(ASO). Oracle Audit Vault. Show less

Network Operating Center - Network nodes such as servers, switches, routers, WAN links, etc are monitored through SNMP architecture. Upon receiving alerts, troubleshoot network device and link failures and fix the issues.Technical Sessions Conducted: - DNS architecture on the Internet.

Client: Commercial Tax Department, Bangalore. - I worked as System Administrator at client, administering Data Center operations and IT infrastructure - Windows, Linux Servers, Cisco switches and Routers.

Client: ING Vysya Life Insurance, Combatore.- This was my first job, I got opportunity to setup new branch office - installation of desktops, printers, windows servers, Cisco switches and routers. - Windows domain configuration, DNS and DHCP services.