Urgent Looking For Sqldba/sql Database/database/immediate
- 3 Minds ESolutions
- 2 - 7 Years
- Amritsar
- 5 years ago
- Email to a friend
- Report this job
Job Description
Post: Sql DBAExp: 2-5 years
Location: Chennai/Pune Mumbai
Fulltime
SQL Server Installation & Maintenance:
Backup and Restore
High Availability & DR
Monitoring, Troubleshooting & Performance tuning
General
Readiness
Latest technology or modules awareness
Analysis Services
Reporting Services
Integration Services
Master Data Services Data Quality Services
Connectivity components
- Installation, Administration and Maintenance of SQL Server Instances.
- Setup Test, Dev, Staging and Production Environments.
- Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
- Apply/Review/Rollback Service Packs
- Firewall configuration and port setup
- Create Users and assign permissions based on the level of database access the user would need.
Backup and Restore
- Design database Backup and Restoration Strategy.
- Once created the database Backups, monitor those backups are being performed regularly
- From time to time recover the databases to a specific point of time, as per the requests.
High Availability & DR
- Setup High-Availability as part Disaster Recovery Strategy for the Databases.
- Failover Clustering
- Database
- MirroringLog
- Shipping
- Replication
Monitoring, Troubleshooting & Performance tuning
- Troubleshoot various problems that arise in day-to-day work and fix the issues.
- Monitoring SQL Server Error Logs and checking your email alert
- Monitoring and Performance Tuning;
- Physical Server Level, Database level (Database settings and options) and query tuning.
- Creating and maintaining Indexes
- Performing database shrinking, memory settings,
- Monitoring CPU usage and Disk I/O activity etc.
General
- Documenting major changes to the SQL Servers.
- Script execution as part of application deployment or changes.
- Coordination between various UGSI teams
- Performance Tuning - Finding root blocker, Long running query (Identifying, analyzing, solution), Index analysis (Analyzing and suggesting new indexes) - using different tools.
- SSRS - Knowledge on configuring SSRS, Data source management, Steps of Report DBs migration, .RDL files management (add/delete/update .RDL files)
Readiness
- Capacity planning
- Migration planning
- Upgradation planning
- Best suited methods analysis and suggestion
- Proof Of Concept (POC)
Latest technology or modules awareness
Analysis Services
Reporting Services
Integration Services
Master Data Services Data Quality Services
Connectivity components
Employement Category:
Employement Type: Full timeIndustry: Full timeFunctional Area: ITRole Category: ITRole/Responsibilies: Urgent Looking For Sqldba/sql Database/database/immediateContact Details:
Company: 3 Minds ESolutionsLocation(s): Amritsar+ View Contact
Fraud Alert to job seekers!
₹ Not Specified
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in