- Data Modeling: Design and document database architecture
- Documentation: Create and maintain documents for all Database related activities like Procedures, Functions, Views SQL, Assemblies, etc.
- Passion for solving challenges-problems & continuous improvement of performance
- Assist developers in problems and/or optimization of SQL Server entities like queries, stored procedures etc.
- Creativity & Out of Box Solutions: Solve problems in a planned, systematic manner
- Ability to Implement Automated Log-Event management & everything that leads to optimum use of existing server resources like Performance Tuning, Index Optimization, Profiling, Query Plan Analysis, Manage Synonyms used in Cross-Database data sharing, SQL Server Security-Encryption
- Design, implement and maintain backup schedule for databases
- Ability to coordinate, provide instruction, track and monitor with IT Team for testing & installation of new patches & service pack
- Ability to implement Clustering, Mirroring, Replication & Failover in require