ROLE
|
Sr SQL DBA
|
LOCATION
|
Lansing MI
|
DURATION
|
LONG TERM
|
RATE
|
DOE
|
DIRECT CLIENT
|
YES
|
INTERVIEW TYPE
|
In-Person Only
|
Local candidates
strongly preferred
ALL candidates MUST be able
to attend a personal interview, NO phone interviews, NO Skype, NO exceptions
|
|
State Experience Highly
Preferred
U.S. Citizens and those
authorized to work in the U.S. are encouraged to apply
Note: For H1 While
submitting I need consultant I 797 OR ID Proof.
|
|
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, independently performs a variety of
complicated tasks, a wide degree of creativity and latitude is expected.
·
Responsible for data analysis and database
management. Involved in maintenance, enhancement, designing of data
dictionaries, physical and logical database models, and performance tuning.
Knowledge of the utilities and production tools used for data storage
management to support the Application Team. Coordinates physical changes to
computer databases; codes, tests, and implements physical database, applying
knowledge of data base management system. 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 location, amount of space, and access
method).
·
Establishes physical database parameters. Uses
structured query language (SQL) to define database objects using database
definition language (DDL) and control access to database objects using data
control language (DCL). Language descriptions and specifies identifiers
of database to database management system or directs others in coding
database descriptions. Calculates optimum values for database parameters,
such as amount of computer memory to be used by database, following manuals
and using calculator. 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 database.
·
Enters SQL to create production data base.
Uses database utility programs and 3rd party utilities to monitor database
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
co-workers 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.
Providing assistance in the planning, development, maintenance, and
monitoring of integrated database systems, and ensuring that the conceptual
and design phases of new applications are consistent with the structural
parameters within the database environment.
·
Evaluates users' requests for new data
elements and systems, incorporates them into the existing shared data
environment, and provides technical assistance. Coordinates the use of data
to ensure data integrity and control redundancy, loads databases, and
reorganizes as needed. Performs data modeling and prototyping. Performs
logical and physical data modeling, designs relational database models, and
creates physical data models from logical data models. Performs security
recovery procedures. Determines and implements database search strategies and
storage requirements. Maintains data dictionary ensuring uniformity of
definitions and sets standards for use of data dictionary. Monitors database
performance and recommends efficiency improvements. 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 security and with monitoring agency disaster recovery
procedures and systems. Assists with the installation of database software
and with analyzing, designing, and implementing databases. Assists in
benchmarking and threshold testing of databases and with establishing and
controlling necessary database security. Assists in the selection of database
management software. Experience in computer systems analysis or computer programming
work.
·
Knowledge of the principles, practices, and
techniques of computer programming and systems design; of computer
operations, systems, and procedures; of project control and cost estimating
techniques; of computer programming languages; of data processing
flowcharting techniques; of database structures and theories; and of current
database technologies.
|
Skills
|
Required
|
Years Used
|
Last Used
|
SQL Server 2008, 2014 experience. Database
administration, data modeling, configuration, security
|
4 Years
|
|
|
Resource Monitoring
|
4 Years
|
|
|
SQL Scripting
|
2 Years
|
|
|
Extract, Transformation and Load processes
|
4 Years
|
|
|
Experience working with DataWarehouse
|
2 Years
|
|
|
Performance tuning
|
2 Years
|
|
|
No comments:
Post a Comment