Junior Database Administrator

About

Description

The Junior Database Administrator at Norton Rose Fulbright oversees global database operations, optimizes performance, and ensures sustainability. Key duties include maintenance, upgrades, backups, disaster recovery, and collaboration. Candidates should have SQL Server experience, T-SQL proficiency, PowerShell scripting knowledge, and database design skills.

Responsibilities

• Perform regular database maintenance, install latest SQL patch, upgrade DB and application while also designing and implementing new databases
• Create and produce ad-hoc report as per business/user requirement
• Identify potential problems, provide technical expertise and propose viable solutions
• Monitor and maintain database storage, database health, performance and sustainability
• Manage SQL Replication, database backup strategies and perform recovery in case of disaster
• Continuous improvement of work practices to automate and reduce support practices
• Monitor and maintain SQL server instances including Always-On availability groups and failover clusters
• Foster strong relationships with key stakeholders across the organization and work closely with cross-functional teams, including data architects, data engineers, business analysts, and system administrators
• Produce and maintain Power BI and SSRS reports Design, develop, and maintain SSIS packages and ETL processes for efficient data transfer and transformation
• Proficiency in documenting database configurations, processes, and troubleshooting procedures

Qualifications

• Tertiary qualifications in IT or a related discipline
• 2 years+ of experience as an SQL Server administrator or in a similar role
• Developing skills in database programming languages like T-SQL, understanding tools like SSRS and SSIS, learning ETL processes, practicing data handling, and improving SQL performance
• Understanding of PowerShell & SQL scripting, stored procedures, triggers etc
• Experience in administrating databases on SQL Server and Microsoft SQL Azure including Always-On availability groups and failover clustering, SQL replication is a bonus
• Good problem solver, focused and dedicated developer with ability to work on your own as well as with a team
• Effectively communicate with key stakeholders and excellent troubleshooting skills

Application instructions:

• To apply simply, click on the apply button