Database Systems Analyst

3 weeks ago

Chicago, Illinois, United States 1872 Consulting Full time
Job Summary:

This role is responsible for designing, developing, and maintaining reliable and secure processes for internal applications. The ideal candidate will assist in the maintenance of the technical infrastructure that hosts various applications.

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

The team consists of experienced professionals, including 2 Software Developers, 1 SQL DBA, and 2 other hybrid SQL Developers / Systems Analysts.

Key responsibilities 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.

Key Responsibilities:

  • Create and maintain automated processes using technical methodologies, programmatical languages, support tools, and systems for internal applications.
  • 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.

Requirements:

  • 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 Have:

  • 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.

  • Database Systems Administrator

    4 weeks ago

    Chicago, Illinois, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    Job SummaryThe Metropolitan Water Reclamation District of Greater Chicago seeks a skilled Database Systems Administrator to design, implement, and maintain relational database systems that support the functional requirements of application systems used by operating departments. The ideal candidate will have a thorough knowledge of database design, control,...

  • Business Systems Analyst

    3 weeks ago

    Chicago, Illinois, United States Apex Systems Full time

    Job Title: Business Systems AnalystJob Summary:Apex Systems, a leading technology solutions provider, is seeking a skilled Business Systems Analyst to join our team. As a Business Systems Analyst, you will play a critical role in analyzing and improving business processes to drive efficiency and productivity.Key Responsibilities:* Analyze business processes...

  • Business Systems Analyst

    3 weeks ago

    Chicago, Illinois, United States Apex Systems Full time

    Job Title: Business Systems AnalystJob Description:We are seeking a Business Systems Analyst to join our team at Apex Systems. As a Business Systems Analyst, you will be responsible for processing client instructions, amendments, and corrections across the life cycle of a futures or option trade and position accurately and efficiently.Key...

  • Senior Systems Analyst

    4 weeks ago

    Chicago, Illinois, United States Health Care Service Corporation Full time

    Job SummaryWe are seeking a highly skilled Senior Systems Analyst to join our team at Health Care Service Corporation. As a key member of our IT department, you will be responsible for designing and implementing technical solutions to meet the business needs of our organization.Key Responsibilities:Develop detailed technical specifications and designs for...

  • Database Systems Specialist

    3 weeks ago

    Chicago, Illinois, United States Powers Health Full time

    Database Administrator Job DescriptionPowers Health is seeking a skilled Database Administrator to join our team. The ideal candidate will have a strong background in database management and administration, with expertise in either Microsoft SQL or Intersystems Iris.The successful candidate will be responsible for ensuring the performance, security, and...

  • Senior Distributed Systems Analyst

    4 weeks ago

    Chicago, Illinois, United States Pyramid Consulting Full time

    Job Title: Senior Distributed Systems AnalystJob Summary: We are seeking a highly skilled Senior Distributed Systems Analyst to join our team at Pyramid Consulting, Inc. The ideal candidate will have a strong background in distributed systems, database management, and middleware technologies.Key Responsibilities:Provide expertise leadership in the design and...

  • Systems Analyst

    4 weeks ago

    Chicago, Illinois, United States Chicago Public Media Full time

    Job OpportunityChicago Public Media is seeking a highly skilled Systems Analyst to join our team. The successful candidate will work closely with our Senior CRM Systems Manager to support and maintain our Customer Relationship Management and Email Management Systems.The Systems Analyst will interact with both internal and external stakeholders, acting as a...

  • Database Systems Specialist

    4 weeks ago

    Chicago, Illinois, United States Community Healthcare System of Northwest Indiana Full time

    Job Summary:The Database Administrator will report to the Manager of Database Administration and be responsible for the administration and maintenance of our healthcare systems. This role will involve working on projects that require onsite presence at our facilities.Key Responsibilities:Administer and maintain our healthcare systemsWork on projects that...

  • Database Systems Engineer

    4 weeks ago

    Chicago, Illinois, United States The LaSalle Group Full time

    We are seeking a skilled and experienced Database Systems Engineer to join our team. As a key member of our database administration team, you will play a crucial role in ensuring the smooth operations and optimization of our valuable databases.Responsibilities:Design, install, configure and maintain SQL server databases, while continuously monitoring and...

  • Business Systems Analyst

    4 weeks ago

    Chicago, Illinois, United States Northwestern Memorial Healthcare Full time

    Job SummaryThe System Business Analyst plays a critical role in supporting the mission, vision, and values of Northwestern Medicine by ensuring the integrity of utilization data and providing timely access to clinical, financial, and administrative information. This position requires a strong analytical mindset, excellent communication skills, and the...

  • Senior System Analyst

    3 weeks ago

    Chicago, Illinois, United States Health Care Service Corporation Full time

    Job SummaryAs a Senior System Analyst at Health Care Service Corporation, you will play a critical role in designing and implementing technical solutions that drive business growth and improve operational efficiency. This is an exciting opportunity to leverage your technical expertise and business acumen to make a meaningful impact on our organization.Key...

  • Database Systems Engineer

    3 weeks ago

    Chicago, Illinois, United States iManage Full time

    About the Role:We are seeking a skilled Database Systems Engineer to join our global Cloud Platform Engineering team. As a key member of this team, you will be responsible for overseeing the end-to-end lifecycle of critical Database Server systems.Key Responsibilities:Leading the implementation, configuration, maintenance, and performance of critical SQL...

  • Database Systems Engineer

    3 weeks ago

    Chicago, Illinois, United States NinjaTrader Full time

    Database Administrator Job DescriptionNinjaTrader is seeking a skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for the performance, integrity, and security of our databases, both on-prem and in the cloud. With thousands of transactions per second, our databases are a critical component of our...

  • Database Developer

    3 weeks ago

    Chicago, Illinois, United States Ardmore Roderick Full time

    Job Title: Database DeveloperArdmore Roderick is a leading civil engineering firm providing infrastructure design, construction services, and program management to various agencies. Our headquarters is located in Chicago, with offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. We were recently named one of the fastest-growing companies in the...

  • Database Systems Architect

    4 weeks ago

    Chicago, Illinois, United States NinjaTrader Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at NinjaTrader. As a key member of our IT department, you will be responsible for the performance, integrity, and security of our databases, both on-prem and in the cloud.Key Responsibilities:Design, implement, and maintain scalable database systems to...

  • Database Systems Engineer

    3 weeks ago

    Chicago, Illinois, United States iManage Full time

    Job SummaryiManage is seeking a skilled Database Systems Engineer to join our global Cloud Platform Engineering team. As a key member of this team, you will be responsible for overseeing the end-to-end lifecycle of critical Database Server systems. This includes automation, implementation, configuration, maintenance, monitoring, upgrade, and performance...

  • UniVerse Database Systems Administrator

    3 weeks ago

    Chicago, Illinois, United States ACE Tech Resources Full time

    Job Title: UniVerse Database Systems AdministratorACE Tech Resources is seeking a highly skilled UniVerse Database Systems Administrator to join our team. As a key member of our IT department, you will be responsible for the administration and maintenance of our UniVerse databases. Your expertise will be crucial in ensuring the smooth operation of our...

  • Senior Cassandra Database Administrator

    4 weeks ago

    Chicago, Illinois, United States R Systems, Inc. Full time

    Job Title: Senior Cassandra Database AdministratorAt R Systems, Inc., we are seeking a highly skilled Senior Cassandra Database Administrator to join our team. The ideal candidate will have a strong background in database management and a proven track record of success in implementing and maintaining large-scale Cassandra clusters.Key...

  • Database Developer

    4 weeks ago

    Chicago, Illinois, United States Ardmore Roderick Full time

    About the RoleArdmore Roderick is a leading civil engineering firm providing infrastructure design, construction services, and program management to various agencies. We are headquartered in Chicago and have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA.We are seeking a skilled Database Developer to join our team. As a key member of our IT...

  • IT Business Systems Analyst

    3 weeks ago

    Chicago, Illinois, United States Saxon Global Full time

    Job Title: Technical Business Process AnalystJob Summary:As a key member of our team at Saxon Global, we are seeking a skilled Technical Business Process Analyst to drive the identification of requirements across business units and identify substandard systems processes through the evaluation of real-time data. This role requires a thought leader for...