Database Administrator (Admin cum development role) Azure, MS SQL
Job Summary
You will be responsible for:-
- Monitor and maintain Microsoft SQL Server MySQL PostgreSQL and Azure SQL Database environments.
- Ensure database availability performance reliability and security.
- Perform database performance tuning and optimize SQL queries indexes stored procedures and database objects to improve application performance.
- Troubleshoot database-related incidents and ensure timely resolution.
- Support application teams in resolving database performance and connectivity issues.
- Manage database users roles permissions and access requests.
- Implement and maintain database security standards and compliance requirements.
- Investigate and resolve blocking deadlocks long-running queries and locking issues.
- Participate in Incident Problem and Change Management processes.
- Support application and development teams in resolving database-related issues and performance concerns.
- Implement and manage Azure SQL High Availability and Disaster Recovery (HA/DR) solutions including Failover Groups (FOG) Geo-Replication Backup & Recovery
and performance monitoring across Azure SQL environments.
Required Technical Skills: -
- B. Tech/MCA or equivalent qualification.
- 3-5 years of hands-on Database Administration experience.
- Strong experience with:
- Microsoft SQL Server (Mandatory)
- MySQL
- PostgreSQL
- Azure SQL Database / Azure SQL Managed Instance (Mandatory)
- Strong knowledge of:
- SQL Query Writing (Mandatory)
- SQL T-SQL MySQL SQL and PostgreSQL SQL
- Query Performance Tuning and Query Optimization
- Stored Procedures Functions Views and Triggers
- Index Management and Execution Plan Analysis
- Database Security and User Management
- Database Monitoring and Troubleshooting
- Blocking Deadlock and Long-Running Query Analysis
- Azure Database Skills:
- Azure SQL Database Administration and Managed Instance
- Azure SQL Failover Groups (FOG).
- Azure Monitor and Performance Monitoring Tools
- Familiarity with Azure database environments and monitoring tools.
- Familiarity with programming languages like Java
- Strong problem-solving skills and ability to think analytically.
- Good to Have Skill:
- MongoDB / NoSQL Databases
- Liquibase
- PostgreSQL
Required Soft Skill: -
- Have the ability to work in teams and take instruction from a variety of people.
- Polite and approachable manners when liaising with people both internally and externally.
- Show a willingness to listen and learn.
- Take initiative in self-development and career progression.
- Good communication skills.
- Be punctual and reliable.
- Take ownership of assigned tasks and take seriously the responsibility for delivering these tasks on time and to a high quality.
- Demonstrate an ability to alleviate pressure and stress through prioritizing work time management and sound organizational skills.
Qualifications :
Graduate
Additional Information :
Good Communication Skills required.
Remote Work :
No
Employment Type :
Full-time
About Company
Our philosophy is to understand our customers business first before we get to the technology. This approach leads to clever software; streamlining old processes, saving money and delivering positive change. Our technology has helped the NHS screen millions of babies for hearing loss ... View more