Job Summary
|
Azure MSSQL DBA L3 Job Description |
|
Experience: -
|
|
Certification: -
|
|
Responsibilities: -
|
|
REDIS L3 Job Description |
|
Experience: -
|
|
Certification: -
|
Key Responsibilities
|
Responsibilities: - REDIS L3
|
Skill Requirements
Technical Requirements (REDIS)
- Proficient in managing REDIS database / Cluster - installation, configuration, upgrade, patching, maintenance, security, sysadmin functions and administration.
- Knowledge of REDIS cluster monitoring tool - Managing, Configuring, setting up alerts and troubleshooting
- Evaluate the Database Server Hardware
- Define/Recommend/Maintain Database Standards and Architecture
- Recommend Server H/W, REDIS Server Editions for a new Build.
- Research and Recommend Patch management for database/instance and Impact Analysis.
- Initiate need and Impact Analysis for Database Migration/Upgrade
- Technical Consultation to L2/L3 and Customer
- Vendor Support and Interaction
- Monitor and optimize REDIS database performance and capacity planning.
- Troubleshoot database issues, maintain database systems availability and scalability.
- Create and maintain REDIS databases required for development, testing, Integration, QA and production usage.
- Performs the capacity planning required to create and maintain the databases.
- The DBA should work closely with Server, Backup and storage administrator to meet Backup, Hardware, Storage and Operating system requirements.
- The DBA should work closely customer to understand the requirements and standards.
- Perform ongoing analysis and tuning of the REDIS database.
- Install new versions of the REDIS database and its features and any other tools that access the REDIS database.
- Application code promotion and migrations of programs, database changes, reference data changes and menu changes through the development life cycle if applicable
- Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
- Troubleshoots with problems regarding the databases, replication and database related Tools.
- Good knowledge of physical database design and responsible for the physical database design
- Ability to perform database and operating system performance monitoring and the necessary adjustments.
- Excellent skill in High availability, replication technologies and failover
- Implement and enforce security requirements for REDIS databases.
- Recommend and Review Backup and Recovery Strategies.
- Provides technical support to application development teams.
- Having experience of DR Solution/Implementation/Execution through various sync methods.
- Designing strategy towards Capacity Management for DB tracks
- Designing REDIS Server Security (Server hardening, Auditing, compliance)
- Good knowledge of the Unix operating system(s)
- Weekly review of incidents/tickets
- Weekly review of CHGs completed/Canceled.
- Weekly review of recommendations made to the DBs
- Automate routine DB jobs.
- Optimize day-today DB activities.
- Documentation and DB procedures write-up.
Knowledge of other Databases is added advantage.
Other Requirements
Technical Requirements (MSSQL)
- Strong expertise in Microsoft SQL Server (MSSQL) administration (2012–2022 versions).
- Hands-on experience with Azure IaaS & PaaS services, including:
- Azure Virtual Machines (SQL on IaaS)
- Azure SQL Database
- Azure SQL Managed Instance
- Proficient in installation, configuration, patching, upgrade, and maintenance of MSSQL environments.
- Experience in High Availability (HA) & Disaster Recovery (DR):
- Always On Availability Groups
- Failover Cluster Instances (FCI)
- Log Shipping, Replication
- Knowledge of Azure Backup, Azure Site Recovery (ASR), and DR drills.
- Strong expertise in performance tuning and query optimization.
- Experience with database monitoring tools (Azure Monitor, Log Analytics, SQL Profiler, DMVs).
- Ability to design, implement, and maintain database architecture and standards.
- Hands-on with security implementation:
- TDE (Transparent Data Encryption)
- Always Encrypted
- Role-based access control (RBAC
- Experience in capacity planning, storage management, and performance management.
- Proficiency in automation using PowerShell, T-SQL scripts, or Azure Automation.
- Ability to perform database migrations (on-prem → Azure, cross-platform migrations).
- Experience in backup and recovery strategy design and validation.
- Knowledge of Redis is an added advantage.