At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
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.
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.
Strong skills with troubleshooting, researching and resolving blocking/deadlocking, connectivity issues, data corruption, security issues etc.
Expert Oracle Skill set should include:
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.).
Special Factors
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.
Vanguard, one of the world's largest 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 our Privacy Policy (https://www.vanguardjobs.com/site-privacy-policy/) to read more information and learn how to change your preferences.