Database Administrator (SQL Server & Azure)

Description

Position at loanDepot

Position Summary:

Responsible for maintaining database performance, availability, security, and data integrity in a 24/7 environment. This role collaborates within a team to execute projects and operational tasks while providing technical expertise and guidance to team members.The DBA must be local to the Irvine, CA or Plano, TX Area.

Responsibilities:

• Demonstrated 5+ year’s experience working as a MS SQL Server administrator.
• Strong understanding of SQL database monitoring and performance tuning.
• Advanced knowledge of HA and DR options.
• Ability to develop automation and scripts to automate tasks and tools to reduce DBA manual touch points (Hands-on experience scripting in PowerShell or any other scripting tool).
• Contributes to the direction of Azure cloud migration.
• Implements, maintains & troubleshoots database replication (SQL Server replication and 3rd Party tools, . Fivetran, Qlik .
• Understands the DBA challenges, delivers a technical solution that meets the unique needs of DBAs with innovation and automation.
• Learns continuously, leveraging training resources and self-directed training, sharing knowledge and skills with the rest of the team.
• Completed multiple migrations/upgrades.

Requirements:

• Bachelor’s degree preferred in Computer Science or related IT field or equivalent work experience.
• Minimum five (5) + years of production DBA experience.
• Minimum three (2) + years SQL development experience.
• PowerShell experience.
• Cloud migrations - Microsoft Azure and/or AWS.
• Strong analytical and problem-solving skills with automation/innovation.
• Extensive experience in High Availability (HA) and Disaster Recovery (DR) options for MSSQL and Azure SQL.
• Experience with replication in multi-server/datacenter environments.
• Experience with multi-datacenter environment, including stretched data center to Azure or AWS.
• Participates in “On-Call” rotation within the Team.
• Experience with SSRS development, SSDT in conjunction with TFS and GIT source control.
• Experience working with CI and Software Engineering teams.
• Active participation in Governance, including data access, encryption, and masking best practices.
• Experience monitoring and supporting ETL pipelines (. Azure Data Factory, SSIS).
• Experience with any of the following would be GREAT to have:
• Databricks
• NoSQL (. Mongo, Cosmos DB, CouchDB,
• Graph Databases (. Neo4J)
• Microsoft Purview

Why work for #teamloanDepot:

• Competitive compensation based on skillset and relatable experience.
• Work with other passionate, purposeful, and customer-centric team members.
• Inclusive, diverse, and collaborative culture where people from all backgrounds can thrive.
• Extensive internal growth and professional development opportunities including tuition reimbursement.
• Comprehensive benefits package including Medical/Dental/Vision.
• Wellness program to support both mental and physical health.
• Discretionary Time Off (DTO) policy to support work-life balance in addition to Paid Voluntary Time Off.