Required SQL DBAs
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
Gtalk: victorpalmtree@gmail.com