About this opportunity
Classicwinesofcalifornia lists this Senior Database Engineer opportunity in ceres, California. Review the employer’s description below for duties, qualifications and application requirements.
Job description
If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.
Full Time Clerical Ceres, CA, US
Salary Range: $125,000.00 To $155,000.00 Annually
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 RESPONSIBILITIES:
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.
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
Lift up to 50 lbs.
WORK ENVIRONMENT:
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
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 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.
#J-18808-Ljbffr
Worksite address
ceres, CA, 95307, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.