Database Administrator (Admin cum development role)- Azure, MS SQL
At a glance
Mid-level Data Architecture & Governance role at NECSWS. Pune · full-time.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Keep SQL Server, MySQL, PostgreSQL and Azure SQL databases available, secure and reliable through routine administration
- Tune queries, indexes, stored procedures and database objects to improve application performance
- Investigate database outages, access problems, blocking, deadlocks and slow queries, then work with application teams on fixes
- Set up Azure SQL failover and recovery capabilities, including Failover Groups, geo-replication and backups
- Handle database access and security controls, and take part in incident, problem and change processes
What you bring
- You have three to five years of hands-on database administration experience
- A B.Tech, MCA or equivalent qualification is required
- You bring practical experience with SQL Server and Azure SQL Database or Managed Instance, plus strong SQL query skills
- You can tune queries and analyze execution plans, and manage database security, monitoring and troubleshooting
Who this fits
This mid-level role suits someone comfortable combining database administration with performance tuning and development-team support. It is based onsite in Pune. You’ll work with others, take direction, communicate clearly and own assigned work through timely delivery.
From the employer
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.
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.
Graduate
Good Communication Skills required.