Lead Database Administrator

Tasks

• Define migration strategies and timelines
• Document legacy database structures and migration plans
• Enforce database query best practices
• Ensure compliance and protect sensitive data
• Implement database monitoring and alerting solutions
• Implement indexing strategies and query optimization
• Lead migration from Microsoft Access to modern databases
• Maintain databases across environments
• Manage backups restores copying archiving and schema updates
• Manage database access controls and permissions
• Monitor database performance and resource utilization
• Perform security assessments and vulnerability reviews
• Provide guidance for stored procedures and data modeling
• Resolve database incidents and perform root cause analysis
• Track database health metrics
• Tune queries and analyze execution plans

Perks/Benefits

• N/A

Skills/Tech-stack

.NET | Cause analysis | Data Governance | Data Ingestion | Data Modeling | Data Quality | Database alerting | Database backups | Database monitoring | Database recovery | Execution Plan | Execution Plan Analysis | Incident Response | Indexing | 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