The Database SQL/Oracle Expert is responsible for managing and optimizing SQL and Oracle database systems within the organization. This role involves designing, implementing, and maintaining database solutions, ensuring data integrity, availability, and performance. The expert will provide technical expertise, support database-related projects, and collaborate with development teams to enhance database functionality.
Key Responsibilities:
Database Management:
• Design, implement, and maintain SQL and Oracle database systems.
• Ensure database schemas, tables, indexes, and queries are optimized for performance and scalability.
• Monitor database performance and troubleshoot issues such as slow queries, locking, and connectivity problems.
• Implement database security measures, including user access controls, data encryption, and auditing.
Performance Tuning and Optimization:
• Conduct database performance tuning and optimization to improve query performance and overall system efficiency.
• Analyze and resolve performance bottlenecks using performance monitoring tools and techniques.
• Implement best practices for database design, indexing, and query optimization.
Backup and Recovery:
• Develop and implement database backup and recovery strategies to ensure data availability and disaster recovery readiness.
• Perform regular backups, test restore procedures, and maintain backup integrity.
• Monitor and manage database replication and synchronization processes.
Database Security:
• Ensure database security policies and procedures are implemented and adhered to.
• Monitor database access and activity logs for unauthorized access attempts or security breaches.
• Implement data encryption and masking techniques to protect sensitive data.
Technical Support and Troubleshooting:
• Provide technical support and troubleshooting for database-related issues.
• Collaborate with development teams to optimize database usage in applications.
• Investigate and resolve database-related incidents and service requests in a timely manner.
Documentation and Training:
• Document database architectures, configurations, procedures, and best practices.
• Provide training and knowledge transfer to other team members on database technologies and best practices.
• Develop and maintain technical documentation for database systems and processes.