W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    Oracle DBA

  • Job Title:

    Senior SQL Engineer

  • Location:

    Redwood City,CA

  • Duration:

    12 Months

  • Domain Exposure:

    Utilities/ Energy, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Responsibilities 
---------------- 

  • Help write and optimize in-application SQL statements
  • Ensure performance, security, and availability of databases
  • Prepare documentations and specifications
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Profile server resource usage, and optimize and tweak as necessary
  • Collaborate with other team members and stakeholders
  • Read and troubleshoot an execution plan
  • Track and monitor performance issues

Skills and Qualifications 
------------------------- 

  • Strong proficiency with SQL (MS SQL Server 2014 / 2016) and its variation among popular databases
  • Experience with some of the modern relational databases
  • Skilled at optimizing large complicated SQL statements
  • Knowledge of best practices when dealing with relational databases
  • Capable of configuring popular database engines and orchestrating clusters as necessary
  • Ability to plan resource requirements from high level specifications
  • Capable of troubleshooting common database issues
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Read and troubleshoot an execution plan
  • Know how to tune queries
  • Knowledge of how to deal with indexes : identify them, manage fragmentation....
  • Demonstrated understanding of DMV
  • Troubleshoot locks and deadlocks
  • Uses query hints and know common Table Expressions
  • Knows how to use SQL Profiler

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract