Hi Partner,


Please go through the below requirement if you have any consultant please
send me the updated profile to *saja...@radgov.com* <saja...@radgov.com%20> or
reach me at *954-691-4588 Ext 856*


*POSITION: SQL DBA*

*LOCATION: Lansing, Michigan 48933, USA*

*DURATION: 9 Months Contract*

*CLIENT: State of MI*

*JOB ID: 460536*

*Rate: $80/hr on C2C (No Benefits)*


*Looking for **12 or more years of experience in  SQL DBA*


*The hiring team is looking to conduct F2F interviews the week of
7/25/2016. Please only submit candidates who are available within that time
frame.*



*Description:*

*Skill*

*Importance*

*Required Yrs of Exp*

*Yrs of Exp*

*Last Used*

Experience working in web development with .NET and C#

Required

10 Years





MS-SQL DBA experience - including creating models, designing DB objects
(tables, indexes, etc.), writing DB procedures functions, and triggers

Required

10 Years





Experience as database architect developing solution architecture from
business requirements, information architecture and technical architecture.

Required

5 Years





Adv SQL knowledge: writing and maintainin lrg complex stored procedures,
tuning SQL for optimum perf and creating and maintaining proper indexes

Required

5 Years





Experience with MVC 4.0 or higher, the Entity Framework, Razor, JQuery and
related .NET technologies and frameworks

Required

5 Years





Experience with software configuration and setup of the SQL translations
needed between the Legacy and Refresh database

Required

5 Years





ETL: Experience translating and transforming datasets based on bus
requirements,

Required

3 Years





ETL: Run real-time extract to retrieve and store the incremental changed
data from the Oracle tables

Required

3 Years





Data Modeling: Experience translating business requirements into a logical
and physical data model

Required

5 Years





Version Control: Using a Source Control Systems (TFS or similar) to
maintain a history

Required

5 Years





SQL Server Integration Services transformation experience

Nice to have







Monitor application related jobs and data replication activities

Required

5 Years






The hiring team is looking to conduct F2F interviews the week of 7/25.
Please only submit candidates who are available within that time frame.

This request is for a SQL DBA with modeling and database conversion skills
to work on the Qualified Voter File Project.

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 data standards. This frequently involves
creating and maintaining a centralized registry of metadata.  Capable of
performing the role of a database administrator, if needed.



*Skills:*
SQL DBA



Thanks & Regards



Shaik Asif

RadGov, Inc

6750 N. Andrews Ave., Suite 200

Fort Lauderdale, FL 33309

Tel: 954-691-4588 Ext 856

Fax: 954-938-2004

saja...@radgov.com

www.radgov.com



Please note: In order to be compliant with current Govt. regulations and
Client requirements, Radgov follows structured recruiting process and
during the process we may require certain information/documentation to
validate the submissions to the client. Radgov (and not the client/s) is
responsible for any communication (between us) during this process. Please
be assured that any information shared with us would remain confidential
and stored on our fully secured servers and however, at any stage if you
are not comfortable with the process (would like to get more
clarification), please communicate your concerns via email to
escalati...@radgov.com for quick response.

-- 
You received this message because you are subscribed to the Google Groups "Open 
Source Erp & Crm" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to open-source-erp-crm+unsubscr...@googlegroups.com.
To post to this group, send email to open-source-erp-crm@googlegroups.com.
Visit this group at https://groups.google.com/group/open-source-erp-crm.
For more options, visit https://groups.google.com/d/optout.

Reply via email to