Need: SQL DBA Architect

Dear Partner,

Hope you are doing great.  If you are comfortable with the below requirement kindly send your updated profile and contact details to john@jjcpl.net


Need:  SQL DBA Architect
Location:  Sacramento, CA
Duration: 10+ Months

Job Description:

• 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