Azure DB Developer

Key Responsibilities

Database Design and Development

• Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, functions, triggers, and indexes.
• Create and optimize logical and physical data models.

T-SQL Development and Optimization

• Write, optimize, and troubleshoot complex T-SQL queries, stored procedures, and functions for high-volume data processing and efficient data retrieval.

Performance Tuning and Optimization

• Analyze and improve database performance through query optimization, indexing strategies, database configuration adjustments, and resource utilization monitoring.

Database Administration and Maintenance

• Perform routine database administration tasks such as backups, restores, disaster recovery planning, index maintenance, and database monitoring.
• Maintain SQL Application Jobs to ensure smooth operation.

Documentation and Best Practices

• Create and maintain comprehensive documentation for database designs, processes, and procedures.
• Ensure adherence to coding standards and best practices.

Cloud Platform Expertise

• Leverage Azure services for database management, including Azure SQL Database, Azure Cosmos DB, Azure Storage, and related services.
• Implement best practices for Azure SQL Database and other Azure data services.