Oracle Plsql Developer resume example with 5+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105(555) 432-1000, resumesample@example.com
Summary
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.
Skills
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
Experience
09/2019 to CurrentOracle Plsql DeveloperCognizant 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/2019Software DeveloperAcrt, 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/2018IT 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 AdministrationKathmandu University, , GPA:
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.