About

Nikhil Arora is a seasoned Senior PLSQL Developer with over 7 years of experience in developing complex SQL queries and PL/SQL programming units/objects on Oracle 11g/12c database. He has a sound knowledge of relational database design and Normalization process and has hands-on experience in analyzing and solving production issues, involving bug fixes and performance tuning. Nikhil is an expert in agile software development methodology and has over 5 years of experience in it. He is well-versed with Jira and has tuned SQL queries using EXPLAIN PLAN, Hints, SQL*Plus Auto trace, and TKPROF. He has used SQL*Loader, Import/Export, UTL_FILE, DBMS_XMLGEN, DBMS_XMLQUERY, DBMS_PIPE, and other Oracle built-in packages. Nikhil has also used Materialized views, Oracle analytical functions, regular expression functions, packages, collections, bulk collect, result set caching, and function result cache for performance boosting. He has done unit testing of PL/SQL packages/function/procedure using utPLSQL unit testing framework. Apart from his technical expertise, Nikhil is also well-versed in DB admin tasks like setting up oracle database, managing table space & data files, configuring backups, user roles privileges, oracle scheduler, DB links, etc. He has hands-on experience in writing UNIX shell scripts (Bash, Csh & Perl) for automating jobs using CRON scheduler. He has also interacted with clients to collect requirements and understand business processes. Nikhil is a quick learner, self-directed, and consistently updates himself with emerging trends in the industry. He enjoys taking responsibility for projects from start to end and is an energetic self-starter with excellent analytical and organizational skills. Currently, Nikhil works as a Senior Member Of Technical Staff at Oracle and has previously worked as a Senior Software Development Engineer at Landis+Gyr and a Software Engineer at Birlasoft. He holds a B.Tech degree in Information Technology from Dehradun Institute of Technology and a degree in Mathematics and Computer Science from Asha Modern School. His tech stack includes SQL, Software Engineer, test, and Normalization, and he has relevant experience of 8.53 years.