Lead SQL Database Engineer

  • location: Los Angeles, CA
  • type: Permanent
  • salary: $120,000 per year
easy apply

job description

Lead SQL Database Engineer

job summary:
Job Summary: The LEAD Senior Database Software Engineer - Team Lead will supervise and work closely with Database Software Engineer team members to design, develop and enhance Microsoft SQL Server database solutions. This team is growing rapidly and they want someone an Innovative and very strong SQL Developer to bring the team forward!

 
location: Los Angeles, California
job type: Permanent
work hours: 8 to 5
education: Bachelors
 
responsibilities:
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
  • Perform other duties as assigned.
 
qualifications:
Qualifications & Requirements:

  • In depth SQL knowledge is required, including advanced 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.
 
skills:
  • In depth SQL knowledge is required, including advanced 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
  • 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.
  • normalizing the data into SQL 2008 & 2012 repositories.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Mechanical Engineer

  • location: Los Angeles, CA
  • job type: Permanent
  • salary: $60,000 - $130,000 per year
  • date posted: 7/16/2018


    Warehouse Cargo Screener

  • location: Los Angeles, CA
  • job type: Temp to Perm
  • salary: $16.50 per hour
  • date posted: 7/12/2018