Lead Technical Database Administrator

Vanguard Group, Inc.

$100K — $130K *
Wayne, PA 19087In-Person
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of experience in database administration, data modeling, or business systems analysis.
  • Undergraduate degree in a relevant field or equivalent training and experience.
  • Expertise in physical and logical data modeling and database design.
  • Strong hands-on skills with diverse mid-tier server and cloud databases, including Oracle, SQL Server, PostgreSQL, and DynamoDB.
  • Knowledge in data migration, data warehousing architecture, and implementation strategies.
  • Proficient in database management in cloud (AWS, Azure) and on-premises environments.
  • Expert in database performance monitoring, tuning, and optimization.
  • Experience with Linux scripting and automation for operational efficiency.
  • AWS Cloud Practitioner Certification or equivalent preferred.

Responsibilities

  • Provide expert DBA services and develop designs for critical business applications.
  • Maintain database logs and bug lists, aligning technical capabilities with business needs.
  • Administer mid-tier server and cloud databases, ensuring optimal performance and providing developer support.
  • Conduct performance analysis and identify areas for quality improvement in databases and applications.
  • Review application designs for compliance, focusing on security, reliability, and performance standards.
  • Train and mentor junior staff, addressing complex issues escalated from them.
  • Test and evaluate IT vendor products as needed.
  • Engage in special projects and additional assignments as required.
  • Design and specify database and data warehouse structures based on technical requirements.
  • Develop strategies for data acquisition and recovery to ensure business continuity and scalability.
  • Manage data migration activities to preserve data integrity and minimize downtime.
  • Troubleshoot complex data processing issues in large-scale environments.

Benefits

  • Opportunity to leverage advanced DBA skills in a high-impact environment.
  • Engagement with cutting-edge cloud technologies.
  • Support for professional development through mentorship.
  • Access to diverse projects that enhance technical knowledge.
  • Collaboration within a team of skilled professionals.
Full 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.

Similar Jobs

More Jobs at Vanguard Group, Inc.

More Information Technology Jobs

Find similar Lead Technical Database Administrator jobs: