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 Database Operations team is responsible for ensuring the operational excellence of Oracle, SQL Server, and cloud data platforms. The team is also responsible for architecture, upgrades, administration, performance and tuning, automation, and feature/function research and development for database infrastructure.
Want more jobs like this?
Get Data and Analytics jobs in Wayne, PA delivered to your inbox every week.
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, connectivity issues, data corruption, security issues etc.
- Expert DBA in database development and supports Oracle's 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, connectivity issues, security issues, etc.
- 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.).
Sponsorship
Vanguard is not offering visa sponsorship for this position.
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 get so much more in return. We invest with purpose - and that's how we've become a global market leader. Here, we grow by doing the right thing for the people we serve. And so can you.
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 Vanguard's 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.