FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Senior Pl-Sql Developer

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Senior Pl-Sql Developer Skills

Below we've compiled a list of the most important skills for a Senior Pl-Sql Developer. We ranked the top skills based on the percentage of Senior Pl-Sql Developer resumes they appeared on. For example, 13.7% of Senior Pl-Sql Developer resumes contained Pl/Sql as a skill. Let's find out what skills a Senior Pl-Sql Developer actually needs in order to be successful in the workplace.

These are the most important skills for a Senior Pl-Sql Developer:

1. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Senior Pl-Sql Developer jobs:
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  • Team was constantly making changes to PL/SQL procedures and packages to fit the changing needs of the customer.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
  • Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
  • Optimized complex SQL queries and PL/SQL blocks by analyzing the execution plan and modifying the SQL.
  • Developed back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
  • Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
  • Developed PL/SQL Procedures & UNIX Scripts for Automation and running files in batch mode.
  • Performed conversions of Data Stage jobs to PL/SQL packages for higher performance.
  • Optimized and tuned PL/SQL subprograms to reduce the loading process.
  • Used PL/SQL to validate data and to populate billing tables.
  • Extracted data using PL/SQL program that runs weekly.
  • Converted Pro*C programs to PL/SQL procedures.
  • Performed SQL and PL/SQL tuning using explain plan, TKPROF, Hints and Indexes.
  • Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
  • Developed PL/SQL packages, procedures, functions, Indexes, sql scripts for the implementation of the very complex business requirements.
  • Involved in data load using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files.

Show More

2. SQL

demand arrow
high Demand
Here's how SQL is used in Senior Pl-Sql Developer jobs:
  • Involved in Tuning SQL queries using Explain Plan and TKPROF utility to improve performance of the queries.
  • Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
  • Worked with Java and J2ee development team and worked for Hibernate mapping and Provided SQL Queries.
  • Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
  • Worked on SQL*Loader scripts to load the data from the flat files to the staging tables.
  • Developed T-SQL and Oracle PL/SQL procedures, tune queries for optimized performance and develop SSIS packages.
  • Involved in Loading Oracle tables from flat files using SQL *Loader with appropriate control file.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Developed Data entry, query and reports request screens and tuned the SQL queries.
  • Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
  • Created SQL loader scripts to load the data from files to temporary tables.
  • Supported BOXI reports testing and prepared expected results using complex SQL queries.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.
  • Developed various programs using Native Dynamic SQL and REF CURSORS.
  • Used SQL*Loader with both direct and indirect load methodologies.
  • Used SQL extensively in command objects of Crystal reports.
  • Created complex relational database queries/SQL, dynamic SQL.
  • Interfaced with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or APEX.
  • Converted T-SQL to PL/SQL or vice versa to report data consistency cross multiple databases.

Show More

9 SQL Jobs

No jobs at selected location

3. Database

demand arrow
high Demand
Here's how Database is used in Senior Pl-Sql Developer jobs:
  • Loaded External files into database using import utility.
  • Extracted required data from the database tables and exported the data to different sources in different formats.
  • Worked for designing Logical and Physical data models for staging and E-Product catalog Databases and staging database.
  • Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
  • Monitor database daily backups and escalate to the database admin if there is any Issue.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Created database scheduler scripts and applications using Unix shell scripts, SQL *Plus script.
  • Filtered and Loaded data from different formats of data sources into Database Tables.
  • Involved in handling the changes in compiling scripts according to the database changes.
  • Worked with several tools to access and perform several operations on database.
  • Created database objects, tables, indexes, procedures, SQL scripts.
  • Involved in migrating database from oracle 9i to 10g database.
  • Provided all business rules for the database for loading data.
  • Utilized SQL*Loader to load flat files into database tables.
  • Support for the development, test and the production databases
  • Maintained the logical and physical structures of the database.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Created the custom tables to import the employee data and insert into the timesheet database.
  • Involved in the Database Design (Relational and Dimensional models) using ERwin.
  • Involved in managing security , granting and revoking privileges on database objects Creating External table for data retrieval and processing.

Show More

5 Database Jobs

No jobs at selected location

4. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Senior Pl-Sql Developer jobs:
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for business objects and reports.
  • Interact with the Business Analyst for any clarifications on business requirements.
  • Understand the Business requirements and convert them into technical specifications.
  • Analyzed the business requirements and proposed and taken appropriate solution.
  • Involved in gathering business requirements, clarification and system design.
  • Designed Technical design document based on the business requirements.
  • Write Technical Specifications based on business requirements.
  • Worked on Logical and Physical Data Modeling to gather the business requirements and convert them into models and design the databases.
  • Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements.
  • Involved in creating detailed Documentation HLD and LLD, which includes all Business requirements and technical specifications.
  • Prepare technical designs for all functional business requirements and provide support for all testing activities.
  • Create, modify or design program reports using SQL scripts by understanding the business requirements.
  • Involved in writing complex SQL Queries to implement the business requirements.
  • Analyzed the business requirements for OWB and Mapped the architecture.
  • Tested the functionality as per the client business requirements.
  • Created new procedures for new business requirements.
  • Involved in the business requirements gathering and analysis, understanding client's Data Warehousing requirements and system analysis.
  • Participated in business requirements reviews and software system (application) designs for testability.
  • Worked with dynamic SQL to get the data from salesforce depending on the business requirements.
  • Created Adhoc reports and data exploration using PL-SQL developer * Conducting version upgrade through developing new application to meet Business Requirements.

Show More

5. Unix

demand arrow
high Demand
Here's how Unix is used in Senior Pl-Sql Developer jobs:
  • Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
  • Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
  • Developed Unix Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.
  • Created batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling.
  • Developed UNIX Shell scripts to automate Notifications for the clients and also execute procedures for support monitor.
  • Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.
  • Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
  • Performed the uploading and downloading of flat files from UNIX server using FTP.
  • Involved in production support, like monitoring the performance of the Unix jobs.
  • Developed Unix Shell Scripts and PL/SQL Procedures to extract and load data.
  • Worked with Unix commands to check and match the output manually.
  • Developed different UNIX scripts for the output of the commands.
  • Modified exiting UNIX Shell Scripts to schedule daily jobs.
  • Used UNIX commands to monitor the scheduled jobs.
  • Worked on UNIX scripting for scheduling the jobs.
  • Developed FTP and mailing program in UNIX.
  • Developed administrative tools using UNIX Shell scripting.
  • Involved in creating UNIX shell Scripting.
  • Read and interpreted UNIX logs.
  • Automated quarterly and fiscal year jobs by setting up Cron jobs in UNIX.

Show More

1 Unix Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Toad

demand arrow
high Demand
Here's how Toad is used in Senior Pl-Sql Developer jobs:
  • Analyzed the system requirements and created logical and physical data models using Power Designer v15.3 and Toad Data Modeler v4.1 tools.
  • Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
  • Used TOAD to accurately assess the efficiency of the SQL statements when application runs by using SQL Tuning Analyzer.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created tables using Toad as well as created and managed roles for different users to access database objects.
  • Involved in designing the logical and physical model of database objects using Toad and Oracle Designer.
  • Involved in data modeling (Physical and logical models) using ERWIN and TOAD tools.
  • Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using Oracle TOAD.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Created Indexes on tables and Optimizing Stored procedure queries using Oracle TOAD.
  • Loaded the data into the tables using TOAD and SQL*Plus.
  • Utilized tools like TOAD during development of the application.
  • Used Quest TOAD to tune query performance.
  • Used Toad for Monitoring the User Session.
  • Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
  • Utilized tools like TOAD during development of the application Performed Unit Testing and data validation.
  • Used Oracle Enterprise Manager, TOAD for developing and managing pl/sql scripts.
  • Test Data Setup for Integration Testing Environment: Oracle 10g, UNIX, SQL, PL/SQL, TOAD, Putty, WINSCP
  • Used Toad Datapoint to work on converting codes from oracle based to vertica.

Show More

7. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior Pl-Sql Developer jobs:
  • Worked on automation of reconciliation between legacy system and new data warehouse.
  • Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
  • Involved in ETL in OLAP database to transfer data from source tables into the data warehouse tables using PL/SQL.
  • Have extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
  • Extracted data from different sources like flat files and loaded into Oracle data warehouse according to the specifications.
  • Supported effort to convert Data Warehouse database objects from using ICD9 diagnostic codes to government mandated ICD10 codes.
  • Involved in building the ETL design and Source to Target mapping to load data into Data warehouse.
  • Maintain and create PL/SQL procedures, functions, packages, indexes and triggers in data warehouse system.
  • Involved in mapping of legacy system tables, columns to new data warehouse tables, columns.
  • Developed stored procedures to extract the data from different sources and load it into data warehouse.
  • Experience with merging data files coming from the customer into the existing data warehouse.
  • Involved in Business Requirements, System analysis and Design of the Data warehouse application.
  • Analyze Business Requirement Documents (BRD) for effect on Data Warehouse database.
  • Performed Data Migration as a part of enterprise data warehouse project.
  • Developed applications for High Volume OLTP and Data Warehouse batch processing.
  • Involved in Data warehouse and Data mart design.
  • Worked as a Data Warehouse Developer using OWB.
  • Maintained custom schema for OBIEE Data Warehouse.
  • Designed modification to hospital claims system to accommodate multiyear claims retention in Data Warehouse database.
  • Extracted data from Oracle and SQL Server using Informatica to load it into a single data warehouse repository.

Show More

2 Data Warehouse Jobs

No jobs at selected location

8. ETL

demand arrow
high Demand
Here's how ETL is used in Senior Pl-Sql Developer jobs:
  • Involved in accomplishing automated data extraction from various RDBMS via scripts, ETL in database usage and especially in data warehousing.
  • Experience using Bulk processing, ETL operations with implicit and explicit cursors, Ref Cursor, collections, DBMS packages.
  • Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
  • Worked on the ETL scripts and fixed the issues at the time of data load from various data sources.
  • Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
  • Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
  • Have closely worked with ETL team to performance tune the queries & figure out the prod issues.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Designed, developed and documented all the packages, procedures and functions involved in ETL process.
  • Developed the ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
  • Designed and Developed ETL Process for loading Flat files into Oracle Database from 35 Different Sources.
  • Used Oracle Data Integrator (ODI) to perform ETL operation on the database.
  • Worked with ETL team and architect to build data model for staging area.
  • Worked with ETL team involved in loading data to staging area.
  • Worked on performance tuning of the ETL processes.
  • Conducted analysis, design, implementation, support and management of full life cycle with ETL application development and business intelligence.
  • Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
  • Used PL/SQL, SQLLoader as part of ETL process to populate the operational data store.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Converted all Oracle ETL Packages to Informatics Mappings and created workflows/Sessions.

Show More

1 ETL Jobs

No jobs at selected location

9. Windows Explain Plan

demand arrow
high Demand

10. Bulk Collect

demand arrow
high Demand
Here's how Bulk Collect is used in Senior Pl-Sql Developer jobs:
  • Used Bulk collect and for all in stored procedures to improve the performance and make the application to run faster.
  • Worked on Database Links and Bulk Collections to perform bulk data loads into database tables from upstream application.
  • Worked on SQL*Loader and Bulk Collections to perform bulk data loads into database tables from external data files.
  • Developed PL/SQL applications using FORALL, BULK COLLECT and MERGE statements of Oracle 10g to improve performance.
  • Created the procedure to bulk upload the data in the database using Bulk Collect.
  • Used features like bulk collect to process large amount of data in data base.
  • Used bulk collections, indexes, materialized views to improve the query executions.
  • Introduced BULK COLLECT approach to the team to pull the records faster.
  • Used Bulk Collect concepts for handling the large amount of the data.
  • Used Bulk Collect and Bulk Bind (FORALL) features with collections.
  • Used collections, bulk collection to handle large amounts of data.
  • Used Bulk collect feature to process the data from Cursor/Ref Cursor.
  • Used PL/SQL bulk collection and DML (insert/update/delete) methods.
  • Optimized PL/SQL code using bulk collects and bulk binds.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Worked extensively with Oracle Collections along with most important performance optimization features like bulk Collect, forall, and table function.
  • Used Bulk collect and For all to reduce context switching between SQL and PL/SQL engine and vice versa.
  • Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
  • Experience of Merge, Bulk Collection, Oracle Collections Index-By Table, VArrays, Nested tables.

Show More

11. Tkprof

demand arrow
high Demand
Here's how Tkprof is used in Senior Pl-Sql Developer jobs:
  • Identify the time taking SQL queries in Cursors and do performance tuning using Explain Plan, TKPROF.
  • Performed SQL and PLSQL tuning and Application tuning using various tools like EXPLAINPLAN, SQL*Trace and TKPROF.
  • Tuned of queries, procedures and functions for better performance using TKPROF and Explain Plan utilities.
  • Performed the Application tuning using Oracle performance tuning tools like Explain Plan, SQL*Trace and TKPROF.
  • Conducted performance tuning of applications through tuning pack and SQL*Navigator, SQL*TRACE, TKPROF utilities.
  • Involved in Performance Tuning of the application using Explain Plan, Hints and TKPROF.
  • Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
  • Participated in improving the performance of the Queries using TKPROF and EXPLAIN PLAN.
  • Trouble shooting performance issues using Explain Plan and TKPROF.
  • Participated in Performance Tuning using Explain Plan and TkProf.
  • Performed PLSQL tuning using BULK COLLECTIONS, Optimizer hints, Histograms, TKPROF, Explain Plan, and PLSQL Profiling.
  • Experience in Performance Monitoring tools (Explain Plan, SQL Trace, and TKPROF).
  • Involved in SQL tuning using SQL trace, TKPROF and Explain Plan.
  • Performed SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility, TKProf & DBMS_PROFILER.
  • Tuned SQL queries using Explain Plan, Analyze, Hints and TKProf utilities to improve performance.
  • Performed SQL performance tuning using Explain plan, Trace utility & TKProf.
  • Used ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE and TKPROF for SQL tuning,.
  • Analyzed the SQL PLUS statements using Oracle Hints, Explain Plan, and TKProf.
  • Optimized SQL queries using Explain Plan, TKProf, Sql hints to improve the performance of the queries.
  • Modified and debugged several pl/sql programs for performance tuning using techniques like explain plan, tkprof and dbms_profiler.

Show More

12. Error Messages

demand arrow
high Demand
Here's how Error Messages is used in Senior Pl-Sql Developer jobs:
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
  • Developed reports for error reporting and send the error messages to legacy system owners.
  • Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.

Show More

13. Informatica

demand arrow
high Demand
Here's how Informatica is used in Senior Pl-Sql Developer jobs:
  • Worked with various active and passive transformations in Informatica PowerCenter.
  • Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
  • Worked on Informatica Power Center 9.1 Tool -Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
  • Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
  • Experience in developing ETL Plans and Processes and using Informatica ETL.
  • Involved in Performance Tuning of mappings in Informatica.
  • Experience with Informatica ETL Tool.
  • Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Used Informatica reusability at various levels of development.
  • Used SQL*Loader, BCP (bulk loader), Informatica Powercenter to load data from external files.
  • Created and modified UNIX shell scripts to run the Informatica Workflows and controlling the ETL Flow.
  • Work on migration of data from CDE to ODS to Warehouse using Informatica workflows and mappings.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
  • Make use of Putty to login to Informatica and Unix server.
  • Worked on Informatica Schedulers to schedule the workflows.
  • Managed Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
  • Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
  • Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
  • Assisted Informatica in the conversion of system from Informatica 5.1.1 to Informatica 6.0 while administering project.
  • Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.

Show More

14. Cursors

demand arrow
high Demand
Here's how Cursors is used in Senior Pl-Sql Developer jobs:
  • Developed Materialized views and Ref Cursors for reporting purpose.
  • Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.
  • Developed complex SQL and PL/SQL queries required to retrieve data from data repository using cursors, joins and sub-queries.
  • Implemented cursors, for cursors and Ref Cursor (dynamic SQL) for fetching data and processing it.
  • Involved in writing Procedures, Functions, Triggers, Cursors, Dynamic SQL and Views using SQL Developer.
  • Worked on PL/SQL Implicit, Explicit, and REF Cursors and created Triggers for tables using SQL Developer.
  • Developed PL/SQL Procedures, Functions, Cursors, and Packages using SQL Developer, TOAD and Oracle 10g.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Experience in using where current of, for update cursors and common type, regular expressions.
  • Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database.
  • Developed PL/SQL stored procedures using cursors, Arrays, Collections and PL/SQL tables.
  • Involved in development, maintenance of Triggers, Joins, Cursors and Views.
  • Used Bulk Collect, Implicit and Explicit Cursors for performing complex data.
  • Processed data Using both implicit cursors and explicit cursors and their attributes.
  • Used PL-SQL features like cursors, ref cursors, Exception handling.
  • Involved in writing procedures and cursors for loading the tables.
  • Implemented Collections, Bulk Collect techniques and REF cursors.
  • Worked on PL/SQLImplicit, Explicit Cursors and created Triggers for tables.
  • Automated quality check tasks by creating pl/sql procedures, cursors, functions and dynamic sql.

Show More

15. XML

demand arrow
average Demand
Here's how XML is used in Senior Pl-Sql Developer jobs:
  • Designed and Developed jobs to extract XML messages using Oracle OCI, Transformer stages and loaded into the target databases.
  • Loaded data from different sources like (Flat/Excel/Access/XML/SQL/ Oracle) to Oracle Database tables using external tables.
  • Source files come in different formats like Excel, XML files and flat files.
  • Transmit process takes the generated XML data and send it to different applications.
  • Involved in development of custom reports using Reports 10g and XML/ BI Publisher.
  • Extracted data from the XML file and loaded it into the database.
  • Worked on XML along with PL/SQL to develop and modify web forms.
  • Used XML Publisher to generate the report design as per business need.
  • Developed COGNOS reports & XML reports based on Business requirements.
  • Used various web service standards such as WSDL and XML.
  • Designed SSIS Packages to transfer data from Text Files, XML Files, Excel, Flat files to SQL Server 2008.
  • Exported reports into various formats like XML, PDF, HTML, EXCEL and MS-Word.
  • Validated out going XML messages Validated flat files coming from downstream systems and mocked up feed files by using vi editor.
  • Developed new PL/SQL Package for processing the fulfilment request for the corresponding templates and generates XML data using DBMS_XMLDOM and DBMS_XMLPARSER.
  • Worked on Web Service Call through Informatica by generating and testing the incoming XML using external Freeware called SOAP UI.
  • Worked on Preparing the XML'sRequests and downloaded the XML's response by parsing it and stored into the Tables.
  • Created PL/Sql procedure to produce XML documents from dictionary tables and transfer documents via Java class to Web service.
  • Developed Static Java classes to process xml data.
  • Designed PL-SQL packages dealing with different data sources (ORACLE SERVER Flat Files, and XMLs etc.)
  • Migrated the XML export of power center workflows to Informatica cloud and scheduled jobs there.

Show More

1 XML Jobs

No jobs at selected location

16. Synonyms

demand arrow
average Demand
Here's how Synonyms is used in Senior Pl-Sql Developer jobs:
  • Worked on generation of scripts for creation of tables, indexes, views, synonyms, grants, roles and privileges.
  • Create database objects such as Tables, Global Temporary Tables, Views, Synonyms, Indexes, Sequences and Database Links.
  • Generated SQL scripts for creating Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
  • Programmed number of database objects like tables, views, indexes, synonyms and materialized views using SQL *plus.
  • Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes and synonyms.
  • Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
  • Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
  • Designed and generated database objects like Tables, Views, Synonyms, Indexes and Sequences.
  • Created new Tables, Indexes, views, synonyms and Sequences in the Oracle database.
  • Designed database objects such as tables, indexes, constraints, sequences and synonyms.
  • Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
  • Created and altered database objects like tables, views, sequences and synonyms.
  • Modified tables, synonyms, sequences, views, stored procedures and triggers.
  • Involved in creation of schema objects like indexes, views, and synonyms.
  • Created synonyms and make sure that users have executable permissions on all objects.
  • Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
  • Created public synonyms on the database links for easy reuse.
  • Designed new tables to integrate with the existing schemas and created constraints, indexes, sequences and synonyms.
  • Invloved in developing Views, procedures, sub procedures, packages, synonyms.

Show More

17. Triggers

demand arrow
average Demand
Here's how Triggers is used in Senior Pl-Sql Developer jobs:
  • Developed stored procedures for database administrative tasks and database triggers to implement database auditing and to store historical data.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Developed complex triggers in reports before/after for validation of user input.
  • Developed Database Triggers for audit and validation purpose.
  • Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models.
  • Designed and developed Oracle Database objects like materialized views, and associated objects like triggers and indexes.
  • Involved into updating procedures, functions, triggers, and packages based on the change request.
  • Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
  • Created triggers on tables and views and associating appropriate trigger timing and trigger events.
  • Developed application and database triggers, functions, procedures, and packages in PL/SQL.
  • Devised PL/SQL statements - Stored Procedures, Functions, Triggers, Views and packages.
  • Developed Database objects like tables, Indexes, triggers for Reporting Database.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Developed automated scripts to create audit triggers for the tables.
  • Developed PL/SQL procedures, functions, packages and triggers.
  • Developed Oracle PL/SQL triggers and procedures.
  • Developed back end interfaces using PL/SQLstored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
  • Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
  • Analyzed, designed and developed Oracleforms 10g queries, layout, report triggers, parameter form, data models etc.
  • Developed Triggers, Procedures, Functions and Packages, Views, GTTs.

Show More

1 Triggers Jobs

No jobs at selected location

18. Constraints

demand arrow
average Demand
Here's how Constraints is used in Senior Pl-Sql Developer jobs:
  • Implemented enforcing data integrity using integrity constraints.
  • Create and maintain indexes, constraints, tables, PL/SQL stored procedures & packages and produce queries to answer business questions.
  • Created Oracle schema i.e., tables, indexes, constraints, triggers, synonyms, database links, roles etc.
  • Created logical and physical database objects - tables, indexes, referential integrity constraints, and Triggers to development needs.
  • Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
  • Worked on the Stored Procedures, Functions and Constraints, Tables, Indexes and Tuned queries for performance.
  • Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, Indexes.
  • Created database objects like Tables, Sequences and Constraints as per the business requirement.
  • Worked on Creation of tables, indexes, sequences, constraints and procedures.
  • Document modeling approach, data sources and transformations, assumptions and constraints.
  • Created the integrity constraints and Database Triggers for the data validations.
  • Developed tables, indexes, constraints, views and sequences.
  • Created new tables, constraints for all the modules.
  • Created indexes, Views, constraints.
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
  • Created and maintained Sybase/DB2 Database Objects like tables, views, indexes, constraints, sequence.
  • Implemented all modules logic by using Triggers and Integrity Constraints.
  • Created tables, constraints, indexes and synonyms Created oracle pl/sql packages, procedures, functions, triggers, cursors.

Show More

19. DB

demand arrow
average Demand
Here's how DB is used in Senior Pl-Sql Developer jobs:
  • Worked on materialized views, DBMS_SCHEDULER for scheduling jobs and UTL_MAIL to send mails using oracle 10g.
  • Worked closely with DBA to implement the Database changes and analyze the performance of the Application.
  • Worked on Dynamic SQL by using Execute Immediate and DBMS_SQL along with Bulk Collect.
  • Performed performance tuning using the DBMS_PROFILER package, this checks the run time behavior.
  • Used ORACLE packages DBMS_PROFILER, SQL_TRACE, and TK_PROF reports performing Package performance analysis.
  • Gathered the table's statistics using DBMS_STATS package and analyzed overall system performance.
  • Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.
  • Get candid feedback from users about the scope of the performance problem.
  • Implemented 11g and upgraded the existing database from DB2 to Oracle 11g.
  • Performed DBA activates of taking backups (Cold and Hot).
  • Implemented RDBMS (normalization) concepts in Data modeling.
  • Used Data dictionaries and DBMS packages very effectively.
  • Atomized routine jobs using DBMS_JOB.
  • Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS, and DBMS_PROFILER.
  • Performed Tuning by using various tools like EXPLAIN PLAN, DBMS_PROFILER, Indexes, Hints etc.
  • Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS_PROFILER, Hints etc.
  • Used PL/SQL programming to develop standard packages like DBMS_SQL, DBMS_JOB, and UTL_FILE.
  • Involved in PL/SQL tuning using various tools like TKPROF, EXPLAINPLAN, DBMS_PROFILER.
  • Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.
  • Used SBM to work on DMR's and DBCR's.

Show More

20. Sub Reports

demand arrow
average Demand
Here's how Sub Reports is used in Senior Pl-Sql Developer jobs:
  • Created various tabular, Matrix, Chart, Drill-down/Drill through, sub reports and linked reports using Reports 10g/11g.

Show More

21. Business Logic

demand arrow
average Demand
Here's how Business Logic is used in Senior Pl-Sql Developer jobs:
  • Worked closely with Stakeholders and Internal users for business logic enhancements and maintenance.
  • Created standard procedures and customized procedures to implement business logic.
  • Developed PL/SQL Packages, Procedures, Functions, Triggers, Indexes and Collections to implement business logic using SQL navigator.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
  • Created the PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.
  • Prepared test cases to validate each transformation logic and business logic and the end result data.
  • Created complex mappings that involved implementation of Business Logic to load data in to staging area.
  • Implemented Complex business Logic as per the client requirement in procedures, functions, packages.
  • Developed different complex PLSQL packages, Perl scripts to accomplish the complex business logic.
  • Created database objects and converted business logic into PL/SQL packages with much efficient performance.
  • Developed procedures, functions and packages to implements the systems business logic using PL/SQL.
  • Identified business logic for data mapping from Third party systems into Patent DB.
  • Developed PL/SQL program unit to test the business logic in testing environment.
  • Created audit tables and implemented complex business logic using triggers.
  • Developed stored procedures to apply business logic on raw data.
  • Implemented Complex business Logic as per the client requirement.
  • Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
  • Used Informatica tool to extract data and modify it depending on the specific business logic.
  • Parameterized sql scripts based on the business logic to move them into core tables.
  • based upon the business logics.

Show More

22. Design Documents

demand arrow
average Demand
Here's how Design Documents is used in Senior Pl-Sql Developer jobs:
  • Authored Business Requirement Documents, Functional and Technical Design documents, Integration Documents and User training Documents.
  • Created both technical and functional design documents for all reports and enhancement requirements.
  • Prepared final design documents and general instruction to follow during development.
  • Developed application technical design documents and user guides for training.
  • Developed technical design documents by reviewing functional requirement documents.
  • Translated end user requirements into design documents.
  • Documented every setup change and wrote technical Design documents (MD 70) for all the reports that have been developed.
  • Create and test the preliminary requirements and produce design documents and assist Business Analyst for functional test.
  • Prepared Detailed Design documents and data flow diagrams for Credit Card Level II integration and Text2Pay projects.
  • Involved in gathering requirements and created design documents and mapping documents, Data modeling.
  • Created Design documents, User manuals, and Unit Test documents.
  • Used these design documents in development of ODI interfaces/packages.
  • Involved in writing Technical and Functional Design Documents.
  • Designed technical design documents for ETL process.
  • Created high level detailed design documents.
  • Prepared Low Level Design Documents.
  • Used ODI Designer tool to design data integrity checks and to built transformations Responsible for technical design documents.
  • Created deliverables such as design documents, Unit test documents and KT documents for the testing team.
  • Participated in signoff of Functional Specification, System Design Documents of PAR.
  • Created ODI design documents from the existing Informatica mappings.

Show More

23. Schema

demand arrow
average Demand
Here's how Schema is used in Senior Pl-Sql Developer jobs:
  • Worked with Designers and developers to translate data requirements into the physical schema definitions for oracle.
  • Designed database schema and created database objects.
  • Created PL/SQL procedures, functions and batch scripts, C++ programs for loading flat files, BCD/Binary files into database schema.
  • Worked on database design - deciding on/ improving schema, table and index design criteria for new and existing modules.
  • Worked with DBA for creating the schema objects like Tables, Synonyms, Sequences, DB Triggers, and views.
  • Created PLSQL procedure to load the data from one table to the other table in different schema for LP Project.
  • Played a major role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
  • Created synonyms and granted privileges on schema objects for other users to be able to share and access content.
  • Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
  • Involved in the development of the Conceptual, Logical and Physical data model of the Star Schema using ERWIN.
  • Worked with ER Studio to analyze logical data models and generate physical DDL scripts for schema generation.
  • Design data model using Oracle BI tool with properties of star schema.
  • Performed physical database designs and built application schemas.
  • Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
  • Worked with DBAs to analyze performance during table space and schema lock issues.
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Table level, schema level and tablespace level backups.
  • Created databases, tables, views & schemas.
  • Worked on roles and grants to schemas to other schemas.

Show More

4 Schema Jobs

No jobs at selected location

24. DBA

demand arrow
average Demand
Here's how DBA is used in Senior Pl-Sql Developer jobs:
  • Involved in tuning SQL statements and complex Stored Procedures for faster execution and actively participated with DBA to utilize performance issues.
  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Involved in daily meetings with development team in Agile environment updating with further steps and providing feedback on current issues.
  • Played a major role in coordinating Admin and DBA Team for data exports, imports and migration between different environments.
  • Worked closely with the DBA for the performance tuning and create daily trade fact table-partitioning to improve the performance.
  • Worked closely with the DBA for the performance tuning and incorporated table-partitioning concepts to improve the performance.
  • Provided continuous feedback and support for PLSQL and SQL Performance turning to developers and Code review.
  • Mentored Junior DBA's and developed department wide standards for Development and Production scripting and processing.
  • Coordinated with DBA in creating and managing tables, indexes, database links and privileges.
  • Coordinated with DBA and Business objects designer group in solving various technical issues.
  • Involved with DBA in creating Table partitioning for the critical bond tables.
  • Support production DBA in daily or emergency procedures to resolve issues.
  • Interacted with the DBA team for Performance Tuning and database issues.
  • Coordinate with the DBA for Table creation and other administrative activities.
  • Coordinated with DBA in improvement of Performance of Database.
  • Involved application deployment process and co-ordinate with DBA Team.
  • Worked closely with the technical teams and DBAs for issues related to code changes, data fixes, and testing.
  • Worked closely with DBAs to fix performance issues caused by Oracle wait events such RC Latch events etc.
  • Coded conversion scripts to and data model patches and coordinated with DBAs for their execution and validation.
  • Resolved temp space issues by talking to DBA Wrote Unix Shell scripts and scheduled various jobs using crontab.

Show More

25. QA

demand arrow
average Demand
Here's how QA is used in Senior Pl-Sql Developer jobs:
  • Resolved production/post production problems coordinating with development/QA team.
  • Helped QA team and support team by explaining the developed code and solved prod issues and UAT issues by fixing bugs.
  • Involved in Source code release to higher environments (QA, UAT and Production) using Tortoise SVN version control tool.
  • Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
  • Supported operations during the build/deployment of a new release to the Integration, QA and Production environments.
  • Created Test Plan for QA and implementation plan for Production implementation once the unit test is done.
  • Performed Unit testing, UAT, created test plan for QA and prepared production implementation scripts.
  • Provide test data QA team to validate front end application and also involved in unit testing.
  • Worked closely with Development, QA, Testing and Production team to implement projects successfully.
  • Prepared test plan for QA for testing before moving from PreProd to Production environment.
  • Created and implemented DDL Implementation Scripts in Development, QA and Production Environment.
  • Oversee the QA activities including Execution of test cases and analyzing test results.
  • Work with QA and provide support to provide timely technical resolutions for defects.
  • Set up Oracle DEV, QA and QAC database environments.
  • Experience in QA testing and Data validation using SQL.
  • Migrated the code into QA (Testing) and supported QA team and UAT (User).
  • Involved all SIT, QA, UAT and Production deployment.
  • Worked with BA in the QA phase of testing.
  • Participate in requirements review, application design review and test plan reviews Coordinate activities with infrastructure, business and QA teams.
  • provided check queries to QA team to test the developed process and provided supports packages to support team.

Show More

26. Test Cases

demand arrow
average Demand
Here's how Test Cases is used in Senior Pl-Sql Developer jobs:
  • Develop and execute unit test cases on the code developed to ensure quality code gets promoted to the testing environments.
  • Created data validation test cases and test scripts for Unit Testing and Integration Testing and documented the same.
  • Involved in writing Test cases and performing data validation and process testing for application moving into production.
  • Created test cases and test reports and worked with QA team to validate the data and scenarios.
  • Executed the regression test cases along with testing new enhancements by using QTP and analyzed results.
  • Involved in creating Test Cases as well as Unit testing all kinds of oracle objects.
  • Prepared Test cases and testing procedures for the database packages and ETL interfaces and packages.
  • Documented business rules, functional and technical designs, test cases, and user guides.
  • Created and executed test cases documenting actual results compared to expected result using HP QC.
  • Involved in developing detailed test plan, test cases and test scripts using PL/SQL.
  • Developed Test cases and performed Unit and Integration testing for every development tasks.
  • Created test cases for Unit testing, Integration testing and User acceptance testing.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repositories.
  • Create test cases and programs before update to QA department for testing.
  • Involved in Unit Testing and preparing test cases for User Acceptance Test.
  • Analyzed Business requirements, Created Test Plans and Test cases.
  • Worked on creating test cases and data validation scripts.
  • Used HPQC for logging defects and executing test cases.
  • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center.
  • Code SQL Stored Procedures and integrated with application Involve in Unit Testing for the application developed using test cases.

Show More

27. Autosys

demand arrow
average Demand
Here's how Autosys is used in Senior Pl-Sql Developer jobs:
  • Automated the process of migration from SQL server to Oracle by using AUTOSYS.
  • Work with Automation tools such as Autosys and Tidal for scheduling jobs, dependencies, and defined calendar dates.
  • Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
  • Run reports between Autosys and Tidal by written queries with the help of SQL DEVELOPER.
  • Schedule Autosys jobs through inserting, deleting and updating jobs in various development instances.
  • Developed the Shell Scripts and Used the Autosys for scheduling Jobs.
  • Scheduled and maintained Autosys/JIL jobs and product support for the jobs.
  • Created several shell scripts to invoke scheduled jobs from Autosys.
  • Created profiles to alias autosys codes and deployed it.
  • Created Autosys jobs which are scheduled to run daily.
  • Provided production support for Batch jobs scheduled through Autosys.
  • Automated executing script files through UNIX using Autosys.
  • Designed Autosys JILS to schedule jobs.
  • Performed requirement gathering, analysis and design for Oracle, Informatica and Autosys scheduler.
  • Worked with Autosys batch scheduling tool to automate running of several database tasks by writing JIL scripts and Korn shell scripts.
  • Created shell scripts to execute script in sql*plus using autosys jobs.
  • Used Cron Jobs and Autosys jobs to schedule various reports.
  • Scheduled batch jobs using Autosys to run the workflows.
  • Scheduled workflows using autosys job plan.
  • Created cronjobs in unix and also installed and migrated the jobs to autosys in unix.

Show More

28. UAT

demand arrow
average Demand
Here's how UAT is used in Senior Pl-Sql Developer jobs:
  • Design detail testing specifications for application development and evaluate all design and coding activities.
  • Evaluated technical feasibility of Flashback database feature for fast database recovery.
  • Analyze complex tickets as and when they arise, resolved them and passed them to UAT under critical time frames.
  • Performed code review & deployment activities in system testing, UAT and Production environments by using subversion version control.
  • Created Test cases for Unit testing, System Integration Test and UAT to check the data.
  • Manage the packaging and release of applications to the training, UAT and production environments.
  • Designed and developed user test scripts for the UAT and migration of the developed codes.
  • Performed unit testing before promoting the code UAT and supported QA with defect resolution.
  • Support SIT, UAT and Production Implementation for Data Migration track of Voyager Program.
  • Prepared UAT and SIT Test Cases based on the functional and technical documents.
  • Designed, Developed and Tested application in UAT environment and Deployed in Production.
  • Worked in different areas like Development, UAT and Production.
  • Involved in UAT testing, Bug fixing and Production move.
  • Provided UAT, production and on-call support for the project.
  • Involved in Unit testing, System testing and UAT.
  • Supported the application during UAT and Production.
  • Performed GUI, Functional, smoke, Security, End to End, back end, Regression and UAT testing.
  • Worked with T-SQL for validating the SQL Server2000 Worked closely with and carried out User Acceptance Testing (UAT).
  • Performed Database Synchronization (Export/Import Schemas) From PROD Environment to UAT / DEV environments.
  • Created Databases Schemas in Dev, SIT, UAT and PROD Environments.

Show More

29. Data Analysis

demand arrow
average Demand
Here's how Data Analysis is used in Senior Pl-Sql Developer jobs:
  • Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
  • Conducted data analysis on various subsystems.
  • Created complex SQL queries, Stored Procedures, functions and database triggers and Views for the purpose of data analysis.
  • Involved in data analysis and reporting on ATT Commerce Service Center Application & Merchandising data for ATT-mobile online shoppers.
  • Conducted multiple Source Data Analysis Sessions with Source Data Providers (Source Systems) to finalize the data requirements.
  • Involved in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data Warehousing Environments.
  • Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose.
  • Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
  • Involved in source data analysis and creating ETL design document along with the enterprise architects.
  • Fix open ticket as created by users that includes code modification and issue data analysis.
  • Performed data analysis, testing, debugging, audits and disaster recovery.
  • Played a key role in setting up infrastructure and test data analysis.
  • Involved in requirements gathering, debugging, regression testing, data analysis.
  • Web server log files and page tagging data analysis.
  • Write Ad-Hoc SQL queries for data analysis and Testing.
  • Performed data analysis and data profiling using SQL.
  • Experience in data analysis & data cleansing.
  • Performed Data analysis for LAP and Oracle GL Accounts, Counterparty, Instrument data.
  • Worked on HDFS, Sqoop, HIVE for data loading and data analysis.
  • Involved with data analysis using Teradata SQL assist from data source.

Show More

30. Easy Retrieval

demand arrow
low Demand
Here's how Easy Retrieval is used in Senior Pl-Sql Developer jobs:
  • Created Table partitions, analyzed tables for performance enhancements and easy retrieval of data.
  • Used Bulk Collections for better performance and easy retrieval of data.

Show More

31. Data Migration

demand arrow
low Demand
Here's how Data Migration is used in Senior Pl-Sql Developer jobs:
  • Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
  • Involved in Legacy data migration and Reports development.
  • Assist team members with technical analysis and participate in all development activities and perform tests on data migration and production platform.
  • Involved in huge data migrations, transfers using utilities like SSIS, bulk copy program (BCP) and bulk insert.
  • Created stored procedures, packages, Indexes, partition pruning, views and more PL/SQL constructs towards the data migration.
  • Involved in the design, development and testing of custom data migration scripts using Oracle PL/SQL in an optimized manner.
  • Develop a Generic Data Migration (ETL) system for the RIS system from many variable databases and formats.
  • Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
  • Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Worked on Data migration project by validating three source data row by row and field by filed.
  • Involved in the Data migration projects by migrating the data in old structure to new structures.
  • Managed more than 10 server instances and migrated code and data migration between different developments environments.
  • Undertake Performance Tuning activities to ensure the procedures and functions used in data migration perform optimally.
  • Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
  • Performed Data Migration using SQL* Loader from flat files in to data base tables.
  • Worked on system analysis with special emphasis on system integration and data migration needs.
  • Worked actively with Developers during data migration from one environment to the other.
  • Worked on Data Migration from legacy system to oracle 11g system.
  • Worked on data migration from one database to other database.
  • Created mappings and workflows for data migration using Informatica Power Center.

Show More

1 Data Migration Jobs

No jobs at selected location

32. Perl

demand arrow
low Demand
Here's how Perl is used in Senior Pl-Sql Developer jobs:
  • Created UNIX shell scripts for execution of Perl scripts including data extraction, loading and stored procedure execution.
  • Developed modules using PERL shell scripts on Oracle database to implement batch processes for late running financial reports.
  • Created trigger events using UNIX and Perl to send email to project managers on high severity issues.
  • Developed software in object-oriented Python, PL/SQL; transformed data with Perl; wrote complex SQL.
  • Check the functionality of data in the front-end whether it is displaying properly or not.
  • Participated in API Project (ECCO/ARBOR tables interface/conversion) using UNIX/SQL/PERL/Pro*C/C++, COBOL Micro-Focus.
  • Worked with requirement analyst to make sure all requirements are tested properly.
  • Created automated jobs using PERL scripts to run the batch jobs.
  • Executed PL/SQL scripts on server using Shell and Perl scripts.
  • Developed several UNIX Shell scripts/Perl Scripts to automate database processes.
  • Created many common components of UNIX and PERL Scripts.
  • Created Perl scripts for running the daily sync cycle.
  • Developed UNIX shell scripts (KSH) and Perl scripts for batch run.
  • Worked as a Senior PL/SQL and Perl/Autosys resource as well as the Lead for developing code in each quarterly release.
  • Created Perl Scripts and Autosys job to automate the monthly report generation process.
  • Develop best practices to ensure coding efficiency and quality using Perl.
  • Analyzed big data for genomics using PERL scripts.
  • Project: Finance Technologies:: PL/SQL, ETL, Perl Database & Tool: Oracle DB 11g, TOAD .
  • Developed scripts in Korn shell and Perl for network management Provided Post production Technical Support to the users.
  • Used Perl and shell scripts (Korn shell) to pre-process data in UNIX.

Show More

33. External Tables

demand arrow
low Demand
Here's how External Tables is used in Senior Pl-Sql Developer jobs:
  • Created views, materialized views and external tables for the various modules based on the needs from Business Team.
  • Worked extensively with oracle External tables to load data from flat files into data mart for further processing.
  • Transform and load of source data into Oracle database using Oracle external tables and PL/SQL stored procedures.
  • Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
  • Designed and implemented an automated data file load system using PL/SQL and Oracle external tables.
  • Worked with external tables, loaded data from flat files into Oracle tables using SQL*Loader.
  • Loaded the data into database tables using External Tables from text and excel files.
  • Created external tables to handle huge volumes of data which is not accesses frequently.
  • Used techniques like direct path load, external tables for loading the data faster.
  • Import of data from SQL Loader to Oracle tables and creation of external tables.
  • Used external tables to manipulate data obtained daily before loading them into the tables.
  • Worked with External Tables, SQL * loader and creation of control files.
  • Created external tables to load data from various files supplied by data supplier.
  • Implemented External tables and created Sequences to generate numbers on the fly.
  • Worked with External Tables to access and import the required information.
  • Used Oracle external tables with SQL*Load to ease files loading.
  • Performed Import/Export of data using SQL*Loader and External Tables.
  • Worked on External Tables and Global Temporary Tables.
  • Create External tables for Warehoused data.
  • worked on partitioning tables, used sql loader and external tables to feed data as part of ingestion process.

Show More

34. Html

demand arrow
low Demand
Here's how Html is used in Senior Pl-Sql Developer jobs:
  • Used HTML tags in PLSQL to deliver a well-organized and readable email status update to the testing group.
  • Used HTML code to incorporate clients' logo into the body of the email.
  • Involved in customizing the web pages by modifying HTML and Java Script.
  • Used Oracle inbuilt packages in implement automated email (HTML) system.
  • Design few pages using HTML and XML to interact with database.
  • Used the HTML Coding for sending email notification for the users.
  • Worked with HTML development for the part of a project.
  • Worked with HTML5/CSS3 to develop/upgrade the GUI of the applications.
  • Created and used HTML for data management and transmission.
  • Generated Dynamic web-reports using HTML and XML.
  • Implemented HTML and JavaScript using on-demand processes.
  • Involved In implementation of HTML, CSS, JAVASCRIPT and AJAX.
  • Used HTML to format the data.
  • Worked with HTML, JavaScript pages in order to create web pages and fix bugs for the Rhapsody web site.
  • Implemented custom HTML java scripting and Jquery when building page reports, buttons and templates in APEX.
  • Used Oracle JDeveloper to support JAVA, JSP and HTML codes used in modules.
  • Generated dynamic web-reports using Java, Jsps, HTML and JavaScript.
  • create HTML formatted reports with Pro*C programs for end users.
  • Developed and Maintained 10000+ AEOS generated HTML Javascript procedures.
  • Scheduled html reports using UTL_SMTP, UTL_MAIL and DBMS_SCHEDULER.

Show More

35. SVN

demand arrow
low Demand
Here's how SVN is used in Senior Pl-Sql Developer jobs:
  • Performed version control management of the developed code using SVN repository to perform check-outs, check-ins and creating new elements.
  • Worked on SVN Subversion for source and version control of the documents prepared for development and testing as well.
  • Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
  • Used SVN version control management software's for maintaining the code version standards and security.
  • Set up Crucible for all projects code review and integrated it with SVN check ins.
  • Prepared environment for IW Production and deployed code into server and SVN for P-CUT.
  • Used Software configuration management tools; Subversion (SVN) and Win CVS.
  • Used tortoise SVN to check in packages, table/view definitions code.
  • Planned version control of production source code using Control SVN.
  • Maintain source code for all database objects using SVN.
  • Source version controlled using Subversion tool (SVN).
  • Maintained different versions of codes using SVN.
  • Maintained version control on files using SVN.
  • Help troubleshoot database problems in various environments when needed Primary technologies: Oracle 11g, PL/SQL, SVN, Agile
  • Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
  • Used tortoise svn version control for changing the codes.
  • Used SVN Tortise for code submission.
  • Used Version Control tools like Tortoise SVN, Microsoft-TFS, IBM-Synergy) Worked on HLD and LLD preparations.
  • Have used SVN Subversion , GIT/Geritt for Version Controlling, Change Management and code review.
  • Experience of working with HP Quality Center ALM , JIRA , Tortoise SVN, SQL Developer, TOAD.

Show More

36. Complex Queries

demand arrow
low Demand
Here's how Complex Queries is used in Senior Pl-Sql Developer jobs:
  • Created numerous complex queries involving joins, correlated sub-queries diverse business requirements.
  • Created Materialized views to analysis complex queries.
  • Helped Developers in writing the Complex queries, Stored Procedures, Packages, and Triggers as per the business requirements.
  • Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
  • Developed reports using complex queries as per client request as a part of production support.
  • Used mantas Scenario Manger to create new AML scenarios, writing complex queries in Oracle.
  • Created and designed reports based on complex queries using Oracle Reports according to the requirements.
  • Created partitioned tables and partitioned indexes to improve the performance of the complex queries.
  • Developed various complex queries to generate various reports to predict business trend.
  • Involved in preparing complex queries as per client's requirements.
  • Prepared complex queries and PL/SQL code for the reporting purpose.
  • Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
  • Developed various Complex Queries, Views for generating Reports.
  • Involved in writing several complex Queries and Procedures.
  • Involved in Performance tuning of complex queries.
  • Developed complex queries to retrieve the data.
  • Created the test scripts and complex queries to test the timesheet application and to quality assurance of the data.
  • Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.
  • Developed complex queries to generate reports for both ad-hoc analysis and scheduling reports.
  • Developed complex queries on Database and developed PL/SQLProcedures to give in nice strategicplans to higher level of management.

Show More

37. Linux

demand arrow
low Demand
Here's how Linux is used in Senior Pl-Sql Developer jobs:
  • Involved in developing, testing, compiling, debugging and maintains the data using oracle, PL/SQL, UNIX, LINUX.
  • Maintained 24/7 high volume availability demands using open source tools such as Linux, Apache, PHP, and MySQL.
  • Developed Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into table.
  • Designed and programmed applications and utilities using C++, Perl, and shell scripting for Linux operating systems.
  • Installed Linux software and setup Apache web servers that provided the launch platform for QA team and developers.
  • Shell scripting for automation of various Linux administrative tasks related to the maintenance of Data Explorer instances.
  • Review Linux shell scripts and make necessary changes required for the process.
  • Worked on Linux server and used vi editor to update XML files.
  • Used Linux and Unix system during the projects.
  • Job scheduling using Linux CRONTAB.
  • Migrated multiple Clients from Solaris, Windows, and Linux to different platforms with Oracle 10g, 9i, 11g.
  • FTP the records to the FTP server in the gzip format on the Linux server using putty and Filezila.

Show More

38. Sdlc

demand arrow
low Demand
Here's how Sdlc is used in Senior Pl-Sql Developer jobs:
  • Tested applications and resolved complex problems throughout software development life cycle (SDLC), including preparing detailed program specifications.
  • Designed application framework and provided APEX guidance and support to technical staff on application maintenance and SDLC process.
  • Managed all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.
  • Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
  • Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
  • Worked on SDLC (Software Development Life Cycle) during the period of application development.
  • Involved all the phases in SDLC and good experience in agile methodologies for application developments.
  • Followed & Implemented Standards for BI & DW at various levels of the SDLC.
  • Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
  • Work within a structured SDLC process of managing software maintenance and development.
  • Involved in SDLC - Analyzed the existing partially developed tool.
  • Worked on all phases of Agile SDLC with minimal guidance.
  • Involved in SDLC including designing, coding and testing.
  • Involved in SDLC gathering requirements from end users.
  • Work towards a balanced, risk-driven SDLC target.
  • Worked on the complete life cycle (SDLC) for the projects.
  • Involved in all the phases of SDLC i.e.
  • Compiled Dev Test Plan, Design & Code Review Docs as part of the deliverable to the SDLC artifacts.
  • Worked on SDLC Iterative life cycle model / Agile Lifecycle (Scrum meetings / Sprints).
  • Worked with IBM Rational Team concert(rtc) to keep track of Agile SDLC life cycle.

Show More

2 Sdlc Jobs

No jobs at selected location

39. Web Application

demand arrow
low Demand
Here's how Web Application is used in Senior Pl-Sql Developer jobs:
  • Experience performing application development work using Oracle Application Express to design and maintain web applications.
  • Facilitate requirements gathering and design sessions of APEX web applications with customers.
  • Developed Oracle PLSQL procedures, SQL routines and mapping tables to convert Legacy data into Web application's oracle database system.
  • Developed Oracle packages, functions and procedures to sync the modified legacy information into new web application's Oracle tables.
  • Created complex Oracle packages and other database objects while application is migrated from Legacy forms to java web application.
  • Card Management System (CMS) is a web application for administration of its Prepaid Open Loop card operations.
  • Developed Database Programs used by Web Application team using Oracle SQL, MySql for Dot net environment.
  • Develop sample web applications and demonstrate the same to clients for easy customization of -the web pages.
  • Developed SQL utilities using SQL*Plus for Web application development, data migrations and conversions.
  • Worked for Web Application Framework and Content Management System built with Java.
  • Support the existing web applications & provide timely resolutions to issues encountered.
  • Created Web application with SQL Server back-end for internal reporting.
  • Used APEX to develop end to end Web Application Development.
  • Conducted functional testing of web applications with HTTP client simulator.
  • Created packages, procedures, functions, cursors in PL/SQL that can be used for backend validations for web applications.
  • Experience in working on jasper reports server for reporting services of an web application.
  • Migrated Oracle Retek application into Common merchandising system (CMS) web application.
  • Used MOD PL/SQL that allows to create Web Applications using Oracle stored procedures.
  • Involved as the developer for web application workflow tool and created various JSP's and servlets.
  • Maintained user provisioning process through custom logic for iStore, ireceivables, iSuppliers, eModules and Web Money web application services.

Show More

40. Production Issues

demand arrow
low Demand
Here's how Production Issues is used in Senior Pl-Sql Developer jobs:
  • Assisted team in resolving issues related to the functional and technical problems and to resolve production issues.
  • Worked closely with business users, development team and DBA for new implementation and fix production issues.
  • Monitored production jobs to make sure the files are properly being processed and fixed production issues.
  • Interacted with client to understand production issues and solved them effectively to not miss the SLA.
  • Created complete new design to resolve the production issues related to reminder letters sending logic.
  • Identified existing production issues and various flaws in the existing system and process flow.
  • Developed Unix Shell script to identify and fix Root cause for Production Issues.
  • Worked closely with Production Support team to Troubleshoot and fix any production issues.
  • Work with application team and production support teams to resolve production issues.
  • Interacted with production support team regarding production issues and release plans.
  • Handled Production issues and managed the same in issue log.
  • Involved in the continuous enhancements and fixing of production issues.
  • Worked with production support team in resolving production issues.
  • Provide the work around for the production issues.
  • Interacted with production support team regarding production issues.
  • Handled Production issues with high pace and efficiency.
  • Worked in resolving the production issues.
  • Worked on production issues and modify code through code optimizations and indexes.
  • Used Salesforce to track production issues/tickets.
  • Worked on Instance management with DBAs, system administrator teams to coordinate instance refreshes, downtimes and production issues.

Show More

41. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in Senior Pl-Sql Developer jobs:
  • Created ETL Mapping specifications using functional specifications and Technical Specifications document based on functional specifications.
  • Interacted with client for requirement gathering and translated Business Requirements to Technical specifications.
  • Translated the business requirements to technical specifications based on the functional specifications.
  • Analyzed the business requirements and prepared Technical specifications document based on it.
  • Prepared detailed Technical Specifications for Business Processes based on Use Cases.
  • Developed technical specifications for various back end modules from Business Principles.
  • Authored technical specifications accurately documenting each phase of completed work.
  • Designed intermediate database tables as per technical specifications.
  • Gathered report requirements and document technical specifications.
  • Convert the functional requirements into technical specifications.
  • Developed Functional and Technical Specifications.
  • Worked with Business Analysts and Business Users team to understand the requirements and translate the requirement into technical specifications.
  • Involved in the team for documenting functional and technical specifications, including specifications for others to build.
  • Documented every phase like Technical specifications, source to target mappings, data and release notes.
  • Documented Technical Specifications and wrote Automated UNIT tests (using PLSQL) for PL/SQL packages.
  • Prepared technical specifications document for the IDRGL Recon process in AIG.
  • Involved in data extraction scripts coding as per technical specifications.
  • Prepared test plans for System and User acceptance test Involved in documenting users requirements, technical specifications and Reporting manuals.
  • Created required technical documents such as Technical specifications Complete responsibility of deliverables as well as the production support.
  • Optimized existing PL/SQL packages and SQL scripts Document Technical Specifications Automated UNIT testing for PL/SQL packages and scripts Provided test support

Show More

42. Analytical Functions

demand arrow
low Demand
Here's how Analytical Functions is used in Senior Pl-Sql Developer jobs:
  • Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
  • Involved in using of new features of Oracle 11g like Analytical functions, flash back Query, regular expressions etc.
  • Experience working with Sequences, Indexes, Views, Table Partitioning, Collections, Analytical functions and Materialized Views.
  • Used Pipeline functions, Functional Indexes, regular Expressions, Merge statements, and analytical Functions.
  • Used single-row functions, aggregate functions, analytical functions, correlated sub-queries and nested sub-queries.
  • Used Oracle features like Global Temporary tables, Analytical functions, and Table functions.
  • Created highly re-usable, robust, highly performing SQL queries using analytical functions.
  • Worked on Oracle table partitioning, collections and Analytical functions in Oracle.
  • Experience with Oracle analytical functions, table functions and hierarchical queries.
  • Developed Reports using Analytical functions ROLLUP, CUBE and Inline Views.
  • Used advanced SQL and analytical functions in various queries.
  • Worked on the Analytical functions.
  • Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
  • Worked on all type of Analytical Functions (RANK, DENSE_RANK, LAG, LEAD etc.).
  • Used analytical functions like RANK, LAG, LEAD and PARTITION BY.
  • Used analytical functions extensively like XML ELEMENT, STRAGG, and RANK to generate adhoc reports as per the business requirements.
  • Developed SQLs using Analytical functions such as Rank () & Dense_Rank ().
  • Used various analytical functions to handle complex logic of pl/sql case statement scenarios.
  • Developed Lookup tables using SQL queries and analytical functions.
  • Used analytical functions like Rank, Dense_rank, Row_number.

Show More

43. DDL

demand arrow
low Demand
Here's how DDL is used in Senior Pl-Sql Developer jobs:
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
  • Create reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
  • Ensured all structural (DDL) changes to the database have a proper build and follow release management/CM process.
  • Used ref-cursor to capture many rows within a PL/SQL block to send the data to Java middle tier.
  • Single point of contact for all database changes and handled all DML and DDL scripts in code repository.
  • Worked in developing database table design, ERD and creating the DDL scripts for the new oracle database.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Generate DDL scripts as per the data model and implement them in the database.
  • Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
  • Fine-tuned DML, DDL scripts with lock hints for improving the performance.
  • Created various DML and DDL statements using Oracle Pl/SQL and SQL.
  • Used Dynamic SQL to implement DDL statements in PL/SQL programs.
  • Modified database structure, DDL, where required.
  • Sound knowledge of DDL triggers.
  • Developed DML and DDL scripts.
  • Created DDL and DML scripts.
  • Implemented parsing xml and flat files from and to the middle ware i.e.
  • Created Triggers tracking logon activity, user objects and DDL operations.
  • Handled data coming from middleware using LOB data types.
  • Created physical database design diagram in toad data Modler and generated ddls from it.

Show More

44. Korn

demand arrow
low Demand
Here's how Korn is used in Senior Pl-Sql Developer jobs:
  • Created KORN Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
  • Used KORN jobs to schedule various reports.
  • Designed and Developed FTP, SFTP and NDM (direct) processes using Java, PL/SQL and Korn Shell Script.
  • Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
  • Experience with building application using Oracle APEX, worked on Korn shell scripts on UNIX platforms.
  • Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment.
  • Used UNIX Shell (Korn) Scripts for Extraction, Transformation and Loading of data.
  • Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
  • Transferred SQL and Korn shell programs into ODI and created data extracts.
  • Developed scripts in Korn shell and Perl for network management.
  • Modified existing Shell Scripts and created new Korn Shell Scripts.
  • Created Korn UNIX Shell script to run Oracle Stored Packages.
  • Analyze Korn shell scripts on UNIX platforms.
  • Executed Korn Shell Scripts in Production.
  • Experience in scripting (UNIX korn shell scripting) to call the PL/SQL programs.
  • Created UNIX shell scripts (Korn) to call Oracle package procedures, extract and load data and handle appropriate errors.
  • Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
  • Created and developed korn shell scripts for calling procedures through unix.
  • Develop Perl, Korn shell, awk , sed scripts in Unix(Solaris).

Show More

45. Master Tables

demand arrow
low Demand
Here's how Master Tables is used in Senior Pl-Sql Developer jobs:
  • Developed SQL scripts for referential integrity check to check validity of incoming data with master tables.
  • Developed triggers to audit data from master tables to Audit tables.
  • Designed and developed master tables, views, sequences and synonyms.
  • Designed and developed master tables, indexes and sequences.

Show More

46. User Acceptance

demand arrow
low Demand
Here's how User Acceptance is used in Senior Pl-Sql Developer jobs:
  • Project Documentation activities like Technical Documentation, Client Discussions for solution and User Acceptance Testing.
  • Detected and Corrected bugs during system integration and user acceptance testing.
  • Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.
  • Involved in migration of the lip modules to the test environment and support for the user acceptance testing.
  • Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Created indexes to improve performance and developed test cases for user acceptance testing and unit testing.
  • Helped End-Users performing User Acceptance Testing (UAT) over the regions involved across the globe.
  • Performed unit testing and user acceptance testing and provided support to QA and other downstream systems.
  • Involved in Coding, Unit Testing, Integration testing, User Acceptance testing of PRISM.
  • Provided reliable, timely support of integration, performance and user acceptance testing processes.
  • Involved in different phase of testing like User Acceptance Testing, Unit testing.
  • Manage User Acceptance Testing of new applications and new versions of existing applications.
  • Engaged in user acceptance testing for migration from Oracle to DB2 UDB.
  • Provide support for all User Acceptance Testing's and for Production issues.
  • Developed test plans and test cases for user acceptance and unit testing.
  • Involved Integration testing and UAT - user acceptance testing.
  • Involved in User Acceptance testing and post production support.
  • Involved in User Acceptance Test with business users.
  • Performed unit and user acceptance testing.
  • Trouble shooting performance issues within packages using DBMS_OUTPUT Coordinated with the business users for User Acceptance Test.

Show More

47. Oltp

demand arrow
low Demand
Here's how Oltp is used in Senior Pl-Sql Developer jobs:
  • Performed normalization of the OLTP database to eliminate redundant data.
  • Developed and Created Database Objects in OLTP and OLAP Systems by Creating triggers, packages, procedures and functions using PL/SQL.
  • Created high performance queries and PL/SQL codes using Bulk Binds, Collections, REF Cursors etc for OLTP and ETL.
  • Handled a lot of OLTP data and applied various performance tuning methods to speed up the data retrieval process.
  • Developed payment engine tasks/batches for file based funds transfers to migrate data between OLTP and payment database.
  • Created/updated conceptual, logical and physical data models using OLTP best practices and according to company standards.
  • Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model.
  • Worked on custom development of data warehouse, operational data store, and OLTP systems.
  • Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
  • Created Logical and physical designs for OLTP, OLAP and DSS models Using Erwin.
  • Project Description: TronWeb (OLTP) is MAPFRE's core Insurance Processing system.
  • Developed projects in an OLTP database environment.
  • Worked on high OLTP applications.
  • Involved with OLTP relational databases system analysis, design, implementation and management.
  • Involved in development using PL/SQL and Datastage, for partner operations applications and customers OLTP applications.
  • Experience with custom development of datawarehouse, operational data store, and OLTP systems.

Show More

2 Oltp Jobs

No jobs at selected location

48. Production Environment

demand arrow
low Demand
Here's how Production Environment is used in Senior Pl-Sql Developer jobs:
  • Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
  • Handled primary DBA responsibilities on both development and production environments.
  • Deployed crucial patches directly into production environments.
  • Provide quality operations support for production environment.
  • Involved in migrating production database from Oracle 10g to 11g on Windows NT and deployment of objects to production environment.
  • Provided support for issues arising in the production environment of CRDB, outside the CCAR project.
  • Supported all the production environments and users on a daily basis by responding to emergency requests.
  • Code Migration and Production support- Migration of code to BUAT, UAT and production environments.
  • Worked in development, testing and production environment using packages, stored procedures, functions.
  • Created Implementation plans to deploy the code in database in UAT and production environments.
  • Developed migration scripts for initial full data loads in Test and Production environments.
  • Worked in all deployment processes to SIT, QA and Production Environments.
  • Developed and executed UNIX Shell Scripts and moved them to production environment.
  • Spool the data in the Production Environment before doing any DML.
  • Created Deployment scripts to deploy changes in production environment.
  • Provided 24*7 on call support to production environment.
  • Participated in the implementation of Data Guard in production environment and performed fail-over/fail-back on a regular pre-defined schedule.
  • Worked in Data modeling, Data mapping and Data flow Extensive knowledge on operations support for production environment.
  • Involved in database, ETL and Tivoli Jobs migration to QA and Production environments.
  • Use of Jil files and applyIM to install changes in development and production environment.

Show More

49. Autotrace

demand arrow
low Demand
Here's how Autotrace is used in Senior Pl-Sql Developer jobs:
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
  • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like EXPLAN_PLAN, AUTOTRACE and DBMS_SQLTUNE.
  • Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR report.
  • Analyzed performance of SQL queries using Explain Plan, Autotrace and Tkprof utilities and Plsql codes using dbms_trace and dbms_profiler packages.

Show More

50. Client Requirements

demand arrow
low Demand
Here's how Client Requirements is used in Senior Pl-Sql Developer jobs:
  • Customized Reports using Reports according to client requirements.
  • Generate analytic reports based on client requirements.
  • Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
  • Generated Reports on the daily basis according to client requirements using Crystal Reports.
  • Involved in created reports as per as client requirements with Tableau.
  • Engaged with management in the review and analysis of client requirements.
  • Developed SAP Business Object Reports as per client requirements.
  • Developed new Oracle Forms as per client requirements.
  • Implement PL/SQL jobs as per the client requirements.
  • Developed and maintained cognos reports according to client requirements.
  • Worked on creating Materialized Views in PROD based on adhoc client requirements.
  • Cater to adhoc client requirements to generate reports.
  • Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.

Show More

Senior Pl-Sql Developer Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Pl-Sql Developer

Pl/Sql

17.7%

SQL

14.7%

Database

11.0%

Business Requirements

7.5%

Unix

7.1%

Toad

6.4%

Data Warehouse

5.5%

ETL

4.0%

Windows Explain Plan

3.9%

Bulk Collect

2.5%

Tkprof

2.5%

Error Messages

2.4%

Informatica

2.4%

Cursors

2.0%

XML

1.9%

Synonyms

1.9%

Triggers

1.8%

Constraints

1.6%

DB

1.6%

Sub Reports

1.5%
Show More

Typical Skill-Sets Required For A Senior Pl-Sql Developer

Rank Skill
1 Pl/Sql 13.7%
2 SQL 11.3%
3 Database 8.5%
4 Business Requirements 5.8%
5 Unix 5.5%
6 Toad 5.0%
7 Data Warehouse 4.2%
8 ETL 3.1%
9 Windows Explain Plan 3.0%
10 Bulk Collect 2.0%
11 Tkprof 1.9%
12 Error Messages 1.9%
13 Informatica 1.9%
14 Cursors 1.5%
15 XML 1.5%
16 Synonyms 1.5%
17 Triggers 1.4%
18 Constraints 1.2%
19 DB 1.2%
20 Sub Reports 1.2%
21 Business Logic 1.1%
22 Design Documents 1.1%
23 Schema 1.1%
24 DBA 1.1%
25 QA 1.0%
26 Test Cases 1.0%
27 Autosys 1.0%
28 UAT 0.9%
29 Data Analysis 0.9%
30 Easy Retrieval 0.9%
31 Data Migration 0.9%
32 Perl 0.8%
33 External Tables 0.8%
34 Html 0.7%
35 SVN 0.7%
36 Complex Queries 0.7%
37 Linux 0.7%
38 Sdlc 0.7%
39 Web Application 0.6%
40 Production Issues 0.6%
41 Technical Specifications 0.6%
42 Analytical Functions 0.6%
43 DDL 0.6%
44 Korn 0.6%
45 Master Tables 0.5%
46 User Acceptance 0.5%
47 Oltp 0.5%
48 Production Environment 0.5%
49 Autotrace 0.5%
50 Client Requirements 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

19,698 Senior Pl-Sql Developer Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.