need a Certified Database Designer with SQL & OLTP

[decentsun]

Title: Database Designer

Client: CA State Dept.

Location: Sacramento, CA

Duration: 36 months

Rate: $5,000 (4 week all inclusive billing cycle)



Description:



The DB Designer will be responsible for:

·        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 Structured Query Language (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 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.

·        Developed and optimized indexes, complex views, constraints, triggers, and stored procedures for large MS SQL Server database with more than 50 tables and included resolving database performance and capacity issues for a period not less than five (5) years.

·        Online Analytical Processing (OLAP), normalizing, and supporting databases used for ad hoc reporting for a period not less than three (3) years.

·        Integrated, initialized, populated, synchronized, cleansed, mapped, and transformed Bulk Data Migration on large scale projects with more than 50 million records for a period not less than two (2) years.

·        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 both OLTP and Data Warehousing data models for a period not less than three (3) years.

·        Experience working with MS SQL Server 2005 cluster including database schema design, optimization, SQL development, failover, replication, XML, meta-data for a period of one (1) year or more.



Desired Skills:



·        Current Microsoft Certified Database Administrator (MCDBAs) Certification and/or ITIL certification.  Provide proof of valid certification.

·        Public Sector Project experience



Education:



Bachelors or graduate degree (MS, MA, PhD) from an accredited college/university in computer science, computer engineering, or comparable area of study.