Kindly respond back to email id : allen.d@hmny.com
Job Title : - Database Designer
Job Location : - Sacramento, CA
Job Duration : - Long Term Contract
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
| Candidate Details | Mandatory |
| Full Name: |
|
| Phone1: |
|
| Phone2: |
|
| Email: |
|
| Authorization(visa status): |
|
| Availability for telephonic/Skype Interview: |
|
| Skype ID/ Video call ID: |
|
| Expected Monthly Rate : |
|
| Current Location: |
|
| Ready to work or relocate ? Sacramento, CA- (Yes/No) |
|
| The interview process would take at least a week's time, will you be fine with this - (Yes/NO) |
|
| How soon can you start a project? |
|
| Why are you looking for Job change: |
|
| End Date of your current/ recent project: |
|
| Do you have any prior plans or commitments which might stop you from taking this position, if yes, plz share: |
|
| Also, be aware that our client conducts a criminal background check/ Test for drug of abuse on candidates who are extended offers of employment. Therefore, before we proceed with your candidacy regarding this project opportunity, please advise us now if you have any felonies or misdemeanors. if yes, plz share: |
|
Regards,
Allen
Technical Recruiter
Contact : 518-620 6850
Helios and Matheson Information Technology Inc
--
You received this message because you are subscribed to the Google Groups "US_Jobs&Consultants" group.
To post to this group, send email to us_jobsnconsultants@googlegroups.com.
To unsubscribe from this group, send email to us_jobsnconsultants+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/us_jobsnconsultants?hl=en.
No comments:
Post a Comment