*Hi,* *This is Thomas Fedrick, - Recruitment and Resources from SancroSoft USA Inc.*
We have an urgent requirement as follows: Please respond with resumes in MS-Word Format with the following details to *[email protected]* Full Name : Location : Contact Number : Email : Availability : Rate per hour: Visa Status : *Requirement Details :--* *Senior SQL DBA/Developer** Sacramento, CA 1 year contract Rate : Competitive* *NEED TO WORK ON MY W2 ---------------ONLY EAD , GC & US CITIZEN * *RESPONSIBILITIES:* • Architecting and designing the data models and database schemas. • Fine tuning and optimizing database performance and throughput for high volume Online Transaction Processing (OLTP) applications. • Implementing database clustering and replication to ensure high availability. • Creating, maintaining, and optimizing database objects (e.g. views, catalogs, and triggers). • Optimizing the performance of SQL query and non-query commands. • Developing and implementing database administration and operational procedures. * * *MANDATORY REQUIREMENTS:* • Experience as a MS SQL Server database architect/designer/developer/administrator on large scale software development projects deployed in production within the last five (5) years which included designing a database cluster to handle more than one million OLTP transactions daily for at least two (2) projects or more. • Must have worked hand in hand with developers and functional leads during all phases of SDLC • Must have experience in writing complex SQL stored procedures and functions • Must have experience in writing complex SQL queries • Developed and optimized indexes, complex views, constraints, triggers, and stored procedures for large MS SQL Server database with more than 100 tables and included resolving database performance and capacity issues for a period not less than five (5) years. • Responsible for cleansing, mapping, and transforming Bulk Data Migration on large scale projects with more than 50 million records for a period not less than five (5) years or more. • Developed conceptual, logical and physical data models through requirements gathering with developers and end users using data modeling tools such as Erwin, S-Designer, ER/Studio, etc. for a period not less than three (3) years. • Experience developing OLTP data models for a period not less than three (3) years. • Education: Baccalaureate or graduate degree (MS, MA, PhD) from an accredited college/university in computer science, computer engineering, or comparable area of study. If substituting an area of study other than computer science or computer engineering, include substantiation for equivalence. • Minimum 1 year experience with MS-Reporting Services • Strong Analytical Skills • Good communication skills *DESIRABLE REQUIREMENTS:* • It is desirable that the Database Designer has experience working with MS SQL Server 2005/2008 cluster including database schema design, optimization, SQL development, failover, replication, XML, meta-data for a period of one (1) year or more. • It is desirable that the Database Designer has a current Microsoft Certified Database Administrator (MCDBAs) Certification. • It is desirable that the Database Designer has worked on State of California information technology projects for three (3) projects or more. • It is desirable that the Database Designer has worked on UI projects for three (3) projects or more. • It is desirable that the Database Designer has worked on a project(s) that directly reports to an organization rated at a SEI CMM Level 3 or above for three (3) projects or more. • Current certification for Practitioner’s or Manager’s Certificate in ITIL IT Services Management. • Familiarity with Oracle Identity Manager • Experience with IDMS and/or DB2 *Thanks & Regards* *Thomas Fedrick** **Recruiting Specialist "IT Services"* *[image: cid:[email protected]] [image: cid:[email protected]] * * **The power of focus* *SancroSoft USA INC* *4944 Sunrise Blvd, Suite B-4 || Fair Oaks, CA 95628 Phone : 916-671-5559* ||* 916-671-5584 *||* Fax: 916-671-1309* *E-Mail :* *[email protected]* <[email protected]> || * www.sancrosoftusa.com* <http://www.sancrosoftusa.com>* **http://www.linkedin.com/in/Thomasfedrick*<http://www.linkedin.com/in/Thomasfedrick> *YIM : **[email protected]* <[email protected]>* * *Gtalk : **[email protected]* <[email protected]>* * The information contained in this email message is intended only for the personal and confidential use of the recipient(s) named above. The message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by email and delete the original message. -- Introduce business in 3800 cities. How? ===================================================== Thanks for using group. Moderator 1) This group is managed by www.BRCIndex.blogspot.com 2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business. 3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club) 4) Reply to two message before posting new one. 5) Donot post same message in all 3800 business Referral Club. You received this message because you are subscribed to the Google Groups "Outsource" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Outsource
