Senior Database Engineer

Bronco Wine Co.; Ceres (CA); Hybrid; USD 125,000 - 155,000; Full time

Benefits offered by this job

Health care coverage

Paid vacation

401(k) with employer match

Employee wine discounts

Group disability insurance

Flexible spending accounts

Employee assistance program

Job summary

Bronco Wine Company is seeking a Senior Database Engineer to support SQL Server and Oracle environments across ERP, reporting, and analytics. This hands-on role designs, develops, and maintains enterprise database solutions, ensuring performance, security, and reliability in a hybrid/remote setup with base in Ceres, CA.

The ideal candidate will lead database engineering initiatives, optimize queries, and collaborate with cross-functional teams to enable data-driven decisions that impact business

Qualifications

• Bachelor’s degree in information technology, computer science, or related field; additional related experience may be considered.
• Proven design and architecture experience with enterprise-scale database solutions.
• Strong hands-on experience with Microsoft SQL Server and Oracle databases.
• Advanced SQL, T-SQL, and PL/SQL expertise; complex queries and optimization skills.
• Experience in data warehouses, ETL/ELT, and data integration for ERP and BI.
• Ability to lead database initiatives, troubleshoot performance issues, and ensure security.
• Willingness to travel 7–10% as needed.

Responsibilities

• Administer, configure, maintain, and optimize Microsoft SQL Server and Oracle environments.
• Design and tune complex T-SQL and PL/SQL solutions including procedures, views, and jobs.
• Review schemas and data models for performance, security, and reliability.
• Develop data warehouse and ETL/ELT pipelines integrating ERP and BI sources.
• Implement monitoring, alerting, and recovery procedures for critical databases.
• Collaborate with IT teams to meet reporting and analytics needs.

Skills

Microsoft SQL Server

Oracle

SQL

PL/SQL

Data Warehousing

ETL/ELT

Performance tuning

Query optimization

Education

Bachelor’s degree in information technology or computer science

Tools

SQL Server

Oracle DB

Job description

Company: Bronco Wine Company

Reporting to: Senior Vice President of IT

Travel Requirements: 7–10%, based on business needs

FLSA Status: Exempt

Employment Category: Full-Time Regular

Pay Range: $125,000–$155,000 annually

Location: Hybrid/Remote. Hybrid employees will be based in Ceres, CA.

Shift: First Shift

Bronco Wine Company is seeking a Senior Database Engineer to support the architecture, development, administration, security, performance, and reliability of the company’s Microsoft SQL Server and Oracle database environments.

This hands‑on technical position designs, develops, administers, and supports enterprise database, data warehouse, and integration solutions for ERP, reporting, analytics, and other business-critical applications. The Senior Database Engineer partners with application, infrastructure, security, and business teams to maintain reliable database environments, improve system performance, protect enterprise data, and support business technology initiatives.

Bronco Wine Company was founded in 1973. Our family‑owned company strives to continue and improve upon being vertically integrated, from the vineyard to the table, focusing on crafting quality wines for every table. Our family’s resilience and sustained growth will continue to be fostered through stewardship of family, valued employees, respected partners, and future generations.

Essential Duties

Database Engineering and Development

• Administer, configure, maintain, and optimize Microsoft SQL Server and Oracle database environments.


• Design, develop, maintain, and optimize complex T‑SQL and PL/SQL solutions, including stored procedures, functions, views, packages, triggers, and database jobs.


• Review database code, schemas, data models, and architecture for performance, scalability, reliability, security, and maintainability.


• Establish and maintain standards for database design, development, testing, deployment, documentation, and change management.


• Design and maintain database solutions that meet business, application, integration, reporting, and analytics requirements.


• Develop and maintain technical documentation for database environments, architecture, configurations, data structures, integrations, recovery procedures, and operational support.

Performance, Availability and Reliability

• Perform advanced database and query tuning using execution plans, indexing, statistics, wait statistics, query profiling, and workload analysis.


• Diagnose and resolve CPU, memory, input/output, locking, blocking, deadlock, TempDB, transaction‑log, storage, and concurrency issues.


• Monitor database health, availability, capacity, performance, and resource utilization and proactively identify potential issues.


• Design and maintain database configurations that support performance, scalability, reliability, high availability, and anticipated growth.


• Troubleshoot complex database, data, integration, and performance issues and conduct root‑cause analysis.


• Develop monitoring, alerting, and response procedures for business‑critical database environments.


• Recommend database configuration, infrastructure, indexing, query, storage, or architectural improvements based on technical analysis and business needs.

Data Warehouse and Integration

• Architect, design, develop, and support enterprise data warehouses, data marts, staging environments, and dimensional data models.


• Develop and maintain extract, transform, and load and extract, load, and transform pipelines that integrate ERP, operational, financial, and other enterprise data sources.


• Design fact tables, dimensions, star schemas, historical data structures, and aggregation strategies.


• Develop data‑validation, reconciliation, error‑handling, monitoring, and data‑quality controls.


• Optimize data models and database structures supporting business intelligence, reporting, analytics, and data‑visualization platforms.


• Partner with business and technical stakeholders to understand reporting, analytics, integration, and data requirements.


• Identify opportunities to improve enterprise data availability, accuracy, consistency, and usability.

Security, Backup and Recovery

• Develop and maintain database backup, recovery, disaster‑recovery, retention, and restore‑testing procedures.


• Manage database users, roles, permissions, service accounts, encryption, auditing, and least‑privilege access.


• Support database vulnerability remediation, security reviews, patching, upgrades, and related risk‑reduction activities.


• Maintain database recovery documentation and participate in business‑continuity and disaster‑recovery testing.


• Monitor and address database security, access, configuration, and compliance concerns in partnership with appropriate IT stakeholders.


• Support secure database‑development and deployment practices.

ERP and Enterprise Systems

• Support database and integration requirements for enterprise resource planning systems and other business‑critical applications.


• Analyze complex ERP schemas and develop efficient data‑extraction and integration strategies.


• Support ERP implementations, upgrades, migrations, data conversions, integrations, and troubleshooting.


• Partner with application, infrastructure, security, reporting, and business teams to resolve complex data and system issues.


• Support data reconciliation, validation, and related activities associated with enterprise‑system changes.


• Evaluate the database and integration impact of proposed application, ERP, infrastructure, or business‑process changes.


• Perform other duties and responsibilities as assigned, consistent with the position’s purpose and operational needs.

JOB REQUIREMENTS:

Minimum Qualifications

• Bachelor’s degree in information technology, computer science, computer information systems, software engineering, data engineering, or a related field; in lieu of a bachelor’s degree, one to two years of additional directly related professional database engineering, database administration, database development, or data‑warehousing experience may be considered.


• Proven experience designing and architecting enterprise‑scale database solutions, including database structures, schemas, relational data models, and complex system integrations.


• Strong hands‑on experience with Microsoft SQL Server and Oracle database environments including database engineering, development, performance optimization, and troubleshooting.


• Advanced proficiency in SQL, T‑SQL, and PL/SQL with demonstrated experience developing, optimizing, and troubleshooting complex database queries and solutions.


• Strong experience developing and optimizing stored procedures, functions, views, packages, triggers, database jobs, execution plans, indexing, and complex queries.


• Strong hands‑on experience designing, developing, and optimizing stored procedures, functions, views, packages, triggers, database jobs, execution plans, indexing strategies, and other database components as applicable to the platform.


• Demonstrated experience independently leading or owning database engineering initiatives, including solution architecture, technical design decisions, implementation optimization, and resolution of complex database challenges.


• Experience engineering and optimizing large transactional databases and high‑volume data environments.


• Experience designing and implementing enterprise data warehouses, dimensional data models, data marts, and ETL/ELT solutions.


• Strong knowledge of database architecture, security monitoring, backup and recovery, disaster recovery, high availability, scalability and capacity planning.


• Experience engineering and optimizing large transactional databases and high‑volume data environments.


• Experience designing, developing, or supporting integrations between databases, ERP platforms, enterprise applications, and reporting or analytics solutions.


• Strong analytical, troubleshooting and root causes analysis skills with demonstrated ability to independently resolve complex database performance and integration issues.


• Effective written and verbal communication skills, including the ability to communicate technical concepts and architectural recommendations to technical and non‑technical stakeholders.


• Strong interpersonal and collaboration skills with experience partnering across application development, infrastructure, security, reporting and business teams.


• Ability to travel approximately 7 to 10% based on project implementation, support and other business needs.

PREFERRED QUALIFICATIONS:

• Experience supporting ERP platforms such as IFS, SAP, NetSuite, Microsoft Dynamics, JD Edwards, Epicor, or similar enterprise systems.


• Experience with data‑integration technologies such as SQL Server Integration Services, Azure Data Factory, Informatica, Talend, or comparable tools.


• Experience with business‑intelligence, reporting, analytics, or data‑visualization platforms such as Tableau, Power BI, Qlik, Cognos, or comparable technologies.


• Experience with cloud and cloud‑data platforms such as Microsoft Azure, AWS, Snowflake, or comparable technologies.


• Experience with scripting and automation using PowerShell, Python, or comparable technologies.


• Experience supporting manufacturing, distribution, supply‑chain, consumer‑products, or comparable business environments.


• Experience integrating AI services, APIs, or AI‑enabled capabilities into enterprise applications, data platforms, or workflows.


• Experience with database migration, modernization, consolidation, or cloud‑adoption initiatives.


• Experience supporting business‑continuity and disaster‑recovery exercises for business‑critical database environments.

KNOWLEDGE, SKILLS AND ABILITIES:

• Advanced knowledge of relational database architecture, engineering, development, administration, and performance optimization.


• Advanced knowledge of Microsoft SQL Server, Oracle, SQL, T‑SQL, PL/SQL, indexing, query design, and execution‑plan analysis.


• Knowledge of database security, access management, encryption, auditing, patching, vulnerability remediation, and least‑privilege principles.


• Knowledge of database backup, recovery, retention, high availability, disaster recovery, and business‑continuity practices.


• Knowledge of enterprise data warehousing, dimensional modeling, ETL/ELT design, data integration, reconciliation, and data‑quality practices.


• Ability to design reliable, secure scalable, maintainable, and high‑performing database and data solutions.


• Ability to diagnose and resolve complex database, integration, application, storage, and performance issues.


• Ability to review technical requirements and translate business and system needs into appropriate database architecture and engineering solutions.


• Ability to evaluate technical risks, identify options, communicate trade‑offs, and recommend practical solutions.


• Ability to work independently and take technical ownership of database environments and solutions throughout their lifecycle.


• Ability to communicate complex technical concepts clearly to technical and nontechnical stakeholders.


• Ability to collaborate effectively with application, infrastructure, cybersecurity, business‑intelligence, reporting, ERP, vendor, and business teams.


• Strong organizational and prioritization skills, with the ability to manage multiple engineering, development, maintenance, and production‑support priorities.

PHYSICAL REQUIREMENTS:

• Ability to sit for extended periods while performing database engineering, administration, development, testing, documentation, meetings, and other computer‑based work, with or without reasonable accommodation.


• Ability to perform assigned duties using standard computer equipment, peripherals, mobile devices, and related technology, with or without reasonable accommodation.


• Ability to lift, carry, push, pull, or move file boxes, computer equipment, supplies, or similar materials weighing up to 50 pounds, with or without reasonable accommodation and/or the use of appropriate material‑handling equipment, as applicable to the assigned task.


• Ability to access company offices, production facilities, storage areas, and other assigned work areas when required for meetings, implementations, troubleshooting, equipment support, records management, or other business needs, with or without reasonable accommodation.

WORK ENVIRONMENT:

• Work is primarily performed in a hybrid/remote professional technology environment.


• Hybrid employees will be based in Ceres, CA.


• The position may require onsite work at company offices, production facilities, warehouses, storage areas, or other operational locations based on project, implementation, database‑support, disaster‑recovery, records‑management, or other business needs.


• The position requires regular collaboration with IT team members, business stakeholders, vendors, and other internal or external partners.


• Travel of approximately 7–10% may be required based on implementation, project, support, and other business needs.


• Production support, system maintenance, upgrades, migrations, incident response, or recovery activities may occasionally require work outside regular business hours.


• Employees must follow applicable company, facility, information‑security, data‑protection, records‑management, and safety requirements while performing assigned duties.

PERSONAL PROTECTIVE EQUIPMENT REQUIRED:

• Side‑shield safety glasses, high‑visibility safety vest, head and ear protection, and appropriate footwear when entering production facilities or other designated operational areas.


• Additional task‑specific personal protective equipment may be required based on the work location, assigned activity, identified hazards, and applicable safety procedures.

WHAT WE OFFER

• Health Care Coverage including medical, dental, vision & prescription – eligible on date of hire for full‑time employees


• Paid Vacation & Holidays


• 401(k) with Employer Match


• Employee Wine Discounts


• Life and AD&D


• Voluntary life and AD&D


• Group Short‑Term Disability


• Group Long‑Term Disability


• Voluntary Critical Illness


• Voluntary Accident & Injury


• Flexible Spending Accounts


• Employee Assistance Program

EEO STATEMENT:

Bronco Wine Company is dedicated to fostering a diverse and inclusive workplace and takes pride in being an equal opportunity employer. All qualified candidates will be considered for employment without discrimination based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability status, protected veteran status, genetic information, or any other characteristic safeguarded by law.

We are committed to cultivating an environment where every individual feels valued, respected, and empowered to reach their full potential.

REASONABLE ACCOMODATIONS

We will provide reasonable accommodations to assist individuals with disabilities in performing essential job functions. If you wish to apply for a position at Bronco Wine Company and require special assistance during the application process, or if you believe you do not meet the necessary qualifications for a posted position due to a protected disability and would like to discuss potential accommodations, please reach out to our Human Resources at [e-mail] for further assistance or guidance.

CALIFORNIA APPLICANT NOTICE:

Bronco Wine Company complies with California pay‑transparency and equal‑pay requirements. The pay scale listed in this document is the salary or hourly wage range the Company reasonably expects to pay for the position and must be completed before the position is advertised. The Company does not seek or rely on an applicant’s salary history when determining whether to offer employment or what compensation to offer, as prohibited by applicable law.

RECRUITMENT AGENCIES:

Bronco Wine Company does not accept unsolicited agency resumes. Bronco Wine Company is not responsible for any fees related to unsolicited resumes.