Hi,
My name is *Samir Mondal*. I am a *Talent Acquisition Specialist *with *Rylee
Technologies Inc*, and I have placed numerous entry to senior -level
resources in both functional and operational positions.
My client has an opportunity *Database Architect 4 *in their corporate
office in *Lansing MI*. I was drawn to your profile by your
qualifications, but am interested in speaking with you because of your
dynamic background.
With that being said, I understand that you may be extremely happy in your
current role, but I thought I would reach out regardless by the off chance
you were looking for a change, or if you were connected with any qualified
individuals on the market.
*Title: Database Architect 4 (497162), Lansing MI*
*Locations: **Lansing MI 48933*
*Duration: **12 Months+ months*
*Job Description:*
This position is for one (1) DBA resource to work on the Qualified Voter
File (QVF) refresh project.
The application is being written in web technologies using ASP.NET MVC 5,
C#, and SQL with a MS-SQL backend database.
The project is to refresh the current State of Michigan Qualified Voter
File (QVF) System and supporting applications to updated technology and
supported DTMB standards. This includes updating the user interface,
application and database. 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.
This position is for one (1) DBA resource to work on the Qualified Voter
File (QVF) refresh project. The application is being written in web
technologies using ASP.NET MVC 5, C#, and SQL with a MS-SQL backend
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, conversion and data synchronization. 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 (SQL Server Integration
Services), 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).
The Senior DBA MUST take ownership of the database and associated
processes. The DBA will work with the architect and business analyst but
will maintain responsibility for database integrity, synchronization across
environments, performance and adherence to standards.
The Senior DBA MUST be proactive in improving the database, technical
processes and customer relationships.
*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.)
• 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
• Bulk data uploads
• 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 (Create, Maintain, Schedule and Run SSIS Packages
SQL query review and tuning
Replication software support
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
synchronization and implementation of a database. Must be able to design,
develop and manipulate database management systems. Requires a depth and
breadth of database knowledge that shall help with formal design of
relational databases and provides insight into strategic data manipulation.
Capable of performing the role of a database administrator, if needed.
*Skills Required: *
Database development with SQL Server Management Studio including creating
models, designing DB objects (tables, indexes, view, stored procedures,
etc), writing DB procedures, functions and triggers, developing solution
architecture from business requirements, information architecture and
technical architecture. Advanced SQL knowledge, software configuration and
setup of the SQL translations needed between the Legacy and Refresh
database, Data Modeling and Version control.
Must understand SQL Server Database projects and how they are applied
across environments and how it is used in the version control process.
*Regards,*
[image: Signature logo]
[image:
https://s3.amazonaws.com/images.wisestamp.com/icons_32/facebook.png]
<http://www.facebook.com/ryleetechnologies/> [image:
https://s3.amazonaws.com/images.wisestamp.com/icons_32/linkedin.png]
<http://www.linkedin.com/company/rylee-technologies-inc>
*Samir Mondal*
*Associate Team Lead, RyleeTechnologies Inc*
*Ê**:* 630-517-0076
****: *sa...@ryleetechnologies.com <sa...@ryleetechnologies.com>
*þ**:* https://www.ryleetechnologies.com
Secret of our Success is the *"Referral Program".* Check out the Program on
our Website.
--
You received this message because you are subscribed to the Google Groups
"CorptoCorp" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to corptocorp+unsubscr...@googlegroups.com.
To post to this group, send email to corptocorp@googlegroups.com.
Visit this group at https://groups.google.com/group/corptocorp.
For more options, visit https://groups.google.com/d/optout.
