Experience in developing logical and physical database design, data modeling using ER/Studio and Oracle SQL Developer Data Modeler Collaborate with data architects for data model management and version control. Conduct data model reviews with project team members. Capture technical metadata through data modeling tools and Create data objects (DDL) Enforce standards and best practices around data modeling efforts. Have extensive experience in database design and PL/SQL development Proven working knowledge in writing complex SQL queries and in query optimization & performance. Good in understanding SQL statement execution and explain plans. Strong working knowledge in writing PL/SQL procedures, functions and packages and advanced concepts like Cursors, Collections and exception handlings Experience in application development using various advanced features of Oracle like Bulk Collections, Autonomous Transactions, Dynamic SQL, Object types and Records. Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file and batch processing Experienced in data analysis, data modeling, development, testing and documentation of projects. Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database. Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, Hints in Oracle databases Experience in UNIX Shell Scripting for batch processing Strong Troubleshooting, Problem solving, Analytical & Design Skills Strong in application development with RAD (Oracle Forms & Oracle Reports) tools Expertise in performing Data export, Import and various operations using TOAD, SQL Developer Good working knowledge of end-user and server-side data processing techniques Good understanding of SDLC and agile development methodologies and the ability to work with minimal oversight. Strong understanding of JavaScript, its quirks, and workarounds Good understanding of asynchronous request handling, partial page updates, and AJAX Proficient understanding of cross-browser compatibility issues and ways to work around such issues Proficient understanding of code versioning tools, such as {{Git / Clearcase / SVN}} Good understanding of browser rendering behavior and performance Good understanding of technology platforms and ability to explain technical concepts to the business users in the context of business requirements Good working knowledge of MetricStream GRC application suite Owning the task and driving it to closure with minimal supervision