Senior Database Developer - Los Angeles, California Based

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