SQL Developer

4 weeks ago


Chicago, United States 1872 Consulting Full time
SQL Developer / Systems Analyst - Hybrid Type Role
99% Remote in Chicago - you'll need to be available to go onsite 1-2x per quarter

Summary:
This role helps design, develop and maintain useful, reliable and secure processes for internal applications and assists with the maintenance of the technical infrastructure that hosts various these applications.

This team is aimed at continuous improvement to streamline workflows in key internal applications that power business, in addition to supporting the infrastructure that these applications run on.

This is a dynamic team you'll be working on consisting of 2 Software Developers, 1 SQL DBA and 2 other hybrid SQL Developers / Systems Analysts.

Specific duties include development of new automated solutions, SQL administration, SQL development, maintaining and creating documentation, supporting infrastructure such as Windows Server and Active Directory, and working with internal team members and 3rd parties to resolve issues associated with these applications and systems.

What you'll be doing
  • Create and maintain automated processes using technical methodologies, programmatical languages, support tools and systems for internal applciations
  • Develop and maintain custom SQL stored procedures and PowerShell scripts to automate department workflows and reduce manual administration
  • Assist in the implementation and administration of SQL maintenance plans, SQL clusters, SQL disaster recovery plans
  • Design, document, and implement new process workflows
  • Interact with SQL Databases to be able to feed other systems, generate reports, provide application support to SQL-based systems and assist with Business Intelligence initiatives
  • Monitor capacity, administer and archive data storage, as required, using scripting, copy utilities and comparison software on storage volumes for both SQL and flat file storage
  • Support infrastructure technologies and processes using Windows Server, Active Directory and Powershell
  • Provide escalated application support as necessary for department software, coordinate and interact with both internal IT teams and Vendor support teams to support such 3rd party systems and applications
  • Maintain proper documentation regarding new and existing Department processes
  • Availability to respond to afterhours requests, alerts and emergencies as needed and periodically help with the installation and upgrade of department systems after hours
Skills we're seeking
  • 2+ years of experience with SQL Development / writing SQL queries
  • Experience working with SQL databases such as SQL Server, PostgreSQL or Azure AQL
  • Experience supporting Microsoft infrastructure technology such as Windows Server and Active Directory and/or Azure
Nice to haves
  • Bachelor's Degree, ideally in Computer Science or an IT related field
  • Experience with reporting using Power BI, SSRS, Tableau or something similar
  • Scripting experience, ideally with Powershell
  • Experience working with business users to gather and document requirements as it relates to business processes and workflows
  • Experience with workflow optimization and Workflow-design tools such as Visio
  • Experience with Networking and Firewalls

  • SQL Developer

    2 weeks ago


    Chicago, United States CrossTech Consulting Group, Inc Full time

    SQL Developer Richmond VA, Jacksonville FL, Chicago IL (Hybrid Job) Experienced MS SQL database developer who will be responsible for developing / maintain TSQL code. 7+ years of full time experience as MS SQL / TSQL Developer with stored procedures, views, triggers, cursors, tables and index creation. Experience with Autosys, BIDS/SSIS, TFS, Bit Bucket,...


  • Chicago, United States Alert IT Solutions Full time

    Job DescriptionJob DescriptionSenior SQL Report Developer Description:A Senior SQL Report Developer is responsible to participate in the analysis, build, and test of software components for data migration solutions. Responsible for developing SQL databases and writing applications to interface with SQL databases. Development often consists of designing...


  • Chicago, United States Syntricate Technologies Full time

    Position: MS SQL DBA/ developer Location: Remote Duration: Fulltime Experience: 8+ Years Job Description: Microsoft SQL 2016 or higher? SSRS report creation, server management, and administration. Separately, approximately how many SSRS reports have you created? SSIS data package building. Separately, approximately how many data packages have you created?...


  • Chicago, United States TEKRRA1 Full time

    Job DescriptionJob DescriptionRate: $70/hr (C2C)Location: Remote (US Based)Work Auth USC & GC OnlyWe are currently seeking a highly skilled SQL Developer with PowerBI expertise for a remote position. This is an excellent opportunity for an experienced professional to contribute to data management and data integrity projects while utilizing their SQL and...


  • Chicago, United States Accord Technologies Inc. Full time

    Job DescriptionJob Description.Net Developer with Angular and SQLLocation: Hybrid Chicago, IL (F2F is required)Only nearby to Chicago ILMust Have:.Net Angular - Hiring manager wants Angular, not reactSQL ServerNice-to-have:OpenShift ContainersKafkaEventbossRedisSecurity domain, specifically Identity and Access Management (IAM) - more importantFinancial...


  • Chicago, United States Saransh Inc Full time

    Role: ETL Snowflake Developer (SQL Database)Location: Chicago, IL (Onsite from Day 1)Job Type: ContractJob Description:10+ years of strong Data warehouse experience.Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries.4+ years of experience in designing and developing cloud computing solutions using Snowflake technology.Experience in...


  • Chicago, United States Saransh Inc Full time

    Role: ETL Snowflake Developer (SQL Database)Location: Chicago, IL (Onsite from Day 1)Job Type: ContractJob Description:10+ years of strong Data warehouse experience.Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries.4+ years of experience in designing and developing cloud computing solutions using Snowflake technology.Experience in...

  • Lead - sql

    1 week ago


    Chicago, United States Kaav Inc. Full time

    Hi Hope you are doing well. Role: Lead - Fullstack (React/Springboot/SQL) Location: Chicago, IL (Onsite) Visa: Any Responsibilities: Lead and mentor a team of full-stack developers, fostering a collaborative and productive environment. Architect, design, and develop scalable and maintainable web applications using React, Springboot, and SQL. Write clean,...

  • PL/SQL lead

    2 weeks ago


    Chicago, United States E-Solutions Full time

    Position: PL/SQL leadLocation: Chicago Metropolitan Area (onsite)JD:Skills: PLSQL, SQL with ETL background, preferably IICS; Exp working in Data Migration projects at lead level; Salesforce knowledge and Salesforce Data Load experience; Good to have - Snowflake, AWS • 8+ years of total experience in ETL as a PLSQL Lead Data Developer with Very good...

  • PL/SQL lead

    2 weeks ago


    Chicago, United States E-Solutions Full time

    Position: PL/SQL leadLocation: Chicago Metropolitan Area (onsite)JD:Skills: PLSQL, SQL with ETL background, preferably IICS; Exp working in Data Migration projects at lead level; Salesforce knowledge and Salesforce Data Load experience; Good to have - Snowflake, AWS • 8+ years of total experience in ETL as a PLSQL Lead Data Developer with Very good...


  • Chicago, United States Photon Interactive UK Limited Full time

    GreetingsWho are we?For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 6000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check ;/p> Lead - Full Stack Developer (React/Springboot/SQL)...

  • Oracle PL/SQL

    2 weeks ago


    Chicago, United States Vantage Point Consulting Inc. Full time

    Oracle PL/SQL for Chicago and Atlanta The team will be subject to multiple critical regulations and also going through a Technology Transformation Journey to build and adopt General capabilities for Data Ingestion, Rules Authoring & Execution, and Analytics capabilities. This is a greenfield project that requires meticulous design to replace multiple legacy...


  • Chicago, United States The Dignify Solutions LLC Full time

    Technical/Functional Skills •Linux & Basic ksh/shell scripting; understanding of SFTP •Oracle & Ansii SQL is a must, Teradata SQL knowledge is a plus •Experience in database software solutions and Restful services is highly desired; •Excellent analytical skills, passion for pinning down technical issues and solving problems. Roles & Responsibilities...


  • Chicago, Illinois, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...


  • Chicago, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...


  • Chicago, United States Komatsu Full time

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and...


  • Chicago, United States Strategic Resource Partners, Inc. Full time

    Job DescriptionJob DescriptionJoin our team in Los Angeles as a Database Administrator, specializing in SQL. We're looking for someone with a knack for managing diverse database environments like Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Your role will be pivotal in shaping, implementing, and maintaining our organization's database...


  • Chicago, Illinois, United States Argo Group Full time

    Argo Group is a leader in specialty insurance with a vibrant culture built on respect, equality, wellness and opportunity. We're an innovative organization that's small enough to be agile and big enough to make a difference in our industry. Our flexible workplace is continuously evolving to ensure all employees feel: Comfortable bringing their whole selves...

  • Sr SQL DBA

    2 weeks ago


    Chicago, United States 1872 Consulting Full time

    Sr SQL DBA - hybrid cloud environment Chicago, IL - hybrid schedule: 3 days onsite in the loop, 2 days WFH Summary We're looking for a dynamic SQL DBA to work in a hybrid-cloud environment, owning various data-related initiatives such as code deployments, configuration updates, performance monitoring, security enhancements, troubleshooting, and...

  • Full Stack

    2 weeks ago


    Chicago, United States Decision Six Inc. Full time

    Job Description:Qualifications:Bachelor's degree in Computer Science, Engineering, or a related field.10+ years of experience in full-stack development.Strong experience with React, Springboot, and SQL.Experience with other front-end technologies such as HTML, CSS, and JavaScript.Experience with cloud platforms such as AWS or Azure is a plus.Excellent...