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 :DatabricksNoSQL (. Mongo, Cosmos DB, CouchDB,Graph Databases (. Neo4J)Microsoft PurviewWhy 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.