Lead Database Analyst.

Lead Database Analyst

Your role

Lead a database team to look after all MS SQL database servers for the company : including of proactive monitoring, vendor management, software currency, capacity planning and proactive collaboration with application team and package solution vendors.

Administrate the production MS SQL servers of online platforms

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

Knowledge of Oracle Database is an advantage.

To succeed in this role

Technical Skills

15 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 or equivalent solution

Knowledge of Oracle Database is an advantage.