• Manage, monitor, and maintain database environments • Ensure database performance, availability, and security • Perform backups, recovery, and disaster recovery procedures • Troubleshoot database issues and optimize queries • Support database migrations, upgrades, and deployments • Collaborate with development and infrastructure teams • Create and maintain technical documentation • Participate in client meetings and provide technical support when needed

• Collaborate with the DBA ops lead in providing leadership to the DBA team to research solutions, delegate tasks to DBAs, review outcomes, troubleshoot issues, and actively participate in or lead team discussions. • Investigate escalated issues, troubleshoot database and API problems, and collaborate with technical staff to develop innovative, efficient solutions. • Design and maintain database connections, ETL/ELT pipelines, and SQL workflows to support application backends and client deliverables. • Implement backup, recovery, and high-availability solutions while monitoring system health and recommending performance improvements. • Ensure secure handling of PHI/PII, enforce SOC audit controls, manage database security practices, and collaborate with IT on cybersecurity configurations. • Provide database access and tools, deploy and review production code changes, communicate issues to project management, and coordinate with clients on database updates and data transfers.

Title: Lead Technical Database Administrator Location: Charlotte, NC, Wayne PA US time type: Full time job requisition id: 177640 Job Description: Core Responsibilities - Provides expert level DBA services and performs physical database design and development for critical business applications and databases with the largest numbers of interfaces and users. - Develops and maintains database logs and bug lists. Understands the business requirements for applications and implements supporting database technical capabilities. - Performs database administration for mid-tier server and cloud platform databases. Performs day to day monitoring and optimizing, and provides developer support for creation of databases, tables, and indexes. Builds backup and recovery jobs (as needed). - Conducts performance analysis of applications and database management systems. Identifies opportunities for continuous quality improvement of technical standards, processes, and technologies. Utilizes logical models to ensure efficient and reliable database performance. - Reviews application designs for compliance with production acceptance requirements. Ensures backup, recovery, security, reliability, and performance of the systems. Develops and maintains policies and procedures for ensuring the security and integrity of a database. - Trains and mentors staff. Resolves the most complex issues elevated from staff with less experience. - Tests and evaluates IT vendor products. - Participates in special projects and performs other duties as assigned. - Designs and specifies the overall structure of databases and data warehouses based on functional and technical requirements. - Develops strategies for data acquisition, archival recovery, and overall database implementation in alignment with long-term scalability and business continuity. - Manages data migration and conversion activities, ensuring minimal downtime and data integrity across systems. - Troubleshoots and resolves complex data processing issues related to large-scale database environments. Qualifications - Minimum of eight years database administrator, data modeling, business systems analyst, development, or related work experience. - Undergraduate degree in a related field or the equivalent combination of training and experience - Expertise in physical and logical data modeling, database design, and performance optimization - Strong hands-on experience with multiple mid-tier server and cloud database platforms (e.g., On-Prem – Oracle, SQL Server, AWS/RDS – Oracle, SQL Server, PostgreSQL, DynamoDB, RedShift) - Knowledge of data migration, data warehouse architecture, and database implementation strategies - Strong experience in database administration and management across both cloud (AWS, Azure) and on-premise environments - Expertise in database performance monitoring, tuning, and optimization - Proficiency in Linux scripting and automation for database and system operations - AWS Cloud Practitioner Certification preferred or equivalent cloud certification Special Factors Sponsorship Vanguard is not offering visa sponsorship for this position. About Vanguard At Vanguard, we don't just have a mission—we're on a mission. To work for the long-term financial wellbeing of our clients. To lead through product and services that transform our clients' lives. To learn and develop our skills as individuals and as a team. From Malvern to Melbourne, our mission drives us forward and inspires us to be our best. 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

• Senior database administrator will be working as part of the DBA team on providing a stable, scalable and well-performing database platform to our internal and external customers. • Responsible for day-to-day operations of database platform, performance tuning, issue troubleshooting • Responsible for Crunchtime application management operations, such as provisioning, decommissioning, patching, upgrades, etc. • Participate in the on-call rotation and act as escalation and source of knowledge for more junior DBAs • Participate in scheduled maintenance work, database patching, upgrades, etc. • Provide database expertise to development, support and other Crunchtime teams