We provide IT Staff Augmentation Services!

Pl/sql Developer & Oracle Database Administrator Resume

SUMMARY

  • Over 10 years of IT experience in PL/SQL Development and Robotics Process Automation Development with tool UiPath and Siebel administration and UNIX.
  • Strong knowledge in SQL, PLSQL , UNIX
  • Strong knowledge in Informatica Power center tools over 2 years .
  • PL SQL/Oracle developer with Golden Gate knowledge
  • Oracle PL/SQL with knowledge of the most recent updates.
  • Experienced in data modeling, And good in deployments.
  • Good in tuning and optimization of sql queries and Plsql subprograms.
  • Well experienced in writing PL/SQL Packages, Functions, Procedures, Cursors & Triggers to implement business logic.
  • Experience in Design, Development, Implementation and support as Oracle Developer in Production and Development using Oracle Tools.
  • Extensive experience in Oracle database
  • Comprehensive involvement in all phases of application lifecycle development be it analysis, development, testing, debugging and User Acceptance Testing (UAT) with QA team.
  • Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers and Dynamic SQL for the data validations and Used PL/SQL Tables and Records
  • Excellent interpersonal and strong communicating, problem - solving skills.
  • Worked in strict deadlines without compromising on the quality.
  • Good knowledge in data warehousing techniques.
  • Good experience in building the datamarts
  • Handled bigger releases and delivered without any bugs.
  • Analyze and fix the performance issues with DBMS PROFILER.
  • Loaded the data into the tables using SQL*Loader
  • Expertise in Understanding and Analyzing Application Requirements.
  • Created relevant staging tables to load the CSV files, identified the business validation rules
  • To Configure and create extension columns for the Base table.
  • Siebel server setup and its maintenance Checking for DEV, system integration testing (SIT), User Acceptance Testing (UAT) and Prod servers daily.
  • Have Knowledge on AWS Concepts
  • Repository migrations and production deployments.
  • Hands on Experience in Siebel CRM 8.1 Applications.

TECHNICAL SKILLS

Database System: PL/SQL, Oracle 9i/10g, PostgreSQL

ETL Tool: Informatica 9.6.1.

RPA Tools: UiPath

Scripting: shell, Unix shell scripting

Operating system: Linux 6.x/7.x, Windows, Unix

Languages: PL/SQL, Siebel, RPA UiPath,Unix

PROFESSIONAL EXPERIENCE

PL/SQL Developer & Oracle Database Administrator

Confidential

Responsibilities:

  • Designed the tables and scenarios for the customer information.
  • Coordinate with clients and gather the requirements.
  • Good knowledge in Postgres DB.
  • Taken care of both 1F and iEN application access and adding new fields in VPM
  • Given access to VPM all users
  • Oracle dba activities.
  • Monitoring piwik report every month access for both 1F and iEN.
  • Written the packages and required functions to get the questionnaire information.
  • Taken care of releases into production without bugs.
  • Test the requirements and got the good feedback from the clients.
  • Knowledge transfer of development to other resources in the project.
  • Responsible for Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
  • Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
  • Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
  • Developed Triggers to enforce complex business rules and to audit changes to data.
  • Created tables and modified table structures by adding new column to existing table and populate data into that column
  • Responsible for PM Assignment matrix

Environment : - Environment: - PL/SQL, Toad, PostgreSQL Pg. Admin, Windows SQL Server 2014, Excel

Senior PL/SQL Developer

Confidential

Responsibilities:

  • Designed the tables and scenarios for the customer information.
  • Coordinate with clients and gather the requirements.
  • Handled a team size of three members.
  • Created the mappings in informatica required for the cdustomer touch points.
  • Written the packages and required functions to get the questionnaire information.
  • Taken care of releases into production without bugs.
  • Test the requirements and got the good feedback from the clients.
  • Knowledge transfer of development to other resources in the project.
  • Responsible for Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
  • Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
  • Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
  • Developed Triggers to enforce complex business rules and to audit changes to data.
  • Created tables and modified table structures by adding new column to existing table and populate data into that column

Environment : - PL/SQL, Toad, Windows SQL Server 2014, Excel

Senior PL/SQL Developer

Confidential

Responsibilities:

  • Designed the tables and scenarios for the customer information.
  • Coordinate with clients and gather the requirements.
  • Handled a team size of three members.
  • Created the mappings in informatica required for the cdustomer touch points.
  • Written the packages and required functions to get the questionnaire information.
  • Taken care of releases into production without bugs.
  • Test the requirements and got the good feedback from the clients.
  • Knowledge transfer of development to other resources in the project.

Environment : - PL/SQL, Toad, Windows SQL Server 2014, Excel

PL/SQL Developer

Confidential

Responsibilities:

  • Handled the team which consists for 4 members.
  • Part of technical and functional discussions with Italian business team.
  • Planned releasing activities and able to release with compromising the quality of work.
  • Designed the tables and scenarios for the customer information.
  • Coordinate with clients and gather the requirements.
  • Handled a team size of three members.
  • Written the packages and required functions to get the questionnaire information.
  • Taken care of releases into production without bugs.

Environment : PL/SQL, Toad, Windows SQL Server 2014, Excel, HTML, Java Script, CSS.

Senior Oracle Developer

Confidential

Responsibilities:

  • Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
  • Designing the flow of the projects and writing the util packages.
  • Gathering reports format, understanding the functionality of the report.
  • Interaction with the client for the requirements.
  • Developing the logic according to the report format using the oracle report builder.
  • Created Access Controls based on User roles.
  • Interaction with the client for the requirements.
  • Dealing with Packages, Procedure, Functions, Tables, Views, Indexes, Synonyms and Queries for reports.
  • Coordinate with the client

PL/SQL Developer

Confidential

Responsibilities:

  • Report Development
  • Played an effective part in defect fixing and ticket resolution
  • Involved in fixing performance issues of RFW components
  • Involved in issue resolution during SIT and UAT
  • Part of support activities during Go-Live
  • Familiar with usage of PL/SQL Developer, Toad and Crystal Reports.
  • Conducted trainings on RFW Development and published documents for the reference of team members
  • Knowledge transfer of development to other resources in the project.

Environment : - PL/SQL, Toad, Crystal Reports

Hire Now