Essential Job Functions

Ownership of Database Design in a Software Development Environment: Responsible for leading and managing the database design process, ensuring it aligns with the software development needs.
Data Capacity Planning: Analyzes and plans for anticipated changes in data capacity requirements, ensuring databases can handle future growth.
Development of Data Standards and Policies: Develops and administers data standards, policies, and procedures to maintain data integrity and compliance.
Data Conversion and Migration: Develops and implements tools for data conversion and migration to support system upgrades and data integration.
Collaboration with Financial Planning & Analysis: Works closely with the Financial Planning Analysis team to explore and define report metrics, ensuring accurate and meaningful data reporting.
Support for Data Access and Warehousing Programs: Supports teams in developing and implementing data access and data warehousing programs to facilitate data storage and retrieval.
Evaluation of Database Technologies: Evaluates and provides recommendations on new database technologies and architectures to ensure the best solutions are utilized.
Information Security Assurance: Ensures the rigorous application of information security/information assurance policies, principles, and practices in the delivery of data management services.
Database Maintenance and Performance Tuning: Assists with maintaining, monitoring, and performance tuning/optimizing databases to ensure high performance and reliability.
Cross-Functional Communication: Communicates effectively cross-functionally, serving as a bridge between technical and non-technical audiences in conversations.

Required Skills

Experience in of experience in database administration of SQL Server database environments.
Knowledge of Microsoft SQL Server: Expertise in Microsoft SQL Server 2014/2016/2019.
Understanding of Relational Databases and T-SQL: Thorough understanding of relational databases, T-SQL, scripting, database normalization best practices, and database technologies and concepts.
Advanced Database Concepts: Understanding of topics like cardinality, parallelism, and parameterization.
Experience with Version Control and CI/CD: Experience with TFS, Git, and setting up CI/CD pipelines.
SQL Development Proficiency: Proficient in SQL development, including writing and troubleshooting SQL code and scripts (stored procedures, functions, tables, views, triggers, indexes, constraints).
Troubleshooting and Performance Tuning: Experience in troubleshooting and resolving database integrity and performance issues, as well as performance tuning and query optimization.
Experience with SQL Server Services: Experience with SSRS, SSIS, or SSAS.
Experience with AWS and Data Tools: Experience with CDC, AWS DMS, S3, AWS Glue, RedShift, Redis Cache, and QuickSight.
Python Knowledge: Working knowledge of Python.

Educational Background: Degree in computer science or related field.

SPONSORSHIP IS NOT AVAILABLE AT THIS TIME

Preferred Skills

Educational Background: Degree in computer science or related field.
Advanced AWS Experience: Experience with AWS DynamoDB, Lambda functions, AWS CodeBuild, CodeDeploy, and CodeArtifact.
Advanced SQL Server Experience: Experience in Microsoft SQL Server replication, partitioning, and sharding.
Data Warehouse/Data Lake Design: Experience working and designing Data Warehouses/Data Lakes.

Mathnasium - The Math Learning Center jobs

Sr. Database Developer/Backend Developer - BASED IN LOS ANGELES, CA.