Lead Database Administrator

Tasks

• Define database migration strategies and timelines
• Design data lake architectures
• Enforce data quality and governance
• Evaluate security vulnerabilities
• Execute database backups restores and archiving
• Implement database monitoring and alerting
• Maintain audit logs for compliance
• Maintain database inventories and schema updates
• Manage data ingestion pipelines
• Manage database access controls and permissions
• Manage database environments
• Migrate Microsoft Access to modern databases
• Monitor database health and performance
• Respond to database incidents with root cause analysis
• Tune SQL queries and indexing

Perks/Benefits

• N/A

Skills/Tech-stack

Access Control | Cause analysis | Data Governance | Data Ingestion | Data Ingestion Pipelines | Data Lake | Data Lake Architecture | Data Modeling | Data archiving | Database Backup | Database Schema | Database Schema Design | Database alerting | Database monitoring | Database recovery | Database security | Execution Plan | Execution Plan Analysis | Indexing | Ingestion pipelines | Microsoft Access | Microsoft SQL | Microsoft SQL Server | MySQL | Plan analysis | PostgreSQL | Query Optimization | Role-based security | Root Cause Analysis | Root cause | SQL Server | Schema Design | Stored Procedures | T-SQL