Ms SQL Database Administrator

4 days ago


Melbourne, Australia The Brain Hawk Consultant Full time

**Database Administrator
- Australia**

**Locations**: Melbourne VIC, Australia

**Skill Set**: Database Administration, Database Development, MS SQL Server Administration, Brent Ozar

**Skill to Evaluate**: Database Administration, Database developer, Database Development, MS SQL Server administration, Brent Ozar

**Experience**: 4 to 6 Years

**Job Overview**:
Job requirement:

- **4-6 years** of experience as a Database Specialist in **Microsoft SQL Server**.
- Experience and expertise with **Microsoft SQL database administration**, **T-SQL development**, and **PowerShell Scripting**.
- Exposure to Database monitoring and health check tools.
- Experience in database maintenance, like fragmentation checks including daily **Backups and Recovery**, re-index operations, update statistics, and other system commands such as DBCC and DMVs
- Exposure to configuring and managing SQL Server High-availability data solutions **Log shipping**, Mirroring, and data synchronization solution Replication.
- Must have good exposure in setting up and troubleshooting the Always-On High availability solutions.
- Must have experience in PowerShell scripting and good to have knowledge in **DBA tools**.
- Good knowledge of designing database files and layouts for Temp DB
- Strong SQL knowledge and experience in creating database objects such as tables, views, stored procedures, Triggers etc.
- Generate code to Extract, Transform and Load (**ETL**) data from one data source to another (**SSIS**).
- Performance tuning of key queries.
- Good exposure to **OLA Hallengren** and **Brent Ozar** performance monitoring scripts.
- Identify and write the best possible code in case of new deployments or when rewriting code when migrating to a newer version of SQL Server.
- Experience in database security and auditing.
- Experience monitoring multiple databases; database performance management and tuning.
- Experience performing database migrations; experience analyzing current database performance and making projections for future growth.
- Good to have knowledge on Reporting tools like PowerBI
- Excellent written and verbal communication skills and the ability to handle multiple tasks under tight deadlines.
- Good team player and able to work with teams across the regions.

**Must Have**
- MS SQL Server Database Administration.
- T-SQL Development: Writing, understanding and modifying the existing SQL queries(CRUD, Joins, Sub queries etc.), stored procedures, functions and triggers.
- PowerShell Scripting: Writing, understanding and modifying the existing PowerShell scripts and new scripts as per the requirement.

**Good to have Knowledge in**
- PowerBI
- SSIS
- DBATools

**Qualification Required**:
**Job Types**: Full-time, Permanent

Pay: $100,000.00 - $120,000.00 per year

Schedule:

- Day shift

Work Location: In person



  • Melbourne, Australia Corptec Technology Partners Full time

    Job description Corptec Technology Partners is an international player in the areas of business transformation and organisational performance. Our diversified client portfolio includes Australia’s best and brightest in FinTech, Retail, Telco and Government organisations. We are looking for a with extensive knowledge of SQL Server and Database...


  • Melbourne, Australia Perigon Group Full time

    Roll is open to Part Time or Full Time - Hybrid working from home options - Work close to home in the Eastern Suburbs **About Us**: As part of this NFP organisation, you'll join a dynamic group of professionals united by our values and a vision of enabling people to lead independent and fulfilling lives, crafting their own narratives and shaping their...


  • Melbourne, Australia Cubic Corporation Full time

    Business Unit: Cubic Transportation Systems Company Details: Cubic offers an opportunity to provide innovative technology for government and commercial customers around the globe, helping to solve their future problems today. We’re the leading integrator of payment and information technology and services for intelligent travel solutions worldwide, and the...


  • Melbourne, Australia Bupa Full time

    Bupa is an international healthcare group which has been committed to a purpose of longer, healthier, happier lives and making a better world for more than 70 years. In Australia and New Zealand, Bupa supports more than 5 million customers through a broad range of health and care services including health insurance, aged care, rehabilitation, dental,...


  • Melbourne, Australia NTT Full time

    **SQL Database Administrator** In a constantly changing world, we work together with our people, clients and communities to enable them to fulfill their potential to do great things. We believe that by bringing everyone together, we can solve problems using innovative technology that can create a world that is sustainable and secure. At NTT, we encourage...


  • Melbourne City Centre, Australia HAYS Full time

    SQL DBA I 6 MONTHS CONTRACT OPPORTUNITY WITH OPTION OF PERMANENT I ATTRACTIVE RATES **Your new company** *** Be a part of an exciting project with the Victorian State Government. Your new organisation is a prominent Victorian State Government Department whose responsibilities and work have a positive impact on the quality of life for all Victorian...


  • Melbourne, Australia NTT Full time

    **Is innovation part of your DNA? Do you want to enable a connected future for people, organizations, and society?** Join our growing global NTT team and you’ll be part of the world’s largest ICT company (by revenue). We’ve combined the capabilities of 28 remarkable companies to become one, leading technology services provider. Together, we help our...


  • Melbourne, Victoria, Australia Expert360 Full time

    Location: Melbourne, AustraliaWork Model: HybridAbout Expert360:Expert360 empowers more than 42,000 (and growing) elite professionals around the world to find great work and be successful. Expert360 was founded in 2013 with a simple but powerful mission - to connect amazing people with great companies to get important work done.We believe in choice,...


  • Melbourne, Victoria, Australia Expert360 Full time

    Location: Melbourne, AustraliaWork Model: HybridAbout Expert360:Expert360 empowers more than 42,000 (and growing) elite professionals around the world to find great work and be successful. Expert360 was founded in 2013 with a simple but powerful mission - to connect amazing people with great companies to get important work done.We believe in choice,...


  • Melbourne, Victoria, Australia Leidos Full time

    Join to apply for the Senior SQL Database Administrator role at LeidosJoin to apply for the Senior SQL Database Administrator role at LeidosLife Days are the Leidos way of recognising that we all need extra time to take care of life. By working slightly more than the minimum weekly hours (2 hours per week for full-timers), you can accrue up to 12 days of...