Database Administrator, Specialist

Overview

Join the Database Operations team at Vanguard India in Hyderabad as a Database Administrator, supporting Oracle, Microsoft SQL Server and AWS database technologies (Postgres, DynamoDB, etc.) to keep the firm's investment platforms available, recoverable and performant.

What you'll do

• Ensure backup, recovery, security, availability, maintenance and performance of enterprise database technology.
• Create and maintain backup and recovery jobs.
• Resolve database issues and help 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.

What you'll need

• 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).
• 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).
• Working knowledge of DBA best practices and concepts: database backup and 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.
• Strong skills with troubleshooting, researching and resolving blocking/deadlocking, connectivity issues, data corruption, security issues etc.
• Great communication and documentation skills that lead to internal problem resolution documents, lessons learned, how-to guides, and knowledge transfer.

Nice to have

• Certification in Oracle, SQL Server, or AWS.
• Working knowledge of Cloud Providers and Solutions / AWS.

Details

• Location: Hyderabad, Telangana, India (Vanguard India).
• Only qualified external applicants will be considered.
• Hybrid working model for most employees.