Apply on Employer Site

Vanguard · 3 weeks ago

Database Administrator, Specialist

Wayne, PA

Full-time

Hybrid

Senior Level

5+ years exp

Vanguard is a global investment management company dedicated to the long-term financial wellbeing of its clients. They are seeking a Database Administrator, Specialist to support all databases, modernize their on-premises footprint, and drive migrations to AWS, combining expertise in Oracle, SQL, and AWS.

FinanceFinancial Services

No H1B

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

Qualification

OracleSQL ServerAWSLinux administrationData modelingPerformance tuningDB migrationMentoring

Required

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