Skip to main content
Time Portal

Launch Your Job Search

Browse openings and submit your resume.

Apply Now

SQL Server API Data Engineer

Irving, TX 75261

Posted: 08/19/2024 Employment Type: Permanent Industry: IT/Computing Job Number: 3089 Remote Friendly: Hybrid

Job Description

SQL Server API Data Engineer
Fulltime
Irving, TX (hybrid)

We have an immediate new job opening for SQL Server API Data Engineer to join our client headquartered in Irving, TX.  This role will be responsible for the development of all phases in SQL, T-SQL, relational database programming/design, APIs, SSIS, and SSRS reporting. 

RESPONSIBILITIES
  • Write stored procedures, table alterations, functions, selects, inner and outer joins, indexes, and SSRS Reports in SQL Server 2019 and 2022
  • Responsible for the ongoing monitoring of Azure Data Factory (ADF) pipelines to ensure data processing workflows are executed correctly and on schedule, as well as designing, developing, and implementing new ADF pipelines to support evolving data integration and processing needs
  • Develop and maintain Azure Logic Apps to automate workflows and integrate various services and data sources
  • Utilize Postman for developing, testing, and documenting APIs; create test scripts, manage environments, and automate API testing to ensure robust and reliable API performance
  • Understanding of JSON and XML – both with custom applications and SQL Server data management
  • Write Power Automate flows, Azure integrations, leverage On-Prem Data Gateways, and Azure AD Enterprise Application Management
  • Performance tuning with stored procedures, functions, set-based code, and index creation
  • Convert business requirements to system design 
  • Own the database schema, which designates responsibility for its design (both current and planned improvement) 
  • Interact with programmers as a *SQL Expert* 

REQUIREMENTS
  • 5+ years of experience with SQL, T-SQL, relational database programming/design, APIs, SSIS, and SSRS reporting
  • 5+ years of experience as an MS SQL programmer in a fast-paced, dynamic environment using a structured software development methodology 
  • Experience designing and implementing large-scale database solutions that are reliable, scalable, and perform at high levels 
  • Expertise with RESTful APIs
  • Ability to interface data from on-premise environments to cloud-based applications/databases, including Azure
  • Experience with indexing strategies is a must, including OLAP/OLTP indexing, Columnstore, partitioning, and compression
  • Working knowledge of security and privacy issues, SQL 2019, and SQL 2022
  • Experience with C#, Python, Script Tasks, and PowerShell development – including ETL/ELT processes and container instances
  • Knowledge of execution plans, statistics, and reading plan diagrams
  • Bachelor’s degree in Computer Science required, Master’s degree preferred 
  • Must be willing to be a team-quality player in a fast-paced environment
  • Must be willing to work in an environment with 50% development and 50% production support
  • High attention to detail is required

**To view all of our job openings, please visit: http://www.alleareconsulting.com/job-openings.
 

Meet Your Recruiter

Megan Holcomb
Senior Account Manager and Recruiting Supervisor

Megan serves as Senior Recruiter and Account Manager for Alleare Consulting.  She combines her knowledge and experience in working with numerous individuals with a strong passion and sense of urgency for our clients. Her desire to match the right person to the culture, core values, and business strategies of our clients has enabled Megan to maintain an extremely high level of client satisfaction.

Mrs. Holcomb holds her Bachelors in Marketing from the University of North Texas and also served as a Kilgore College Rangerette at Kilgore Junior College.

Apply Online
Apply with LinkedIn Apply with Facebook Apply with X

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Irving, TX

Discover exciting job opportunities in the vibrant city of Irving, Texas! Known for its diverse community and thriving economy, Irving offers endless possibilities for career growth and development. With its close proximity to Dallas Fort Worth International Airport, major corporations, and charming neighborhoods like Las Colinas, Irving is the perfect place to advance your career. Explore job listings in this bustling city and be part of the dynamic energy that surrounds attractions like the Toyota Music Factory, the Irving Arts Center, and the Mustangs of Las Colinas sculpture. Embrace the blend of Texan hospitality and cosmopolitan flair that makes Irving a truly exceptional place to work and live. Take the next step in your career journey and find your perfect match in Irving, Texas!
Search
Jobs
Request
Talent
Contact
Us
Time Portal