Match score not available

Senior SQL Developer

extra holidays - extra parental leave
Remote: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

7+ years of experience in SQL Development, Extensive IT experience with Microsoft SQL Server, Advanced T-SQL and performance tuning skills, Familiarity with ETL tools and data warehousing, Experience with SQL Server Integration Services (SSIS).

Key responsabilities:

  • Design, test, implement, and maintain data models
  • Lead tuning, upgrade, and configuration projects
  • Manage backup jobs and scheduling for environments
  • Troubleshoot database issues and supply ad hoc reporting
  • Document processing procedures and assist in architecture design
CME logo
CME SME https://www.gotocme.com/
201 - 500 Employees
See more CME offers

Job description

This is a remote position.

We are seeking a Senior SQL Server DBA/Developer to join our team who will be responsible for developing and testing software code and meeting customer needs, based on development rules set by your lead. In a nutshell, you’ll be building and growing in a place where we truly love working, and we think you will too.


The responsibilities of the Senior SQL Server DBA/Developer include:

  • Working closely with application developers to design, test, implement, perfect and maintain efficient transactional and analytical data models.
  • Leading/engaging in tuning, upgrade, and configuration projects to enhance performance and ensure stability.
  • Optimizing and keeping backup jobs and schedules as well as maintain Production, DR and Development environments.
  • Troubleshooting database and data issues as they occur.
  • Supplying Ad Hoc data reporting and data pulls for Analytics teams.
  • Performing various ad-hoc data loading and data manipulation tasks.
  • Managing routine data exports for clients, partners, and SMEs.
  • Creating and managing scheduled tasks and data processing scripts.
  • Documenting data collection, processing, and presentation procedures.
  • Helping support architecture and process flow diagrams for data systems.


Requirements
  • 7+ years of experience as an SQL Developer or in a similar role.
  • Extensive IT experience using database technologies, specifically Microsoft SQL Server and analytical databases.
  • Advanced experience in writing, debugging, optimizing and performance tuning stored procedures, views, UDFs and complex Transact SQL (T-SQL) Queries for highly concurrent OLTP (online transactional processing) systems.
  • Extensive experience writing Transact SQL (T-SQL) Queries, dynamic queries, indexes, constraints, views, functions.
  • Experience in performance tuning and query optimization.
  • Familiarity with ETL tools and data warehousing concepts.
  • Leads the design, development, and planning for solutions and technology standards to solve complex business problems
  • Works with business, support, or development teams recommending system improvements.
  • Responsible for the core database development for a custom application.
  • Experience with SQL Server Integration services (SSIS).
  • Experience managing multi-DB environment setup (Including production).
  • Extensive experience in maintenance of highly concurrent OLTP (online transactional processing) systems.
  • Prior experience troubleshooting SQL Server service data issues and able to solve it without causing data loss.

Preferred:

  • Experience with cloud data solution (e.g., Azure Fabric).
  • Knowledge of big data technologies (e.g., Vertica, Synapse).


Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Data Reporting
  • Troubleshooting (Problem Solving)

Related jobs