Job Description :
Client: State of MI - Direct
Rate: $65/hr on C2C
Job Title: Oracle DBA
Location: Lansing MI 48933
Duration: 12 Months
Position Type: Contract
Interview Type: In-Person only
Required Skills:
* Oracle Database Administration Required 5 =
Years
* PL/SQL Performance/Query Optimization Required =
5 Years
* Oracle Database Licensing/Configuration Required =
5 Years
* Reporting Tools Required 5 Years
* Unix/Linux Experience Required 5 Years
* Automation or Task Scheduling Experience Required =
5 Years
* Experience working longer-term/extended contracts Highly de=
sired
Question 4 In-person interviews only. The hiring team is looking t=
o conduct interviews on April 5, 6, and 9 - 9:30am to 11:30am only. Please =
confirm you have discussed this with your candidate and the candidate will =
be available to interview during that timeframe. If not, please forgo submi=
tting the candidate. Thanks
Question 6 Ideal candidate would be open to longer-term contract -=
and has a background that includes long-term contracts in work history.
Job Description:
Responsible for query/data analysis, database administration, automated tas=
k scheduling, and reporting/document management services. Involved in maint=
enance, enhancement, designing of data dictionaries, physical & logical dat=
abase models, performance tun.
Years of Experience:
4-7 years of experience.
Job Description:
Has knowledge of commonly used concepts, practices, and procedures within a=
particular field. Relies on instructions and pre-established guidelines to=
perform the functions of the job. Primary job functions do not typically r=
equire exercising independent judgment.
*Responsible for data analysis and database management. Involved in mainten=
ance, enhancement, designing of data dictionaries, physical and logical dat=
abase models, and performance tuning. Knowledge of the utilities and produc=
tion tools used for data storage management to support the Application Team=
Coordinates physical changes to computer databases; codes, tests, and imp=
lements physical database, applying knowledge of data base management syste=
m. Designs logical and physical databases reviews description of changes to=
database design to understand how changes to be made affect physical data =
base (how data is stored in terms of physical characteristics, such as loca=
tion, amount of space, and access method
*Establishes physical database parameters. Uses structured query language (=
SQL) to define database objects using database definition language (DDL) an=
d control access to database objects using data control language (DCL La=
nguage descriptions and specifies identifiers of database to database manag=
ement system or directs others in coding database descriptions. Calculates =
optimum values for database parameters, such as amount of computer memory t=
o be used by database, following manuals and using calculator. Specifies us=
er 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 b=
ases and what data can be accessed by user. Tests and corrects errors, and =
refines changes to database.
*Enters SQL to create production data base. Uses database utility programs =
and 3rd party utilities to monitor database performance, such as distributi=
on of records and amount of available memory. Directs programmers and analy=
sts to make changes to data base management system. Reviews and corrects pr=
ograms. 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 m=
ore types of data base management systems. Providing assistance in the plan=
ning, development, maintenance, and monitoring of integrated database syste=
ms, and ensuring that the conceptual and design phases of new applications =
are consistent with the structural parameters within the database environme=
nt.
*Evaluates users'' requests for new data elements and systems, incorporates =
them into the existing shared data environment, and provides technical assi=
stance. Coordinates the use of data to ensure data integrity and control re=
dundancy, loads databases, and reorganizes as needed. Performs data modelin=
g and prototyping. Performs logical and physical data modeling, designs rel=
ational database models, and creates physical data models from logical data=
models. Performs security recovery procedures. Determines and implements d=
atabase search strategies and storage requirements. Maintains data dictiona=
ry ensuring uniformity of definitions and sets standards for use of data di=
ctionary. Monitors database performance and recommends efficiency improveme=
nts. Creates test database environment for applications section, including =
the creation of necessary libraries and procedures.
*Executes the procedures necessary to save, retrieve, and recover databases=
from hardware and software failures within established procedures. Assists=
with determining, implementing, and enhancing standards on database securi=
ty and with monitoring agency disaster recovery procedures and systems. Ass=
ists with the installation of database software and with analyzing, designi=
ng, and implementing databases. Assists in benchmarking and threshold testi=
ng of databases and with establishing and controlling necessary database se=
curity. Assists in the selection of database management software. Experienc=
e in computer systems analysis or computer programming work.
*Knowledge of the principles, practices, and techniques of computer program=
ming and systems design; of computer operations, systems, and procedures; o=
f project control and cost estimating techniques; of computer programming l=
anguages; of data processing flowcharting techniques; of database structure=
s and theories; and of current database technologies.