Database Developer

4 weeks ago

Chicago, Illinois, United States Ardmore Roderick Full time
Job Title: Database Developer

Ardmore 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 Chicagoland area by Crain's Chicago.



Our mission is to advance the design and construction of critical infrastructure and the built environment to improve communities. We value our team's safety, experience, and professional development, as well as excellence, diversity and inclusion, innovation, and our communities.



Job Summary

This is a hybrid position, with at least three days per week in the Chicago Jardine Water Plant Office. The DWMPMO provides program management, engineering, and IT implementation services to the Chicago Departments of Water Management, Transportation, and Assets, Information, and Services. 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 three departments.



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.
  • Modify database objects according to requests and perform tests.
  • Ensure data quality and integrity in database development techniques.
  • Liaise with system analysts and business owners to improve applications and establish best practices.
  • Prepare design specifications and functional documentation for assigned database projects.
  • Provide data management support to users.
  • 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.
  • Respond to occasional requests for Production to resolve any database related customer issue.
  • Provide technical support for enterprise (on-premise) systems, middleware, and administration tools.


Requirements


  • Experience with SQL Server 2014/2016, SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), and/or SQL Server Reporting Services (SSRS).
  • Experience with Oracle 11g or 12c and Oracle SQL Developer.
  • 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.
  • Knowledge of software development and user interface web applications.
  • Ability to understand front-end users' requirements and problem-solving attitude.
  • Oral communication skills to effectively explain technical concepts.
  • Ability to perform and develop ETL processes in the context of multiple integrations systems.
  • Experience with business process implementation in the design and implementation of systems and using database management systems and their integration.
  • Experience and ability to quickly learn new IT systems.
  • B.S in the field of Computer Science or relevant field of study.
  • Minimum 3 years of related experience.


Ardmore Roderick offers a competitive salary and benefits package, as well as the opportunity to significantly affect the development of our rapidly growing firm. We are 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

    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

    4 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 Oracle Database Developer

    4 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

    3 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

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

  • Senior .NET Developer with NoSQL Database Expertise

    4 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

    1 month 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

    4 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

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

  • Senior Database Architect

    1 month 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 Engineer III

    4 weeks ago

    Chicago, Illinois, United States ShipBob, Inc. Full time

    Job SummaryWe are seeking a highly skilled Database Engineer III to join our team at ShipBob, Inc. As a key member of our data engineering team, you will be responsible for designing, implementing, and maintaining SQL Server databases to support our applications and services.Key ResponsibilitiesDesign and implement database solutions to meet business...

  • Database Systems Engineer

    1 month 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...

  • Senior Database Specialist

    4 weeks ago

    Chicago, Illinois, United States United Software Group Full time

    Job Requirements:As a key member of the United Software Group team, we are seeking a highly skilled Senior Database Specialist to join our team. The ideal candidate will have advanced SQL programming skills and experience with Teradata or other database systems. Additionally, the candidate must have healthcare claims data experience and proficiency with...

  • Database Systems Specialist

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

  • Postgres Database Specialist

    4 weeks ago

    Chicago, Illinois, United States Syntricate Technologies Full time

    Postgres Database SpecialistWe are seeking a highly skilled Postgres Database Specialist to join our team at Syntricate Technologies. As a Postgres Database Specialist, you will be responsible for designing, implementing, and maintaining large-scale Postgres databases.Key Responsibilities:Design and implement high-performance Postgres databasesDevelop and...

  • Postgres Database Administrator

    4 weeks ago

    Chicago, Illinois, United States Diverse Lynx Full time

    Database Administrator RoleWe are seeking a skilled Postgres DBA to join our team at Diverse Lynx LLC. As a key member of our development team, you will be responsible for ensuring the performance and reliability of our PostgreSQL databases.Key Responsibilities:Work with development teams to troubleshoot and resolve performance-related issuesMigrate...

  • Database Systems Architect

    1 month 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...

  • Snowflake Database Administrator

    4 weeks ago

    Chicago, Illinois, United States Diverse Lynx Full time

    Job SummaryAs a Snowflake Database Administrator at Diverse Lynx LLC, you will be responsible for managing and administering Snowflake databases and warehouses for multiple environments. Your primary goal will be to ensure high performance, availability, and security of our databases. You will implement and maintain database security by creating roles,...

  • Adjunct Faculty in Database

    4 weeks ago

    Chicago, Illinois, United States InsideHigherEd Full time

    Job Title: Adjunct Faculty in DatabaseJob Summary: DePaul University invites expressions of interest for a pool of qualified Part Time Faculty to teach courses in a variety of disciplines across all 10 colleges and schools.Responsibilities:Teach courses in database and related areas.Develop and implement curriculum in database and related areas.Assess...

  • Database Systems Engineer

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