Analyze Queries and Stored Procedures, tune the SQL for optimal performance
Strong Experience and hands-on in database modelling, administration, tuning and troubleshooting performance problems
Knowledge on Replication strategies, log shipping and Mirroring.
Strong knowledge on database backup & recovery.
Implementation and maintenance of Always-On High Availability Disaster Recovery setup on Microsoft SQL Server for Business Continuity Plan, "on-premises" or on "Cloud"
Understanding of streaming data analytic and resources
Hands on experience with NO SQL databases (DynamoDB, mongo dB etc.)
Experience with cloud databases.
Experienced with cache software.
Hands On Experience on SSAS and SSRS.
Monitor Production Servers for optimal performance
Experience in Data Migration between disparate systems. Preferably SSIS.
Powershell scripting for administration and job automation required.
Exposure to AWS cloud infrastructure and database tuning on Amazon RDS.
Strong exposure on database configuration for SaaS applications.
MCSE/MCSA certification preferred.
Advanced knowledge of database structure and theory
Familiarity with reporting tools
Ability to work independently with minimal supervision and assistance.