Key Responsibilities

• Install, configure, and maintain application databases and related software.
• Monitor database performance and implement tuning and optimization strategies to ensure high availability and responsiveness.
• Manage database security, including access controls, user permissions, and data encryption.
• Develop and implement backup and recovery strategies to safeguard data.
• Perform regular backups and verify the integrity of backup data.
• Execute disaster recovery plans and ensure minimal downtime in case of system failures.
• Monitor and resolve performance issues related to database and application interaction.
• Perform regular maintenance tasks such as data cleanup, index rebuilding, and statistics updating.
• Support database integration and migration tasks, ensuring smooth transitions and minimal disruptions.
• Provide support for application development and deployment, including debugging and resolving database-related errors.
• Assist in the creation and execution of test plans for database changes and upgrades.
• Conduct regular audits and reviews of database security and access controls.
• Evaluate and recommend new tools, technologies, and practices to enhance database management and performance.

Required Experience/Skills

• Experience in the insurance industry is a plus, providing valuable insight into industry-specific data structures and requirements.
• Proficiency in working with large tables and complex joins, ensuring data integrity and optimal query performance.
• Skilled in modeling tables and database structures with a focus on delivering the best query performance and minimizing response times.
• Extensive experience with AWS RDS (Relational Database Service), including managing and optimizing relational database systems in the cloud environment.
• Strong experience in SQL tuning, with a proven ability to analyze and improve query performance to meet business needs.
• Essential knowledge and experience with NoSQL databases, particularly DynamoDB, to support a variety of data storage requirements.
• Familiarity with database security best practices, ensuring compliance with relevant data protection regulations and standards.
• Experience in planning and implementing robust disaster recovery and backup strategies to protect critical data assets.
• Experience with version control systems like Git for managing database schema changes and maintaining version history.
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues and implement effective solutions.
• Experience managing databases across multiple platforms (e.g., Oracle, SQL Server, MySQL) and integrating them into a unified data architecture.

Posted By