SQL Server Database Architect

  National Collegiate Scouting Association
  Houston, TX
  Sports Technology
  Posted/Updated: 11/22/17

Job Summary

SQL Server Database Architect

Location: Houston, TX

Job Code: 782

# of Openings: 1

EEO Job Category: (3) Technicians

Description

SQL Server Database Architect



ABOUT FRONT RUSH AND ACS ATHLETICS

Front Rush and ACS Athletics have joined forces to become the largest provider of technology for college athletics departments. Our products are loved by Coaches and trusted by compliance administrators. Our mission is to help College Coaches recruit the best athletes for their teams and make college athletic departments drastically more efficient. We now have a larger customer roster than all other vendors in the space combined, with nearly 10,000 teams at more than 1,200 colleges and universities across all levels of the National Collegiate Athletic Association, the National Association of Intercollegiate Athletics and the National Junior College Athletic Association.It's an extremely exciting time for our company - we are growing fast and have a lot to accomplish!





Database Architect Details

We are looking for a modern-day database guru who can support large, existing SQL Server databases used for enterprise .NET applications. In addition to your positive attitude and leaving your ego at the door, you possess some knowledge of NoSQL databases and application caching layers. You will provide leadership, strategy, and innovation for production data architecture and management, utilizing relational and emerging database technologies. You will interact directly with the product management team to understand business and technology objectives and drive solutions that effectively meet the needs of the company. You will collaborate with support and data science teams to design, implement and continuously improve database-driven solutions. You will also own primary responsibility for designing the highly scalable and robust database systems along with monitoring and troubleshooting the key health parameters.





Responsibilities

Architect all new database solutions (tables, procs, indexes, functions, views, etc) and maintain existing enterprise database solutions
Work in an agile sprint environment and deliver high performing, highly scalable solutions
Release management during sprint process keep dev, staging, and production DBs in sync
Plans and implements Database backup and recovery with tested recoverability
Implement robust change control and configuration management policies
Capacity planning & system-level architecture in accordance with business projected volumes and infrastructure capacity
OS/Storage/DB configuration and optimization
Database security checks and audits
General database health checks, monitoring, and Database refreshes
Physical data model/architecture, DDL generation, and maintenance
DB server migrations and decommissioning
Database creation, configuration, and upgrading
Lead troubleshooting and recovery as part of incident response.
Database tuning (proactive and reactive)
Maintain and revise DB documentation as needed
Disaster recovery/failover services
Work with application dev teams as apps Dba to optimize DB performance (SQL query, reconfig etc.)
Manage offshore SQL devs
Ensure availability of all databases
Manage database users and security/access control
Contribute significant, new and innovative ideas tell us what we don't know!
Maintain technical currency in database and technology trend through research/education and personal development



Qualifications

Minimum 10 years on SQL database design and administration experience (5 years on SQL Server)
Minimum 5 years database architecture experience
Understanding of SQL Server versions 2005 and beyond
Proven expertise developing logical and physical data models and designs based on business requirements
Experience in architecting, optimizing, maintaining large enterprise databases and applications.
Expert Knowledge of SQL (Query) tuning
Experience with data pipelines and ETL techniques
Experience with Data Warehouse design, ETL (Extraction, Transformation & Load), architecting efficient software designs for .NET platform
Working knowledge of NoSQL databases, such as MongoDB and Cassandra
Experience with big data analytics technologies
Some AWS RDS experience helpful but not required
Experience with ETL and BI Tools (SQL Server SSIS, Mode Analytics)
Passion for about continuous learning, experimenting, applying and contributing towards cutting edge open source Big Data technologies and software paradigms
Excellent oral and written communication skills



Benefits

Medical, Dental, Vision, & Life Insurance
Pre-Tax Flexible Spending Account
401(k) Match Up to 3%
Parental Leave
Wellness Reimbursement Program - $65 per month
Online Health Assessments
Great PTO (Paid Time Off) Plan



Location

Houston, TX, Greater Toronto Area (Stouffville) or remote.



Reigning Champs LLC is committed to providing equal employment opportunities to all employees and applicants without regard to race, religion, color, sex, national origin, citizenship status, uniform service member status, age, disability, sexual and gender orientation, genetic information or any other protected status in accordance with all applicable federal, state, and local laws.

Are you a returning applicant?

Previous Applicants:

Email:

Password:

If you do not remember your password click here.

Back to Search Results

New Search

How to Apply for Position:

Upgrade your account to paid subscription and gain access to this job as well as all other sports job opportunities:

Upgrade to a premium membership for complete access!

Subscribe today and gain access to 407 jobs in the sports industry - Cancel anytime

Payment Details

*By joining JobsInSports.com, you agree to the Terms of Agreement and to receive important email communications. To ensure uninterrupted service, your membership will be autorenewed at the regular price at the time you joined. You may cancel at any time. Simply refer to our Cancellation Policy.

Similar Jobs

Second Engineer in Charge
  Sports & Entertainment Company
  Central Region
  Sports Technology
  Posted/Updated: 04/19/24
Home Run Productions Support Engineer
  Sports Media
  Central Region
  Sports Technology
  Posted/Updated: 03/22/24
Vice President, Consumer Products
  Professional Soccer League - NY
  Northeast Region
  Sports Technology
  Posted/Updated: 04/18/24
Vice President, Consumer Products
  Professional Soccer League
  Northeast Region
  Sports Technology
  Posted/Updated: 04/16/24
Vice President, Consumer Products
  Soccer
  Northeast Region
  Sports Technology
  Posted/Updated: 04/11/24

Ready to Get Started?

Get access to the most up-to-date live sports jobs now!