Lead Technical Database Administrator

Vanguard
Wayne, PA, United States
3 months ago
Apply on juju.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Microsoft Azure Business Software Business Systems Cloud Computing Cloud Database Databases Data Integrity Data Migration Data Warehousing Database Design Amazon DynamoDB
+9 more
PostgreSQL Microsoft SQL Server Oracle (Applications) Performance Tuning Shell Script Data Processing Cloud Platform System Database Performance Amazon Redshift

Job description

  • Provides expert level DBA services and performs physical database design and development for critical business applications and databases with the largest numbers of interfaces and users.

  • 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 and cloud platform databases. Performs day to day monitoring and optimizing, and provides developer support for creation of databases, tables, and indexes. Builds backup and recovery jobs (as needed).

  • Conducts performance analysis of applications and database management systems. 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. Ensures backup, recovery, security, reliability, and performance of the systems. Develops and maintains policies and procedures for ensuring the security and integrity of a database.

  • Trains and mentors staff. Resolves the most complex issues elevated from staff with less experience.

  • Tests and evaluates IT vendor products.

  • Participates in special projects and performs other duties as assigned.

  • Designs and specifies the overall structure of databases and data warehouses based on functional and technical requirements.

  • Develops strategies for data acquisition, archival recovery, and overall database implementation in alignment with long-term scalability and business continuity.

  • Manages data migration and conversion activities, ensuring minimal downtime and data integrity across systems.

  • Troubleshoots and resolves complex data processing issues related to large-scale database environments.

Requirements

  • Minimum of eight 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

  • Expertise in physical and logical data modeling, database design, and performance optimization

  • Strong hands-on experience with multiple mid-tier server and cloud database platforms (e.g., On-Prem - Oracle, SQL Server, AWS/RDS - Oracle, SQL Server, PostgreSQL, DynamoDB, RedShift)

  • Knowledge of data migration, data warehouse architecture, and database implementation strategies

  • Strong experience in database administration and management across both cloud (AWS, Azure) and on-premise environments

  • Expertise in database performance monitoring, tuning, and optimization

  • Proficiency in Linux scripting and automation for database and system operations

  • AWS Cloud Practitioner Certification preferred or equivalent cloud certification

About the company

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., Vanguard, one of the world’s leading investment management companies, serves individual investors, institutions, employer-sponsored retirement plans, and financial professionals. We have a diverse and talented crew with a culture that promotes teamwork, along with an unwavering focus on serving our clients’ best interests.

This website uses “cookies” to distinguish you from other users. A cookie is a small file of letters and numbers placed on your computer or device. This helps us to provide you with a good experience when you browse our website and also allows us to improve our site and services. The cookies are stored locally on your computer or mobile device. To accept cookies you can continue browsing as normal. Or you can go to ourPrivacy Policy (https://www.vanguardjobs.com/site-privacy-policy/) to read more information and learn how to change your preferences.

Read More

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on juju.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:21 min

Building a custom bash script to detect secrets

Dwayne Mcdaniel · LIVE

5:37 min

Extensibility and programmability features of the PostgreSQL database

Silvano Coriani Silvano Coriani · Europe 2026 Virtual

1:44 min

Career transition into cloud native and data management

Michael Cade · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

Videos

See all

Related articles

See all