MS SQL Database Administrator

Role & responsibilities

• Lifecycle management of databases on-premises or in the cloud such as:
• Provisioning of databases,Upgrading the database,Decommissioning the database,Patch Management of the database,Backup, restore, and recovery of databases,Data Move (Export/Import) within the database,Database Performance Tuning
• Database Security, including but not limited to:
• User Management,Authentication and Authorization
• Database Resource Management (memory, storage, tablespaces, archives, etc.)
• Monitoring of databases such as:
• Database availability,Database capacity, including utilization, allocation, etc.,Events and incidents from monitoring,Security vulnerabilities
• Troubleshooting, such as failed jobs, ORA-errors, blocking sessions, etc.
• Customizing the database environment to meet specific business requirements and workloads.
• Adherence to established rules and standards by the service and Customer
• Admin On Duty who manages the daily operation and ensures the service KPIs and SLA are met. Offering 24/7 technical support with experienced engineers to assist with any questions or issues.
• Deliver Operation KPI Report

Preferred candidate profile

• Minimum 7+ years of experience
• Provisioning, upgrading, and decommissioning of databases, Patch management, Backup, restore, and recovery, Data moves (export/import),Performance tuning
• Security management (user, authentication, authorization),Resource management (memory, storage, tablespaces),Monitoring (availability, capacity, events, security)
• Troubleshooting (failed jobs, errors, blocking sessions),Customizing to meet business requirements,Adherence to established rules and standards
• Hands-on multi-tier architecting skills.
• Sound knowledge of Infrastructure design (Compute, Storage, Network).
• Good knowledge of cloud security practices.
• Linux & Windows Hands-on Expertise.
• Cloud Level certification.
• Linux and Windows certifications , Ansible and automation certification
• Python and Scripting knowledge, Devops Skills