Oracle Plsql Developer resume example with 5+ years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000,
  • Worked over 5 years in Oracle, MySQL and PL/SQL.
  • Experience working with Entity Relationships (ER diagrams).
  • Well versed in writing complex SQL Queries, creating database objects like tables, views and indexes in MySQL and Oracle.
  • Proficient in writing PL/SQL Procedures/Functions, Packages Triggers and working with Indexes, Joins and Constraints in Oracle.
  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus and Toad.
  • Tuning of the SQL queries, which takes long time to process the request using Explain Plan.
  • Strong in query optimization and performance tuning.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
  • Used DBMS_SCHEDULER to schedule reporting and data synchronization procedures.
  • Possessing strong hands on background in supporting production environments and meeting customer needs.
  • Well versed with software development life cycle and comprehensive understanding of software testing mythologies and tools.
  • Extensive working experience in troubleshooting UNIX and Windows operating systems.
  • Excellent troubleshooting, debugging, and analytical skills.
  • Willing to learn and adapt new challenges.
  • Ability to work independently as well as in a team effectively.
  • Talented Software Developer equipped with great coding, debugging and project management abilities. Accomplishes project goals consistently with elegant, scalable code. Works great with team members under Agile and Scrum frameworks.
  • Languages: PL/SQLJavaScript, HTML,XML , SQL,PHP
  • Operating Systems: Windows.
  • Databases: Oracle 8i/9i/10g/11g, MS Access, MySQL 4.0/5.0, MSSQL Server 2000/2005
  • Tools: SQL*Loader, SQL*PLUS. TOAD, Oracle Export/Import, Data pump, CVS
09/2019 to Current Oracle Plsql Developer Cognizant Technology Solutions | Bedminster, NJ,
  • Involved in requirement analysis and design.
  • Collaborated with business intelligence developers to generate different procedure.
  • Developed SQL loader to data into custom tables.
  • Created triggers to store data into history tables.
  • Involved in handling daily issues assigned to me on ticketing system.
  • Creating indexes on database tables to improve database performance to eliminate full table scans and reduce disk access cost.
  • Extensively used standard oracle packages and dynamic sql.
  • Created different ad-hoc reports using Sql and Plsql
  • Extensively used SQL PLUS, Toad and Sql Loader as required
  • Created different database objects like Packages, Procedure, Functions, Tables, and Views
  • Extensive use of PL/SQL records, collection and analytical functions.

Environment: Oracle 11g, PL/SQL, TOAD, XML , Jira

11/2018 to 05/2019 Software Developer Acrt, Inc. | Auburn, CA,
  • Involved in developing Integrated Taxation System (ITS) for Inland Revenue Department, Nepal as a database developer.
  • Created database objects (Packages, Procedures, Views, Materialized Views, Triggers, Collections, Records) used by front-end developers
  • Involved in writing migration scripts to transfer data form old system (Oracle 10G) to new system (Oracle 11g)
  • Involved in exporting and importing database form one server to another using data pump
  • Wrote complex procedures to calculate income tax slabs
  • Involved in database redesign as required
  • Wrote multiple PLSQL scripts to generate different reports (Non filer, Outstanding, VAT Returns etc) and schedule it using DBMS_SCHEDULAR
  • Involved in Database and system administration jobs like checking current open session, checking and releasing locked objects, creating database jobs, create new database users (Income tax Officers) and granting necessary privileges and roles
  • Used SQL LOADER to load transaction data into a database table
  • Wrote script to transfer external image files to BLOB files from old system (Oracle 10g) to new system (Oracle 11g)
  • Created simple triggers to insert deleted and updated records in a journal table and compound triggers to update status of a record after updating other fields of a table
  • Extensive use of database links to transfer data from one database to another
  • Created materialized and normal views to load data from old system before the feature being implemented in new system
  • Involved in installing Oracle single instance database server 10g in Linux 5
  • Involved in taking Oracle 10g single instance database backups using RMAN
  • Involved in creating and updating Oracle reports and Forms in Oracle 10g for old Inland Revenue department system
  • Created USERS, ROLES, PROFILES and assigned ROLES and PRIVILEGES to users

Environment: Oracle 10g/11g, PL/SQL, TOAD, MS-EXCEL, LINUX 5

09/2017 to 10/2018 IT Trainee (Quality Assurance/SQL Developer) Professional Computer System | City, STATE,
  • Involved in writing queries as requested by the end users and exported in excel.
  • Involved in testing and debugging existing modules.
  • Involved in building new database procedures to insert and update records used by front end PHP developers.
  • Created indexes in database tables before being verified by supervisor.
  • Involved in creating different test cases of existing PHP based web application.
  • Validating data in front end application and backed database tables.
  • Compile unit testing results and work with developers to discuss the bugs identified.
  • Involved in testing user interface bugs across different browsers and devices.

Environment: Oracle 10g, PL/SQL, TOAD, MS-EXCEL

Education and Training
Expected in Bachelor | Business Administration Kathmandu University, , GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Kathmandu University

Job Titles Held:

  • Oracle Plsql Developer
  • Software Developer
  • IT Trainee (Quality Assurance/SQL Developer)


  • Bachelor

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: