WHO WE ARE

Based in Plain City, Ohio, Select Sires Inc. is committed to enhancing the productivity and profitability of dairy and beef producers. Highly fertile semen and genetic consultation are provided by three farmer-owned and -controlled cooperatives domestically, while World Wide Sires, Ltd. delivers international service. As the industry leader, Select Sires Inc. supplies farmers and ranchers with the world's best genetics, services and programs.

SELECT SIRES, INC MISSION

With the highest integrity, maximize the productivity, profitability, and sustainability of livestock producers who feed the world.

SELECT SIRES, INC. CORE VALUES

Select Sires, Inc. is currently seeking candidates to join our team as a Database Developer/Administrator. This full-time, salary, non-exempt position and is a hybrid position. The position reports to Director of enterprise Data. 

 JOB DESCRIPTION

The Select Sires Data Team is looking to add another database administrator to the growing team. The Data Team is made up of Data Analyst, Data Engineers, Data Warehouse Engineers, Data Scientist, and Database administrators. We are working to transition Select Sires, Inc. into a data-informed company using data as a competitive advantage. Such qualities as availability, stability, recoverability, maintainability, and performance are key to support all data activities. 

We have a mixture of on premises SQL Servers, Azure databases and Serverless Databricks data environment. If you want to leverage your existing experience with traditional database administration and help maximize the value of transitioning to the Azure cloud this role may be for you.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Ensure availability, stability, recoverability,  maintainability, and performance of database and servers to support      transactional data systems, analytical data systems.
• Proficiency in classic on-premises SQL Server, including T-SQL programming.
• Experience with Azure SQL Database and its associated services.
• Familiarity with Databricks and its application in data engineering and analytics.
• Strong understanding of database design principles and best practices.
• Strong understanding of automation: Data pipelines, SQL DACPACs, PowerShell, Infrastructure as code (IaC)
• Knowledge of best practices for data security, user permissions, and compliance with data regulations.
• Knowledge of data warehousing concepts and ETL processes.
• Knowledge of principles of Transaction data systems.

SELECT SIRES, INC. COMMITMENT TO EMPLOYEE GROWTH AND SUCCESS

Select Sires is a team-oriented atmosphere, encouraging employees to take greater responsibility for their careers to grow personally and professionally.

• Select Sires offers employees competitive compensation packages that include flexible benefits,
• Professional development through mentoring and internal and external training,
• Advancement opportunities through career planning,
• A culture instilled by a commitment to excellence, a passion for customer success, and high ethical standards,
• A focus that includes work/life balance,
• Community-oriented mindset as a major contributor to local organizations and events

REQUIRED SKILLS AND ABILITIES OF A DATABASE DEVELOPER/ADMINISTRATOR: 

• Reliable means of transportation to report to work on time
• Valid driver’s license with acceptable driving record
• Willingness to travel short distances as business demands dictate
• A positive attitude with a passion for learning
• Strong written and verbal communication skills
• Ability to work in an open cubicle concept with moderate business office noise

REQUIRED EDUCATION EXPERIENCE

• 3 years of experience in administering, managing, and tuning SQL Server databases
• Experience with: On premise SQL Server Instances, Azure SQL Database and Azure Managed Instance
• Experience with Data replication including SQL Server Merge Replication Publisher and subscriber configuration  
• Expertise in SQL
• Experience using automation: SQL Server DACPACs, Data Pipelines, PowerShell, Infrastructure as code (IaC)
• Experience with HA/DR SQL Enterprise is a plus
• Experience with SQL Monitoring technology is a Plus (i.e. Red-Gate SQLMonitor)
• Implement and manage company data management practices and policies
• Demonstrated experience in troubleshooting and resolving database problems
• Demonstrated experience in tuning database and its objects
• Understanding of databases indexes and index maintenance
• Great interpersonal and communication skills  

PHYSICAL REQUIREMENT OF A DATABASE DEVELOPER/ADMINISTRATOR

• Constantly (6-8 hours) stand, sit, or walk, talk, hear, and use hands and fingers to operate a computer, telephone, and keyboard
• Seldomly (0-1 hours) stoop/kneel to install computer equipment
• Constantly (6-8 hours) vision abilities required by this job including close vision requirements necessary for computer work 
• Seldomly (0-1 hours) floor lift (0-17"), knee lift (18" -29"), waist lift (30" -36"), chest lift (37" -60"), overhead lift (>60"), push/pull or carry up to 20 lbs.

DISCLAIMER

The job description is not intended to cover or describe all tasks, duties, and responsibilities the employee may be asked to perform. Select Sires retains the right to change or add new tasks, duties, and responsibilities to the employee at any time, with or without notice.

WORK AUTHORIZATION

Evidence of work authorization upon employment is required in compliance with the Immigration Reform and Control Act of 1986. Completion of USCIS form I-9 will be required to verify employment eligibility within three business days of the first day of employment.

AAP/EEO STATEMENT

Select Sires, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Select Sires, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location where the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.Select Sires, Inc. expressly prohibits workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Select Sires, Inc.'s employees to perform their job duties may result in discipline up to and including termination.