Senior Database Administrator

About Innovan Technologies Private Limited:

Innovan

Fast-forwarding to now, we rapidly grew into a much larger team which helped us to creatine various "Centers of Excellence (COE)" in domains such as Low-Code/No-Code, AI/ML, Generative AI, Integration Platform as a Service (iPaaS), Platform as a Service (PaaS) & Software as a Service (SaaS) while working on multi-cloud architecture and creating hybrid cloud solutions.

Position Summary

We are seeking an experienced Senior Database Administrator (DBA) with a strong background in Oracle, PostgreSQL, and MySQL to join our team. The ideal candidate will be responsible for designing, implementing, managing, and optimizing database systems to ensure high performance, security, and reliability. This role requires deep expertise in database administration, performance tuning, backup/recovery, and high availability solutions.

Essential Job Functions and operations

• Manage and maintain Oracle, PostgreSQL, and MySQL databases across development, testing, and production environments.
• Design and implement backup strategies, disaster recovery plans, and high availability solutions.
• Ensure database resilience and perform regular recovery testing.
• Perform database installations, upgrades, and patches to ensure optimal performance and security.
• Perform database backups, restores, and recovery operations to ensure data protection and continuity.
• Monitor and troubleshoot database performance issues and implement necessary optimizations.
• Analyze and optimize database queries and indexes to improve performance.
• Implement and manage database maintenance tasks, including reorganization and statistics updates.
• Enforce database security policies, user access controls, and encryption mechanisms.
• Ensure compliance with industry standards (GDPR, HIPAA, etc.) and best practices.
• Ensure compliance with industry standards and regulations related to data privacy and security.
• Design and implement database schemas, tables, and relationships to support application requirements.
• Develop and maintain database scripts for automation, data migration, and integration tasks. Develop scripts for automation of administrative tasks, monitoring, and reporting. Utilize tools like Ansible, Shell, or Python for process automation.
• Monitor database usage and capacity and plan for future growth and scaling.
• Implement and manage database partitioning and clustering as needed.
• Maintain comprehensive documentation for database configurations, procedures, and troubleshooting steps.
• Communicate with stakeholders to understand database requirements and provide updates on database health and performance.
• Other duties assigned.

Required Skills and Abilities

• 10+ years of experience with Azure SQL and Oracle databases, database design, performance tuning, and optimization techniques.
• 10 + years of experience in database backup and recovery, including disaster recovery planning.
• Strong problem-solving skills and the ability to troubleshoot complex database issues.
• Excellent communication and interpersonal skills, with the ability to convey technical information to non-technical stakeholders.
• Experience with database monitoring and management tools.

Preferred Qualifications:

• Certifications: Oracle DBA (OCP), PostgreSQL Professional, MySQL DBA Certification.
• Experience with cloud-native database solutions (RDS, Aurora, Cloud SQL).
• Exposure to CI/CD pipelines and DevOps practices.

Financial Responsibilities

• Oversee and manage the technical budget related to architecture and development tools.
• Optimize resource usage to ensure cost-efficiency for database operations.

Education

Bachelor’s degree in computer science, Engineering, or a related field.

Experience and Qualifications

• 10+ years of experience in database administration, with a focus on Azure SQL and Oracle databases.
• Proven track record of managing and optimizing complex database environments.
• Experience with database backup, recovery, and security practices.
• Demonstrated expertise in database performance tuning and capacity planning.