Database Administrator (Admin cum development role)- Azure, MS SQL
NEC Software SolutionsPune, MH, IndiaOn-Site
Needs a free Superjobs account. You'll finish on NEC Software Solutions's SmartRecruiters page.
Skill score
Summary
This Database Administrator will monitor, tune, secure and troubleshoot Microsoft SQL Server, MySQL, PostgreSQL and Azure SQL environments, while supporting application teams with database performance and connectivity issues. It suits a candidate with 3-5 years of database administration experience who is comfortable with query optimization and Azure high availability and disaster recovery.
- Estimated salary
- Est. ₹18–27 LPA
- Estimated for a mid-level role, ~20 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, Pune, MH, India
- Experience
- 22+ yrs
- Employment type
- Full-time
Job description
Roles and responsibilities
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.
Skills required
Top skills
- Microsoft SQL Server
- Azure SQL Database
- SQL query writing
- T-SQL
All skills (9)
- MySQL
- PostgreSQL
- Query performance tuning
- Database security
- Azure SQL failover groups
- Azure Monitor
- Java
- MongoDB
- Liquibase
Qualifications
- 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.
Nice to have
- 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
Other details
Additional Information
Good Communication Skills required.
Company info
About NEC Software Solutions
On 1st July 2021, Rave Technologies became NEC Software Solutions India. This change brought us under the global NEC Corporation brand. We have more than 30 years of experience in providing end to end IT services across the globe and have earned a reputation for delighting our customers by consistently