Position Overview: We are seeking an experienced Lead Database Architect to lead the design, development, evaluation, and implementation of enterprise database architecture and technology solutions. This role is responsible for defining database strategies, recommending database technologies, establishing architectural standards, and ensuring optimal database performance, scalability, availability, and maintainability across the organization. The ideal candidate will have extensive experience with Oracle databases and Microsoft SQL Server, along with working knowledge of other database platforms such as PostgreSQL, MariaDB, MySQL, Snowflake, or MongoDB.
Oracle accounts for approximately 70% of the organization's database activity, while Microsoft SQL Server accounts for another 20%. Therefore, strong Oracle database architecture and administration experience is particularly important.
Key Responsibilities
- Design, evaluate, and recommend enterprise database architectures and solutions that maximize performance, scalability, high availability, and maintainability.
- Define database architecture standards, technology strategies, and best practices across multiple database platforms.
- Lead the evaluation, selection, and implementation of database technologies based on business and technical requirements.
- Develop and maintain database architecture documentation, technical standards, best practices, and implementation guidelines.
- Provide architectural guidance and recommendations for Oracle, Microsoft SQL Server, and other database management systems.
- Define database performance optimization strategies and resolve complex database performance and availability challenges.
- Design and recommend high availability, disaster recovery, backup, and recovery solutions.
- Evaluate emerging database technologies, industry trends, and competitive products to establish the organization's future database technology roadmap.
- Identify opportunities for database modernization, technology upgrades, and buy-versus-build decisions.
- Develop and promote database automation strategies for routine maintenance and administration activities.
- Collaborate with infrastructure, application development, cloud, and data engineering teams to deliver effective database solutions.
- Maintain relationships with database technology vendors and service providers.
- Provide technical assistance and architectural guidance to internal and external database users.
- Mentor DBA team members and technical leads, providing direction on database architecture, implementation, and operational best practices.
Required Qualifications & Technical Skills
1. Database Architecture & Administration
- 7+ years of experience in database administration, database architecture, or related database technology roles.
- Strong hands-on experience with Oracle Database architecture and administration.
- Experience with Microsoft SQL Server architecture and administration.
- Experience with at least three of the following database management systems in a lead technical role:
- Oracle
- Microsoft SQL Server
- PostgreSQL
- MariaDB
- MySQL
- Snowflake
- MongoDB
- Strong understanding of enterprise database design, architecture, and implementation.
2. Database Performance & High Availability
- Expertise in database performance tuning, optimization, and troubleshooting.
- Experience designing and implementing high availability and disaster recovery solutions.
- Strong knowledge of database backup, recovery, and restoration strategies.
- Ability to analyze and resolve complex database performance and reliability issues.
3. Cloud & Database Technologies
- Experience with cloud database technologies and database solutions.
- Familiarity with ETL/ELT technologies and data integration processes.
- Knowledge of emerging database technologies and modern database architecture approaches.
4. Automation & Operating Systems
- Experience developing automated processes for routine database maintenance and administration.
- Working knowledge of Microsoft Windows Server and Unix/Linux environments.
- Experience with database monitoring, maintenance, and operational automation.
5. Technical Leadership & Strategy
- Experience leading database architecture initiatives and providing technical direction.
- Ability to establish database standards, best practices, and technology roadmaps.
- Experience evaluating database products, vendors, and emerging technologies.
- Ability to mentor DBAs and guide technical teams.
- Strong analytical, problem-solving, written, verbal, and organizational skills.
- Ability to work independently and collaborate across multiple technical teams.