Senior Database Analyst

Job Duties:

• Administrate the production MS SQL servers of online platforms : monitoring, logging cases to MS Support and follow through the case until it is resolved, patching, password rotation and support platform lead to perform annual capacity planning.  

• Configure SQL Cluster, Database Mirroring and Log Shipping 

• Configure SQL monitoring, identify performance bottleneck, and database performance tuning 

• Analyze query execution plan and performance statistics to help developers on performance tuning 

• Create SQL Server Audit to trace activities on production database servers 

• Maintain database table index and column statistics, identify and create missing indexes 

• Design and create automated script for database backup and restore 

• Develop ETL process for data warehouse by SQL Server Integration Services (SSIS)  

• Perform database integrity check, apply services pack (SP) and security cumulative updates (CU) 

• Manage SQL Server login, database user, and permissions 

• Generate analytical reports for business team using SQL Server Reporting Services (SSRS) 

• Make maintenance tasks plan and execute maintenance tasks 

Skills / Knowledge:

Techinical Skills 

• 10 year relevant experience

• Programming language – Transact-SQL 

• Development tools – SQL Server Management Studio, SQL Sentry Plan Explorer, TSQLLint 

• Load Testing tools – SQL Server Profiler, SQLQueryStress 

• SQL Tracing tools – SQL Server server-side SQL Trace, client-side SQL Profiler 

• Server Operating System – Windows Server 2012, Windows Server 2016, Windows Server 2019 and others 

• Relational Database – SQL Server 2012, SQL Server 2016, SQL Server 2017, SQL Server 2019 and others 

• Database High Availability solution – MSSQL Failover Cluster, Availability Group, Log Shipping 

• Database Replication solution – SQL Server Transactional Replication 

• Database Monitoring tools – Idera SQL Check, SentryOne Power Suite for SQL Server 

• Database Performance Tuning tools – Database Engine Tuning Advisor 

• Database Auditing tools – SQL Server Audit 

• Data Transformation tools – SQL Server Integration Services 

• Data Reporting tools – SQL Server Reporting Services, Visual Studio Report Designer 

• Database Backup & Maintenance solution – Netbackup