jobs in united states of america today

Title: SQL DBA

Location: Rosemead, CA

Rate: $48-50/hr Max

Contract, 2-3 months

Interview: F2F

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.

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.