Heta Goda
Database Specialist @50hands Organization
Signup · Get unlimited contacts
WORK HISTORY
Database Specialist @50hands Organization
Mississauga, ON, CA
EDUCATION
Saurashtra University
Bachelor's degree, Computer Science
ABOUT HETA GODA
Over 9+ years of experience on large scale 24x7, daily 50K transaction databases like Oracle 12c/11g/10g/9i RAC, SQL Server 2012/2008, PostgreSQL 9.4/9.1 and MySQL database in Windows/Linux/Unix operating systems.•Experience on installation, configuration, conversion (patch), deployment, migration, maintenance, database administration, Data analysis, troubleshooting on different RDBMS database technologies.•6+ years of experience in Data Migration(up to 1 Tbs) from Oracle->Oracle, Oracle->SQL Server, SQL Server->Oracle, Oracle-> PostgreSQL, MySQL-> Amazon RDS (Cloud Migration) and SQL server-> Azure.•Expertise on Data Replication, logical/Physical backup using RMAN, Disaster Recovery using RMAN/ Oracle Data Guard, physical/logical storage, ASM Management, Capacity Planning, Scalability, performance optimization and data security as in user access control frameworks and roles/privileges in Oracle. •Experience in designing and developing OLTP & OLAP / Data Warehouses and data cleansing in Oracle.•Experience on Backup, recovery, performance tuning using SQL Profiler, Data replication in SQL Server.•Experience on Backup/recovery, performance tuning using pgAdmin, Stream replication in PostgreSQL.•Excellent skills in ERWIN physical/logical data modeling for designing with normalization form and PL/SQL Programing/T-SQL/SQL Programming in Oracle/SQL Server/PostgreSQL/MySQL.•Very strong in Unix/Linux shell script and cron services for batch/job scheduling and OS related command. •3+ years’ Experience of Java, spring and hibernate framework for developing reporting solution.•Experience of ETL (Extract, conversion, load) from multiple data sources (Flat files, Excel, Xml, RDBMS)in Microsoft BI tool SSIS and Informatica and also used SQL*Loader for data loading in Oracle.•Skills on Integration, unit and various testing and delivery through Waterfall/SDLC/Agile methodologies.•Strong working knowledge on Big Data Hadoop ecosystem i.e. HDFS, MapReduce, HBase, SQOOP, HiveQL, Hive, Impala, PySpark, Lambda, NoSQL, MongoDB, Flume, Kafka, Real time Spark streaming.•Hands-on experience and strong skills on Scala/Python (Programming language) scripting language.Very strong conceptual understanding of Oracle Cloud and Azure Cloud.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.