Database Administration: Manage, configure, and maintain Oracle databases, ensuring high availability, security, and performance.
Performance Tuning & Optimization: Work on performance tuning of queries, indexing, and database optimizations to ensure fast and efficient data access.
Backup & Recovery: Develop and maintain robust backup, recovery, and disaster recovery strategies.
Data Warehousing Support: Provide expertise in data warehousing technologies, especially with experience in platform like Vertica.
Capacity Planning & Scaling: Monitor database growth and assist with scaling strategies, ensuring databases can handle growing data volumes and meet business requirements.
SQL Query Optimization: Design and implement best practices for SQL queries to optimize performance and reduce system load.
Collaborate with Development Teams: Work closely with development teams to design database structures and improve database architecture.
Automation: Automate repetitive tasks and improve operational efficiency for database maintenance and monitoring.
Data Integrity & Security: Ensure data integrity, data migration, and manage database security policies, including user access and encryption.
Documentation & Best Practices: Maintain comprehensive documentation for all database management procedures, policies, and system configurations.
Troubleshooting & Support: Provide timely support and troubleshooting to resolve database issues, ensuring minimal disruption to business operations.