Techstar Software Development India Hiring for Sql Server Dba at Hyderabad, Telangana, India Full Time

Job Description

Work Location: Hyderabad (Work From Home due to Covid-19)Primary Skills required: SQL Server DBARole Responsibilities
Database Administration for the SQL Server 2005 to SQL Server 2019 (Maintenance, Security, Upgrades, Performance Tuning, etc.)
Installing, Configuring and Upgrading SQL Server/Applying Service Packs
Server and Database Security Administration
SQL Server Replication Designing SQL Server Systems and Implement
A good knowledge of the physical database design
Create database objects (tables, indexes, etc.)
Write database procedures, functions and triggers
Tune database queries, tuning and Monitoring SQL Server
Code or data synchronization
Ensure data consistency in the database through DBCC commands.
Should have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries.
Should be very strong in replication concepts and troubleshooting replication issues with in SLA.
Extensive experience in designing and handling Disaster recovery/high availability.
Failover Clustering; Data Modeling
Implementation experience in Enterprise wide automation tools/custom automation.
Data Transformation and Loading; Experience with SSIS and SSRS troubleshooting
Upgrade from DTS to SSIS packages; Backup the current code for rollback purposes
Analysis – Analyze the data to determine the core problems
Testing – Test the various options to ensure they perform better and do not cause worse performance in other portions of the application
Plan growth and changes (capacity planning)
Perform general technical trouble shooting and give consultation to development teams
Interface with Microsoft Corporation for technical support.
Patch Management and Version Control
Tools
Should have good understanding of the MS SQL, related utilities and tools
Identification – Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures or third party tools
Backing Up and Restoring SQL Server, Knowledge of ALL MS DB backup and recovery scenarios
Establish and maintain sound backup and recovery policies and procedures
Backup tools; Performance tools; Check for failed processes
Research errors, Validate disk space is not low, validate none of the databases are offline or corrupt
Perform database maintenance : Perform both MS SQL and operating system performance tuning and monitoring
Familiarity with SQL Always-on technologies and the latest versions of SQL Server
Requirements
At least 12-15 years working as a DBA and handling production critical databases/Servers.
10 or more years of experience as a SQL Database Administrator/Engineer
10 or more years of hands on Production/Development DBA/DBA experience.
Candidate Should have Communication Skills
.
Who can join Immediately – 15 days preferred
.
Please call me on 9121275762
.Job Types: Full-time, Part-timeSalary: INR1,200,000.00 – INR2,000,000.00 per yearBenefits:

• Food allowance
• Health insurance
• Life insurance
• Paid sick time
• Paid time off
• Work from home

Schedule:

• Day shift

Experience:

• Scripting: 3 years (Preferred)
• SQL server DBA: 8 years (Required)

Education:

• Higher Secondary(12th Pass) (Preferred)

COVID-19 Precaution(s):

• Remote interview process
• Personal protective equipment provided or required
• Plastic shield at work stations
• Temperature screenings
• Social distancing guidelines in place
• Virtual meetings
• Sanitising, disinfecting, or cleaning procedures in place

Speak with the employer
+91 9121275762