*Hi* *This is sandi from gtechnologiesinc* *Database Designer* ** *Rate: $DOE*
*12+ months* *Start : 21-Jun-10* *Sacramento, CA* * * *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. * * * *The Database Designer shall at a minimum meet the Mandatory Requirements defined below and as many of the Desirable Requirements as possible. * * * *REQUIREMENTS:* *• Experience as a MS SQL Server database architect/designer/ developer/ administrator on large scale software development projects deployed in production within the last 5 years which included designing a database cluster to handle more than one million OLTP transactions daily for at least two (2) projects. * *• 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 one (1) year or one (1) project. * *• 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 from an accredited college/university* *• Minimum 1 year experience with MS-Reporting Services* *• Strong Analytical Skills* *• Good communication skills* * * *PREFERRED:* *• 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.* *• 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 five (5) projects or more. * *• 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 of eight (8) years or more. * *• Responsible for cleansing, mapping, and transforming Bulk Data Migration on large scale projects with more than 50 million records for a period of 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 of five (5) years or more. * *• Experience developing OLTP data models for a period of five (5) years or more. * *• 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. * *• Familiarity with Oracle Identity Manager* *• Experience with IDMS and/or DB2* * Thanks & Regards sandi Recruiter G Technologies Inc. 4340 Stevens Creek Blvd, San Jose, CA 95129. Tel: (408)-414-2032 Ext 205&201 Fax:408-716-8873 [email protected] www.gtechnologiesinc.com * -- You received this message because you are subscribed to the Google Groups "KNOW.IT" 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/know_it_az?hl=en.
