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: $125000.00 to $155000.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 familys 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 familys 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 companys 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 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.