Aerosphere Hiring for SQL Database Administrator Job at Gharuan Full Time

Responsibilities:

• Knowledge of MSSQL database architecture and internals.
• Installation, Patching, configuration and upgrading of Microsoft SQL Server software and related products.
• Managing SQL Server 2016, 2014 and 2012 databases.
• Handling daily SQL activities like Backup, Restore, Monitoring, SQL Jobs configuration,
• managing security, applying Service Packs or hot fixes and troubleshooting.
• Maintaining SQL replication ,Log Shipping and basic knowledge of High-Availability Always-on clusters.
• Indexing, Data import/Export, Database Migration,Database Security
• Develop custom database objects (T-SQL scripts, stored procedures, tables, views, functions,Trigger )
• Basic knowledge in Performance tuning of SQL queries and providing solutions to improve query and server level performance.
• Capable of handling on-call out-of-business hours including weekends.
• Document the company’s database environment
• Tuning and troubleshooting T-SQL queries to improve performance.
• Assist developers with query tuning and schema refinement.
• Work closely with the Application team to solve their issues related to databases e.g. slow access, deadlocks etc.
• Use different tools (e.g. SQL Profiler, SQL logs,DTA etc.) to identify deadlocks, slow SPROC execution etc.
• Provide Suggestions for Solutions

2. Skills and Qualifications: –

• Candidates must be Graduate in any discipline. Technical degrees ( B.E, Btech) are preferred but not a requirement.
• 2+ years MS SQL Server Administration experience required
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with backups, restores and recovery models
• Knowledge and hands on of High Availability (HA) and Disaster Recovery (DR) options for SQL Server, e.g. Clustering, Mirroring, and Always On configuration.
• Experience working with Windows server, including Active Directory
• A logical approach to problem-solving and the ability to work under pressure
• Self-motivation and a high level of initiative
• Excellent communication, interpersonal and management skills
• Good time management skills to plan and prioritize workload and demands

Job Types: Full-time, Regular / Permanent

Salary: ₹65,000.00 – ₹90,000.00 per month

Benefits:

• Commuter assistance

Schedule:

• Day shift

Application Question(s):

• What is the largest amount of data points handled by you?

Education:

• Bachelor’s (Required)

Experience:

• Database administration: 1 year (Required)

Speak with the employer
+91 9878428616
Expected Start Date: 16/08/2022