Need :Sr SQL DBA -Lansing, MI (Skype or In-person) (8+ years Only)

[Mani Recruiter]

*Dear,*

*Hope you are doing well…..*

*Please send resumes to r...@hclglobal.com *



*ROLE*

*Sr SQL DBA*

*LOCATION*

*Lansing MI*

*DURATION*

*LONG TERM*

*RATE*

*DOE*

*CLIENT*

*DIRECT*

*INTERVIEW TYPE*

*Skype Or In-Person*

*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*

4-7 years of experience in the field or in a related area.



*Job Description*

Familiar with standard concepts, practices, and procedures within a
particular field. Relies on limited experience and judgment to plan and
accomplish goals. A certain degree of creativity and latitude is required.
Works under limited supervision with considerable latitude for the use of
initiative and independent judgment.



•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 

Need :Sr SQL DBA -Lansing, MI (Skype or In-person) (8+ years Only)

[Mani Recruiter]

*Dear,*

*Hope you are doing well…..*

*Please send resumes to r...@hclglobal.com *



*ROLE*

*Sr SQL DBA*

*LOCATION*

*Lansing MI*

*DURATION*

*LONG TERM*

*RATE*

*DOE*

*CLIENT*

*DIRECT*

*INTERVIEW TYPE*

*Skype Or In-Person*

*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*

4-7 years of experience in the field or in a related area.



*Job Description*

Familiar with standard concepts, practices, and procedures within a
particular field. Relies on limited experience and judgment to plan and
accomplish goals. A certain degree of creativity and latitude is required.
Works under limited supervision with considerable latitude for the use of
initiative and independent judgment.



•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 

Need :Sr SQL DBA -Lansing, MI

[mani recruiter]

*Hello,*

*Hope you are doing well…..*

*Please send resumes to r...@hclglobal.com *



*ROLE*

*Sr SQL DBA*

*LOCATION*

*Lansing MI*

*DURATION*

*LONG TERM*

*CLIENT*

*DIRECT*

*INTERVIEW TYPE*

*Skype or In-Person*

*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.*

The project is to refresh the current architecture and software platform to
a supported DTMB application standard and update the user interface. It is
also to make sure that the current vendor support is a sustainable model
for QVF system with its suite of applications such as QVF, QVF-GUI,
QVF-Lite, E-Wizard, Street Index and Electronic Poll Book along with
hardware and database components.



Directly from Manager: "I am looking for a DBA that has done design,
development and implementation of databases.  ...Not a maintenance DBA that
adjusts tables.  The ETL is critical – skill to convert data from an older
fragmented design to a new streamlined design."



A high level architecture has been defined that will meet MDOS objectives
and support the clerks. The application will have 2 components – a web
based and a client based.  The client based will have a local database that
is message synced with the central database.  It is being written in web
technologies using .net, C# communicating and MS/SQL database.



The Senior Database Consultant, under State direction, will be responsible
for database work related to the solution.  They will help to perform
design and review tasks related to the QVF web portal with focus on
database, back end query access data recovery and infrastructure
components.  They will do initial data conversion between the current QVF
database (Oracle) and the QVF Refresh database (SQL).  They will also use a
software tool (TBD), which will be used to keep the production databases in
synch, close to real-time as possible, during the rollout phase of the
project.



The Senior DBA will be executing tasks as defined in the State of
Michigan’s Project Management Methodology (PMM) as well as the Systems
Engineering Methodology (SEM).



*Specific tasks may include but are not limited to*

•  Assist with the design of a highly available fault tolerant database
infrastructure

•  Assist with technical design activities, including optimizing data
access for a web portal application, leveraging features in SQL to reduce
latency, and providing insights that could improve application performance

•  Creation and maintenance of Application objects (For ex. Type of
tables and indexes, Partition types/keys, foreign keys/constraints, segment
type and size etc.)

•  Creation of processes to replicate production databases
(de-normalized to normalized)

•  Help with layout application schemas and tablespaces

•  Define and maintain database roles and permissions for Application
objects

•  Develop and execute statistics collection plan for application
objects depending on volume and type of queries (For ex. Timing of
statistics collections, Lock statistics, enable/disable HISTOGRAM etc.)

•  Define and execute data purge/archival policy

•  Review backup policy with System DBA and help suggest
schedule/timings to avoid conflict with application processes

•  Review SQL execution plans on critical application queries

•  Help with Application code testing during application releases or DB
upgrade/migration to avoid SQL performance issues

•  Validate OR test database HA and COB solutions and automatic
application failover ensuring proper TNS connection string, DB services or
configuration is used

•  Bulk data uploads

•  Testing Adhoc queries in UAT before it is implemented in Production
using emergency login

•  Assist with infrastructure optimization and design, including
identifying bottlenecks, improving responsiveness, and reducing single
points of failure.



*TASKS*

Technical support is required to assist with the following tasks:

Database design

Database conversions

SQL query review and tuning

Replication software support



*Years of Experience*

12 or more years of experience in the field.

*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.



Designs and builds relational databases. Develops strategies for data
acquisitions, archive recovery, and implementation of a database. Must be
able to design, develop and manipulate database management systems, data
warehouses and multidimensional databases. Requires a depth and breadth of
database knowledge that shall help with formal design of relational
databases and provides insight into strategic data manipulation.
Responsible for making sure an organization's strategic goals are optimized
through the use of enterprise