1872 Consulting
SQL Developer / Systems Analyst
1872 Consulting, Chicago, Illinois, United States, 60290
SQL Developer / Systems Analyst - Hybrid Type Role99% 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 applciationsDevelop and maintain custom SQL stored procedures and PowerShell scripts to automate department workflows and reduce manual administrationAssist in the implementation and administration of SQL maintenance plans, SQL clusters, SQL disaster recovery plansDesign, document, and implement new process workflowsInteract with SQL Databases to be able to feed other systems, generate reports, provide application support to SQL-based systems and assist with Business Intelligence initiativesMonitor capacity, administer and archive data storage, as required, using scripting, copy utilities and comparison software on storage volumes for both SQL and flat file storageSupport infrastructure technologies and processes using Windows Server, Active Directory and PowershellProvide 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 applicationsMaintain proper documentation regarding new and existing Department processesAvailability to respond to afterhours requests, alerts and emergencies as needed and periodically help with the installation and upgrade of department systems after hoursSkills we're seeking
2+ years of experience with SQL Development / writing SQL queriesExperience working with SQL databases such as SQL Server, PostgreSQL or Azure AQLExperience supporting Microsoft infrastructure technology such as Windows Server and Active Directory and/or AzureNice to haves
Bachelor's Degree, ideally in Computer Science or an IT related fieldExperience with reporting using Power BI, SSRS, Tableau or something similarScripting experience, ideally with PowershellExperience working with business users to gather and document requirements as it relates to business processes and workflowsExperience with workflow optimization and Workflow-design tools such as VisioExperience with Networking and Firewalls
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 applciationsDevelop and maintain custom SQL stored procedures and PowerShell scripts to automate department workflows and reduce manual administrationAssist in the implementation and administration of SQL maintenance plans, SQL clusters, SQL disaster recovery plansDesign, document, and implement new process workflowsInteract with SQL Databases to be able to feed other systems, generate reports, provide application support to SQL-based systems and assist with Business Intelligence initiativesMonitor capacity, administer and archive data storage, as required, using scripting, copy utilities and comparison software on storage volumes for both SQL and flat file storageSupport infrastructure technologies and processes using Windows Server, Active Directory and PowershellProvide 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 applicationsMaintain proper documentation regarding new and existing Department processesAvailability to respond to afterhours requests, alerts and emergencies as needed and periodically help with the installation and upgrade of department systems after hoursSkills we're seeking
2+ years of experience with SQL Development / writing SQL queriesExperience working with SQL databases such as SQL Server, PostgreSQL or Azure AQLExperience supporting Microsoft infrastructure technology such as Windows Server and Active Directory and/or AzureNice to haves
Bachelor's Degree, ideally in Computer Science or an IT related fieldExperience with reporting using Power BI, SSRS, Tableau or something similarScripting experience, ideally with PowershellExperience working with business users to gather and document requirements as it relates to business processes and workflowsExperience with workflow optimization and Workflow-design tools such as VisioExperience with Networking and Firewalls