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 10 XTD 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, My SQL and Postgre SQL • Candidates with experience on working with other open-source non-SQL Databases such as Apache Kafka , Cassandra, Mongo DB, 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 Postgre SQL or Mongo DB, 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, My SQL and Postgre SQL 4. Experience on working with other open-source non-SQL Databases such as Apache Kafka & Cassandra, Mongo DB 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