Required SQL DBAs

Posted by admin Thursday, September 2, 2010

Any Interest for the below job opening, Kindly send me the resume in word format If Interested

 

Job Title:          SQL DBAs

Location:          Rosemead/ Pasadena ,  CA

Duration:          3 month contract

 

Looking for local candidate only !

 

§  Requirements: 

§  MS in Computer Science, Engineering or Business.  MCITP: Database Administrator and/or MCTS Database Specialist on SQL Server 2005 (MCTS: SQL Server 2005) or equivalent.

§  5+ years of experience as a SQL Database Administrator with at least 3 years working directly with SQL Server required.

§  3+ years experience with T-SQL production.

§  2+ years experience with Client Server or .NET programming background.

§  Expertise in creating sophisticated SSIS from scratch.

§  Exposure in 3rd party backup and performance diagnosis & monitoring tools. 

§  Hands on technical lead role experience in the migration of SQL 2000 to 2005/2008 along with the installation of SQL 2005/2008 and configuration of SQL Server with best practices of storage performance.

§  Hands on experience in Transactional, log-shipping and mirroring replication.

§  In-depth knowledge of indexing strategy to include solid T-SQL skills and strong understanding of SQL 2005/2008 system view.

§  Ability to automate routine processes with any combination of delivered tools and scripting languages (i.e. VB, Java & PowerShell) under strict time and resource constraints.

§  SSRS and SSAS are bonus skills.

Focus on high ROI strategic projects.

 

Responsibilities:

§  Maintain and monitor database backup and restore processes.

§  Coordinate with the Network Administer & Developers to ensure data security & availability and meet the necessity of database refresh in development/staging environment.

§  Understand the effects of different replication methodologies to select and configure the settings while maintaining the stability of the data stream.

§  Own database performance tuning analysis & optimization.

§  Troubleshoot vendor and in-house applications.

§  Communicate and maintain SQL Server concepts and best practices including SSAS & SSRS.

§  Plan, design, and implement the database capacity, physical and logical modeling, and security practices for every phase of major .NET application development.

§  Administer varieties of SQL Server jobs and proactively monitor & optimize any data replication/ETL processes.

§  Review the design and deployment of data objects from development/staging to production.

§  Act as the first technical contact for any query/database performance issues and assist developers and business power users in query requests and enhancements.

§  Understand the implications of various replication methodologies and SQL Server security best practices including SSAS and SSRS.

§  Execute and enforce operational and administrative tasks with a focus on maintaining the stability of the data stream.

§  Assist in deployment of .NET applications, SSIS packages, SSRS-RDL and SSAS cubes. 

§  Ensure data objects naming convention and enforce data integrity by building data cleansing rules and refining the ETL processes.

§   

 

 

Thanks & Regards,

Victor
West Coast Consulting, LLC

9233 Research Drive, Irvine, CA, 92618
Office: 949.743.0065 Ext. 210
Fax: 714.844.9091
Email: victor@westcoastllc.com

http://in.linkedin.com/in/victorpalmtree

YIM:    victorpalmtree@yahoo.com

Gtalk:  victorpalmtree@gmail.com

MSN:   victorpalmtree@hotmail.com




Releated Post: