Senior Database Engineer

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 At Bronco Wine Company, we understand that our success is driven by our talented, committed workforce. We value the contributions each employee makes to our achievements, and our aim is to offer a comprehensive benefits program that is competitive, helping us attract and retain top talent. Our Benefits are crafted to support the needs of our employees and their families, ensuring the package is simple to understand, easy to access, and affordable for all.

• 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 HR@broncowine.com 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.