Ms Sql Database Administrator

Job description

We are looking for a qualified MSSQL DBA L3 with 7+ 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:

• 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)

Role: 

IT & Information Security – Other

Industry Type: 

IT Services & Consulting

Department: 

IT & Information Security

Employment Type: 

Full Time, Permanent

Role Category: 

IT & Information Security – Other

EducationUG: 

B.Tech/B.E. in Computers