Oracle and MS SQL Database Administrator

Job Title : Oracle and MS SQL Database Administrator

Functional Area : SAP Operations & Enterprise Analytics

Duration : 24 months Contract

Work type : Hybrid

Project Description :

• Expertise in Oracle and MS SQL (3 to 5 years) is required for this role.
• The successful candidate will be responsible for managing, configuring, and optimizing Oracle and MS SQL databases, ensuring high availability, and providing support for related systems.

Mandatory Education :

• Microsoft Certified Professional or equivalent
• Oracle Certified Professional or equivalent

Desired Education :

• 2 to 4 years of formal education (technical school or university) in a related field

Mandatory Experience :

• Projects and support that include Microsoft Server, Azure, and related products from a system administration perspective. This includes the following :
• Proficiency in VMware
• Proficiency in Azure and Windows Administration
• Technical Documentation : Ability to create technical documentation and user guides for new systems or updates.
• Security Management : Ensuring the security of systems by setting up and managing permissions.

Desired Experience :

• Database Installation and Configuration : Experience in installing and configuring Oracle and MS SQL databases on various operating systems. This includes setting up database instances, configuring network connectivity, and ensuring optimal performance through proper configuration settings.
• Performance Tuning and Optimization : Proficiency in monitoring and optimizing database performance, analyzing performance metrics, identifying bottlenecks, and implementing tuning techniques to enhance database efficiency.
• Backup and Recovery : Expertise in implementing and managing backup and recovery strategies to ensure data integrity and availability. This includes configuring backup schedules, performing regular backups, and executing recovery procedures in case of data loss or corruption.
• Security Management : Knowledge of database security best practices, including user authentication, authorization, and encryption. This involves configuring security settings, managing user roles and permissions, and ensuring compliance with security standards.
• Database Migration and Upgrades : Experience in planning and executing database migrations and upgrades. This includes migrating databases between different versions or platforms and upgrading database software to newer versions while minimizing downtime and ensuring data integrity.
• High Availability and Disaster Recovery : Knowledge of high availability (HA) and disaster recovery (DR) solutions for Oracle and MS SQL databases. This includes configuring and managing technologies such as Oracle Data Guard and Oracle Real Application Clusters.

Expected Deliverables :

• Backup and Recovery Plans : Create and maintain comprehensive backup and recovery strategies to ensure data integrity and availability. Regular backups are scheduled and monitored to prevent data loss and ensure quick recovery in case of failures.
• Performance Tuning Reports : Analyze and optimize database performance. The DBA will identify bottlenecks, implement tuning techniques, and provide detailed reports on the performance improvements achieved.
• Security Configuration Standards : Implement and maintain security measures to protect the database from unauthorized access and threats. This includes configuring user authentication, authorization, and encryption settings.
• Database Health Checks and Monitoring : Conduct regular health checks and monitoring to ensure the database is running smoothly. This includes checking for any issues, monitoring system performance, and generating reports on the overall health of the database.