Sybase Dba - Singapore - Smart IMS
1 week ago
Description
In-depth knowledge of Microsoft SQL Server Instances, Database administration and SQL Server components such as Database engine (SSDS), Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services(SSAS) running on Windows Standalone and Cluster servers
Strong understanding and/or working experience of Microsoft SQL Server installation, upgrade, database setup and implementation of SQL Server technologies such as SQLAlwaysOn, Database Mirroring, Log Shipping, SQL Replication and Windows Standalone\Clustering using Storage-level replication for High availability and Disaster recovery.
Experience in SQL Server Instance upgrade from SQL Server lower version to latest version and Database migration from one SQL Server to another
Strong knowledge in utilizing SQL Server monitoring and troubleshooting\performance tools such SQLCMD, SQL profiler, Database Import/Export, Database upgrade tool and SQL Server Management Studio
Experience in addressing SQL database alerts/issues, capacity constraints and performance related items.
Demonstrated ability in problem solving, identify tuning opportunities, implement improvement, and advise Production support\developer teams on root cause/analysis, SQL tuning and permanent solution.
Experience in MS Dos/Powershell scripting, T-SQL scripting and Linux shell/Perl scripting will be plus.
More jobs from Smart IMS
-
Network Security Engineer
Singapore - 1 week ago
-
Testing and Commissioning Engineer
Singapore - 3 days ago
-
Service Desk Engineer
Singapore - 2 days ago
-
Cut-in / Out Test & Commissioning Engineer
Singapore - 3 days ago
-
Field Service Team Lead
Singapore - 3 days ago
-
Financial Analyst
Singapore - 1 week ago