Database Administrator

Database Developer/AdministratorThe 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 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 ResponsibilitiesMaintain 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.Excellent problem-solving skills and attention to detail.Strong communication and collaboration skills.Required Education and Experience3 years of experience in administering, managing, and tuning SQL Server databasesExperience with: On premise SQL Server Instances, Azure SQL Database and Azure Managed InstanceExperience with Data replication, including SQL Server Merge Replication Publisher and subscriber configuration.Expertise in SQLExperience using automation: SQL Server DACPACs, Data Pipelines, PowerShell, Infrastructure as code (IaC)Experience with HA/DR SQL Enterprise is a plusExperience with SQL Monitoring technology is a plus (i.e. Red-Gate SQLMonitor)Implement and manage company data management practices and policiesDemonstrated experience in troubleshooting and resolving database problemsDemonstrated experience in tuning database and its objectsUnderstanding of databases indexes and index maintenanceGreat interpersonal and communication skillsPhysical Demands & Working ConditionsWhile performing the duties of this job, the employee is regularly required to, stand, sit; talk, hear, and use hands and fingers to operate a computer and telephone keyboard reach, stoop kneel to install computer equipmentSpecific vision abilities required by this job include close vision requirements due to computer workLight to moderate lifting is requiredRegular, predictable attendance is required; including quarter-driven hours as business demands dictateModerate noise (business office with computers, phone, and printers, light traffic)Ability to work in an open cubicle conceptAbility to sit at a computer terminal for an extended period of timeTravel RequirementOccasional travel may be requiredDisclaimerThe 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 AuthorizationEvidence 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 StatementSelect 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.