Wayne, PA
Vanguard is not offering visa sponsorship for this position.
As a Lead Database Administrator, you will be joining the Database Operations team providing technical leadership to a team of DBA's supporting a large Oracle portfolio with additional Microsoft SQL Server and AWS database technologies. You will work with application developers, fellow DBA's, and IT leadership to improve the efficiency, resiliency, production stability, automation, and reliability of Vanguard's database
infrastructure.The
The ideal candidate should have strong knowledge of
- DBA best practices and concepts database backup & recovery, database performance tuning, database monitoring, and maintenance.
- Expert knowledge of Oracle
- Working knowledge of SQL Server and other contemporary relational DBMS platforms.
- Strong experience in AWS Cloud (Postgres, DynamoDB and RedShift.
- Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.) and resolve database related issues.
- Ability to support multiple releases, including latest versions of Oracle and Microsoft SQL Server.
- Designing databases and data modeling concepts.
- Strong automation and scripting skills PowerShell, Shell Scripting, PL/SQL, T-SQL, etc.
- Great communication and documentation skills that leads to internal problem resolutions documents, lessons learned, how to, and knowledge transfer.
- Strong skills with troubleshooting, researching and resolving
- blocking/deadlocking,
Expert Oracle Skill set should include
- Expert DBA in database development and supports Oracles latest versions on a Linux platform.
- Strong experience in AWS Cloud (Postgres, DynamoDB and RedShift.
- Strong skills using Bash/Korn shell scripting & PL/SQL for automation of database administration tasks and notifications.
- Robust experience with High Availability using RAC and Disaster Recovery using Data Guard.
- Expert at troubleshooting and resolving database integrity,
- blocking/deadlocking,
- Strong knowledge of RMAN for backups and recovery using a catalog.
- Robust experience using OEM 13c for monitoring & alerting.
- Knowledgeable of the Linux environment.
- Experience with advanced Performance Tuning.
- Strong knowledge of Oracle tools, (Toad, SQL Developer, OEM, OID, etc.).
Special Factors
Sponsorship
About Vanguard
We are Vanguard. Together, we're changing the way the world invests.
For us, investing doesn't just end in value. It starts with values. Because when you invest with courage, when you invest with clarity, and when you invest with care, you
can
We want to make success accessible to everyone. This is our opportunity. Let's make it count.
Inclusion Statement
Vanguard's continued commitment to diversity and inclusion is firmly rooted in our culture. Every decision we make to best serve our clients, crew (internally employees are referred to as crew), and communities is guided by one simple statement Do the right thing.
We believe that a critical aspect of doing the right thing requires building diverse, inclusive, and highly effective teams of individuals who are as unique as the clients they serve. We empower our crew to contribute their distinct strengths to achieving Vanguard's core purpose through our values.
When all crew members feel valued and included, our ability to collaborate and innovate is amplified, and we are united in delivering on Vanguards core purpose.
Our core purpose To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.
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.