Role Overview
We are seeking a skilled and experienced Database Administrator to join our team. The Database Administrator will be responsible for the performance, integrity, and security of our databases, ensuring optimal functionality and data availability. The ideal candidate will have a strong background in database management systems and a proven track record of maintaining and optimizing complex databases.
ROLE COMPETENCIES & ACTIVITIES
- Install, configure, and maintain database management systems (DBMS), including but not limited to Oracle, SQL Server, MySQL, and PostgreSQL.
- Design and implement database schemas, tables, views, indexes, and stored procedures to support application requirements and optimize performance.
- Develop and maintain logical and physical data models, ensuring data integrity, normalization, and efficiency.
- Monitor database performance, identify bottlenecks, and optimize SQL queries, database parameters, and server configurations for improved performance.
- Implement and maintain backup and recovery strategies, including regular backups, database mirroring, replication, and disaster recovery plans.
- Implement and enforce security policies and access controls to protect sensitive data, including user authentication, authorization, and encryption mechanisms.
- Monitor database health and performance using monitoring tools and proactively address issues to minimize downtime and ensure availability.
- Forecast future database capacity requirements based on data growth trends and application demands, and plan and implement scaling strategies accordingly.
- Apply database patches, updates, and upgrades in a timely manner to ensure system stability, security, and compliance.
- Maintain comprehensive documentation of database configurations, schemas, processes, and procedures for reference and audit purposes.
- Perform regular audits and reviews of database configurations and access controls to ensure compliance with industry regulations and organizational policies.
- Develop and maintain disaster recovery plans and procedures to minimize data loss and downtime in the event of system failures or disasters.
- Identify opportunities for automation in database administration tasks and develop scripts and tools to streamline routine processes.
- Collaborate with developers, system administrators, and other stakeholders to troubleshoot database-related issues and implement solutions
Experience & Qualifications
Knowledge, Skills and Experience
- Strong understanding of database design principles, normalization, and data modeling techniques.
- In-depth knowledge of database performance tuning, query optimization, and troubleshooting methodologies.
- Experience with database security concepts, including user authentication, authorization, and encryption.
- Familiarity with backup and recovery strategies, disaster recovery planning, and high availability solutions.
- Excellent analytical and problem-solving skills, with the ability to diagnose and resolve complex database issues.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
- Certification in relevant database technologies (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator) is a plus. .
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Proven experience as a Database Administrator, with a minimum of [15 years] of hands-on experience managing enterprise-level databases.
- Proficiency in database management systems such as Oracle, SQL Server, MySQL, IRIS , or PostgreSQL.
