Meaningful work,
meaningful life

Job Role: MSSQL DBA | 10+ years

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)