sql database developer in ontario

posted
job type
contract
salary
US$ 50 per hour
apply now

job details

posted
location
ontario, california
job category
Information Technology
job type
contract
salary
US$ 50 per hour
reference number
631012
phone
.
apply now

job description

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.

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 

qualification

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.

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.

educational requirements

Bachelors