Job Description :
new position 12/26 - SMI_SSD_846

Client: State of MI - Direct

Rate: $75/hr on C2C

Job Title: SQL Server DBA

Location: Lansing MI 48933

Duration: 12 Months

Position Type: Contract

Interview Type: In Person Only

Required Skills:

* SQL Server 2008, 2014 experience. Database administration, data m=
odeling, configuration, security Required 4 =
Years
* Resource Monitoring Required 4 Year=
s
* SQL Scripting Required 2 Years
* Extract, Transformation and Load processes Required =
4 Years
* Experience working with datawarehouse Required =
2 Years
* Performance tuning Required 2 Yea=
rs

Question 5 The client plans to schedule IN PERSON ONLY interviews =
for this position January 4rth and 5th. Please confirm your candidate will =
be available to interview any of those days if selected.

Job Description:
Responsible for data analysis and database management. Involved in maintena=
nce, enhancement, designing of data dictionaries, physical and logical data=
base models, and performance tuning.

Years of Experience:

8-11 years of experience in the field or in a related area.

Job Description:
Relies on experience and judgment to plan and accomplish goals, independent=
ly performs a variety of complicated tasks, a wide degree of creativity and=
latitude is expected.
*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.