Database Architect / Administrator

Job Title: Database Architect / Administrator (L2/L3 Support)

Location: Northfield, IL (Onsite)

Role Summary:

We are seeking a highly skilled professional with expertise in data architecture and database administration to provide design support and Level 2/Level 3 technical support for enterprise applications. This role involves ensuring data design consistency, optimizing logical and physical database models, managing installations and upgrades, and collaborating with ADM teams to deliver secure, high-performing database solutions.

Key Responsibilities:

• Data Design & Architecture Support:
  • Ensure design consistency across applications and identify data redundancies in the enterprise data model.
  • Develop and maintain data standards, definitions, and logical database designs (ERDs).
  • Provide consultation to ADM teams on database requirements aligned with technical specifications.
  • Recommend updates to the enterprise data model and logical data model.
  • Advise on integration of data across multiple systems and provide architectural sign-off on database designs.
  • Research existing data sources and map source entities to logical models.
  • Collaborate with data modelers and DBAs to define metadata and maintain data dictionaries.

• Database Software Management:
  • Install, configure, patch, and maintain database software.
  • Perform version upgrades and manage software lifecycle (patches, evolution).
  • Handle software license management and maintain accurate inventory of deployed components.

• Physical Database Administration:
  • Define and optimize physical data file placement and indexing strategies.
  • Design and configure database storage and replication strategies.
  • Plan and implement backup and restore procedures.
  • Translate logical schemas into physical database layouts.
  • Perform database reorganizations, re-indexing, and tuning for optimal performance.

• Compliance & Standards:
  • Operate within customer-defined standards, policies, and procedures.
  • Validate standards and processes before deployment and document run books.
  • Ensure compliance with security requirements and industry best practices.

• Performance & Monitoring:
  • Monitor and optimize physical database performance.
  • Configure monitoring tools for alerts and thresholds.
  • Maintain valid disaster recovery (DR) plans and test regularly.
  • Identify SQL tuning opportunities and implement recommendations.

• Support & Collaboration:
  • Provide Level 2 and Level 3 technical support for all database software.
  • Coordinate with ADM teams and third-party providers for design and impact analysis.
  • Participate in hardware changes and perform data migrations.
  • Develop implementation and fallback procedures for database changes.

• Required Skills & Qualifications:
  • Strong experience in data modeling (logical & physical) and enterprise data architecture.
  • Expertise in DBMS installation, configuration, patching, and performance tuning.
  • Proficiency in SQL, indexing, and optimization techniques.
  • Knowledge of data integration strategies, metadata management, and data dictionaries.
  • Familiarity with disaster recovery planning and security compliance.
  • Excellent analytical, troubleshooting, and collaboration skills.

• Preferred Skills:
  • Experience with multiple DBMS platforms (Oracle, SQL Server, PostgreSQL, Redshift, Dynamo DB etc.).
  • Knowledge of cloud database environments (AWS RDS, Azure SQL).
  • Exposure to data warehouse design, ETL processes, and automation tools.

• Experience Level:
  • 7 10 years in data architecture and database administration with L2/L3 support responsibilities