SQL DBA Inspiroz

  • company name Inspiroz
  • working location Office Location
  • job type Full Time

Industry Type - IT - Software

Category: Enterprise - SAP / Oracle

Experience: 3 - 4 years required

Pay: INR 1 - INR 7lpa /year

Type: Full Time

Location: Mumbai

Skills: SQLBase, Microsoft SQL Server, PL/SQL, MySQL, NoSQL, Transact-SQL

About Inspiroz

Inspiroz is a subsidiary of ACS International, which has been honoured by the Inc 500 for five consecutive years and inducted into the Inc 500 Hall of Fame. The advancement of technology excites us. What excites us even more is the chance to implement technology that empowers educators to inspire students to realise their full potential. Our team is comprised of an extraordinary assortment of individuals. At Inspiroz, our team members have diverse educational backgrounds and experience working in school settings. We have a unique understanding of what truly matters in order to address challenges.

Job Description

Job Responsibilities:
• Designing databases and ensuring their stability, reliability, and performance.
• Design, create, and implement database systems based on the end user's requirements.
• Improve application's performances.
• Prepare documentations for database applications.
• Memory management for database systems.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Take regular database backup.
• Test databases and perform bug fixes.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.
Technical Requirement:

• Experienced as SQL Developer, T-SQL Programming
• Excellent understanding of Microsoft SQL Server
• Hands on experience with Transparent Data Encryption (TDE)
• Must have worked on SQL server reporting services & SQL server Analysis Services
Intermediate level on below:
• High Availability (HA) & Disaster Recovery (DR)
• Windows Server, Active Directory (AD)
• Practical application of NoSQL/ NewSQL databases

· Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.)
· Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
· Develop and maintain exceptional database on SQL server
· Develop, implement and optimize stored procedures and functions using T-SQL
· Analyze and interpret ongoing business report requirements
· Build appropriate and useful reporting deliverables
· Analyze existing SQL queries for performance improvements and suggest new queries
· Develop procedures and scripts for data migration Technical Requirement:
Expert level on below:
· Experienced as SQL Developer, T-SQL Programming
· Excellent understanding of Microsoft SQL Server
· Hands on experience with Transparent Data Encryption (TDE)
· Must have worked on SQL server reporting services & SQL server Analysis Services
Intermediate level on below:
· High Availability (HA) & Disaster Recovery (DR)
· Windows Server, Active Directory (AD)
· Practical application of NoSQL/ NewSQL databases
General Requirement
· BS/MS degree in Computer Science, Engineering or a related subject
· Sense of ownership and pride in your performance and its impact on company’s success
· Critical thinker and problem-solving skills
· Team player
· Good time-management skills
· Great interpersonal and communication skills