sql dba - Bengaluru, India - Capgemini

    Capgemini
    Capgemini Bengaluru, India

    1 week ago

    Capgemini background
    Description
    Job Description

    Job Purpose Support SQL migration security and other project activityKey Accountabilities Develop processes for optimizing database securitySet and maintain database standards Manage database accessPerformance tuning of database systems Install upgrade and manage database applicationsDiagnose and troubleshoot database errorsMust have knowledge on Always on setup and troubleshooting skillsRecommend and implement emerging database technologiesCreate and manage database reports visualizations and dashboardsCreate automation for repeating database tasks Be available for oncall support as neededStrong command of SQL and SQL server toolsExperience in monitoring SQL Server logs to ensure the backup operations batch commands or other scripts and processes have completed successfullyExpert in using tools like Bulk Copy BCP Data Transformation Services DTS in SSISExperience in configuring and managing Linked Servers data transfer between SQL Server and other heterogeneous relational databasesExperience in Supporting Large DatabasesTroubleshooting and documenting root cause analysisExperience in MS SQL Server performance tuning along with SQL Profiler clientserver connectivity query optimization Database Maintenance plans Database Consistency Checker using DBCCExperience in installing Service Packs patches and hotfix for SQL Server and OS Keep update with new feature service pack version technology etc for SQL Database and Management Advanced knowledge of database security backup and recovery and performance monitoring standardsUnderstanding of relational and dimensional data modeling PowerShell and TSQL scripting skills Familiarity with SSAS SSIS SSRS Excellent written and verbal communication skillsExperience with cloud services AWS Microsoft Azure Skills And ExperienceExperience SQL installation and configurationGood knowledge on SQL work flow and basic architecture Good hold on Backup and recoveryKnowledge on system databases Knowledge on user management and server rolesProven experience on temp db issuesProven experience on handling database space and disk space issuesMust have knowledge on blockings and deadlocks Knowledge on HADR conceptsPrimary Skill

    SQL SERVER DBASecondary Skill

    ALWAYSON/CLUSTERING