* Installation, Administration and Maintenance of SQL Server Instances
* Setting up Test, Development, Staging and Production Environments
* User creation and permission management
* Designing and implementing database Backup and Restoration Strategy
* Designing and implementing optimum storage strategies
* Setup High-Availability as part Disaster Recovery Strategy for the Databases
* Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning
* Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
* Ability to detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space, SAN latency and other resource contention issues
* Setup of Maintenance plans, Index management, integrity checks, configuration, patching
* Solid acquaintance with windows server, security delegation, SPNs, storage components
* Documenting configuration and other changes to the SQL Servers
* Service Pack management
Qualifications
* Strong SQL programming skills, particularly for the Microsoft SQL Server.
* Technically proficient and possess a strong understanding of database management, including disaster recovery, and replication.
* Experience managing complex project activities and project coordination.
* Technical knowledge of data-warehousing and big data best practices/techniques.
* Must have excellent organizational, documentation, and communication skills
* Strong problem-solving and metadata skills.
by via developer jobs - Stack Overflow
No comments:
Post a Comment