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.