5+ years technical support, technical consulting experience, or information technology experience OR Bachelor's Degree in Computer Science, Information Technology (IT), or related field AND 3+ years technical support, technical consulting experience, or information technology experience
• Experience in a customer facing or customer support role with strong troubleshooting and problem-solving of complex technical issues involving multiple technologies in a team environment
• Experience with SQL Server or an equivalent database product
• Solid knowledge on performance tuning and database design, T-SQL language
• Experience in capacity planning, sizing SQL Server environments and high availability configurations
• Ability to meet Microsoft, customer and, or government security screening requirements are required for this role. These requirements include, but are not limited to the following specialized security screenings: Microsoft Cloud Background Check: This position will be required to pass the Microsoft Cloud Background Check upon hire, transfer and every two years thereafter.
Experience in one or more of these areas desirable
• Industry experience with Microsoft Server products, network connectivity, UNIX or other operating systems, migrating databases to the cloud or upgrading from one version of Microsoft SQL Server to a higher version.
• Experience in creating technical documentation and sharing knowledge with others through training delivery and mentoring
• Other experience such as:
o Containers: docker, k8, open shift, cloud storage, flannel
o Big Data: spark, yarn, livy, zookeeper, ranger, knox, polybase
o Machine Learning: sparkSQL, java, scala, python, jupyter
o Data Sources: mongodb, cloudera, teradata, Oracle, DB2
o Monitoring: collectd, graphana, fluentd, influxdb, elastic search
o Experience with Linux script-based development environments and tools (PERL, Python, Ruby, PhP, etc.)
Language Qualification
Mandarin Language: fluent in reading, writing and speaking. English Language: confident in reading, writing and speaking.
Required (but not limited to the below) Skills & experience in the following areas:
• MS SQL Server DBA experience
• Installing, upgrading & updating SQL Server
• Configuring & Administrating SQL Server and SQL Server on Azure VM as per best practices.
• Backup Strategies
• Performance Tuning & optimizing.
• High Availability & DR solutions (AlwaysOn Availability Groups, FCI, Windows Server Clustering Service, Replication, LogShipping)
• Security (Encryption at rest(TDE), Encryption in transit(SSL))
• Compression
• Understanding of Database properties and advanced configuration options
Table Partitioning
Ability to meet Microsoft, customer and / or government security screening requirements are required for this role. These requirements include, but are not limited to the following specialized security screenings: Microsoft Cloud Background Check: This position will be required to pass the Microsoft Cloud Background Check upon hire / transfer and every two years thereafter.
