Sql Server Database Administrator

Technical Skills 
• Experience with Log shipping is must. 
• Experience with Clustering (Must have)
• Experience with Mirroring (Must have)
• Replication (Snapshot, Transactional replication) (Must have)
• Database Designing & Normalization
• Security settings, integration with Active Directory, LDAP, Locking a User, naming conventions etc.
• Reading and Analyzing Query Plan
• Performance Optimization for SQL Server/Query/Stored Procedures etc. 
• SQL Server and DB Administration
• Database backup/restore planning
• Data Recovery Plans
• Knowledge of AWS environment (EC2, S3 Bucket) (Additional)

Responsibilities
As a database administrator, need to:
• Establish the needs of users and monitoring user access and security
• Monitor performance and manage parameters to provide fast responses to front-end users
• Map out the conceptual design for a planned database
• Consider both back-end organization of data and front-end accessibility for end-users
• Refine the logical design so that it can be translated into a specific data model
• Further refining the physical design to meet system storage requirements
• Install and test new versions of the database management system (DBMS)
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Develop, manage and test back-up and recovery plans
• Ensure that storage and archiving procedures are functioning correctly
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security
• Commission and install new applications and customize existing applications to make them fit for purpose
• Manage the security and disaster recovery aspects of a database.