Database Administrator (MS SQL , SQL queries, Azure)

Company Description

NEC Software Solutions (India) 

On 1st July 2021, Rave Technologies became NEC Software Solutions India. This change brought us under the global NEC Corporation brand. We are proud to be part of an organisation with 122 years of experience in evolution with technology and innovation.

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 surpassing expectations and helping them deliver robust, market-ready software products that meet the highest standards of engineering and user experience. Supported by more than 1300 exceptionally talented manpower, we are a hub for offshore support and technology services.

We work with diverse industry verticals which include publishing, media, financial services, retail, healthcare and technology companies around the world. Our customers range from two-person startups to $bn listed companies.

For more information, visit at www.necsws.com/india.

About NEC Corporation 

NEC Corporation is a Japanese multinational information technology and electronics company, headquartered in Tokyo, Japan. It is recognised as a ‘Top 50 Innovative Company’ globally and the NEC Group globally provides “Solutions for Society” that promote the safety, security, fairness and equality of society. Their main goal is to help create a safer society with their innovations in technologies.

NEC Corporation has established itself as a leader in the integration of IT and network technologies while promoting the brand statement of “Orchestrating a brighter world.” NEC enables businesses and communities to adapt to rapid changes taking place in both society and the market as it provides for the social values of safety, security, fairness and efficiency to promote a more sustainable world where everyone has the chance to reach their full potential. 

For more information, visit NEC at https://www.nec.com.  

 

 

Job Description

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.