Database Administrator (MS SQL , SQL queries, Azure)

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.

Department: NEC Internal
Function: Information Technology
Experience Level: Mid-Senior Level