Database Administrator, Specialist

Overview

On Site
Full Time

Skills

Migration
Oracle
SQL
Incident Management
Scheduling
Database Design
Backup
Recovery
Quality Improvement
Regulatory Compliance
Policies and Procedures
Data Modeling
Business Systems
Training
PL/SQL
High Availability
Oracle RAC
Microsoft SQL Server
Disaster Recovery
Oracle Data Guard
Database Administration
Amazon Web Services
PostgreSQL
Amazon DynamoDB
MySQL
Amazon Redshift
Failover
Linux Administration
Red Hat Linux
CentOS
Oracle Linux
Scripting
Performance Tuning
Database Migration
Database
Finance
Collaboration

Job Details

Join a global Operational DBA team responsible for supporting all databases at Vanguard. Our team spans the U.S. (day shift) and Australia (night shift), working together to deliver seamless 247 coverage. As part of the U.S. day shift team , you'll play a critical role in modernizing our on-premises footprint and driving migrations to AWS. This position combines strong Oracle and SQL expertise with advanced AWS skills to design and operate highly available, resilient environments.

What you'll do:
  • Incident Management
  • Change Review/Scheduling/Fulfillment
  • Customer Request Fulfillment
  • Project Work
  • On-call Duty

Responsibilities:
  • Provides advanced level DBA services and performs physical database design and development for large business applications and databases.
  • Develops and maintains database logs and bug lists. Understands the business requirements for applications and implements supporting database technical capabilities.
  • Performs database administration for mid-tier server databases. Performs day to day monitoring and optimizing, and provides developer support for creation of databases, tables, and indexes. Builds backup and recovery jobs.
  • Identifies opportunities for continuous quality improvement of technical standards, processes, and technologies. Utilizes logical models to ensure efficient and reliable database performance.
  • Reviews application designs for compliance with production acceptance requirements. Develops and maintains policies and procedures for ensuring the security and integrity of a database.
  • Trains and mentors staff. Resolves complex issues elevated from staff with less experience.
  • Participates in special projects and performs other duties as assigned.

Qualifications:
  • Minimum of five years database administrator, data modeling, business systems analyst, development, or related work experience.
  • Undergraduate degree in a related field or the equivalent combination of training and experience.
  • Advanced database administration in Oracle, SQL Server and associated using high availability (Oracle RAC, SQL Server Availability Groups) and disaster recovery tools (Oracle Dataguard).
  • Advanced database administration in AWS for Postgres, DynamoDB, MySQL, and RedShift with highly available environments and failover/ DR solutions.
  • Linux system administration, including Redhat-based systems like Centos or Oracle Linux, monitoring systems - developing scripts and using applications to monitor systems and databases and Support development teams in tasks related to database including performance tuning, DB migration to new platform, assistance to DB query and structure definition.

Special Factors

Sponsorship
Vanguard is not offering visa sponsorship for this position.

About Vanguard

At Vanguard, we don't just have a mission-we're on a mission.

To work for the long-term financial wellbeing of our clients. To lead through product and services that transform our clients' lives. To learn and develop our skills as individuals and as a team. From Malvern to Melbourne, our mission drives us forward and inspires us to be our best.

How We Work

Vanguard has implemented a hybrid working model for the majority of our crew members, designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.