TEKsystems
Senior SQL Server Database Developer
role at
TEKsystems
The Opportunity The Senior SQL Server Database Developer is the enterprise expert for designing, developing, and optimizing data processing systems and pipelines used to populate data into transactional databases, data warehouses, data marts, or other data repositories. A Senior SQL Server Database Developer builds systems to create and optimize data sets and data systems for operating applications, performing analysis, or identifying business or technology issues. You will be responsible for operational support and incident/problem management, from creating logging instrumentation to analysis and process improvements. They also coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems. You will report to the Associate Vice President of Corporate Services Technology.
The Day-to-Day
Use Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and delivering enterprise data asset solutions in collaboration with business intelligence teams, our users, or other IT teams
Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software
Design, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data files
Develop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a variety of platforms
Coordinate security, application monitoring, development tooling, and related capabilities with responsible teams
Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered
Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs
Train junior data and business intelligence personnel across the company, including developing material, mentoring, and guiding junior personnel on their technical skill growth
Your Qualifications
15+ years' experience developing data-related solutions and software
10+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platform
4+ years of experience with multiple cloud technologies in the Microsoft Stack (Azure IaaS and PaaS) along with familiarity with alternative cloud technologies
4+ years of experience designing and development on-premises and cloud-based (Azure) infrastructure and platform components
4+ years of hands-on development and deployment experience with Azure cloud using .NET, T-SQL, Azure SQL, Azure Storage, Azure Data Factory, Cosmos DB, GitHub, Azure DevOps, and CI/CD pipelines
Advanced knowledge of ETL and/or ELT tools, including batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, MuleSoft, or equivalent software
Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases
Advanced knowledge of multiple programming languages, such as C#, Java, Python, SQL, Scala, or similar
Advanced knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software
Bachelor's degree in Computer Science, Information Technology, or other relevant field
Compensation $125,000 - $180,000 base salary per year in the state of WA. New hires should expect to start at the lower end of the range depending on experience. Eligible for a discretionary bonus based on firm and individual performance.
Skills
Sql
Sql server
Ssis
Azure
Ssrs
Etl
database experience
schemas
Additional Skills & Qualifications MUST SIT ON-SITE IN CAMAS, WA FOR THE FIRST 90 DAYS. THEN ABLE TO WORK REMOTELY 75 DAYS PER YEAR.
Experience Level Expert Level
Pay And Benefits The pay range for this position is $125000.00 - $180000.00/yr.
Why TEKsystems?
TEKsystems is a leader in Full-Stack Technology Services, Talent Services, and real-world application, helping clients drive transformation. TEKsystems and TEKsystems Global Services are Allegis Group companies. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Application Deadline: This position remains open until filled.
#J-18808-Ljbffr
role at
TEKsystems
The Opportunity The Senior SQL Server Database Developer is the enterprise expert for designing, developing, and optimizing data processing systems and pipelines used to populate data into transactional databases, data warehouses, data marts, or other data repositories. A Senior SQL Server Database Developer builds systems to create and optimize data sets and data systems for operating applications, performing analysis, or identifying business or technology issues. You will be responsible for operational support and incident/problem management, from creating logging instrumentation to analysis and process improvements. They also coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems. You will report to the Associate Vice President of Corporate Services Technology.
The Day-to-Day
Use Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and delivering enterprise data asset solutions in collaboration with business intelligence teams, our users, or other IT teams
Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software
Design, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data files
Develop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a variety of platforms
Coordinate security, application monitoring, development tooling, and related capabilities with responsible teams
Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered
Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs
Train junior data and business intelligence personnel across the company, including developing material, mentoring, and guiding junior personnel on their technical skill growth
Your Qualifications
15+ years' experience developing data-related solutions and software
10+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platform
4+ years of experience with multiple cloud technologies in the Microsoft Stack (Azure IaaS and PaaS) along with familiarity with alternative cloud technologies
4+ years of experience designing and development on-premises and cloud-based (Azure) infrastructure and platform components
4+ years of hands-on development and deployment experience with Azure cloud using .NET, T-SQL, Azure SQL, Azure Storage, Azure Data Factory, Cosmos DB, GitHub, Azure DevOps, and CI/CD pipelines
Advanced knowledge of ETL and/or ELT tools, including batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, MuleSoft, or equivalent software
Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases
Advanced knowledge of multiple programming languages, such as C#, Java, Python, SQL, Scala, or similar
Advanced knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software
Bachelor's degree in Computer Science, Information Technology, or other relevant field
Compensation $125,000 - $180,000 base salary per year in the state of WA. New hires should expect to start at the lower end of the range depending on experience. Eligible for a discretionary bonus based on firm and individual performance.
Skills
Sql
Sql server
Ssis
Azure
Ssrs
Etl
database experience
schemas
Additional Skills & Qualifications MUST SIT ON-SITE IN CAMAS, WA FOR THE FIRST 90 DAYS. THEN ABLE TO WORK REMOTELY 75 DAYS PER YEAR.
Experience Level Expert Level
Pay And Benefits The pay range for this position is $125000.00 - $180000.00/yr.
Why TEKsystems?
TEKsystems is a leader in Full-Stack Technology Services, Talent Services, and real-world application, helping clients drive transformation. TEKsystems and TEKsystems Global Services are Allegis Group companies. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Application Deadline: This position remains open until filled.
#J-18808-Ljbffr