eclipse how to install java sql developer

#Eclipse how to install java sql developer code#
#Eclipse how to install java sql developer professional#

Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.Involved in Business Requirements, System analysis and Design of the Data warehouse application.Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.

#Eclipse how to install java sql developer code#

Used Jprofiler for java code profiling.Įnvironment: SQL* Plus, SQL* Loader, Java, Eclipse, Windows XP, UNIX,Git.

Used core java, java threading (to dynamically create processes).

Designed and developed migration module.

Used Tibco jms queue messaging system for internal data transmission.

Used Spring and Apache CXF while developing web services and used Postman to test the same.

Developed REST web services client code using swagger tool for code generation.

Worked on various phases of the project starting from collecting various business requirement, Designing of architecture, developing and testing.

Tools: Erwin and Oracle Designer, Power Designer, Testing with Postman, Swagger, Tibco jms queue, Jprofiler Programming Languages: SQL, PL/SQL, Java, HTML, PythonĪpplication Software: MS Office (Word, Excel, PowerPoint),Access,D2K,Oracle Forms 9i,Oracle Reports, Visual basic, Visual SourceSafeĭatabase Development Tools: Toad, SQL*Loader, SQL*Plus, SQL Developer, Putty, Enterprise Manager, Query Analyzer, SQL Profiler, PL/SQL developer, explain plan, awr repository, Informatica, ADDM

Ability to work independently and drive tasks to completion.ĭatabases: Oracle 9i, 10g, 11g,12c,IBM - DB2.

Experience in leading a team 4, while still performing database development duties.

Experience in using HPROF for PLSQL code performance. Performance tuning knowledge in SQL and PLSQL by using explain plan and row source operations to identify bottlenecks in queries and remediate them.

Experience in performance tuning for Oracle RDBMS using Explain Plan and HINTS.

Gather, analyze, summarize database information and prepare recommendations towards SOX initiative within organization.

Good experience in using PLSQL Collections.

Experienced in transforming complex business requirements from customer into development plan by using objects like Stored Procedures, Functions, Packages and Triggers to support Agile development.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) and other DB objects.

Experienced on installing oracle, creating database, creating directory, users, roles, grants, table spaces, partitioning in oracle.

Expert in creating Business reports, parameterized reports and in designing report layout using oracle reports.

Experience in the creation and maintenance of scripts (SQL Plus/KSH) used in database change management, MySQL to Oracle migrations, and schema setup.

Experience on REST services, Message Queues.

#Eclipse how to install java sql developer professional#

Eleven years of extensive professional IT programming experience as an Oracle PL/SQL Developer, Data Analysis, Design, Coding, Reporting, Database modeling, ETL Data Modeling, Maintenance, Testing, Documentation and Implementation of Business Applications.