sql dba - Pleasanton, United States - Tata Consultancy Services

    Tata Consultancy Services
    Tata Consultancy Services Pleasanton, United States

    Found in: Talent US C2 - 1 week ago

    Tata Consultancy Services background
    Description

    Job Description: SQL DBA

    ·SQL DBA will be responsible for implementation,configuration, maintenance and performance of critical SQL Server RDBMSsystems, to ensure the availability and consistent performance of our corporateapplications.

    ·The candidate will be responsible for themaintenance and sustainment of the SQL Server database, ensuring itsoperational availability and readiness.

    Responsibilities:

    ·Manage SQL Server databases through multipleproduct lifecycle environments, from development to mission-critical productionsystems.

    ·Configure and maintain database servers andprocesses, including monitoring of system health and performance, to ensurehigh levels of performance availability and security.

    · & nbsp; Independently analyze, solve and correct issuesin real time, providing problem resolution end-to-end.

    ·Provide 24x7 support for critical productionsystems.

    ·Perform scheduled maintenance and supportrelease deployment activities.

    ·Share domain and technical expertise, providetechnical mentorship and cross-training to other peers and team members.

    ·Manage complex database environments consistingof high availability AOAG databases and FCI instances.

    ·Other duties as directed by management.

    Skills and Qualifications:

    ·Strong proficiency in MS SQL database management.

    ·Experience with Performance Tuning andOptimization (PTO), using native monitoring and troubleshooting tools.

    ·Experience with backups, restores and recoverymodels.

    ·Knowledge of High Availability (HA) and DisasterRecovery (DR) options in SQL Server.

    ·Experience working with Windows server.

    ·Excellent written