Lead, Database Engineering

Grade Level (for internal use):

11

Job Description

The Role: Lead, Database Engineering.

The Team: We are seeking for a highly experienced Lead Database Administrator (DBA) with proven expertise in managing a team of 10 people and handle complex enterprise database environments and integrating AI-driven solutions for intelligent performance tuning, automation, and predictive analytics. Combining deep SQL expertise with advanced knowledge in artificial intelligence and machine learning, this professional, leads cross-functional teams in building resilient, secure, and self-optimizing database infrastructures, skilled in automating routine tasks, optimizing query performance, and applying AI to proactively detect anomalies, forecast resource needs, and ensure continuous availability of mission-critical systems.

The Impact: This is an excellent opportunity to join Enterprise Solutions as we transform and harmonize our infrastructure into a unified place while also developing your skills and furthering your career as we plan to power the markets of the future.

Whats in it for you: This is the place to hold your existing Database, Infrastructure, DevOps and Leadership skills while having the chance to become exposed to fresh and divergent technologies (e.g. AWS/ Snowflake/ Terraforms/Python/CI/CD)

Responsibilities: The Lead DBA will manage a team of 10 people and optimize SQL Server 2016/2019/2022, Oracle 12c/19c, Postgres 14/15/16 and MySQL databases hosted in AWS environments such as Amazon RDS, Amazon EC2, and Amazon Aurora. The role requires expertise in database performance tuning, security, cloud-based best practices, proactively detect anomalies, forecast resource needs, and ensure continuous availability The DBA will collaborate closely with architects, developers, system administrators, and Devops teams to ensure efficient database integration with business applications.

Team Leadership & Management

• Leading, mentoring, and guiding a team of database administrators, fostering a collaborative and high-performing environment.
• Providing expert-level support for escalated database-related issues, leading root cause analysis, and implementing corrective actions.
• Working closely with other IT teams (e.g., development, devops) to ensure seamless integration and alignment of database solutions.
• Implementing and enforcing database security policies, managing user access controls, and ensuring data protection and compliance.
• Assist developers in leveraging SQL Server Profiler, Oracle AWR, and AWS Performance Insights for tuning queries.
• Work closely with developers to design and maintain optimized database schemas for SQL Server, Oracle, Postgres & MySQL

Database Management & Maintenance

• Administer and maintain SQL Server, Oracle, PostgreSQL, MySQL databases hosted on Amazon RDS and Amazon EC2.
• Perform database installations, patching, and upgrades on AWS infrastructure.
• Configure and manage multi-AZ deployments, Read Replicas, AOAG, and Data Guard to ensure high availability.
• Manage SQL Server Always On configurations for improved failover and availability.
• Implement database partitioning, compression, and indexing strategies for performance optimization.

AI/ML Integration & Automation

• Implement AI-powered observability tools for predictive monitoring and anomaly detection (e.g. for query optimization or capacity forecasting)
• Predictive performance modeling (e.g., forecasting CPU, memory usage)
• AI-based query optimization using workload analysis
• Proactive alerting using anomaly detection models (e.g., Prophet, isolation forest)
• Automation scripts in Python and Shell to monitor DB health
• Integration with AI platforms (Azure ML, AWS Sage Maker, or custom models)
• Lead efforts in automating DBA task using AI/ML (e.g. index recommendation, workload pattern recognition)

Data Integrity & Security

• Implement security best practices using AWS services like AWS KMS, IAM Roles, and Security Groups for database access control.
• Manage encryption for data at rest and in transit using Transparent Data Encryption (TDE) for SQL Server and Oracle.
• Ensure compliance with organizational and industry security standards.

Backup & Recovery

• Design and implement automated backup strategies using AWS Backup and RDS Automated Snapshots for SQL Server.
• Use Oracle RMAN for Oracle database backups and recovery.
• Develop and test disaster recovery plans using AWS DMS and Cloud Endure.

Monitoring & Alerting

• Configure proactive alerts for performance issues, storage limits, and availability risks using CloudWatch and AWS SNS.

• Collaboration & Documentation

• Collaborate with developers, cloud architects, and DevOps teams to integrate database changes into CI/CD pipelines.
• Document database architectures, configurations, backup strategies, and recovery plans.

Tools & Technologies

• Oracle Enterprise Manager (OEM), SQL Developer, TOAD
• Python (pandas, scikit-learn), Oracle ML (OML), AutoML
• Shell scripting, PowerShell, PL/SQL, PG/SQL
• Git, Jenkins, Terraform, Ansible, CloudFormation
• Goldengate, AOAG, DMS, Data guard

What Were Looking For:

• Oracle Certified Professional (OCP)
• Microsoft Certified: Database Administrator
• MySQL Certified: Database Administrators
• PostgreSQL Certified: Database Administrators
• AWS Certified Solutions Architect
• 14+ years of experience as Lead DBA managing a team of 10 or more.