Essential Job Functions

SPONSORSHIP NOT AVAILABLE

Position Description

Analyzes and plans for anticipated changes in data capacity requirements.
Develops and administers data standards, policies, and procedures.
Develops and implements data conversion and migration tools.
Collaborate closely with the Financial Planning & Analysis team exploring and defining report metrics.
Supports teams developing and implementing data access and data warehousing programs.
Evaluate and provide recommendations on new database technologies and architectures.
Ensures the rigorous application of information security/information assurance policies,principles, and practices in the delivery of data management services.
Assists with maintaining, monitoring, and performance tuning/optimizing databases.Required Skills (“What you are good at”)
5+ years’ experience in database administration of SQL Server database environments.
Knowledge of Microsoft SQL Server 2014/2016+
Thorough understanding of relational databases, T-SQL Scripting, database normalization best practices, database technologies, and concepts
Database Design in a Software Development Environment as a contributor
Experience with Team Foundation Server, Visual Studio Team Server, and/or Azure DevOps
Proficient with SQL development – ability to write and troubleshoot SQL code and design (procedures, functions, tables, views, triggers, indexes, constraints)
Experience troubleshooting and resolving database integrity and performance issues.
Experience with performance tuning and query optimization.
Experience with SSRS, SSIS or SSAS - A MUST
Experience with DMS, CDC, and RedShift - A MUST

Preferred Skills

Degree in computer science or related field.
Experience with AWS – RDS – DynamoDB
Experience in Microsoft SQL Server Replication
Experience with Microsoft Azure SQL Database
Data Warehouse/Data Lake
Communicates well cross-functionally and can serve as a “bridge” between technical and non-technical audiences in conversations.

Job Type: Full-time

Pay: $120,000.00 - $140,000.00 per year

Benefits:

401(k)
401(k) matching
Dental insurance
Employee discount
Health insurance
Life insurance
Paid time off
Vision insurance

Experience level:

2 years
8 years

Schedule:

Monday to Friday

Application Question(s):

How many years of experience do you have with SSRS, SSIS or SSAS?
How many years of experience do you have with DMS, CDC, and RedShift?

Education:

Bachelor's (Required)

Experience:

Database administration: 5 years (Preferred)
SSRS, SSIS or SSAS: 2 years (Preferred)

Work Location: Hybrid remote in Los Angeles, CA 90056

Mathnasium Learning Centers

New Jobs

Senior Database Developer - Los Angeles, California based