*Hello,* *Hope you are doing well…..*
*Please send resumes to r...@hclglobal.com <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 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* *Required* *Years Used* *Last Used* Experience working in web development with .NET and C# *10 Years* MS-SQL DBA experience - including creating models, designing DB objects (tables, indexes, etc.), writing DB procedures functions, and triggers *10 Years* Experience as database architect developing solution architecture from business requirements, information architecture and technical architecture. *5 Years* Adv SQL knowledge: writing and maintainin lrg complex stored procedures, tuning SQL for optimum perf and creating and maintaining proper indexes *5 Years* Experience with MVC 4.0 or higher, the Entity Framework, Razor, JQuery and related .NET technologies and frameworks *3 Years* Experience with software configuration and setup of the SQL translations needed between the Legacy and Refresh database *3 Years* ETL: Experience translating and transforming datasets based on bus requirements, *3 Years* ETL: Run real-time extract to retrieve and store the incremental changed data from the Oracle tables *3 Years* Data Modeling: Experience translating business requirements into a logical and physical data model *5 Years* Version Control: Using a Source Control Systems (TFS or similar) to maintain a history *5 Years* SQL Server Integration Services transformation experience *5 Years* Monitor application related jobs and data replication activities *5 Years* *Thanks,* *Mani* *Technical Recruiter* *HCL Global Systems, Inc* *24543 Indoplex Circle| Suite 220 |* *|Farmington MI |* *r...@hclglobal.com )248-473-0720 EXT 157 *Certified Minority Business Enterprise (MBE)* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
