Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+

SQL Database Developer


Job ID : 15008

Job Title : SQL Database Developer

Location : Kansas City, MO

Company Name :  Dataquad Inc.

Industry : Information Technology

Salary : $55,101 - $119,101  per year

Job Type : Fulltime

Posted on: 2020-07-28


Required Skills : SQL Server, SSRS, Data Warehouse, T-SQL, Azure DevOps

Benefits : No benefits are available


Responsibilities:

  • Experience and knowledge working with large sets of data, tables containing millions to billions of rows.
  • Design, develop, test, tune, and implement database objects and any supporting SQL scripts using Microsoft SQL Server.
  • This includes but is not limited to stored procedures, views, functions, data manipulation scripts, and ETL.
  • Assist developers with complex query tuning and refinement.
  • Design databases and queries to optimize performance and scalability.
  • Implement and upgrade databases, automation of data quality rules, naming conventions, optimized queries, and indexing.
  • Maintain and enhance the database schema and ETL processes related to the firm's reporting applications.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Maintain technical documentation and data dictionary as system modifications are made.

Required Qualifications: 

  • A minimum of 7 years of work experience in Analytic and Database programming positions using either MS-SQL or Oracle databases. SQL Server 2008/2012/2014/2016.
  • Knowledge of relational database, data warehouse and operational data store design that lead to support business intelligence solutions applications.
  • Understanding of Data Warehouse methodologies and approaches such as star schema and Kimball models.
  • Experience with advanced query design, stored procedures, views, functions, index design, and T-SQL performance tuning techniques.
  • Experience with SQL Server SSRS.
  • Data partitioning (valuable to increase capacity and performance of large systems of data) SQL encryption (their data is in PCI audited data centers and they will use this to allow for more security in the solutions they provide customers)
  • Preferred Experience with Azure DevOps.
  • Experience with banking or financial system data is a plus.
  • The SQL Database Developer will have a strong background in SQL database design and development experience.
  • Qualified candidates will develop and support scalable enterprise databases and ETL solutions.
  • This is a hands-on position requiring the candidate to be able to work with applicable technologies to develop and maintain databases across the organization while ensuring high levels of data availability.
  • The position requires a broad business perspective and a willingness to step into multiple roles.

 

    Latest Jobs For You

    • Project Engineer

      Journey Group Sioux Falls, SD

      Essential Duties and Responsibilities: Assist the Project Manager with project procurement, ...

      View Job
    • Software/Database Developer

      CSL SOFTWARE SOLUTIONS Burlington, VT

      Ideal Experience/Skills: Knowledgeable in SQL, preferably Microsoft Transact-SQL Server 2012....

      View Job
    • Entry Level Computer Programmer

      Revature Chattanooga, TN

      Job Requirements: College degree (Associates or Bachelors) Must be authorized to work in the...

      View Job
    • Software Developer - Entry Level

      360 View Nashville, TN

      Job Description: Looking for talented graduates who are hungry to be challenged and grow their...

      View Job
    • Electrical Engineer – Entry and Mid-Level

      Elliott Bay Design Group Entry, WV

      Responsibilities & Duties: Work will primarily be in an office environment (5 days per ...

      View Job

    Thanks For Your Feedback

    We’re an equal opportunity provider.
    All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
    OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

    Attach A Resume First