Kanhiyalal K.

Kanhiyalal K.

A Goal-oriented professional with over 2 decades of experience in Databases for Admin & Architecture

Hyderabad , India

Experience: 3 Years

Kanhiyalal

Hyderabad , India

A Goal-oriented professional with over 2 decades of experience in Databases for Admin & Architecture

36454 USD / Year

  • Immediate: Available

3 Years

Now you can Instantly Chat with Kanhiyalal!

About Me

  • A goal-oriented professional with over 2 decades of experience in Cloud Solutions Architecture for Database
  • Won Information Technology Award for outstanding contributions to ERP Implementation Excellence, 2015 and Marathon Motor &...
  • Conferred with Information Technology Award for Outstanding Contributions in, Regal Beloit Corporation
  • Supervised all corporate Oracle instances including an Oracle Data Warehouse of over 500 DB servers
  • Strong Technical Leader set the direction for the team and guides the team in designs, system architectures and drive technically on a day to day basis.
  • Spearheaded and grew the DBA practice for the Global Technology Center of India – Global Service Delivery group for Regal Beloit Corporation (RBC)
  • Worked on RBC manufacturing BU to automated the application software, industrial automation and industry 4.0 for iOT
  • AWS Certified Solutions Architect Professional & Azure Solutions Architect Expert with 4 years Architecture and Designed High Availability, Disaster Recovery for business application, databases, modernize application on Cloud environment
  • Considerable expertise in integrating AWS cloud services integrated with on premise Oracle applications.
  • Hands-on-experience in analyzing information system needs, evaluating end-user requirements, custom designing solutions &  troubleshooting for complex information systems

Show More

Skills

Data & Analytics

Mobile Apps

Networking & Security

Graphic Design

Portfolio Projects

Database Migration workload to Azure

Company

Database Migration workload to Azure

Description

 

 

Client:        Deloitte Cloud Services
Role:        Database Cloud Architect 
Title:        Database Migration workload to Azure

Period:        Nov’19– Nov’20

  • Assess database using tool Azure Migrate: Database Assessment and and migrate using tool Azure Migrate: Database Migration
  • Azure migration strategies consideration of On-premises server specification, IaaS Linux VMs specification, storage, database and network specification, refactor for to moving a business-critical application, hybrid & multitenant architecture
  • Exposure to security models, tenant isolation, encryption at transit, encryption in rest, key management, vulnerability assessments, application firewalls, SIEM, etc.

Show More Show Less

Skills

Azure Encryption

Database System Migration to AWS cloud

Company

Database System Migration to AWS cloud

Description

Client:        Anthem Inc.
Role:        Database Cloud Architect - AWS
Title:        Database System Migration to AWS cloud

Period:        Jun’19– Nov’19

        
DR and Database Support

-    Architectural application migration experience to AWS Cloud, Well versed with DB migration techniques to cloud and best practices for HA/DR strategy for large complex migrations
-    Proficient in RDS concepts including database design, querying, performance tuning Identifying Workload-Specific Database to design and select appropriate database services for specific types of data and workloads 
-    Determine strategies for disaster recovery and high availability, Designed database solutions for performance, compliance, and scalability
-    Compare the costs of database solutions 
-    Deployment, Migration & Automate database solution deployments, determine data preparation and migration strategies
-    Execute and validate data migration, determine maintenance tasks and processes
-    Determine backup and restore strategies, manage the operational environment of a database solution 
-    Determine monitoring and alerting strategies, Troubleshoot and resolve common database issues
-    Optimize database performance, Database Security such as Encrypt data at rest and in transit
-    Evaluate auditing solutions, determine access control and authentication mechanisms
-    Recognize potential security vulnerabilities within database solutions
-    Architect database for Dynamo DB, AWS Amazon Aurora considering high-availability, Disaster Recover and fault-tolerant architectures
-    Determine & Provided solution for how to design a multi-tier architecture 
-    Architect solutions for elasticity and scalability Backup and Recovery Approaches Using AWS
-    Architect Database DR Using AWS Regions considering RPO and RTO for Business Continuity as per SLA
-    Assist migration team to Application Database to Amazon RDS
-    Worked on Migration Web application to Amazon and keep Oracle Database in On-premise
-    Worked on Migration your Oracle Database to Amazon Aurora and cross regional replication.
-    Have a fair understanding of how to architect an ERP environment from scratch. From CPU, storage, memory sizing and DB configuration parameters.
 

Show More Show Less

Oracle DB deployment

Company

Oracle DB deployment

Description

Client:        Microsoft Corporation
Role:        Principle Consultant – Oracle Solution Architect
Title:        Oracle DB deployment

Period:        Sep’18– Jan’19

-    Design solutions for Oracle DR & HA on Azure IaaS
-    Technical Solution design to Oracle Database Upgrade & Migrate to Azure on Oracle Enterprise Linux Responsible for coordinating support activities for technical issues that occur with the underlying iaaS, such as Oracle Databases, Connectivity issue with Application, Azure Compute, managing storage, Azure Networking etc.
-    Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing.
-    Oracle grid installation/ASM Configuration, Oracle Installation, Data Guard configure, Data Migration
 

Show More Show Less

Motion Control Systems

Company

Motion Control Systems

Description

Client:        Regal Beloit Corporation
Role:        Architect – IT 
Period:        Feb’18– May’ 18
Project:        Motion Control Systems

-    Architect database for AWS Amazon Aurora considering high-availability, Disaster Recover and fault-tolerant architectures
-    Design solutions for Database Backup and Recovery Approaches Using AWS
-    Assist migration team to Application Database to Amazon RDS
-    Worked on Migration Web application to Amazon and keep Oracle Database in On-premise
-    Worked on Migration your Oracle Database to Amazon Aurora and cross regional replication.
 

Show More Show Less

Oracle Database Migration on AWS

Company

Oracle Database Migration on AWS

Description

Client:    Regal Beloit Corporation 
Period:        May’16– Dec’16
Highlights:

-    Provided support in production, development and administration
-    Prepared and delivered cross-region snapshot, database snapshot to a different AWS region
-    Led the automation of patch management for Oracle Database under EC2
-    Worked on Cloud Computing AWS EC2, RDS, Data Migration Service (DMS), Schema Conversion Tool (SCT) 
-    Configuration of ETL ecosystems and perform regular data maintenance activities such as data loads, data fixes, schema updates, database copies
-    Redshift Database design using distribution style, sorting, encoding features
-    Developed design of DR as per the Service level agreement using RTO and RPO concept
-    Managed tablespaces and monitored the space of data files, resized and added new data files, creating tables paces, rollback segments, user maintenance, database security imposition by creation and granting of roles & privileges, performance tuning, backups, tuning of SQL statements and support for Oracle toolsets and utilities
-    Supervised the set-up of test servers on Amazon for Oracle E-Business Suite R12 and Oracle 11g databases using AMIs
-    Configured EC2 & RDS Instances an Oracle Instances and administered an Amazon RDS Instance for Oracle using RDSADMIN utility
-    Performed the migration of database from AWS RDS into Oracle Public Cloud database using Data Pump hosting through Oracle SQL Developer

Show More Show Less

E-Business Support

Company

E-Business Support

Description

Client:    Regal Beloit Corporation 
Period:        Jan’16 – Apr’16

Highlights:
-    Worked for IT development for as Managed operations like refreshes, code migration, data fix, scheduling jobs using Control-M, performance tuning, troubleshooting and Java development framework for to access motion control application 
-    Opening, Managing, and Resolving Oracle SRs (Troubleshoot issues raised by users and provide timely resolutions), via a thorough understanding of Oracle Apps technical environment
-    Worked on Oracle FMW, SOA, WebLogic, Oracle IDM / SSO / OID
-    Responsible for all technical matters related to the Oracle Applications and databases including Patch application upgrades, cloning, refreshes, monitoring and tuning the operating environment, coordinating/executing all code migration
-    Developed patching, cloning and backup strategy for Oracle E-business R12(12.1.3) Databases on Amazon EC2 Cloud
-    Launching Oracle Database 11g instances in AWS, Scaling up and Deployment
-    Migration of Oracle databases using AWS Database Migration Service (AWS DMS) into AWS
-    Deployment & configuration of EC2 & RDS Instances an Oracle Instances
-    On Proof of concept, replicating data from Oracle E-Business Suite Release 12.2 using Oracle GoldenGate
-    Support and Maintenance of Oracle E-Business Suite 12.2.*
-    Initiated guidelines as per the business requirements in Oracle Application R12 upgrade, R12 installation for CWB module, financial, supply chain planning, manufacturing, HRMS and so on
-    Examined all technical matters related to the Oracle Application database including upgrades, cloning, monitoring and tuning the operating environment, coordinating/executing all code migration
-    Provided full applications (11i / R12.1.*) support, including Installation and Cloning of Applications
 

Show More Show Less

Database Support

Company

Database Support

Description

Period:        Jul’13 – Dec’15
Highlights:
-    Supervised the set-up of OEM 13c for database monitoring/performance/diagnostics
-    Examined AWR, ASH and ADDM, Analyzing, Capacity Planning 
-    Upgraded oracle databases and launch into to production environment
-    Installed and configured OGG from DB(Source) to new Oracle RAC Database. Setup of 4 Node RAC DB
-    Conducted performance tuning through OEM SQL Profile, AWR and ADDM
-    Developed primary structures such as table spaces, Schema, tables and indexes and DB Links
 

Show More Show Less

Skills

AWR SQL

Fusion Middleware Support

Company

Fusion Middleware Support

Description

Period:        Jun’10 – Jul’13

Highlights:
-    Configured and integrated Oracle Access Manager & Web Gates
-    Installation & Configuration   of Discoverer, Integration with SSO/OID
-    Installation & Configuration of Oracle BI 12c and integration with SSO/OID
-    Deployment of RPD through Enterprise Manager, Fusion Middleware Administrator Console
-    Worked closely with BI Development team and Proactively worked on Capacity Management 
-    Led the migration of both 10g OSSO (Oracle’s old Single Sign-On) and 10g OAM to new 11gR2 Oracle Access Manager including integration with Portal, E-Business Suite (R12) using OIM Connectors
-    Implemented most complex and highly available systems (Active-Active Cluster) including disaster recovery
-    Assisted in the migration of 10000+ users to Courion Identity & Access Management and integrated with Oracle 10g Application Server, Maintained Password policy as per the business requirements

Show More Show Less

Fidelity Investment International

Company

Fidelity Investment International

Description

Role:        Senior Oracle DBA
Period:        May’09 – Aug’09
Environment:       AIX, Solaris, Windows 
Database:              Oracle 9i,10g,11g, Data Guard, SQL Server, DB2, Sybase, Oracle 11g RAC, RMAN, ASM,     SQL*Loader, Data Pump, OEM (Grid Control), Golden Gate    

Show More Show Less

Oracle On-Demand Tier 1, Tier 2 & Tier 3 Customers

Company

Oracle On-Demand Tier 1, Tier 2 & Tier 3 Customers

Description

Role:        Technical Analyst - Capacity Management
Period:        Jul’06 – Apr’09
Environment:    MS Windows 2000/XP, Unix (Linux, HP, IBM, SUN, AIX), IBM (OS/390)
Database Software: Oracle 9i, 10g, 11g, Real Application Cluster, Oracle Enterprise Manager, Data Guard
ERP Applications:  E-Business Suite (11.5.5, 11.5.8, 11.5.10, R12), PeopleSoft Enterprise, Siebel 7.5.2, Hyperion, Oracle Fusion, Application Integration Architecture & WebLogic
Middleware:    Application Server, Identity Management, WebLogic Server, Fusion Middleware

Show More Show Less