Oracle and MS SQL DBA

Deliverables:

Backup and Recovery Plans: This includes creating and maintaining 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: These reports involve analyzing and optimizing database performance. The DBA identifies bottlenecks, implements tuning techniques, and provides detailed reports on the performance improvements achieved.
Security Configuration Standards: DBAs are responsible for implementing and maintaining 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: Regular health checks and monitoring are conducted 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.

Must Haves:

Setting up database instances, configuring network connectivity, and ensuring optimal performance through proper configuration settings.
Experience with VMware
Experience with Azure and Windows Administration
Ability to create technical documentation and user guides for new systems or updates.
Experience ensuring the security of systems by setting up and managing permissions.
Microsoft Certified Professional or equivalent
Oracle Certified Professional or equivalent

Nice to Haves:

2 to 4 years of formal education (technical school or university)
Performance Tuning and Optimization: Proficiency in monitoring and optimizing database performance. This involves 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, as well as 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, Oracle Real Application Clusters (RAC), SQL Server Always On Availability Groups, and SQL Server Failover Clustering.

Perks: