13 days old
2018-07-032018-07-31

SQL Database Developer

Ontario, CA 91764
  • Job Code
    631012
  • Payrate
    $50 To $55
job summary:

Randstad is seeking a SQL Database Developer in the greater Inland Empire. This person will be expected to:

  • Analyze requirements to design normalized databases.
  • Analyze requirements to design data warehouses and reports.
  • Optimization strategies and troubleshooting (blocking/deadlocking, indexing, triggers, sprocs, functions, etc.)
  • Experience within an enterprise SDLC, Agile Development, or XP
  • Strong written/oral communication skills including proactively escalating unresolved issues
  • Operational experience (tracking / resolving incidents within production environment to meet SLAs)
  • Proficiency using SSMS
  • Produce/maintain ad-hoc queries
  • BS Computer Science or above.
  • In depth knowledge of Microsoft SQL Server databases
  • Experience with database backup and restore.
 
location: Ontario, California
job type: Contract
salary: $50 - 55 per hour
work hours: 8 to 5
education: Bachelors
 
responsibilities:

Responsibilities include:

  • SQL Stored Procedures
  • User Defined Functions
  • Job Management of Automation Tasks
  • Manages and maintains the databases, performs troubleshooting and tuning when necessary.
  • Participates in the design/planning of new databases and related technology.
  • Implements SSIS/SSRS/jobs/scripts to support the applications and interfaces between them.
  • Designs, develops, and maintains data warehouses.
 
qualifications:

Requirements:

  • Analyze requirements to design normalized databases.
  • Analyze requirements to design data warehouses and reports.
  • Optimization strategies and troubleshooting (blocking/deadlocking, indexing, triggers, sprocs, functions, etc.)
  • Experience within an enterprise SDLC, Agile Development, or XP
  • Strong written/oral communication skills including proactively escalating unresolved issues
  • Operational experience (tracking / resolving incidents within production environment to meet SLAs)
  • Proficiency using SSMS
  • Produce/maintain ad-hoc queries
  • BS Computer Science or above.
  • In depth knowledge of Microsoft SQL Server databases
  • Experience with database backup and restore.
  • 3+ years in SQL scripting and tuning.
  • 2+ years in PowerShell scripting and SSIS packages.
  • Able to design database tables. Need to be familiar with first, second, and third normal forms. Understand data integrity, referential integrity, primary key, and foreign key.
  • Familiar with Kimball data warehouse methodology. Familiar with Dimensional modeling.
  • Familiar with SQL Server development. Familiar with T-SQL. Being able to create stored procedure, functions, synonyms, views, tables, constraints, and indexes.
  • Familiar with Oracle development. Familiar with PL/SQL.
 
skills:
  • SQL DB Developer
  • Experience designing database tables (familiar with first, second, and third normal forms, data integrity, referential integrity, primary key, and foreign key.
  • Dimensional modeling.
  • SSIS
  • TSQL
  • troubleshooting (blocking/deadlocking, indexing, triggers, sprocs, functions, etc.)
  • Powershell

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.

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

SQL Database Developer

Randstad Technologies
Ontario, CA 91764

Share this job

SQL Database Developer

Randstad Technologies
Ontario, CA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast