Hello,
We Gain America, Inc one of the fastest growing IT Consulting Company in US. We have an urgent requirement with our client/Preferred Vendor. The job details are given below. Position : SQL DBA/Architect/Designer Location : Sacramento, CA Duration : 6 months+ Should have the min. 10+ year consultant. 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 Even if you are not interested at this time, can you please send us your current resume, so that we can contact you if we get a requirement that fits your skill set The referral of your friends and colleagues are appreciated. Contact No: E-mail ID: Availability: Visa Status/Citizenship: Current Location: Rate & Employer Details: Regards, Ravi Gain America, Inc. I 13804 Hull Street Road Midlothian, VA 23112 Direct: 703-828-5948 / 703-880-8775 I Fax: 917-475-8362 I [email protected] I P Please consider the environment before printing this e-mail -- You received this message because you are subscribed to the Google Groups "Business Objects User Group" 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/businessobjects?hl=en.
