What are the responsibilities and job description for the Database Administrator position at SysMind Tech?
Position : Database Administrator
Location : Woodland Hills, CA
Duration : Fulltime
- Experience in SQL server Database administration, windows, azure / aws cloud knowledge , SSIS , SSRS Administration.
- Installing and configuring SQL Server.
- Configure and maintain database servers and processes.
- Experience with backups, restores and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Extensive configuration knowledge on always on, failover clustering, log shipping, Mirroring on on-prem and cloud is recommended.
- Administrating high availability solution like log shipping, mirroring, clustering, and replication.
- Experience on user creation, assigning roles and privileges.
- Administering / migration users, logins, jobs, linked servers, other SQL server objects with minimum efforts.
- Administering SSIS, SSRS and SSAS.
- Migrating SQL server databases from On-prem to cloud.
- Automating administration tasks, managing security, monitor server performance and activities.
- Expertise on encryption and SQL server TDE.
- Monitor system's health and performance.
- Space management including file group, managing transactional log files.
- Ensure high levels of performance, availability, sustainability, and security.
- Analyze, solve, and correct issues in real time.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with query tuning and schema refinement.
- Provide 24x7 support for critical production systems.
- Good knowledge on aws / azure.
- Perform scheduled maintenance, patching and support release deployment activities.
- Experience on patching, deploying security updates, upgrading SQL server.
- Active participation in Production support tasks and meeting the deadlines.
- Fair Knowledge on other RDMS like Postgres, MySQL.
