Database Administrator, Specialist

Location: Hyderabad, India

About Vanguard

Founded in 1975, Vanguard is one of the world's leading investment management companies. The firm offers investments, advice, and retirement services to tens of millions of individual investors around the globe—directly, through workplace plans, and through financial intermediaries.

Vanguard India

Vanguard’s office in India is a significant milestone in our global expansion. We are committed to establishing an enduring technology center in Hyderabad, Telangana and are excited to be adding talent who will focus on Artificial Intelligence (AI), mobile, and cloud-based technologies that drive our business outcomes and deliver a world-class experience for our clients.

Role Summary

At Vanguard, technology is integral to helping our clients reach their personal goals. We depend on IT 24/7 to run our investors’ assets. That puts your expertise in Technology Operations at the heart of our business.

As a Database Administrator, you will be joining the Database Operations team supporting Oracle, Microsoft SQL Server and AWS database technologies (Postgres, DynamoDB, etc.). 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 primarily responsible for ensuring the operational availability/recoverability of all enterprise database platforms. The team is also responsible for administration/maintenance, upgrades/patching, performance tuning and completion of database requests from internal customers.

Responsibilites

• Ensure backup, recovery, security, availability, maintenance and performance of enterprise database technology.
• Create and maintain backup and recovery jobs.
• Resolve database issues and help to determine root cause.
• Perform administration, installation, upgrade, configuration, and patch management of all enterprise database technology.
• Perform on-call support on a rotational basis.
• Provide support during normal business hours to developer requests on a rotational basis.
• Recommend database technology features/functions to application developers.
• Assist with testing and evaluating IT vendor products.
• Review application designs for compliance with production acceptance requirements.
• Provide key technical input and expertise in large scale projects.

Qualifications and Skills

• Minimum 5 years of experience as a database administrator, data modeler, business systems analyst, developer, or in a similar role involving enterprise data platforms
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and experience
• Minimum of five years database administrator experience with Oracle, SQL Server or AWS (Postgres, DynamoDB)
• Certification in Oracle, SQL Server, or AWS, preferred but not required.
• Excellent written and oral communication skills, including interviewing and presentation skills.
• Strong relationship management, analytical, problem solving and organizational skills.
• Broad knowledge of the financial services industry.
• Ability to effectively multi-task.
• Flexibility, strong decision-making skills and effective time management skills.
• Proven ability to work with attention to detail under tight time constraints.

Working knowledge and experience with some or all of the following:

• MS Windows and/or Linux (Redhat) based operating systems
• Virtualization – VMware
• Distributed Computing Hardware Technologies
• Network Technologies – SDN, DNS, Ethernet Fabrics, Firewalls, Load Balancers, WAN, WiFi, etc.
• Directory Services – Active Directory/LDAP
• Backup and disaster recovery testing
• Job scheduling (Control-M)
• ITIL (Incident/Problem Management, CMDB) (ServiceNow)

The ideal candidate should have working knowledge of

• DBA best practices and concepts: database backup & recovery, database performance tuning, database monitoring, and maintenance.
• Hands on experience of Oracle, SQL Server and AWS (Postgres, DynamoDB) database technologies.
• Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.) and resolve database related issues.
• Ability to support multiple releases (e.g., Oracle 12c/18c/19c, Microsoft SQL Server 2016/2019, etc).
• Designing databases and data modeling concepts.
• Automation and scripting skills; PowerShell, Shell Scripting, PL/SQL, T-SQL, etc.
• Working knowledge of Cloud Providers & Solutions / AWS preferred.
• 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.

Location

This role is based in Hyderabad, Telangana at Vanguard India. Only qualified external applicants will be considered.

Our mission

Vanguard adheres to a simple purpose: To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.

Our commitment to you

Vanguard takes the same long-term view of your success—at work and in life—with Benefits and Rewards packages that reflect what you care about, throughout all the phases and stages of your life. Our Total Rewards programs provide you and your loved ones with wellness support for key areas in your life:

Financial wellness

We're committed to enabling your financial success and provide competitive offers and programs.

Physical wellness

We're committed to providing benefits that support your physical health and wellness.

Personal wellness

We're committed to providing resources that help support the full scope of your life.

How we work

Vanguard has implemented a hybrid working model for most of our employees (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.