SQL Server Database Administration 6 To 9 Years Pune - Capgemini

    Capgemini
    Capgemini Pune, India

    3 weeks ago

    Capgemini background
    Description

    Job Description

    • SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.
    • MS SQL Server DBA (L3 / L2 Level Support for SQL Server): 2022 / 2019 / 2017 / 2016 / 2014
    • Hands on technical experience with AG replica failover/Failback and HA-DR Solutions (Log shipping / Replication / Mirroring).
    • Experience in Database Administration including Installation, Configuration, User Access Management, Backup/Recovery, Monitoring and Performance Tuning, Space Utilization.
    • Troubleshoot issues related to SQL Backup – Restore, DB performance, Shrink DB files, Blocking and deadlock,
    • SQL Server Build including Post QA checks.
    • SQL Server Upgradation / Patching on Always ON / Standby servers.
    • Perform system health checks and provide recommendation reports.
    • PowerShell programming experience preferred (would like to automate sql installs, and other processes)
    • DB maintenance plans, Plan and Perform Patching (pre and post checks), Server Decommissioning
    • Administration and refinement for Monitoring tools: Review, revise, and update monitoring thresholds and alerts to enable infrastructure stability.
    • Installation/Upgradation/Migration of SQL Servers.
    • Apply any patches or service packs for SQL Server.
    • Configure High Availability/Disaster recovery solutions.
    • Configure automated alerts to send a mail to team if any issues.
    • Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
    • Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
    • Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.

    Primary Skills

    • MS SQL Database administration
    • MS SQL Server DBA
    • Database tuning
    • Data modeling
    • Microsoft SQL Server
    • Troubleshooting
    • SQL SERVER

    Secondary Skills

    • Work on Writing custom stored procedures, t-sql queries , powershell scripts , views, and triggers based on requirements for DB maintenance and automate tasks.
    • Work on writing technical and RCA(Root Cause Analysis) documentation.
    • Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
    • work on performance tuning like provide suggestions to crete indexes and tune stored procedures.
    • Troubleshoot recurring problems and fix them permanently.
    • Conduct DB DR Drill activity , ensure to bring the DR site online if any outage at Primary site.
    • Work on prepare and create standardize operational and process documents.