About The Role

Advanced skills and experience in database design, development, security, backup, recovery, performance tuning, and troubleshooting
Leads and mentors junior DBAs, coordinates with other IT teams and communicates with stakeholders and clients.
Maintain database integrity for cloud & locally hosted databases
Setup Test, Dev, Staging, and Production Environments. (Installing SQL Server)
Solve complex problems and develop a proof of concepts to validate ideas and technologies
Perform in-depth system analysis, and recognize problems, opportunities, or underlying patterns and relationships.
Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix, etc. (Security and General Administration)
Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
Work as part of a team and provide 24x7 support
Set up high availability as part of Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication, Always on)
Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options), and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity, etc)
Documenting major changes to the SQL Servers. (General)
Handling ticking tools like service now as on priority tickets
Postgre SQL – Basic Knowledge