Database Developer-2506270RV02

Ardmore Roderick
Full_time•$125k-155k/year (USD)•Chicago, United States

📍 Job Overview

  • Job Title: Database Developer-2506270RV02
  • Company: Ardmore Roderick
  • Location: Chicago, IL, United States
  • Job Type: On-site
  • Category: Database Developer
  • Date Posted: June 12, 2025

🚀 Role Summary

The Database Developer at Ardmore Roderick will design and maintain efficient, secure, and reliable database systems. They will collaborate with cross-functional teams to integrate databases with web applications and ensure data integrity. Key responsibilities include:

  • Designing and implementing database structures and procedures
  • Ensuring data quality and integrity
  • Liaising with stakeholders to understand business needs and improve applications
  • Participating in the full development life cycle, from concept to delivery and debugging
  • Supporting enterprise systems, middleware, and administration tools

💻 Primary Responsibilities

  • Database Design & Development:

    • Design stable, reliable, and effective database objects and procedures based on customer requirements
    • Ensure data quality and integrity in database development techniques
    • Create logical data models and translate them into physical database structures that integrate with existing or proposed database structures
    • Gather user requirements and identify new features

  • Database Administration & Support:

    • Modify database objects according to requests and perform tests
    • Prepare design specifications and functional documentation for assigned database projects
    • Provide data management support to users
    • Respond to occasional requests for Production to resolve any database-related customer issues
    • Provide technical support for enterprise (on-premise) systems, middleware, and administration tools

  • Collaboration & Stakeholder Management:

    • Liaise with system analysts and business owners to improve applications and establish best practices
    • Work closely with stakeholders and other developers to dynamically link backend databases to 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

  • Troubleshooting & Problem-Solving:

    • Troubleshoot technical database issues, requirements, limitations, and parameters for management and staff, and understand business work processes and business impact
    • Understand and apply troubleshooting, root-cause analysis, application design, solution development, human factors/usability design, and implementation of medium-sized projects
    • Effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk
    • Analyze data, perform research, and diagnose and solve problems using problem-solving skills combined with analytical skills

🎓 Skills & Qualifications

Education: Bachelor's degree in Computer Science or a related field of study

Experience: 3+ years of relevant experience with the following systems:

  • SQL Server 2014/2016, SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), and/or SQL Server Reporting Services (SSRS)
  • Oracle 11g or 12c and Oracle SQL Developer

Preferred Skills:

  • Experience with enterprise asset management systems such as Infor EAM or IBM Maximo
  • Business intelligence and reporting platforms such as PowerBI or SAP Business Objects
  • Visual Studio solution deployment utilizing Team Explorer / Team Foundation Server (TFS)

Required Skills:

  • Strong problem-solving and analytical skills
  • Ability 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
  • Experience with business process implementation in the design and implementation of systems and using database management systems and their integration
  • Ability to perform and develop ETL processes in the context of multiple integrations systems

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

  • Demonstrate experience with SQL Server and Oracle systems through case studies or projects
  • Showcase problem-solving skills and analytical abilities through real-world examples
  • Highlight experience with ETL processes and data integration projects
  • Include examples of collaborating with cross-functional teams and stakeholders to improve applications

Technical Documentation:

  • Provide code comments, version control, and documentation standards for SQL scripts and stored procedures
  • Include data modeling diagrams and entity-relationship (ER) diagrams for complex database structures
  • Demonstrate understanding of database performance optimization techniques and indexing strategies

💵 Compensation & Benefits

Salary Range: $124,987 - $154,980 per year (Ardmore Roderick)

Benefits:

  • Medical, Dental, and Vision Plans
  • 401K, Paid Maternity Leave, Competitive PTO
  • Employee Assistance Program (EAP) and more

Working Hours: 40 hours per week

🎯 Team & Company Context

Company Culture:

  • Industry: Infrastructure solutions firm specializing in Utilities, Transportation, Aviation, Rail and Transit, Building and Facilities Projects
  • Company Size: Medium (100-250 employees)
  • Founded: 1994
  • Team Structure: Cross-functional teams with infrastructure solutions experts working to solve client evolving project needs
  • Development Methodology: Agile/Scrum methodologies and sprint planning for web projects, code review, testing, and quality assurance practices, deployment strategies, CI/CD pipelines, and server management

Company Website: Ardmore Roderick

📈 Career & Growth Analysis

Database Developer Career Level: Mid-level with a focus on database design, administration, and support, as well as collaboration with cross-functional teams and stakeholders

Reporting Structure: Reports to the Database Administrator or a similar role within the IT department, with potential to mentor junior team members and influence database strategy

Technical Impact: Designs and maintains efficient, secure, and reliable database systems, ensuring data integrity and supporting web applications, enterprise systems, and middleware tools

Growth Opportunities:

  • Database Architecture: Develop expertise in database architecture and design patterns, with opportunities to lead database projects and strategy
  • Technical Leadership: Gain experience in technical leadership, mentoring junior team members, and driving database best practices
  • Emerging Technologies: Stay up-to-date with emerging database technologies and trends, and contribute to their integration within the organization

🌐 Work Environment

Office Type: On-site, with offices in Chicago, IL, and other locations across the United States

Office Location(s): Chicago, IL, United States

Workspace Context:

  • Collaborative workspace with infrastructure solutions experts working together to solve client evolving project needs
  • Access to necessary tools, multiple monitors, and testing devices for database development and administration
  • Cross-functional collaboration with designers, marketers, and business teams to integrate databases with web applications and improve applications

Work Schedule: Standard business hours with flexibility for deployment windows, maintenance, and project deadlines

📄 Application & Technical Interview Process

Interview Process:

  1. Phone/Video Screen: Technical phone or video screen focusing on problem-solving skills, analytical abilities, and database knowledge
  2. On-site Interview: On-site interview with a technical assessment, case study presentation, and stakeholder discussions
  3. Final Round: Final round with a more in-depth technical assessment and company culture fit evaluation

Portfolio Review Tips:

  • Tailor your portfolio to showcase your experience with SQL Server and Oracle systems, ETL processes, and data integration projects
  • Include examples of collaborating with cross-functional teams and stakeholders to improve applications
  • Highlight your problem-solving skills and analytical abilities through real-world examples

Technical Challenge Preparation:

  • Brush up on SQL Server and Oracle system knowledge, including stored procedures, triggers, and data modeling techniques
  • Practice problem-solving skills and analytical abilities through database-related exercises and case studies
  • Familiarize yourself with Ardmore Roderick's company culture, team structure, and development methodologies

🛠 Technology Stack & Web Infrastructure

Database Technologies:

  • SQL Server 2014/2016, SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
  • Oracle 11g or 12c and Oracle SQL Developer

Development & DevOps Tools:

  • Visual Studio solution deployment utilizing Team Explorer / Team Foundation Server (TFS)
  • Enterprise asset management systems such as Infor EAM or IBM Maximo
  • Business intelligence and reporting platforms such as PowerBI or SAP Business Objects

👥 Team Culture & Values

Database Developer Values:

  • Data Integrity: Prioritize data quality, accuracy, and consistency in all database design and administration activities
  • Collaboration: Work closely with cross-functional teams, stakeholders, and other developers to integrate databases with web applications and improve applications
  • Continuous Learning: Stay up-to-date with emerging database technologies, trends, and best practices
  • Problem-Solving: Approach database challenges proactively, using strong problem-solving skills and analytical abilities to identify and implement effective solutions

Collaboration Style:

  • Cross-functional integration between developers, designers, and stakeholders to improve applications and establish best practices
  • Code review culture and peer programming practices to ensure code quality and knowledge sharing
  • Knowledge sharing, technical mentoring, and continuous learning opportunities to drive technical excellence and innovation

📈 Challenges & Growth Opportunities

Technical Challenges:

  • Designing and implementing efficient, secure, and reliable database systems that meet evolving business needs and scale with the organization
  • Ensuring data integrity and performance optimization in complex database environments
  • Collaborating with cross-functional teams to integrate databases with web applications and improve applications

Learning & Development Opportunities:

  • Database Architecture: Develop expertise in database architecture and design patterns, with opportunities to lead database projects and strategy
  • Technical Leadership: Gain experience in technical leadership, mentoring junior team members, and driving database best practices
  • Emerging Technologies: Stay up-to-date with emerging database technologies and trends, and contribute to their integration within the organization

💡 Interview Preparation

Technical Questions:

  • Database Fundamentals: SQL Server and Oracle system knowledge, including stored procedures, triggers, and data modeling techniques
  • Problem-Solving: Problem-solving skills and analytical abilities through database-related exercises and case studies
  • Company-Specific: Ardmore Roderick's company culture, team structure, and development methodologies

Company & Culture Questions:

  • Technical Culture: Database developer values, collaboration style, and knowledge sharing practices
  • Company-Specific: Ardmore Roderick's company culture, team structure, and development methodologies
  • User Experience Impact: Understanding user experience principles and their application to database design and administration

Portfolio Presentation Strategy:

  • Tailor your portfolio to showcase your experience with SQL Server and Oracle systems, ETL processes, and data integration projects
  • Include examples of collaborating with cross-functional teams and stakeholders to improve applications
  • Highlight your problem-solving skills and analytical abilities through real-world examples

📌 Application Steps

To apply for this Database Developer position at Ardmore Rocker:

  1. Tailor Your Portfolio: Customize your portfolio to highlight your experience with SQL Server and Oracle systems, ETL processes, and data integration projects, emphasizing collaboration with cross-functional teams and stakeholders to improve applications
  2. Resume Optimization: Optimize your resume for web technology roles, emphasizing project highlights, technical skills, and relevant experience
  3. Technical Interview Preparation: Brush up on SQL Server and Oracle system knowledge, practice problem-solving skills and analytical abilities, and familiarize yourself with Ardmore Ricker's company culture, team structure, and development methodologies
  4. Company Research: Research Ardmore Ricker's company culture, team structure, and development methodologies to demonstrate your understanding and enthusiasm for the role and organization

Application Requirements

Candidates should have a minimum of 3 years of relevant experience with SQL Server and Oracle systems. They must possess strong problem-solving and analytical skills, along with the ability to work independently and as part of a team.