SQL Developer/ DBA

Essential Duties

Key Responsibilities

Database Architecture & Strategy

• Design, implement, and govern enterprise database architecture standards, ensuring scalability, security, performance, and maintainability.
• Define long-term database strategies, data models, and architectural roadmaps aligned with business objectives.
• Evaluate and recommend database technologies, architectural approaches, and best practices.
• Lead architecture reviews and provide guidance on complex database-related initiatives.
• Serve as the technical authority for all database design and architecture decisions.

SQL Server Administration & Performance Optimization

• Architect, administer, and support Microsoft SQL Server environments across development, test, and production systems.
• Review, refactor, and optimize complex T-SQL code, including stored procedures, functions, views, triggers, and queries.
• Analyze execution plans and implement indexing, partitioning, and performance tuning strategies.
• Identify and resolve database bottlenecks through root-cause analysis and proactive monitoring.
• Establish standards for database security, backup/recovery, availability, and operational excellence.

Data Modeling & Database Design

• Design and maintain logical and physical data models that support enterprise applications and reporting needs.
• Develop scalable database structures utilizing normalization, denormalization, partitioning, and indexing best practices.
• Ensure data integrity, consistency, and governance across enterprise systems.
• Create solutions that support high-volume transactional and analytical workloads.

Data Integration & Enterprise Data Pipelines

• Design and support enterprise data integration architectures and pipeline frameworks.
• Integrate SQL Server environments with ERP, manufacturing, warehouse management, and third-party business systems.
• Develop and optimize ETL/ELT processes, APIs, and data synchronization solutions.
• Partner with application, infrastructure, and business teams to ensure reliable and efficient data movement across platforms.

Legacy System Modernization

• Lead modernization initiatives involving legacy Microsoft Access databases and VBA-based applications.
• Analyze and extract business logic from legacy systems and redesign solutions using scalable, modern architectures.
• Plan and execute database migrations, consolidations, and platform transformation projects.
• Identify opportunities to improve reliability, performance, and supportability through modernization efforts.

Manufacturing Data Solutions

• Design and optimize database structures supporting manufacturing operations and product lifecycle management.
• Develop solutions involving Bills of Materials (BOMs), recursive hierarchies, product structures, and manufacturing calculations.
• Address performance and scalability challenges associated with complex BOM processing and manufacturing data workloads.
• Collaborate with operational stakeholders to ensure data architectures support business processes and reporting requirements.

Technical Leadership

• Provide mentorship and guidance to developers, DBAs, analysts, and technical teams.
• Conduct architecture reviews, code reviews, and database design evaluations.
• Establish standards and best practices for database development, governance, and operational support.
• Collaborate with business and technology leaders to balance performance, maintainability, scalability, and business needs.

Job Description:

We are seeking an experienced Database Architect to lead the design, optimization, modernization, and governance of our enterprise data platforms. This individual will serve as the technical authority for database architecture, providing strategic guidance while remaining hands-on with SQL Server development, performance tuning, data integration, and legacy system modernization efforts. The ideal candidate combines deep SQL Server expertise with strong architectural vision and experience supporting complex manufacturing and operational environments.

Job Qualifications

Required Qualifications

• 10+ years of experience as a SQL Server DBA, Database Architect, or similar senior-level database leadership role.
• Expert-level knowledge of Microsoft SQL Server architecture, administration, and performance tuning.
• Advanced proficiency in T-SQL, stored procedures, functions, query optimization, and database design.
• Deep understanding of data modeling, normalization, indexing strategies, partitioning, and enterprise database architecture.
• Experience designing and supporting enterprise-scale data integration and pipeline solutions.
• Strong background integrating databases with ERP, manufacturing, warehouse, and external business platforms.
• Experience modernizing legacy Microsoft Access and VBA-based applications.
• Proven experience working with manufacturing systems, Bills of Materials (BOMs), and hierarchical data models.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills with the ability to influence technical and business stakeholders.

Preferred Qualifications

• Experience with cloud-based database platforms and hybrid architectures.
• Experience with ETL/ELT tools, API integrations, and modern data platforms.
• Familiarity with manufacturing ERP systems and supply chain applications.
• Experience supporting high-availability, disaster recovery, and business continuity solutions.
• Knowledge of data governance, security, compliance, and master data management principles.