DBA Administrator (Senior)
- Infogain
- 10 - 15 years
- Noida, Gurugram
- 2 months ago
- Email to a friend
- Report this job
Job Description
Job Role: MSSQL DBA | 10+ year s
Position Summary: 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
Requirements & Skills:
Requirements & Skills: 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)
- 8-11 Years
- Primary Skill: Database Administrator
- Sub Skill(s): Database Administrator
- Additional Skill(s): Microsoft SSIS, SQL Server DBA
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: InfogainLocation(s): Noida, Gurugram+ View Contact
Keyskills: System architecture Linux MySQL SSRS Database administration Windows Oracle SSIS microsoft Unix shell scripting
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Infogain
A Silicon-Valley headquartered company, Infogain is a global business oriented IT consulting provider of front-end, customer-facing technologies, processes and applications, leading to a more efficient and streamlined customer experience. We want our clients€™ interactions with their cus...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in