Senior DBA

Compelling Opportunity for Senior DBA (Contract)
6 Month Contract | Immediate

End Client :

Innovative Entity in Insurance Industry
Role:

Sr. Database Administrator (Contract)
Engagement Model

: 6 Month Contract through 10XTD
Location : Hyderabad, India
Experience:

10+ years of IT experience with a min of 8 Years experience as DB administrator in a reputed organization.
Reports To : Head of IT Infrastructure Operations

Job Summary and Experience : The Database administrator is responsible for the Installation, configuration and Administration of Databases as per the business requirements.

Primary Skills:
• Deep technical proficiency in Database management, including expertise in database design mainly on MSSQL, MySQL and PostgreSQL
• Candidates with experience on working with other open-source non-SQL Databases such as Apache Kafka , Cassandra, MongoDB, etc will be preferred
• Knowledge of server operating systems (Windows & Linux) 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)

Key Responsibilities:
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, Extended Events to solve long running queries, 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 modelling
• Experience in DB migrations (MSSQL to other opensource databases such as PostgreSQL or MongoDB, etc) wherever required

Compliance and Documentation:
• Ensure databases meet compliance standards and industry regulations
• Document database configurations, changes, and troubleshooting procedures
• Other duties as 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

Preferred Certifications and Skills
• Microsoft Certified: Azure Database Administrator Associate
• AWS Certified Database – Specialty

Work Environment:
• May require occasional on-call / weekend availability / work in shifts for database-related emergencies. Ability to work under pressure.
• Collaborate with Primary Functions, System Admins and Developers to provide the right solutions.

Screening Criteria
1. 10+ years of IT experience
2. Min of 8 Year’s experience as DB administrator in a reputed organization.
3. Deep technical proficiency in Database management, including expertise in database design mainly on MSSQL, MySQL and PostgreSQL
4. Experience on working with other open-source non-SQL Databases such as Apache Kafka & Cassandra, MongoDB
5. Knowledge of server operating systems (Windows & Linux) and hardware components
6. Experience in backup/recovery of databases
7. Familiarity with performance tuning and database optimization
8. Understanding of cloud database services (e.g., AWS RDS, Azure SQL Database)
9. Available to work from office in Hyderabad
10. Available to join within 1 week

Considerations
· 6 Month Contract
· Location – Hyderabad
· Working from office
· 5 day working

Interested Profiles,
· Kindly apply

Note
o Additional inputs to be gathered from the candidate to put together the application