professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom 9 years programming experience oracle plsql developer analysis design implementation business applications using oracle relational database management system rdbms knowledgeable oracle developer skilled data collection analysis management works well pressure consistently meets deadlines targets delivering high quality work highlyskilled software development professional bringing 9 years software design development integration advanced knowledge oracle sql plsql ms tsql involved phases sdlc software development life cycle analysis design development testing implementation maintenance timely delivery aggressive deadlines effectively made use table functions indexes table partitioning collections analytical functions materialized views query rewrite transportable table spaces developed complex database objects like stored procedures functions packages triggers using sql plsql excellent technical analytical skills clear understanding design goals er modeling oltp dimension modeling olap expertise dynamic sql collections exception handling experience sql performance tuning using costbased optimization cbo excellent communication interpersonal analytical skills strong ability perform part team sql developer 9 years progressive experience java databases application programming dedicated building customized technical solutions alignment operational needs objectives critical thinker analyst problem solver known continuous delivery quality products across diverse business environments skills patch management bug fixes data warehousing software products tools ms sql server 2022 work history sr oracle plsql developer 082019 122022 carlisle syntec inc greenville il oraclesqlplsql performance tuning data modelling sql plus unix shell scripting toad oracle sql developer created optimal technical solutions user needs indepth system analysis analyzed existing sql queries identify opportunities improvements maintained complex tsql queries views stored procedures multidatabase environment little supervision devised highquality database solutions ranging size complexity increasing productivity improving data sharing coordinated development team provide necessary stored procedures packages necessary insight data involved continuous enhancements fixing production problems generated server side plsql scripts data manipulation validation materialized views remote instances created scripts create new tables views queries new enhancement application using toadcreated indexes tables faster retrieval data enhance database performance partitioned fact tables materialized views enhance performance extensively used bulk collection plsql objects improving performing extensively used advanced features plsql like records tables object types dynamic sql handled errors using exception handling extensively ease debugging displaying error messages application collaborated product management design build test systems oracle developerbackend developer 042016 072019 union bank nigeria plc city state customized developed oracle workflows meet company business processes developed customized oracle reports forms meet functional business requirements followed standard methodologies coding write clean selfdocumenting code developed advance plsql packages procedures triggers functions indexes collections implement business logic using sql navigator participated change code reviews understand testing needs change components worked troubleshooting defects timely manner used principles normalization improve performance involved etl code using plsql order meet requirements extract transformation cleansing loading data source target data structures collaborated technical contributors application development resolve application defects flexcube application supportjunior oracle developer 122013 032016 union bank nigeria plc city state provided functional technical support corporate retails banking applications including trade finance modules like bills collections funds transfer loans deposit treasury general ledger channels interface management atm pos mobile provided efficient 2nd level user support flexcuberelated issues specified design changes implemented recommended program amendments tracked escalated issues oracle financial services systems ofss prompt resolution produced new reports procedures delivering updated existing reports endofcycle backup ensure smooth operations bank wrote sequences automatic generation unique keys support primary foreign key constraints data conversions created custom reports forms end users check details errors worked closely clients establish problem specifications system designs developed customized oracle reports forms meet functional business requirements network administrator 112012 102013 interra network ltd city state performed daytoday lan wan administration maintenance support configured networks smooth reliable operation meet business processes objectives identified immediately resolved issues network devices managed data backups disaster recovery operations comply business continuity initiatives network engineering documentation network design structured cabling wireless technology consulting security solutions internal external clients education master science information technology 012016 national open university nigeria nigeria bachelor science physics 122007 university ado ekiti nigeria certifications itil information technology infrastructure library oca oracle database sql certified expert ocs oracle autonomous database cloud 2019 certified specialist