Senior Sql Database Administrator @ Capgemini Technology

Job Description

SQL Database Administrator professional with 7+ years of experience in MSSQL Database Administration on-premises and azure environments Should have good knowledge on SQL Server Architecture. Azure IaaS, PaaS, Database Migration experience of On-Premises SQL Server Databases Microsoft Azure hosted DBs and managed instances. Hands on Experience in planning and performingdatabase migrations and upgrades (In Place, Side by Side) (e.g., SQL 2008 R2 to 2019/2022 SQL database movement from/to cloud). Hands on experience ininstallation, configuring & Patching MS SQL Server versions (MSSQL 2014,2016,2017,2019,2022) with service packs, cus and hot fixes on standalone, clustered servers and private/on premise cloud environments. Expertise in administration ofhigh availability solutions like Clustering, Always On, Log Shipping and Replication with experience in Cloud Exposure. Expertise inInstall and configure new Microsoft SQL Server instances, including Always On availability. groups and failover clustering. Experienced in Database Performance, Maintenance and Development to perform the following: Log file Usage & Temp DB management. Monitoring and resolving data lock issues, Disk Space issues Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes. Creation of right indexes, creating logins and users, Fixing Orphaned users Experienced in Configuration and manage SQL Security settings. Experienced inDatabase Backup/Restore, Recovery & DR. Hands on Experience on Create, modify, and optimize SQL Server Agent jobs and maintenance plans, troubleshoot failed jobs and resolve issues in a timely manner. Hands on Experience ofTroubleshoot application slowness and performance issues. Good Knowledge ofT-SQL query tuning Working experience ofmanaging & upgrade of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) & SSAS Instance. Experience in using SQL Server Tools like Import/Export Wizard, SSMS, SQL Profiler, DTA and SQL Query Analyzer. Good Knowledge of PowerShell, Implementing Scripting solutions for Monitoring and Task automation. Should beflexible & ready to work in 24x7 support environment. Should haveknowledge/certification in MS Azure/AWS cloud

Employement Category:

Employement Type: Full time
Industry: IT Services & Consulting
Role Category: Network / System Administration
Functional Area: Not Applicable
Role/Responsibilies: Senior Sql Database Administrator

+ View Contact

Keyskills:   Azure Database Migration Database Maintenance Database Development Disaster Recovery PowerShell Monitoring AWS SQL Database Administration SQL Server Architecture SQL Server Installation SQL Server Patching High Availability Solutions Always On Availability Groups Database Performance SQL Security Database BackupRestore SQL Server Agent TSQL Query Tuning SQL Server Integration Services SSIS SQL Server Reporting Services SSRS SQL Server Analysis Services SSAS SQL Server Tools Task Automation MS Azure