Oracle Database Developer
Stem Xpert
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Qualifications
- 7+ years developing conceptual, logical and physical data models.
- 2+ years working with Oracle 11g.
- 5+ years writing SQL statements.
- 7+ years using DDL and DML.
- 7+ years ETL experience with an automated tool.
- 3+ years writing stored procedures in PL/SQL.
Responsibilities
- Lead a team in complex data conversion of legacy systems.
- Write complex SQL statements including spatial queries.
- Perform ETL using automated tools.
- Establish physical database parameters and performance tuning.
- Train users on database management.
Skills
Tools
Job description
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:
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.
- 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
- 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
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 database parameters. Codes database descriptions and specifies identifiers of database to database management system or directs others in coding database 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 databases and what data can be accessed by user. Tests and corrects errors, and refines changes to database. Enters code to create production database. Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to database management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of database changes on other systems and staff cost for making changes to database. Modifies database programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of database management systems. May train users.
- 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 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
- 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 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
- IBM Datastage experience Desired
- Experience using Safe FME for data conversion Desired
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
