Lead Technical Database Administrator

About the role

The Lead Technical Database Administrator is responsible for providing expert-level DBA services and performing physical database design and development for critical business applications and databases. They also manage data migration and conversion activities, ensuring minimal downtime and data integrity across systems.

Responsibilities

• Develops and maintains database logs and bug lists.
• Understands business requirements for applications and implements supporting database technical capabilities.
• Performs database administration for mid-tier server and cloud platform databases, including day-to-day monitoring and optimizing.
• Conducts performance analysis of applications and database management systems, identifying opportunities for continuous quality improvement.
• Reviews application designs for compliance with production acceptance requirements, ensuring backup, recovery, security, reliability, and performance of the systems.
• Trains and mentors staff, resolving the most complex issues elevated from less experienced staff.
• 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.
• 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.