Database Developer

4 weeks ago

Chicago, Illinois, United States Ardmore Roderick Full time
Job Description

Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services, and program management to various agencies.

Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was recently named by Crain's Chicago as one of the fastest-growing companies in the Chicagoland area.

Our Mission:

We advance the design and construction of critical infrastructure and the built environment to improve communities.

We Value:

Our team

  • Our team's safety, experience, and professional development is our top priority.

Excellence

  • Our clients receive best-in-class service and innovative solutions.

Diversity & Inclusion

  • Diversity is a cornerstone in everything we do. Whether among our team or within the community, we advocate for inclusion and equality.

Innovation

  • We look for ways to move people forward through thoughtful engineering.

Our Communities

  • We not only pledge safe engineering solutions, but we also work with our neighbors to strengthen our bond and provide for the future.

The DWMPMO provides program management, engineering, and IT implementation services for the Chicago Department of Water Management (DWM) and other City Departments as needed.

As part of the Program Team supporting the City's IT initiatives, DWMPMO leads IT implementations in a suite of existing systems utilized by the City.

The primary responsibility of the Developer position will include the effective design and development of enterprise-wide database systems with specific attention on Geographic Information Systems (GIS) Enterprise Geodatabases for the City of Chicago.

This position will leverage the Microsoft SQL Server platform along with Esri's ArcGIS Enterprise platform and will be responsible for identifying innovative approaches and solutions in a rapid application development environment.

The candidate should be able to provide high-quality support for the production, test, and development environments by implementing, managing, monitoring, and maintaining multiple database servers and databases.

This role is a hybrid position, with at least three (3) days per week in the Chicago Jardine Water Plant Office.

Responsibilities:

  • Design stable, reliable, and effective database objects and procedures based on customer requirements.
  • Translate technical database issues, requirements, limitations, and parameters for management and staff, and understand business work processes and business impact.
  • Work alongside GIS team to understand spatial data and Esri's Enterprise Geodatabase design.
  • Monitor GIS database and system performance, address possible issues, and ensure the continuous delivery of high-quality information to the client.
  • Ensure data quality and integrity in database development techniques.
  • Provide data management support to GIS team.
  • Participate in all stages of the development life cycle, from concept planning to build, testing, delivery, debugging, and documentation.
  • Work closely with stakeholders and other developers to dynamically link the backend databases to the web interfaces.
  • Write, debug, and unit test complex stored procedures and triggers.
  • Review, develop, and design data models using standard diagramming techniques, in conjunction with application development teams.
  • Create logical data models and translate into physical database structures that integrate with existing or proposed database structures.
  • Gather user requirements and identify new features.
  • Develop technical and training manuals.
  • Mentor GIS team on database skill sets.

Necessary Abilities and Skills:

Experience with the following systems:

  • SQL Server 2014/2016, SQL Management Studio (SSMS)
  • Esri's ArcGIS Desktop, Esri's ArcGIS Enterprise

Aptitude to work on multiple assignments simultaneously including working under pressure to meet project and task deadlines.

Ability to write complex queries for ad-hoc requests and data analysis, developing stored procedure, triggers, and functions across varied platforms with PL-SQL and T-SQL.

Understanding of troubleshooting, root-cause analysis, application design, solution development, human factors/usability design, and implementation of medium-sized projects.

Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk.

Problem-solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems.

Capability to work independently and as part of cross-functional teams, including with analysts and subject matter experts.

We strongly encourage you to apply even if you don't meet all of the job requirements.

If you are looking for the opportunity to gain invaluable experience and thrive in a collaborative environment, this may be the position for you.

Ardmore Roderick offers a competitive salary and benefits package as well as the opportunity to significantly affect the development of our rapidly growing firm.

Benefits package includes health insurance, dental insurance, vision insurance, 401k match, life insurance, disability insurance, flexible spending accounts, health savings account, paid holidays, PTO, paid maternity leave, and employee assistance program.

Ardmore Roderick is an Equal Employment Opportunity employer that is committed to diversity and inclusion in the workplace.

All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability status, protected veteran status, or any other characteristic protected by local, state, or federal law.

Ardmore Roderick participates in E-Verify.

We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities.

Please reach out to us if you require reasonable accommodation in responding to a job announcement, interviewing, or otherwise participating in the employee selection process.

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

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

    4 weeks ago

    Chicago, Illinois, United States Ardmore Roderick Full time

    Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies.Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was recently named by Crain's Chicago as one of the fastest growing companies in the...

  • Database Developer

    3 weeks ago

    Chicago, Illinois, United States Ardmore Roderick Full time

    Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies.Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was recently named by Crain's Chicago as one of the fastest growing companies in the...

  • Development and Database Supervisor

    3 weeks ago

    Chicago, Illinois, United States Nourishing Hope Full time

    Job DescriptionNourishing Hope, a dynamic Chicago nonprofit agency, seeks a skilled Development and Database Supervisor to support its fundraising efforts. This role involves overseeing online and offline donation processing, ensuring compliance with government grants, managing fundraising operations, and leading donor database management.Key...

  • Senior Database Developer

    4 weeks ago

    Chicago, Illinois, United States R.J. O'Brien Full time

    Job Title:Senior Database DeveloperBusiness Unit:RJO TechnologyLocation:ChicagoReports To:Director, Risk & PortalFull Time/Part Time:Full TimeHours : 8:00 a.m. - 5:00 p.m. CST/CDTPosition Summary:This is a unique opportunity for an experienced SQL Database & SSIS developer to play a key role in designing, developing, and enhancing our backend data...

  • Senior Oracle Database Developer

    3 weeks ago

    Chicago, Illinois, United States Saxon Global Full time

    Job SummaryAs a Senior Oracle Database Developer at Saxon Global, you will be responsible for designing, building, testing, and deploying high-quality database solutions that meet project objectives and technology architecture standards. This role requires expertise in Oracle database development, performance tuning, and Unix scripting. If you have a strong...

  • Database Architect

    2 weeks ago

    Chicago, Illinois, United States Phillip Capital Inc. Full time

    Database Developer Role at Phillip Capital Inc.Phillip Capital Inc. is a leading futures and brokerage business seeking a highly skilled Database Developer to join its agile team of developers.The ideal candidate will have experience in scalable database design and optimization, including the use of profilers, replication, backup/restore, and security...

  • Database Architect

    3 weeks ago

    Chicago, Illinois, United States PhillipCapital Full time

    Database Developer OpportunityPhillip Capital Inc. is seeking a skilled Database Developer to join its agile team of developers. The ideal candidate will design and develop database architectures and systems, develop database monitoring metrics, and maintain database objects in a software version control environment.About the RoleAs a Database Developer, you...

  • Database Architect

    4 weeks ago

    Chicago, Illinois, United States Phillip Capital Inc. Full time

    Phillip Capital Inc. Employment OpportunityJob Title: Database Developer (Hybrid)Location: Chicago, IL Phillip Capital Inc. is seeking a skilled Database Developer to join a dynamic team of developers to build innovative software solutions for its futures and brokerage businesses.About Phillip Capital Inc. and the Phillip Capital GroupPhillip Capital Inc. is...

  • Database Engineer

    4 weeks ago

    Chicago, Illinois, United States Kaufman Hall & Associates LLC Full time

    Job DescriptionKaufman Hall & Associates LLC is seeking a skilled Database Engineer to join our Revenue and Operations Improvement practice. As a key member of our team, you will design, develop, and maintain databases to support complex data analysis for healthcare systems across the country.The ideal candidate will have a strong background in Microsoft SQL...

  • Database Architect

    4 weeks ago

    Chicago, Illinois, United States Syntricate Technologies Full time

    Job Title: Database ArchitectJob Description:Syntricate Technologies is seeking a skilled Database Architect to design and implement efficient data platforms. The ideal candidate will have a strong understanding of relational database concepts and experience with Oracle performance tuning techniques.Key Responsibilities:Design and implement data platforms...

  • Senior .NET Developer with NoSQL Database Expertise

    3 weeks ago

    Chicago, Illinois, United States ICONMA Full time

    Job Description:As a Senior .NET Developer with NoSQL Database Expertise at ICONMA, you will be responsible for designing, developing, and deploying scalable applications using .NET programming languages. You will collaborate with leads and internal teams to produce software design and architecture, and develop documentation throughout the software...

  • Database Engineer

    4 weeks ago

    Chicago, Illinois, United States Kaufman Hall Full time

    Job Title: Database EngineerKaufman Hall is seeking a skilled Database Engineer to join our Revenue and Operations Improvement practice. As a key member of our team, you will be responsible for designing, developing, and maintaining databases that support our clients' complex data analysis needs.Key Responsibilities:Design and develop databases to support...

  • Database Administrator

    3 weeks ago

    Chicago, Illinois, United States 1872 Consulting Full time

    Database AdministratorAt 1872 Consulting, we are seeking a skilled Database Administrator to join our team. The ideal candidate will have a strong background in SQL Server and experience in database administration, performance management, and tuning. Key responsibilities include optimizing stored procedures, designing and implementing internal data feeds,...

  • Database Administrator

    4 weeks ago

    Chicago, Illinois, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job Title: Database AdministratorJob Summary: We are seeking a skilled Database Administrator to manage and operate Microsoft SQL Server database instances. The ideal candidate will have experience with SQL Server, including optimization, backups, and automation scripts. Excellent communication and problem-solving skills are required.Responsibilities: Manage...

  • Database Administrator

    3 weeks ago

    Chicago, Illinois, United States Diverse Lynx Full time

    Job Summary:We are seeking a highly skilled Database Administrator to join our team at Diverse Lynx LLC. The successful candidate will be responsible for managing and administering Snowflake databases and warehouses for multiple environments, ensuring high performance, availability, and security.Key Responsibilities:Implement and maintain database security...

  • Database Administrator

    4 weeks ago

    Chicago, Illinois, United States Diverse Lynx Full time

    Job Title: Database AdministrationAt Diverse Lynx LLC, we are seeking a highly skilled Database Administrator to join our team. As a key member of our data management team, you will be responsible for managing and administering Snowflake databases and warehouses for multiple environments, ensuring high performance, availability, and security.Key...

  • Senior Database Architect

    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 highly skilled Senior Database Administrator to lead the design, implementation, and maintenance of its relational database systems. This key role will be responsible for developing and overseeing database policies and procedures to ensure the integrity and availability of...

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