Highly proficient Sr Database Architect/Administrator with 18+ Yrs of experience on MS SQL Server, Oracle and MySQL.
- Has over 18 years of Microsoft Database Design/Architecture Experience.
- Lead and manage a team of DBAs
- Leads technical efforts to architect, design and support database solutions.
- Design and build multi node/multi version HA database infrastructure for database consolidation project.
- Extensive experience with Microsoft Database migrations on On-Prem and on Cloud
- Excellent knowledge of relational database design concepts, coding of functions, triggers and procedures, debugging and tuning SQL
- Experience with setting up DR & BC solutions: Always ON in multi-subnet, Log shipping, Replication, DB Mirroring, Failover Cluster, Custom log shipping.
- Develop and maintain database documentation and standards.
- Experience on Agile Project Management methodology
- Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Proficiency in many SQL techniques including stored procedures, triggers, views, cursors
- Extensive experience in Installation, Configuration and Maintenance of MS SQL Server versions in both clustered, Non-clustered Environment, on VMWare, Physical hardware, and on Cloud.
- Experience in managing servers in high-availability environments across multiple data centres.
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Rollouts, Load Testing, Database consistency checks using DBCC Utilities.
- Experience in implementing policies and procedures for ensuring the security and integrity of the SQL Server databases.
- Expertise with Table Design, Database Design and Index Design.
- AWS Certification
- On call support