Job Description Job Description 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, i.e. Fivetran, Qlik etc.).
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
