Senior Lead Database Administrator

Tasks

• Analyze and optimize SQL queries
• Create database documentation and standards
• Define migration strategies and timelines
• Design database architectures for analytics
• Document legacy database structures
• Establish database best practices
• Execute schema updates
• Implement database monitoring and alerting
• Implement indexing strategies
• Lead database migrations
• Maintain audit logs and ensure compliance
• Maintain database availability and integrity
• Maintain database inventory
• Manage database access controls and permissions
• Manage database environments
• Migrate Microsoft Access to modern databases
• Perform database backups and restores
• Provide code review and guidance
• Respond to database incidents and perform root cause analysis
• Track database health metrics
• Tune database performance

Perks/Benefits

• N/A

Skills/Tech-stack

.NET | Access Control | Audit Logging | Backup and Recovery | Data Governance | Data Ingestion | Data Ingestion Pipelines | Data Lake | Data Lake Architecture | Data Modeling | Data archiving | Database Migration | Database performance | Database performance tuning | Database security | Execution Plan | Execution Plan Analysis | Indexing | Ingestion pipelines | Microsoft Access | Microsoft SQL | Microsoft SQL Server | Monitoring and Alerting | MySQL | Performance Tuning | Plan analysis | PostgreSQL | Query Optimization | Role-based security | SQL Query Optimization | SQL Server | SQL query | Stored Procedures | T-SQL