Please reply to:- Rajneet Singh Bharaj / [email protected] / 609-606-9010 Ext.# 1404
Job Details:-
| Job Title : | Technical Consultant-Database Adminstrator |
| Location : | Lansing, MI |
| Expected Duration of Project : | 12 Months |
| Start Date : | 12/09/2014 |
| Interview Type : | Telephonic, Personal |
| Duties & Responsibilites : | • Developing an expertise in the data needs of our customer • Database design • Coding for new database objects & coding to change existing objects • Processing data in proper formats • Oversight to ensure established standards are followed • Capturing metadat • Protect the integrity of the database • Facilitate the use of the data content Skills Required -Database Administrator capabilities with 8 or more years of experience, relies on experience and judgment to plan and accomplish goals, performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected. -Coordinates physical changes to computer data bases; and codes, tests, and implements physical data base, applying knowledge of data base management system: -Designs logical and physical data bases reviews description of changes to data base design to understand how changes to be made affect physical data base (how data is stored in terms of physical characteristics, such as location, amount of space, and access method). -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. -Database Administrator capabilities with 1-7 years of experience, relies on experience and judgment to plan and accomplish goals, -performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected. Skills Preferred-Experience Required The candidate must meet the basic qualifications of 8 or more years of generic IT experience as defined for a Sr Database Administrator. In addition, this position requires a concentration in database design, data transformation, writing geospatial queries, physical database modifications, writing stored procedures and other duties relating to Data Administration. Each senior candidate will score between 1 and the maximum possible for each category. Points will be determined from review of the experience section NOT from the “Summary of Skills” area of a resume or application. a. More than 7 years experience developing conceptual, logical and physical data models (using data modeling software) including the facilitation of modeling sessions b. 5 years experience writing complex SQL statements including spatial queries using Oracle’s SDO_Geometry data type. c. More than 7 years experience with Data Definition Language (DDL) and Data Manipulation Language (DML) to physically change the database d. 5 years experience performing the function of extract-transform-load (ETL) using an automated tool e. 5 years experience using Oracle system utilities and DBMS packages to minimally generate dynamic SQL f. 3 years experience writing database stored procedures and functions using PL/SQL Experience Preferred Additional skills that are considered highly desirable (but not required) and may be used to supplement close scoring and assist in making a final selection are: Oracle Spatial Network and/or Topology Model Geographic Information Systems (GIS) & geodatabases Business Objects – Universe Definition Data Administration and Governance Object-Relational mapping TOAD software Dimensional database design INTERVIEW PROCESS: In person |
Click here to see details and upload resume for this job.
Click here to see all jobs on jobs.compunnel.com.
--
You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.
