Vacancy expired!
- Hybrid - 5% onsite role.
- Setting up SQL database server in both Azure and on-premises.
- Configuring database server for high level performance, availability, sustainability, and security.
- Upgrading, migrating, and patching database servers on various SQL releases.
- Configuring and monitoring SQL database servers, in particular, SQL clusters with Always On Availability Groups.
- Providing database maintenance support, including database backup/recovery, index optimization/statistics update, and user/group access management, etc.
- Providing database operational support with the ability to analyze, solve, and correct issues in real time.
- Working directly with project managers, application owners, and vendors, the DBA is responsible for providing database administration support by assessing SQL server requirement from business/functional/technical aspects, proposing, and implementing database solutions following DBA standards and the industrial best practice.
- Other duties include support of all development, test/staging, and production database environments, security assessments and remediation, procedure documentation.
- In addition, the individual needs to be available 24 hours X 7 days for effective coverage of production database support.
- 10-15 years of in-depth experience for MS SQL production database administration for large enterprise, interdisciplinary environment.
- 5 years of in-depth experience in design, installation, and configuration of MS SQL Cluster with AlwaysOn high availability group in multi-subnet for healthcare enterprise system.
- 5-10 years of in-depth experience in managing work deliverables through ticketing system for project-base.
- In-depth experience in SQL database encryption, including data-in-motion encryption with SSL certificate.
- 5 years of in-depth experience in MS SQL replication technology.
- 10 years of experience with backups, restores and recovery models, able to implement effective and best practice database maintenance procedures using native SQL Server and third-party tools (Ola Halengren).
- Experience and knowledge in PowerShell scripting.
- Critical thinker and problem-solving skills. Team player. Good time-management skills. Great interpersonal and communication skills.
- Experience on Windows server and enterprise network is a plus.
- Experience on other RDBMS platform, such as DB2 or Oracle is a plus.
- ID: #49319085
- State: California Los angeles 90024 Los angeles USA
- City: Los angeles
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2023-02-20
- Deadline: 2023-04-20
- Category: Et cetera