Lead Database Administrator

Tasks

• Create database documentation and standards
• Define migration strategies and timelines
• Design and maintain data lake architecture
• Enforce data quality and governance
• Establish database best practices
• Implement indexing strategies
• Implement monitoring and alerting
• Lead database migrations
• Maintain audit logs
• Maintain database availability and integrity
• Manage access controls and permissions
• Manage data ingestion pipelines
• Manage database environments
• Migrate Microsoft Access to modern databases
• Optimize queries using execution plans
• Perform backups restores and archiving
• Perform root cause analysis
• Perform security assessments
• Provide database guidance and code review
• Respond to database incidents
• Track database health metrics
• Tune database performance

Perks/Benefits

• N/A

Skills/Tech-stack

.NET | Access Control | Archiving | Audit Logging | Backup and Recovery | Cause analysis | Data Governance | Data Ingestion | Data Ingestion Pipelines | Data Quality | Database Migration | Database alerting | Database monitoring | Database performance | Database performance tuning | Database security | Execution Plan | Indexing | Ingestion pipelines | Microsoft Access | Microsoft SQL | Microsoft SQL Server | MySQL | Performance Tuning | PostgreSQL | Query Optimization | Role-Based Access | Role-Based Access Control | Root Cause Analysis | Root cause | SQL | SQL Server | T-SQL