Senior Database administrator
- Infinite
- 10 - 15 years
- Noida, Gurugram
- 2 months ago
- Email to a friend
- Report this job
Job Description
Job Role: MSSQL DBA | 10+ year sPosition Summary: GDCI is looking for a qualified MSSQL DBA L3 with 10+ years experience of working for companies in related fields. The candidate is responsible for effective installation/configuration, operation, migration and maintenance of MSSQL databases. Responsibilities:
- Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
- Facilitate brainstorming meetings with clients to review, analyse, and assess business systems and needs
- In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
- Assists in the selection of a database management system and the maintenance of database performance
- Participate in continuous process improvement
- Download and install SQL Server service packs and updates.
- Configure and maintain SQL Security controls
- Make recommendations for system architecture per Microsoft SQL Server best practises
- Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
- Create, change, and improve SQL Server Agent tasks and maintenance plans
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
- Troubleshoot application sluggishness and poor performance
- In charge of T-SQL query tuning
- In charge of database migrations and server updates
- Create documentation and training for routine database administration activities, as well as train server operations employees on them
- In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
- Integrate SQL Server with corporate applications
- T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
- Extensive knowledge of SQL and SQL server tools
- Experience in Database Performance, Development and Maintenance
- In-depth understanding of database security, backup and recovery, and performance monitoring requirements
- Familiarity with relational and dimensional data modelling
- Extensive knowledge in database design, implementation, and conversion
- Knowledge of PowerShell and Unix shell scripting
- Experience with SSAS, SSIS, and SSRS
- Outstanding writing and verbal communication abilities
- Meticulous attention to detail
- Working knowledge of Linux and Windows Server infrastructures
- Extensive knowledge of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
- Prior experience with cloud services (AWS, Microsoft Azure,GCP)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: InfiniteLocation(s): Noida, Gurugram
Keyskills: System architecture Linux Database design Process improvement MySQL SSRS Windows Oracle SSIS Unix shell scripting
Similar positions
Infinite
About Xperience Infinite: Xperience Infinite specializes in developing cutting-edge Computerized Maintenance Management System (CMMS) solutions tailored for UK-based retail giants. Our innovative products are designed to manage and maintain assets and resources efficiently, ensuring optimal perfor...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in