MLB.com | Current job openings | My Account - TeamWork Online | Mobile


Current available jobs in Baseball Operations:





Baseball Operations: Player Personnel/Scout
SQL Server Database Developer, Baseball Operations - New York Yankees (Bronx, NY)

Description:
The New York Yankees organization is accepting applications for an experienced SQL developer in their Baseball Operations department. This position reports to the senior Baseball Operations staff and will assist in the development of database systems which integrate with existing baseball analytics tools and web-applications as part of our player information and evaluation platform.
 

Primary Responsibilities:
• Analyze business requirements and design reports using stored procedures to support our front office baseball applications
• Perform data integrity checks between systems to identify duplicate records, incorrect imports or data mapping issues
• Setting up ETL operations to import and normalize data from different data providers
• Performance tuning of SQL objects and queries
• Working with major and minor league pitch, hit and player tracking datasets, college and other amateur data, international baseball data, and many other baseball data sources

Qualifications and Experience:
• Must have 3-5 years experience developing in T-SQL
• Deep experience developing stored procedures, CRUD operations and advanced data manipulation skills with T-SQL (CTEs, pivots, temp tables, XML)
• Ability to design and layout a database schema from scratch, including table objects, constraints, indexes, foreign keys, triggers, etc.
• Experience in ETL operations, specifically loading data via different techniques, including bulk loading using BCP operations
• Experience performance tuning of queries and database objects, including things like table partitioning, index tuning, query hints, locking, schema normalization, etc. Ability to utilize SQL Profiler and a thorough understanding of execution plans is a must
• Excellent communication and problem solving skills – must be able to breakdown a complex task and put together an execution strategy with little guidance
• An understanding of typical baseball data structures, basic and advanced baseball metrics, and knowledge of current baseball research areas
• Basic knowledge of Microsoft SQL Server Database administration tasks including backups, maintenance plans, replication, security.
• Experience developing CLR user-defined functions and aggregates
• .NET development experience in C#, primarily as it relates to the data access layer, including things like nHibernate, Microsoft.Practices and/or other ORM tools
• Experience with SSIS and PowerShell
• Unit testing in SQL
• MCSA/MCSE Certification preferred, but not required


This description is intended to describe the type of work being performed by a person assigned to this position. It is not an exhaustive list of all duties and responsibilities required by the employee. The New York Yankees is an Equal Opportunity Employer. The company is committed to the principles of equal employment opportunity for all employees and applicants for employment.

 

Note: When you apply for this job online, you will be required to answer the following questions:

1. Do you have 3+ years experience writing in T-SQL? YES/NO
2. If Yes, describe when you would use a CTE vs. a temp table in your work?
3. Have you used SQL Profiler or execution plans to analyze performance bottlenecks in your code? YES/NO
4. If Yes, describe briefly how you would approach the identification of a performance issue in a SQL query.
5. Have you ever used the bcp utility to bulk import data into a SQL database? YES/NO


Apply for this position      |      Go back job listings


Baseball Operations: Athletic Trainer/Physical Therapy/Doctor
Assistant Athletic Trainer Intern - Oakland Athletics, Dominican Summer League (La Victoria, DR)

One (1) seasonal internship position is now available within the Oakland Athletics minor league system.  The available position will be located in the Dominican Republic working alongside the Athletic Trainer for the Dominican Summer League team in La Victoria.  This position will begin on or around June 1, 2014 and end on or around August 31, 2014.

Duties and responsibilities include, but are not limited to the following:

• Assisting the Athletic Trainer with evaluation, treatment and rehabilitation of injuries
• Recordkeeping using the electronic medical records system (Sutton Medical)
• Assisting with maintenance programs for all players

Requirements:

• Bilingual in Spanish/English, highly preferred
• Possess, or working towards obtaining a degree in Sports Medicine or related field, highly preferred
• CPR/AED certification
• NATA Certified, preferred, but not required

All interested applicants must submit a resume and references to: Jeff Collins, Oakland A’s Minor League Medical Coordinator, 1802 N. 64th St., Phoenix, AZ 85008, or by fax at (480) 945-0557 before May 15, 2014. No phone calls, please.

The Oakland A’s are an Equal Opportunity Employer


Apply for this position      |      Go back job listings


Baseball Operations: Athletic Trainer/Physical Therapy/Doctor
Assistant Athletic Trainer Intern - Oakland Athletics, Spring Training (Phoenix, AZ)

One (1) seasonal internship position is now available within the Oakland Athletics minor league system.  The available position will be located in Phoenix, AZ working alongside the Certified Athletic Trainers for Spring Training and the Arizona Summer League team.  This position will begin on or around May 15, 2014 and end on or around August 31, 2014.

Duties and responsibilities include, but are not limited to the following:

• Assisting the Certified Athletic Trainer with evaluation, treatment and rehabilitation of injuries
• Recordkeeping using the electronic medical records system (Sutton Medical)
• Assisting with maintenance programs for all players

Requirements:

• Bilingual in Spanish/English, preferred, but not required
• Possess, or working towards obtaining a degree in Sports Medicine or related field, highly preferred
• CPR/AED certification, highly preferred
• NATA Certified, preferred, but not required

All interested applicants must submit a resume and references to: Jeff Collins, Oakland A’s Minor League Medical Coordinator, 1802 N. 64th St., Phoenix, AZ 85008, or by fax at (480) 945-0557 before May 1, 2014. No phone calls, please.

The Oakland A’s are an Equal Opportunity Employer


Apply for this position      |      Go back job listings


 

Sports Jobs Board Powered by TeamWorkOnline.com


Technical problems? Contact the TeamWorkOnline webmaster / FAQ

TeamWorkOnline Privacy Policy (popup window)