Oracle Database Developer

TekWissen provides a unique portfolio of innovative capabilities that seamlessly combines clients insights, strategy, design, software engineering and systems integration. Our tightly integrated offerings are tailored to each clients requirements and span the services spectrum from Application Development/Maintenance, testing, IT Consulting & staffing for IT Infrastructure Management through strategic consulting and industry oriented Business Process. Our end-to-end Business Process as a Service (BPaaS) solutions support complex, high-value, knowledge based work. Combining applications, platforms, infrastructure, knowledge processes, and domain expertise allows us to deliver greater efficiencies and innovative business capabilities.

Why TekWissen

• • Proven experience in delivering high performance data driven results since 2009.
• • We give our clients access to the same collaboration tools used internally by our development team, providing full visibility into project progress and team communication. .Client also has access to source code, so you can provide feedback early on.
• • Same team throughout the whole development phase and support. We consider loyalty to be our strategic priority.
• • Competitive cost structure utilizing offshore resources.
• • Ability to provide cost efficient post launch support.
• • Time zone allows daily morning Scrum meeting with entire team. For clients in the US, the overlap is 10-12 hours a day.
• • Low up-front investment we are open to start with a small trial project.
• • No lock-in - You can adjust the team size up and down as needed upon two weeks' notice
• • Our projects managers are based in both the US and India. You can opt for a US-based project manager.
• • We work on fixed price projects, essentially taking on the risk for cost overruns and miscalculations. This also helps clients budget with more certainty.
• • Keep you in the know of where the industry is going so you get the advantage of new technology.

Hello ,

Hope you are doing well….!!!

Client: State of Michigan

Role: MDOT - Oracle Database Developer/Pgmr

Requisition ID: 470833

Duration: 10 + Months

Short Description: MDOT is in need of an Oracle Database Developer. They are currently working with Oracle 11g.

Complete Description:

Description below - but here are some additional items from the manager:

• Will be working as a team and likely leading the team

• Highly complex data conversion of legacy systems to a new ERP

• Complex business rules that are fluid and can change

• Mission critical project

• High pressure

• Must be well organized and can work with Project Managers

• The knowledge and use of Talend Software and Oracle PL SQL Tools is a plus

MDOT is in need of an Oracle Database Developer. They are currently working with Oracle 11g. This position requires a concentration in database design, data transformation, writing geospatial queries, physical database modifications, writing stored procedures and other duties related duties.

Responsibilities in this role include, but are not limited to, developing conceptual, logical and physical data models (using data modeling software) including the facilitation of modeling sessions. They will be writing complex SQL statements including spatial queries using Oracle’s SDO_Geometry data type. They will be using Data Definition Language (DDL) and Data Manipulation Language (DML) to physically change the database. The resource will be performing the function of extract-transform-load (ETL) using automated tools and will be using Oracle system utilities and DBMS packages to minimally generate dynamic SQL. The resource will also be writing database stored procedures and functions using PL/SQL.

Establishes physical data base parameters. Codes data base descriptions and specifies identifiers of data base to data base management system or directs others in coding data base descriptions. Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. Tests and corrects errors, and refines changes to data base. Enters code to create production data base. Selects and enters codes of utility program to monitor data base performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. May train users.

Skill

• Developing conceptual, logical and physical data models Required 7 Years

• Oracle 11g Required 2 Years

• Experience writing SQL statements Required 5 Years

• Experience with Data Definition Language (DDL) and Data Required 7

• Experience performing Extract-Transform-Load (ETL) using an automated tool Required 7 Years

• Experience using Oracle system utilities and DBMS packages Required 5 Years

• Experience writing stored procedures and functions using PL/SQL Required 3 Years

• Experience writing spatial queries using Oracle’s SDO_Geometry data type Desired

• Experience with Oracle Spatial Network and/or Topology Model Desired

• Experience with Geographic Information Systems (GIS) & geodatabases Desired

• Experience with Business Objects Desired

• Data Administration and Governance experience Desired

• Object-Relational mapping experience Desired

• Experience with TOAD software Desired

• Dimensional database design experience Desired

• IBM Datastage experience Desired

• Experience using Safe FME for data conversion Desired

• Experience with ESRI ArcGIS Desired

• Developing conceptual, logical and physical data models Required 7 Years

• Oracle 11g Required 2 Years

• Experience writing SQL statements Required 5 Years

• Experience with Data Definition Language (DDL) and Data Required 7

• Experience performing Extract-Transform-Load (ETL) using an automated tool Required 7 Years

• Experience using Oracle system utilities and DBMS packages Required 5 Years

• Experience writing stored procedures and functions using PL/SQL Required 3 Years

• Experience writing spatial queries using Oracle’s SDO_Geometry data type Desired

• Experience with Oracle Spatial Network and/or Topology Model Desired

• Experience with Geographic Information Systems (GIS) & geodatabases Desired

• Experience with Business Objects Desired

• Data Administration and Governance experience Desired

• Object-Relational mapping experience Desired

• Experience with TOAD software Desired

• Dimensional database design experience Desired

• IBM Datastage experience Desired

• Experience using Safe FME for data conversion Desired