As a Database Administrator, you will play a crucial role in managing and maintaining the organization’s Oracle and SQL database systems. Your responsibilities will span database design, implementation, performance optimization, security, backups, disaster recovery, issue troubleshooting, and collaboration with cross-functional teams.
Key Responsibilities:
- Develop and implement databases based on organizational requirements, ensuring efficient data storage, retrieval, and integrity.
- Optimize database performance through tuning, indexing, and query optimization to enhance system efficiency.
- Develop and implement backup and disaster recovery plans to ensure data integrity and availability without hindering performance.
- Regularly monitor and maintain databases, including data cleaning and archiving to manage storage and improve performance.
- Implement monitoring systems to track database performance metrics and configure alerts for potential issues.
- Diagnose and resolve database-related issues, collaborating with development and DevOps teams to address performance bottlenecks and challenges.
- Implement and maintain database security protocols, access controls, and data encryption to protect sensitive information, ensuring compliance with regulations and organization’s security policies.
- Manage database software upgrades, apply patches, and ensure compatibility with other systems.
- Estimate future data growth and plan for hardware and software requirements to ensure the scalability of database systems.
- Maintain comprehensive documentation of database architectures, configurations, and processes.
Required Skills/Competencies:
-
- Excellent communication skills.
- Strong problem-solving skills.
- Proficiency in Oracle and SQL.
- Strong SQL, PL/SQL, and performance tuning skills.
- Minimum 5 years of experience working with Oracle and SQL databases.
- Knowledge of database security principles.
- Experience with database monitoring tools and configuring alerts.
- Experience supporting a production environment.
- Experience working with remote teams.
- Familiarity with PowerShell or Python for task automation.
- Familiarity using tools like Git and Jira.
Qualification and Experience:
-
- Bachelor’s degree in computer science, Information Technology, or related field.
- Minimum 5 years of experience in database administration.