Oracle Database Developer/Programmer

Intelligence and National Security Alliance; Lansing (MI); On-site; USD 85,000 - 120,000; Full time

Job summary

360 IT Professionals is seeking an Oracle Database Developer in Fremont, CA to design and optimize databases using Oracle 11g. The role focuses on data modeling, complex SQL, ETL, and GIS-enabled queries, with duties including writing stored procedures and tuning performance.

TOAD and Oracle tools are part of daily work, and collaboration with cross-functional teams is essential. The candidate will lead and coordinate database development tasks, ensuring data integrity and scalability while

Qualifications

• SQL knowledge with complex queries and performance tuning.
• Experience with ETL processes and data transformation.
• Geospatial data handling using GIS tools and Oracle SDO_Geometry.

Responsibilities

• Develop conceptual, logical and physical data models.
• Write complex SQL including spatial queries.
• Perform ETL using automated tools; modify database with DDL/DML.
• Develop stored procedures and functions in PL/SQL.
• Train staff and optimize database performance.

Skills

SQL

ETL

Geospatial queries

PL/SQL

Oracle 11g

Tools

TOAD

Oracle SDO_Geometry

Oracle Spatial

Job description

Company Description

360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.

Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and JQuery mobile.

Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one’s business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel’s through us.

We make sure that we deliver performance driven products that are optimally developed as per your organization’s needs. Take a shot at us for your IT requirements and experience a radical change.

Job Description

• 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
• High pressure
• The knowledge and use of Talend Software and Oracle PL SQL Tools is a plus

Our client 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

Qualifications

Oracle 11g, DDL, DML, ETL, Geographic Information Systems (GIS), TOAD, Oracle Spatial Network and/or Topology Model, Oracle’s SDO_Geometry, SQL

Additional Information

Thanks & Regards

Vikas Kumar

vikas.kumar(@)360itpro.com