Key Responsibilities:
- Database Administration: Manage and maintain SQL Server and PostGres databases hosted in the Azure environment.
- Naming Conventions: Implement and enforce strong naming conventions to ensure consistency and organization within the database.
- View Development: Create and optimize database views to support data retrieval and reporting needs.
- Index Optimization: Identify opportunities to improve database performance through effective indexing strategies.
- Process Standardization: Establish and maintain standardized database administration processes to ensure efficiency and consistency in database management.
- Design Evaluation: Evaluate database design elements to identify opportunities for improvement and enhancements.
- Integration of New Applications: Collaborate with development teams to integrate new applications seamlessly into the existing database infrastructure.