jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 5 years experience designing developing implementing testing database applications solutions oracle plsql developer skills oracle plsql specialist experience using sql navigator toad oracle sql developer eclipse developing tools experience working harvest ca software change manager pvcs vm git version controls advanced knowledge various databases oracle ms access teradata working knowledge db toolsutilities like om sqleloader explain plan tkprof importexport expdpimpdp work history 052012 current oracle plsql developer advanced knowledge linux shell scripting data warehouse etl design knowledge knowledge java core c c advanced problem solving skills troubleshooting debugging performance scalability optimization knowledge using data modeling tools erwin visio cognizant technology solutions delaware city de involved understanding technical direction programming staff back end database design development perspective developed linux shellsql scripts data extraction transformation load staging tables developed plsql proceduresfunctionspackages load data dimension fact tables improved data warehouses performance implementing advanced oracle data warehousing features materialized views partitioning external tables dimensions parallel execution worked production support team immediately resolve failures production data processing collaborated business users resolving data inconsistency reporting issues used sqlloader created external tables order load data flat files oracle tables extensively used bulk collect forall statements manipulating large amount data enhance performance wrote complex sql queries using joins sub queries retrieve data database also made use set operators like union union intersect minus responsible performance tuning using explain plan tkprof oracle hints used table partitioning huge table increase database performance responsible import export database objects per requirement also used db links accessing data across different databases used sql navigator ide developing managing plsql scripts used bitmap btree index functional based index enhance performance retrieval data database table handled errors using system defined exceptions user defined exceptions optimized enhanced existing procedures sql statements better performance attended walk code review status meeting discuss status project 092010 022012 oracle plsql developer cognizant technology solutions dover de involved understanding technical direction programming staff back end database design development perspective developed procedures functions packages implements business requirement using plsql created dynamic sql script plsql build sql statements dynamically runtime used sqlloader created external tables order load data flat files oracle tables extensively used bulk binding collections manipulating large amount data enhance performance wrote complex sql queries using joins sub queries retrieve data database also made use set operators like union union intersect minus 092005 102007 oracle dbaplsql developer education 2010 ionnor solutions city state analyzed business requirements project studying business requirement specification document installed upgraded oracle database server migrated database db2 ms access oracle database createdmodified tables views queries new enhancement application using toad createdmodified database objects like packages procedures functions triggers handled errors using exceptions extracted data flat files transformed accordance business logic mentioned client created indexes tables faster retrieval data enhance database performance extensively involved using hints direct optimizer choose optimum query execution plan created custom plsql procedures read data flat files dump oracle database using sqlloader used plsql wrap utility encrypt plsql source code make code portable platform wrote complex sql queries including inline queries sub queries faster data retrieval multiple tables created modified several unix shell scripts dos batch files according changing needs project client requirements master science computer engineering university bridgeport bridgeport ct usa 2005 post graduate diploma computer application computer application 2004 guru nanak dev university punjab india bachelor science computer application guru nanak dev university punjab india certifications oracle advanced plsql developer certified professional 1z00511z01471z0146 oracle certified associate oracle solaris 10 operating system 1z0876