Must work within client's standards, policies, procedures, templates and SDLC
Experience administering all five SQL Server engines: SQL Server Database Services (SSDS); SQL Server Reporting Services (SSRS); SQL Server Analysis Services (SSAS); SQL Server Integration Services (SSIS) and SQL Server Master Data Services (SSMDS)
Experience with T-SQL, XML, VB, C# and HTML languages
Experience with Windows Server Operating System • Experience with Windows Group Policy
Experience with Windows and SQL authentication • Experience with SQL Server patching
Experience with extraction, load and transformation (ETL) constructs
Experience with SQL Replication
Experience with load balancing
Experience with active directory integration
Experience with ad hoc distributed queries
Experience with database mail
Experience with database backup/restore processing
Experience with disaster recovery plans
Experience with database, table and column encryption
Experience with SSL certification administration
Experience with performance tuning, monitoring and alerting
Experience with indexing and statistics strategies
Experience with SQL Agent job and alert system
Experience with RedGate SQL Compare and Data Compare tools
Experience with generating data dictionaries, data migration plans, data flows, entity relationship diagrams and deployment plans documentation
Stay Safe & Be Healthy !
Kindest Regards, Raj A Digital Minds Technologies Inc