System Administration and SQL DBA :
- Knowledge of Microsoft Dynamics D365 Finance & Operations (D365 F&O) Installation, Configuration and its System Administration using Life Cycle Services (LCS)
- Working with all departments to implement D365 F&O technology and monitoring to ensure efficiency and smoothness
- Identify areas of improvement and develop plans to address them
- Work with IT partners to deploy changes to D365 F&O database
- Keeping up to date and informed on Microsoft Dynamics 365 F&O application patches
- Manage users and security, Manage services and workflow and Manage administration in D365 Finance & Operations
- Knowledge on Microsoft Dynamics 365 F&O productivity tools such as alerts, Batch Job, Document Management, WCF, Email, Setting up Role-Based Security, Setting Help Server and Workflows
- Must have worked on both server administration and application administration
- Knowledge of servers, system monitoring tools and Windows operating systems SQL Database Administration
Knowledge of Tools :
- SQL profiler, DynPerf, AX trace, WCF tracing, Debug Diag, Proc Dump and fiddler
- Hands-on experience on performance tuning & optimization Knowledge of Administering and Maintaining Microsoft SQL Server Databases (DB backup & recovery, planning & design of infrastructure)
- Hands-on query writing skills on SQL server Database Experience on Administering Microsoft SharePoint, IIS and .NET Framework (Creating and managing Web sites, Web services, virtual directories, and application pools) Experience on installation & configuration of SSRS, SSIS & SSAS
- Understanding & resolving locking, block and deadlock issues
- Understanding existing indexing and provide improvements for re-indexing Understanding SQL architecture from failover, log executing queries etc. and providing improvements Configure SQL Server monitoring utilities to minimize false alarms
- Deploy database change scripts provided by third party vendors In case of any performance issues, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index query changes Failover clustering, SAN replication, and other high availability technologies
No comments:
Post a Comment