
Senior Analyst - Database
- Hyderabad, Telangana
- Permanent
- Full-time
JOB DESCRIPTION:
- Monitor and optimize database performance, ensuring high availability and reliability.
- Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
- Perform database deployments
- Optimize database queries and stored procedures for maximum efficiency and performance
- Provides support for troubleshooting and resolving database-related issues reported by application teams
- Ensure data consistency and accuracy across different systems and databases.
- Ensure database designs are optimized for performance, scalability, and reliability
- Configures and manages Azure Databases, including automated backups, replication, and high-availability options
- Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
- Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
- Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
- Participate in on-call rotations and off-hours support for Database support and incident response
- Provide on-site disaster recovery assistance when required
- Perform all other duties and special projects as assignee
- Configures and manages Azure Databases, including automated backups, replication, and high-availability options
- Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
- Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
- Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
- Work closely with other IT teams, including developers, system administrators, and security teams, to ensure that the database platform meets the needs of the business
- Participate in on-call rotations and off-hours support for Database support and incident response
- Provide on-site disaster recovery assistance when required
- Perform all other duties and special projects as assigned
- Bachelor's degree in computer science, Information Technology, or a related field.
- Additional education, certifications, or other distinctions are a plus
- Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
- Azure AZ900, DP900, DP-300 training required.
- Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred.
- Minimum 3 years' SQL Server and/or Azure SQL database development environments.
- Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc..
- Extensive experience with SQL Server and Azure SQL Databases.
- Strong knowledge of T-SQL, stored procedures, and database design principles.
- Experience with performance tuning and query optimization.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
- Experienced with scripting languages and automation tools a plus (AI tools, Infrastructure as Code (IaC), Azure DevOps, PowerShell, and ARM templates) a plus.