LA - SQL Database Software Engineer/Lead (with proficiency in performance tuning and optimization) )

Location: Los Angeles, California
Date Posted: 02-23-2018
Position: SQL Database Software Engineer/Lead 
Location: Los Angeles, CA
Duration: One year plus contract
 
Local Candidates!
NO OPT CANDIDATES! 


Required Qualifications:
Our client is looking for Sr. SQL Developers/Leads with senior performance tuning and optimization experience


Job Summary:  The Database Software Engineer - Team Lead will supervise and work closely with Database Software Engineer team members to design, develop and enhance Microsoft SQL Server 2005/2008 database solutions.
 
Qualifications & Requirements: 
  • In depth SQL knowledge is required, including advanced application tuning skills.
  • Expertise in Microsoft SQL Server 2008 and 2012. OLTP and OLAP.
  • Developing custom ad hoc reports using SQL 2012, SQL Reporting Services, SSIS, or Crystal reports.
  • Experience with clustering and log shipping.
  • Experience mapping multiple data sources from various data formats and normalizing the data into SQL 2008 & 2012 repositories.
  • Strong communication skills and the ability to share ideas and work well in small teams.
  • Possesses excellent problem solving capabilities.
  • Independent and self-motivated.
  • Bachelor's degree in computer science, engineering, business or the equivalent is preferred and 10 years database development experience is preferred.
  • Experience with Microsoft SQL Server 2008 and SSIS is required.  
  • Knowledge of SSRS, XML and C# technologies is required.
  • Basic knowledge of BigData, NOSQL, Predictive Analysis and latest MS SQL features is a plus.
 
Duties & Responsibilities: 
  • Work with developers and business users to define requirements, perform analysis of specifications and design, and implement robust, maintainable solutions and rules that meet the business requirements.
  • Lead and participate in reviews and quality assurance processes to ensure that the data architectures and standards are being adhered to.  Enforce policies and procedures to team members.
  • Create and maintain conceptual, logical, and physical database models.
  • Create SSIS packages to import/export data, and load and process data.
  • Develop and enhance stored procedures.  Write ad-hoc SQL queries to support report requests.
  • Design and develop meaningful business reports (BI), either web based or thick client.
  • Prepare data for job runs.  Support jobs in process.  Troubleshoot, analyze and repair job issues.
  • Give work assignments and evaluate work of other Database Software Engineers
  • Take ownership of solving complex business problems for the client.
  • Innovate and share findings with other leads.
  • Take steps to implement new architectural changes for client systems.
  • Mentor and train other Database Software Engineers and encourage best practices.
  • Work effectively with other Software Engineers, IT Project Managers, Business Systems Analysts, and Customer Service Managers.
  • Perform other duties as assigned.
 If interested, please e-mail your resume to mary@jba.com with the following information:
Name of the candidate:
Two Tel. numbers ( Home and cell):
E-mail address:
Availability Date upon confirmation:
Current Location:
Number of years of SQL development experience/writing complex stored procedures per above requirement:
T-SQL experience:
Performance Tuning & query Optimization :
Your hourly rate(  CTC or W2):
2 professional references:
 
 

Mary Avikians
Client Services Manager
JBA International, LLC
1192 N. Lake Avenue, Pasadena, CA  91104
Direct: 626-204-6914
E-mail: mary@jba.com
www.jba.com
 
or
this job portal is powered by CATS