skillindiajobs
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Sr. SQL DBA

3.00 to 5.00 Years   Pune   18 Aug, 2022
Job LocationPune
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaDBA / Datawarehousing
EmploymentTypeFull-time

Job Description

    *. Sr., SQL Database Administrator Responsibilities:
    • Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
    • Review, analyze, and evaluate business systems and user needs by facilitating brainstorming sessions with stakeholders.
    • Highly skilled at database design, installations, conversions
    • Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
    • Participates in Database Management System selection and maintains database performance
    • Engage in ongoing process improvement
    • Experienced in Database Performance, Maintenance and Development to perform the following:
      • Database management including backups, recovery, and maintenance
      • Database management for export, import and mass data loads
      • Analyzes and generation of all tables and index statistics
      • Monitoring and resolving data lock issues
      • Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes
      • On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions
      • Create indexes to achieve critical dataset response time for time sensitive reports.
    • Install SQL Server service packs and updates.
    • Configure and manage SQL Security settings.
    • Make system design recommendations according to Microsoft SQL Server best practices.
    • Manage database backup & recovery & DR planning in collaboration with IT manager and
    System Engineer.
    • Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
    • Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in
    a timely manner.
    • Troubleshoot application slowness and performance issues.
    • Responsible for T-SQL query tuning
    • Responsible for database migrations and server upgrades.
    • Develop documentation and training of routine database administration tasks and train server
    operations staff on these tasks.
    • Responsible for ETL of large data into SQL Server Author and modify SQL Server Reporting
    • Perform SQL Server integration with enterprise applications.
    • T-SQL Programming Perform additional tasks as assigned
    Education and Experience Requirements:
    • Bachelors Degree in Computer Science, Computer Engineering, Technology or equivalent
    • MCSE/MCSA certifications preferred
    • Experience with Linux and Windows Server environments
    • Good to have experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
    • Experience with cloud services (AWS, Microsoft Azure) a plus
    • Experience in Logical and Physical Database modelling
    • Must have working experience in a clustered Windows environment.
    • Must have configuration and troubleshooting of SQL Server Integration Services (SSIS)
    • Must have configuration and troubleshooting of SQL Server Reporting Services (SSRS)
    ,

Keyskills :
sql server reporting servicessql server integration servicesmicrosoft sql serverdatabase management systemms sqlsql serversql databasequery tuning

Sr. SQL DBA Related Jobs

© 2020 Skillindia All Rights Reserved