Had around 11 years of experience in Oracle, SQL Server, DB2, MS Access in database design, development, implementation and support client-server applications. Handled projects individually and able to Managed multiple projects for a team of size 25+.
Extensive experience in PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions, and Packages, Oracle Supplied Packages, Collections, Exception Handlers, Partitioned Tables, Triggers, Materialized Views, Table Indexing, SQL*Loader and using latest features to optimize performance.
Experience in BigData EcoSystems(Hadoop HDFS, PIG, HIVE, HBASE, SQOOP)
Expertise in Performance Tuning & Optimization of SQL statements.
Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
Ability to program UNIX shell scripts in applications that schedule, validate flat file data, file handling, execute SQL, archive files or FTP files.