Senior Database Engineer

About the job

The Role

This position will report to: SVP OF IT

Travel Requirements: Based on Business needs 7-10%

FLSA Status: Exempt

Shift:1

Employment Category: Full-Time Regular

Pay Range: $125,000.00 to $155,000.00

Onsite Position

Bronco Wine Company 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.o Wine Company 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.

JOB STATEMENT: The Senior Database Engineer is a hands-on technical role responsible for the architecture, development, administration, security, performance, and reliability of the company’s Microsoft SQL Server and Oracle database environments. The role also designs and develops enterprise data warehouse and integration solutions supporting ERP, reporting, analytics, and other business-critical applications.

KEY RESPONSABILITIES:

Database Engineering & Development

• Own the administration, configuration, maintenance, and optimization of Microsoft SQL Server and Oracle environments.
• Design, develop, and optimize complex T-SQL and PL/SQL, including stored procedures, functions, views, packages, triggers, and database jobs.
• Review database code and architecture for performance, scalability, reliability, and maintainability.
• Establish standards for database design, development, deployment, and change management.

Performance & Reliability

• Perform advanced database and query tuning using execution plans, wait statistics, indexing, statistics, query profiling, and workload analysis.
• Diagnose CPU, memory, I/O, locking, blocking, deadlocks, TempDB, transaction log, storage, and concurrency issues.
• Monitor database health, performance, availability, and capacity and proactively identify potential issues.
• Design database configurations for performance, scalability, high availability, and growth.

Data Warehouse & Integration

• Architect, design, and develop enterprise data warehouses, data marts, staging environments, and dimensional models.
• Develop and maintain ETL/ELT pipelines integrating 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, and data-quality controls.
• Optimize data models and database structures supporting BI, reporting, analytics, and data visualization platforms.

Security, Backup & Recovery

• Own 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, patching, upgrades, and security reviews.
• Maintain database recovery procedures and participate in business continuity and disaster recovery testing.
• ERP & Enterprise Systems
• Support database and integration requirements for enterprise ERP and business applications.
• Understand complex ERP schemas and develop efficient extraction and integration strategies.
• Support ERP implementations, upgrades, migrations, data conversions, integrations, and troubleshooting.
• Partner with application, infrastructure, security, and business teams to resolve complex data and system issues

Other duties as assigned

QUALIFICATIONS:

• 7+ years of experience in database engineering, development, administration, or data warehousing.
• Strong hands-on experience with Microsoft SQL Server and Oracle.
• Advanced SQL, T-SQL, and PL/SQL development and performance-tuning skills.
• Strong experience with stored procedures, functions, views, packages, execution plans, indexing, and query optimization.
• Experience designing and building enterprise data warehouses, dimensional models, and ETL/ELT solutions.
• Strong knowledge of database architecture, security, backup/recovery, disaster recovery, monitoring, and capacity planning.
• Experience working with large transactional databases and high-volume data environments
• Strong analytical, troubleshooting, and root-cause-analysis skills.

PREFERRED EXPERINCE:

• ERP platforms such as IFS, SAP, NetSuite, Microsoft Dynamics, JD Edwards, Epicor, or similar enterprise systems.
• Data integration technologies including SSIS, Azure Data Factory, Informatica, Talend, or similar tools.
• BI, reporting, analytics, and data visualization platforms such as Tableau, Power BI, Qlik, Cognos, or similar technologies.
• Cloud data platforms including Snowflake, Azure, AWS, or similar technologies.
• Scripting and automation using PowerShell, Python, or similar technologies.
• Manufacturing, distribution, supply chain, or consumer products environments.
• Integration of AI services, APIs, and AI-enabled capabilities into enterprise applications.

PHYSICAL REQUIREMENTS:

• Sit for extended period of time
• Perform tasks using standard computer equipment
• Lift up to 50 lbs.

WORK ENVIRONMENT:

• Limited noise level
• Indoor climate

PERSONAL PROTECTIVE EQUIPMENT REQUIRED:

• Side shield safety glasses, safety vest, head/ear protection and proper footwear when in production facility.

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.

• Medical
• Dental
• Vision
• 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
• 401K
• Paid time off

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 Accommodations: 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 [email protected] for further assistance or guidance.

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