Sr. IT Engineer-DBA

工作内容

Job Code: TC230022

About Supermicro

Supermicro® is a Top Tier provider of advanced server, storage, and networking solutions for Data Center, Cloud Computing, Enterprise IT, Hadoop/ Big Data, Hyperscale, HPC and IoT/Embedded customers worldwide. We are the #5 fastest growing company among the Silicon Valley Top 50 technology firms. Our unprecedented global expansion has provided us with the opportunity to offer a large number of new positions to the technology community. We seek talented, passionate, and committed engineers, technologists, and business leaders to join us.

Job Summary

Supermicro is looking for a experienced DBA in IT System team. The main goal is providing user satisfaction for services. Duties include but not limited to setting strategies and direction for support, coordinating other IT teams, installing new DB, and supporting existing DB.

Essential Duties And Responsibilities

• Follow enterprise standards, procedures, physical data storage, maintenance, access, backup and recovery, documentation, security, and best practices in a team environment

• Responsible for the installation, update, configuration and production support for all SQL Server Database Services and servers

• Provides SQL DBA support based on SQL monitoring and maintenance solutions, respond to SQL alerts, and provide on-call support

• Works closely with application and IT teams to design and optimize all DB environments

• Performs advanced database administration activities including; installation, configuration, monitoring, space management, database backup and recovery, and disaster recovery procedures

• Performs installation, configurations, and maintenance for SQL Server AlwaysOn Availability Group

• Performs database environment reviews and provides DB improvement solutions to application owners

• Provide HA and DR solutions for Dev, Test and production environments

• Provide technical writings and detailed documentation on technology standards and procedures and make recommendations for optimization

• Independently be able to provide performance measures of transactional databases, identifying bottlenecks, disk analysis and other metrics to provide tuning recommendations

Qualifications

• Bachelor’s degree with minimum 3 years of experience, or an equivalent combination of education and work experience

• In-depth knowledge in database performance tuning

• Experience writing T-SQL stored procs or complex queries

• Experience in installation, configuration, patching, migration, upgrades HA/DR strategies

• Must have good understating of architecture principles within MS SQL Server database technologies

• Should be able to support 24X7 support for critical systems

• Experience working with both on-premise and cloud

• Experience in SQL Query tuning by Profiler/indexing, understanding optimizer and execution plans

• Good to have, experience in MySQL

• Product Areas:

o Operating Systems/Databases

- Microsoft Windows Server 2014, 2016, and 2019

- Microsoft SQL Server 2014, 2016, 2017 and 2019

- SSRS, SSIS, SSAS are good to have

o Areas of proficiencies:

- Proficient skills with T-SQL and PowerShell

- SQL Installation upgrade/patching, and configuration

- Solid SQL tuning skills

- Backup and Recovery, solid with HA/DR solutions

- Solid understanding of High Availability – Configure, install and support Always-On AG, Clustering, Mirroring, Log shipping, Replication, etc.

- Familiar with SQL Monitoring tools/solutions

•Team-oriented interpersonal skills, ability to work independently or part of team