Senior MS SQL Database Developer

  • Salary

    $60 Per Hour

Experience

8 to 10 Years

Posted On

Dec 13, 2023

Company

TechVilla Solutions

Travel Requirements

0%

Job Overview

Required Skills

  • MS SQL Database
  • Relational Database
  • SQL
  • Continuous Integration
  • TDD
  • Red Gate
  • Business Intelligence

Job Type

Contract - Corp-to-Corp, Contract - Independent, Contract - W2

Work Authorization

N/A

Location

Oakland, CA

Job Description

Roles & Responsibilities:

  • Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
  • Working cohesively with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
  • Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering data driven solutions.
  • Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment
  • Provide solutions to promote data integrity in enterprise systems.
  • Participate in code reviews to validate effectiveness and quality of code.
  • Liaise with Developers to improve applications and establish best practices
  • Publish documentation and collaborative information using internal tools.

Skills Required:

  • Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million of new data records every day.
  • Strong analytical and organizational skills. This job involves analyzing existing databases and the client’s needs to develop effective data driven solutions.
  • Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions.
  • Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures.
  • Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
  • Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS.
  • Experience in troubleshooting and resolving data related issues.
  • Excellent oral and written communication skills.
  • Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies.
  • Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
  • Performance tuning experience using 3rd party tools.
  • Audit/compliance experience in highly regulated environment.
  • Experience using JIRA and Confluence as part of development life cycle.
  • Experience with Business Intelligence tools such as Tableau, SSRS, Power BI.
  • Familiar with Continual Improvement processes.
  • Familiar with Git.

Experience Required:

  • 8 years + relational database and SQL experience
  • Creativity, curiosity, initiative, and self-management are key attributes candidate embodies.
  • Solid experience (4 years +) in coding complex SQL queries and stored procedures. The ability to explain the details of performance tuning internals of the database.
  • Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum)
  • Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test-Driven Development (TDD) a big plus Experience with
  • Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM).
  • Healthcare domain knowledge a big plus.

Job ID: TS230328

  • Posted By

    James William

Designation

Sr. HR

Company

Techvilla Solutions

Last Login

Feb 27, 2024

Posted On

Dec 13, 2023


Related Jobs
  • JobType
  • Contract - W2

Posted On: Feb 01, 2024 01:34 PM


  • Company
  • COMPANY

    PB Consulting

  • Company
  • experience

    8 to 12 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $55 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • SQL Server
    • ALTERYX
    • Data Modeling
    • ETL
  • JobType
  • Contract - W2

Posted On: Dec 20, 2023 12:20 PM


  • Company
  • COMPANY

    Techvilla Solutions

  • Company
  • experience

    8 to 12 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $60 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • SQL queries
    • SQL Server
    • Performance Tuning
    • Jenkins / TeamCity / Bamboo
  • JobType
  • Contract - Corp-to-Corp
  • Contract - Independent
  • Contract - W2

Posted On: Dec 13, 2023 12:08 PM


  • Company
  • COMPANY

    TechVilla Solutions

  • Company
  • experience

    8 to 10 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $60 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • MS SQL Database
    • Relational Database
    • SQL
    • Continuous Integration