*SQL Administrator(10+ Years) Only Citizen* *Duration: 12+ months*
*Rates: $70/h on C2C* *Lansing, MI* *Interview: Phone/Skype* *Only Citizen* Skills Required .Net, MS SQL-Server, SSIS, SSRS, Object oriented programming, TFS, ASP.Net, HTML, MVC [MANDATORY SKILLS] Skills Preferred Database administration of a large system with multiple environments. Experience Required At least ten years of experience as a SQL DBA on a large scale database. • At least Ten years of experience working with SQL database used by both front end web application and thick client. • At least five years of experience with SSIS and SSRS • At least five years of experience in database performance tuning. At least five years of experience as a Senior DBA leading other DBA’s -. Education Preferred An undergraduate degree in a technical field such as mathematics, electrical engineering, computer science of information technology. Additional Information Due to data access requirements contractor must be a US citizen There is no direct public transportation to this location. Candidate must have their own vehicle. Contractor must have a valid US Driver's License and must obtain a valid Michigan Driver's License within 30 days of start of work assignment. All prospective contractors will be required to pass background and security clearance prior to the start date of this contract. Job Description: Senior Database Administrator resource to work on the Business Application Modernization (BAM) project. BAM has 2 major applications – a public facing web application used by the public to primarily renew registrations and driver licenses and a thick client application used by motor vehicle clerks and the Department of State to register and title motor vehicles, obtain driver license and personal identification cards, register voters, and manage approximately 20 million vehicles and 8 million driver and identification card holders. The Database Administrator Senior will work with the BAM architecture team and development team on all aspects of database administration – they will review and assist in database design, database architecture, database performance, and review/develop database stored procedures that effectively support the BAM project. They will review storage needs and database design to use the storage most effectively. They will review database logs and work with developers looking for performance improvements. Based on the .Net architecture, the BAM solution optimizes the distribution of hardware, software, data and control, making appropriate information available to the affected users and application across all phases of the project. All BAM System data are stored in the Microsoft SQL Server Database Management System. The Microsoft SQL Service engine is run on two servers while the data is stored on the State of Michigan Storage Area Network. BAM has interfaces to many outside systems, some real time, using MSMQ, others are batch. The security for the BAM System is the State of Michigan Active Directory (AD). The BAM System is hosted on the Microsoft Internet Information Service (IIS) servers using the Microsoft .Net Framework. All .Net objects, along with the client–facing Web pages are stored on the Microsoft IIS servers. BAM is deployed using the COMET.NETsolution framework. The .NET architecture provides a set of robust facilities for application development and is the programming model underlying developing , deploying, and running Web services and applications for COMET. The .NET common language runtime and class libraries are at the center of the .NET Framework. The common language runtime manages memory, security, and language integration. The State uses .NET common language runtime running on Windows 2003 servers (servers will be upgraded to 2012 in the near future). The .NET managed business components in COMET useADO.NET to connect to the SQL Server database where the operational data is stored. This position, under State direction, will support the databases in all the BAM environments. They will be responsible for ensuring the solution is supported and changes implemented to agreed upon design. *Thanks & Regards* Sunny Mehta Sage Group Consulting Inc. Direct: 732-784-6481 Office: 732-767-0010 Extn: 601 Email: [email protected] -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
