• BS degree in Information Technology, Computer Science, or equivalent • 5+ years of architectural and developing applications on the Microsoft SQL Server 2005 and 2008 database platform • Must have a proven requirements gathering expertise • Must have recent hands on experience in the following areas: • End-to-end SDLC experience: analysis and scoping, design, development, QA, and deployment • T-SQL development experience, including query tuning and debugging • 3 + Years MS SQL Server Integration Services (SSIS) • Relational and Data Warehousing design and development • Logical and Physical Data modeling • Demonstrable Full Life Cycle experience in the design and hands on development of Systems using SSIS. ...View Job Details

Duration : 6 Months Plus Description: Develop application software in Oracle PL/SQL, PHP, JavaScript and HTML Analyze functional requirements and develop of new product functionality Develop design specifications and influence system architectural direction Implementation of new interfaces with customer legacy systems Develop test strategy and test cases for integration testing of developed system components. Maintain software after it goes live. Develop and maintain technical documentation including but not limited to design specifications, architectural diagrams, user guides, etc. Apply proven technologies, tools, and best practices Qualifications: 5-10 years of intensive application development experience in Oracle PL/SQL including hands-on knowledge of Oracle Tuning on Unix platform is a must Excellent knowledge of relational database theory, Oracle database architecture, and Oracle database features Healthcare application architecture, design, database modeling, and development experience is a plus. Superior oral and written communication skills Excellent teamwork and time-management skills Discipline to provide documentation and maintainable code for future users and developers Prior experience of working with offshore development teams is desirable. ...View Job Details

Title: Senior Data Analyst for Task 6 Chantilly, VA • 10 or more years experience performing data analysis and related support • Minimum 10 years experience with MS SQL Server, Ingres, Oracle, MS Access or equivalents in any combination. Current experience with MS Access and SQL server desired. • Have a Bachelor’s degree from an accredited school Information System Security Engineer/Architect for Task 8 Part time position • Must have an active DoD IAM or IAT certification at a level II or higher or obtain certification within 30 calendar days of working on the project • Must have 3 or more years experience in support of or working in Federal Government Information Assurance (IA) programs. • Have a Bachelor’s degree from an accredited school, preferably in Computer Science, Business Information Systems, or a related scientific or technical discipline. Thanks Priya Microsoft SHAREPOINT Implementer & Solutions provider ( Direct(Optional(Cell (Fax) Best way to Reach me at  ...View Job Details

Develop and maintain an expert level of knowledge regarding products and services of the company to achieve product development and functionality requirements. Design, code, test and debug custom queries using Microsoft Transact-SQL and SQL Server Reporting Services according to the defined technical specifications. Design, code, test and debug business logic for software applications using Transact-SQL according to the defined technical specifications. Design, code, test and debug automated reporting and database processes (using SQL Server Integration Services). Determine how new systems or system enhancements may improve process flow and business function. Diagnose and address operational data requests. Participate in customer support processes. Assists and prepares components/packages for implementation and provide support for release. Requirements: 5 to 8 year minimum experience developing database projects using Transact-SQL on SQL Server 2000/2005/2008. Dimensional Modeling skills; experience with Start Schemas Experience with Team Foundation Server (TFS) Expert-level SQL query development and Transact-SQL development skills. Experience using SQL Server Integration Services (SSIS) for ETL and process automation. Experience with Report Development (Crystal Reports, SQL Server Reporting Services, or others). BS or equivalent degree in computer sciences, software design, engineering, information systems, related field or comparable experience. Strong analysis, design, coding and testing skills required (knowledge of SDLC methodologies). Personal characteristics include: self motivated, thorough, articulate, detail-oriented, creative, personable, and team-player. Can work independently and as part of a team, in a fast-paced environment. Can complete tasks and projects with minimal instruction and supervision. ...View Job Details

Job description: This position is responsible for working with an existing database creating stored procedures, triggers, packages, etc that support a web-based, user-facing application. This position works within an Oracle environment using SQL and PL/SQL. Essential Functions: · Codes, tests, debug documents, and installs modified and new PL/SQL applications. some XML and/or Java · Works with clients and project team to interpret and implement specifications and assignments in a timely and accurate manner. · Monitors results for performance and accuracy and responds to errors and urgent problems. · Takes initiative to independently correct problems encountered during the development, testing and execution processes. · Maintains integrity of program logic and coding. ...View Job Details

Responsibilities: Work closely with the business developing capabilities utilizing the data warehouse/production platform and align project designs with senior management. Provide technical leadership to the project team members on the design, development, test and implementation of IDN project deliverables. Monitor Performance, Availability, Capacity, Error Handling and Dependencies. Acts as an expert technical resource and provide leadership and guidance to application developers. Collaborate with business partners, other functional groups within American Express and outside vendors to ensure the successful delivery of solutions. Actively participate on System Design & Implementation reviews. Provide coaching and mentoring for IDN technical resources. Participate with on-call support of IDN applications. Perform analysis, development and evaluation of data mining in a data warehouse environment which includes: data design; database architecture; design and implementation of Extraction, Transformation, and Loading processes; metadata and repository creation. Develops and monitors processes to ensure system maintainability and reliability and accuracy of data loaded into the data warehouse. Qualifications: Bachelors degree (or higher) in Computer Science or a related discipline (or equivalent combination of education and work experience) and at least seven (7), typically ten (10) years of solid, diverse work experience supporting distributed applications residing on multiple environments. Highly skilled in impact analysis and problem solving/issue resolution. Extensive experience gathering requirements, designing, and developing data warehouses. Ability to perform at a high level under pressure, manage crisis response activities, lead/coordinate activities of cross-organizational teams. Must be self-motivated and have the ability to work as part of a group, or, at times, independently. Ability to prioritize multiple activities, workloads, and objectives. Demonstrated ability to lead team efforts, including delegation of and follow-up on tasks delegated in a geographically dispersed, multi-functional environment. Strong leadership, decision-making skills, and ability to assume significant leadership responsibility without direct authority. Must have excellent communication skills, analytical ability, strong judgment and organizational skills, and the ability to work effectively with Business and Technologies Leaders and staff. Knowledge and practical experience of applications development in distributed network environment. Must understand business drivers and core technology functionality in Content Management and Enterprise Information Technologies. Highly skilled in managing customer expectations and the ability to facilitate interactive sessions with business / functional personnel. Results-oriented with creative approach to solving business problems, focus divergent opinions in order to gain consensus and move development/decision processes forward. Additional Information: SQL Development -- Highly Preferred Knowledge of mainframe and Sybase IQ technologies a plus Must be highly proficient with: SQL, stored procedure development, data analysis, data warehouse concepts, UNIX operating system, cross platform integration techniques, performance troubleshooting, and Project Life Cycle Development. ...View Job Details

Duration: 3-6 month contract to perm Location: Reston/Dulles, VA Develop and maintain an expert level of knowledge regarding products and services of the company to achieve product development and functionality requirements. Design, code, test and debug custom queries using Microsoft Transact-SQL and SQL Server Reporting Services according to the defined technical specifications. Design, code, test and debug business logic for software applications using Transact-SQL according to the defined technical specifications. Design, code, test and debug automated reporting and database processes (using SQL Server Integration Services). Determine how new systems or system enhancements may improve process flow and business function. Diagnose and address operational data requests. Participate in customer support processes. Assists and prepares components/packages for implementation and provide support for release. Requirements: 5 to 8 year minimum experience developing database projects using Transact-SQL on SQL Server 2000/2005/2008. Dimensional Modeling skills; experience with Start Schemas Experience with Team Foundation Server (TFS) Expert-level SQL query development and Transact-SQL development skills. Experience using SQL Server Integration Services (SSIS) for ETL and process automation. Experience with Report Development (Crystal Reports, SQL Server Reporting Services, or others). BS or equivalent degree in computer sciences, software design, engineering, information systems, related field or comparable experience. Strong analysis, design, coding and testing skills required (knowledge of SDLC methodologies). Personal characteristics include: self motivated, thorough, articulate, detail-oriented, creative, personable, and team-player. Can work independently and as part of a team, in a fast-paced environment. Can complete tasks and projects with minimal instruction and supervision ...View Job Details

Skills Required: • SQL Server 2008 • Transact-SQL • Team Foundation Server(TFS) • SSIS/SSRS • Dimensional modeling • star schema Job Description: • Develop and maintain an expert level of knowledge regarding products and services of the company to achieve product development and functionality requirements. • Design, code, test and debug custom queries using Microsoft Transact-SQL and SQL Server Reporting Services according to the defined technical specifications. • Design, code, test and debug business logic for software applications using Transact-SQL according to the defined technical specifications. • Design, code, test and debug automated reporting and database processes (using SQL Server Integration Services). • Determine how new systems or system enhancements may improve process flow and business function. • Diagnose and address operational data requests. Participate in customer support processes. • Assists and prepares components/packages for implementation and provide support for release. ...View Job Details

We are looking for MicroStrategy Developer/Architect position at Redwood city, CA – Long Term Contract Skills: • Experience with Business Intelligence full life-cycle and architecture: Performance Management, Business Intelligence, Score carding, and Dash boarding. • Must have experience in using Microstrategy BI reporting tool. • Must have experience in creating advanced reports in Microstrategy including multi-prompt reports, drill down reports and conditional lay-outs etc. • Experience in architecting business metadata layers and BI portals. • Must have good understanding of Oracle database, SQL, and data modeling. Experience with Teradata is plus. • Must have worked with customers in capturing their reporting requirements, building them, testing and deploying. If you are interested in the above opening please respond with your word resume and provide us the following details. • Full Name: • Rate Expectation: • Citizenship / Visa Status : • Availability for Interview : • Contact Number (s) : • Email id : • Start Date : • Current City and State: Dominic Savio Korcomptenz Inc Direct Fax Web : _______________________________ An ISO 9001:2000 Company ...View Job Details

Duties: Responsible for supporting business critical applications in Development Information Technology. Applies software development life-cycle (SDLC) methodologies in creating solutions to assist the monitoring of clinical trials in web-enabled environments. Act as Level 2 Support for Electronic Data Capture application. Work with IT project teams, database administrators, validation and QA staff. Skills: 5+ years of experience in software development in a cross database environment (Oracle, SQL Server). Industry experience in biotechnology, pharmaceutical healthcare is required. Experience with Electronic Data Capture applications and in particular Medidata RAVE is highly desirable. ...View Job Details

Must have: PSP web applications using PL/SQL Web Cartridge. (Number of yrs exp) :_________ JavaScript, CSS and DHTML is required. (Number of yrs exp) :_________ Oracle Database Development ( number of yrs exp) :_________ PL/SQL development ( number of yrs exp) :_________ Desirable: Perl, Java and XML development experience, ERP experience Functional knowledge of Supply Chain Management, Manufacturing Process Control is desirable. ...View Job Details

Position: MSSQL Server Developer/Architect Location: Chicago, IL Duration: 3 to 6 months Due By: Immediate Start: ASAP Notes: Need someone local to Chicago with excellent communication skills/USC & GC are highly preferred. • BS degree in Information Technology, Computer Science, or equivalent • 5+ years of architecting and developing applications on the Microsoft SQL Server 2005 and 2008 database platform • Must have a proven requirements gathering expertise • Must have recent hands on experience in the following areas: • End-to-end SDLC experience: analysis and scoping, design, development, QA, and deployment • T-SQL development experience, including query tuning and debugging • 3 + Years MS SQL Server Integration Services (SSIS) • Relational and Data Warehousing design and development • Logical and Physical Data modeling • Demonstrable Full Life Cycle experience in the design and hands on development of Systems using SSIS. ...View Job Details

Dear Partner, Please find the requirement and reply back with details Location – Jersey City Rate/Salary - $65k (fulltime) - $45/hr (contract) Senior Level Database Developer Job Duties and Responsibilities: • Perform product analysis and development tasks of increasingly complex nature which may require extensive research and analysis under supervision of technical lead. • Work independently with little direct supervision in the development, testing, implementation and maintenance of systems of moderate size/complexity. • Provide detailed analysis of problems and recommends solutions. • Apply innovation and creativity to development process and problem-solving. • Participate in the development of detailed design documents for major applications. • Provide adequate and proactive support for various applications. Technical Experience • Must have at least 6-8 years experience as a database developer and possess expert level technical skills in SQL programming, stored procedure creation and optimization, as well as script writing, batch processing, and report generation. • Must have at least 6-8 years experience working closely with Database Administrators in the design, implementation, tuning and maintenance of highly available (HA) and high volume databases. o Experience with multi terabyte databases and multi data-center replication is mandatory. o Experience with clustered implementations is mandatory. Technical Skills • Microsoft SQLServer 2005 and SQL 2K are mandatory. • Expert understanding of the SQL programming language and MS SQLServer development and administrative tools is mandatory. • Expertise with design and development of SSIS packages are required. • Working knowledge of Oracle is a plus. • Scripting language skills, such as PERL, is strongly desired. Business Experience • Experience in financial services industry is mandatory • Experience supporting critical client facing products is mandatory • Understanding of brokerage applications, particularly the Institutional space is strongly preferred. Please follow the below template while submitting the resumes: Name of the Candidate Skill Set Exp[Yrs] Rate Availability Flexible time for the interview Contact Number Email Current Organisation Current Location Re-Location Employer details Please reply this as well Technology No of years Total IT Microsoft SQLServer 2005 SQL 2K SQL programming Scripting language Perl Oracle SSIS send profiles to  ...View Job Details

---- Need EAD, GC, US Citizen --- Oracle/ PL SQL Developer: 10 positions Location: Washington DC Duration: 6+ months Financial experience would be great. Minimum experience 10+yrs ...View Job Details

Required Skills: PL/SQL Coding, PL/SQL Development experience , Knowledge of DOORS and UCM is a plus. Location: Herndon, VA Duration: 6 months plus PL/SQL DEVELOPER The Candidate will be a PL/SQL developer on the Financial Services Team. The Financial Services (FS) team is responsible for analyzing, designing, developing and providing Test and Production support for business functionality that enables the client to service loans. In developing and supporting FS functionality, FS team members work closely with members of other Servicer and Investor Reporting functional development teams, supporting teams such as Architecture, Database Management and Operation, and the Test, Requirements and Business teams. Prime Responsibilities/Duties: · Design & development of software using primarily PL/SQL batch processing. · Design & document processes and procedures for application deployment. · Follow existing processes and procedures for application deployment. · Work with various teams to determine software requirements. · Provide metrics and project planning updates for the development effort. · Provide technical expertise and lead junior developers as required. · Be on a 24x7 rotation to provide tier-3 application support Candidate Requirements: Must-Have Skills: · Six or more years experience developing and maintaining PL/SQL code. PL/SQL Development experience of at least 3 years must be within the most recent three year period. · Excellent written and verbal communications skills. · Expertise in Application Development with knowledge of full software development life cycle. · Understanding of Database deployment architectures. · Understanding of change management and automation/repeatability. · Skills should include working with tools such as Ant, Rational ClearCase, ClearQuest. · Demonstrated experience in working through production environment deployments. · Strong knowledge and use of development, methodologies, standards and procedures. · Excellent teaming and leadership skills. Nice to have Skills: · Ability to multi-task and provide expertise for multiple development teams across concurrent project tasks. · Ability to provide technical expertise to junior team members and consult with other application developers to tune and performance test new and existing code base. · Knowledge of DOORS and UCM is a plus. ...View Job Details

Job Title: ORACLE Data Architect Location: Boston, MA Durations: 6 months contract Job Description: ORACLE Data Architect/Consultant- Exposure to Basic Relational Database Concepts - basic types of databases,data integrity, the relational model,etc . Ability to understand basics of DBDesign , Logical modeling , Normalization & De-Normalization Techniques . SQLConstructs Ablility to understand and implement Data Types, Basic SQL SELECTStatements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views . SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic AccessMethods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics,Optimizer Hints Basics, Gathering Statistics Basics . Adv SQL Basics: Able tounderstand and implement Datetime Functions, Advanced Subqueries, HierarchicalQueries,DDL & DML Extensions, Transaction Management . Tools Level 1 usage .Database Programming Basics: Ability to understand and implement DeclaringVariables, Executable Statements, Control Structures, Composite Data Types,Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions,Creating Database Triggers . Adv Database Programming: Ability to understandand implement Collections, Multilevel collections, Ref Cursors, BulkProcessing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performanceaspects in PL./SQL . Exposure to Basic Relational Database Concepts - basictypes of databases, data integrity, the relational model,etc . Ability tounderstand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques . Woking knowledge of DB Design/Modelingtechniques(Logical and Physical DB modeling) ...View Job Details

General Description This person will perform the role of Conversion Developer, a member of the Conversion Technical Team. Responsibilities include: Develop staging software to load legacy system data to SQL Server database. Build software to perform data quality assessments. Build conversion software based on data mapping from legacy systems to the new CSES and FCCMS systems. Work with county legacy system technical staff to arrange for and complete data extractions. Report progress and issues to the Conversion Technical Team Lead. Required Skills This person will have the following skills: A robust knowledge of ETL and Data Transformation tools, Database Administration Skills and proven capability in writing Stored Procedures & Functions on the SQL Server. Excellent communication skills. Proficient with SQL Server. Proficient with MS SQL Server Integration Services (SSIS). Proficient with MS Office Suite 2007. Proficient with MS Access. Desired Skills This person will have the following desired skills: Knowledgeable with Child Support Enforcement or Domestic Relations and Judicial Court processes. Ability to travel within the State of South Carolina. Job Experience Five years of hands-on SQL Server experience. Three years of automated conversion experience. HW/SW packages MS Office Suite 2007 MS Access 2007 SQL Server 2005 MS SQL Server Integration Services (SSIS) Education Requirements BS degree in computers or related field or equivalent job experience ...View Job Details

PL / SQL (ETL) Developer Atlanta, GA. 6+ Months We need PL/SQL (ETL) developers with some UNIX PRIMUS provides expertise as a full service IT provider. We bring together the right people, knowledge, methodology, and technologies you require for the project at hand. We pride ourselves in being small enough that every project is important, and large enough to assure that every project will get done, on time and on budget. Whether its staff augmentation, strategy consulting, technology integration (offsite or onsite, time and materials or fixed bid projects) or offshore development solutions, PRIMUS can get the job done. ...View Job Details

I need Sr PL/SQL Developer with Oracle Database Architecture expertise. Performance tuning, Data Modeling, OLTP and Unix Shell Scripting expertise preferred. Must be senior PL/SQL Developer on Oracle RDMS. ONLY LOCALS CANDIDATES. ...View Job Details

Details are as follows: Title : Oracle Developer Requirement : Oracle, Oracle forms, PL/SQL, DW integration. DB interfaces w/ SAP Location : Portland, ME Rate : $48/Hour Duration : 6 months Required : Telephonic Description: Will work on ongoing project support, small enhancement requests, modifications. Skills are Oracle, Oracle forms, PL/SQL, DW integration. DB interfaces w/ SAP, so SAP integration experience is a plus. Code Development & Configuration - Develops code for high-risk, highly-complex requirements. Configures applications or systems for high-risk, highly-complex requirements. Installs software and software updates for critical systems. Executes the deployment of code across environments. Conducts design and code reviews. Manages and facilitates cross functional issue resolution at a complex level. ...View Job Details

Position: SQL Server Developer Location: Houston, TX Duration: 6 Months Billing Rate: $35/hr W2 Description: The position of SQL Server Developer will effectively work with members of our finance and IT teams to gather information from disparate systems, consolidate that data into a meaningful structure, and present that information to end users either in report or database table format. Sound RDBMS table design for reporting and sourcing a SQL Server Datamart. Development of T-SQL programs to modify and process data in a SQL Server 2008 database. Design documentation prior to development, Unit testing prior to delivery of all modifications to supervisor or business. Documentation of developed processes and existing processes as required. Work to be completed according to the client's practices for source code control, testing, approval, and code migration, Understanding of Oracle RDBMS (including PL/SQL programs) to assist in supporting existing applications on a day-to-day basis. Possess very strong T-SQL and database design using Microsoft SQL Server 2005/2008. 5 or more years of experience using SQL Server database technologies including, but not limited to: All table types, Index optimization, Constraint development, View development, Functions, and Procedures, Be self-motivated to produce quality, detail oriented database objects and documentation. Demonstrate the ability to complete tasks with minimal direct supervision. Possess skills to analyze business requirements and identify gaps during design phase. Have skills and discipline using Microsoft Word and Visio. Preferred Skills: SQL Server; T-SQL; Tables; Oracle; RDBMS; PL/SQL ...View Job Details

Required Skills: Migration experience from Sybase to oracle. Nice to have: C programming and SQL knowledge/experience (C embedded SQL highly preferred) Familiarity with E*Trade development (services and databases) life-cycle and environments ...View Job Details

Location: Atlanta, GA Duration: 9 mos 50/hr Role Oracle and MySQL Developer F2F Interview Qualifications BS in Computer Science or related field required; MS in Computer Science or related field preferred Six or more years of database development experience At least two years of Java/J2EE experience At least five years of RDBMS experience, epecially Oracle and/or MySQL At least two years experience with scripting (UNIX shell, Perl, etc) Two or more years experience with J2EE application servers Expert in RDBMS, with a working knowledge of Hibernate and Hibernate Caching strategies (ehcache) Understanding of database design / modeling patterns and their practical application At least two years experience building and delivering distributed systems that perform critical business or operational functions, preferably in a real- or near-real time environment Two or more years experience with digital video and audio systems development is preferred Experience with the tracing and tuning of database interactions (SQL) from both applications and database Experience versioning and formalizing the release of database changes to an existing environment, and automating the same Candidates must demonstrate excellent communication and verbal skills ...View Job Details

Oracle Data Architect/Consultant Location : Boston ,MA Duration : 6 Months + Start Date : ASAP Required Skills: Experience: 7+ years • Exposure to Basic Relational Database Concepts - basic types of databases,data integrity, the relational model,etc • Ability to understand basics of DBDesign , Logical modeling , Normalization & De-Normalization Techniques • SQL Constructs Ablility to understand and implement Data Types, Basic SQL SELECTStatements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic AccessMethods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics,Optimizer Hints Basics, Gathering Statistics Basics • Adv SQL Basics: Able tounderstand and implement Datetime Functions, Advanced Subqueries, HierarchicalQueries,DDL & DML Extensions, Transaction Management • Tools Level 1 usage •Database Programming Basics: Ability to understand and implement DeclaringVariables, Executable Statements, Control Structures, Composite Data Types,Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions,Creating Database Triggers • Adv Database Programming: Ability to understandand implement Collections, Multilevel collections, Ref Cursors, BulkProcessing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performanceaspects in PL./SQL • Exposure to Basic Relational Database Concepts - basictypes of databases, data integrity, the relational model,etc • Ability tounderstand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques • Woking knowledge of DB Design/Modelingtechniques(Logical and Physical DB modeling) •SQL Constructs Ablility tounderstand and implement Data Types, Basic SQL SELECT Statements, Restrictingand Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions,Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML),Constraints, Views • SQL Query Tuning Basics: Understanding of SQL Tuningconcepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Traceand TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to theOptimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, GatheringStatistics Basics • Adv SQL Basics: Able to understand and implement DatetimeFunctions, Advanced Subqueries, Hierarchical Queries,DDL & DML Extensions,Transaction Management • Tools Level 1 usage • Adv SQL & SQL Tuning Techniques:Ability to implement Tunning Concepts/Techniques like Explain Plan, Accessmethod, Generate SQL Trace and TKPROF report, Forcing Index Hints, GatherStatistics, Managing Optimizer Statistics, Using Indexes, Using Plan Stability,Using Application Tracing Tools, SQL Access Advisor • Database ProgrammingBasics: Ability to understand and implement Declaring Variables, ExecutableStatements, Control Structures, Composite Data Types, Explicit Cursors,Handling Exceptions, Creating Procedures, Creating Functions, Creating DatabaseTriggers • Adv Database Programming: Ability to understand and implementCollections, Multilevel collections, Ref Cursors, Bulk Processing, Bulk Bindand Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects in PL./SQL • AdvDatabase Programming: Ability to understand and implement Advanced ExplicitCursors, Managing Subprograms, Creating Packages, Oracle Supplied Packages,Adv. Triggers, Managing Dependencies • SQL Developer Tool for DatabaseProgramming • Tools Level 1 Usage • Able to use TOAD for Database Development •SQL Constructs Ablility to understand and implement Data Types, Basic SQLSELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basi. ...View Job Details