Senior Database Administrator

The core responsibilities for the job include the following:
Database Management:
Install, configure, and upgrade database software and tools.
Monitor database performance and perform regular tuning.
Configure and manage automation of tasks.
Create and finetune databases as per the requirements of Internal stakeholders (product development / primary functions) / Insurers.
Data Integrity and Availability:
Ensure high availability of databases and minimize downtime.
Manage data replication and mirroring as needed.
Plan and configure a high availability and disaster recovery (HA/DR) environment.
Data Security:
Implement data security policies to safeguard sensitive information.
Conduct regular backups and disaster recovery planning.
Performance Optimization:
Monitor and optimize the performance of database systems.
Resolve performance bottlenecks and improve query efficiency.
Using DMVs, SQL Profiler, and Extended Events to solve long-running queries and performance issues.
User Access and Roles:
Define and manage user roles, permissions, and access levels.
Address issues related to data access and connectivity.
Database Design and Development:
Collaborate with developers to design and implement efficient database solutions.
Assist in database schema design and data modeling.
Experience in DB migrations (MSSQL to other open-source databases such as PostgreSQL, MongoDB, etc. ) wherever required.
Compliance and Documentation:
Ensure databases meet compliance standards and industry regulations.
Document database configurations, changes, and troubleshooting procedures.
Other duties are assigned by Head of IT Infrastructure from time to time.
Incident Management:
Respond to and resolve database-related incidents and service requests as per the defined SLA.
Conduct root cause analysis for recurring issues and apply permanent fixes.
Requirements:
Deep technical proficiency in Database management, including expertise in database design mainly in MSSQL, MySQL, and PostgreSQL.
Candidates with experience working with other open-source non-SQL Databases such as Apache Kafka, Cassandra, MongoDB, etc., will be preferred.
Knowledge of server operating systems and hardware components.
Effective Troubleshooting, communication, and problem-solving abilities.
Experience in backup/recovery of databases.
Familiarity with performance tuning and database optimization.
Understanding of cloud database services (e. g., AWS RDS, Azure SQL Database).
Excellent work experience in MSSQL administration, fine-tuning of DB, and DB Security aspects (Encryption, etc).
Work experience of implementing HA and DR solutions in both MSSQL and Postgres / Open-source Databases.
Work experience migrating MSSQL to Postgres or other open-source Databases.
Ready to work from the office (5 days a week) and, if required, during weekends.
Preferred Certifications and Skills:
Microsoft Certified: Azure Database Administrator Associate.
AWS Certified Database - Specialty.

Experience
8-12 yrs