Oracle DBA-Onsite-New York City

Oracle DBA

HYBRID

NY CITY

10+ Years PROFILES ONLY

ANY VISA

Project hours: 7hours/day and 35hours/week

Scope of Work:

• Manage and monitor Oracle Exadata Database Machine appliances, including tasks such as smart scans, cell management, and flash cache management.
• Administer, Upgrade databases to 19c version and maintain, and optimize Oracle databases on Exadata machines and Oracle Cloud Infrastructure ExaCS platform, ensuring high performance and availability.
• Administer SQL Server databases, ensuring performance and security.
• Implement and oversee cloud database solutions, particularly in Oracle Cloud Infrastructure environments, including database migration, performance tuning, and cost optimization.
• Configure and manage backup, recovery, and disaster recovery strategies in both Exadata and cloud environments.
• Collaborate with network administrators and IT infrastructure teams to ensure efficient integration of Exadata and cloud databases with other enterprise systems.
• Lead efforts in performance tuning and query optimization for databases running on Exadata and in cloud environments.
• Implement and manage security measures for databases in Exadata and cloud platforms, including encryption, access control, and audit logging.
• Coordinate with Oracle support for Exadata-specific issues and maintain up-to-date knowledge of Oracle's latest offerings and best practices.
• Develop automation scripts to streamline database administration tasks in both Exadata and cloud environments.
• Observability and Management Configure OEM, setting up of alerts and resolving issues.
• Develop and maintain dashboards in Grafana for real-time data visualization.

Requirements:

• Minimum 10 years of experience in Oracle Database Administration, with significant expertise in Exadata environments.
• Minimum 7 years of experience in SQL Server Database Administration.
• Strong experience with Oracle GoldenGate and Exadata Database Machine.
• Proven experience in managing databases in cloud environments, especially OCP and Azure
• Strong knowledge of database backup, recovery, and disaster recovery practices in Exadata and cloud platforms.
• Excellent skills in performance tuning and query optimization for Oracle databases.
• Experience with database security management in Exadata and cloud environments.
• Familiarity with automation and scripting languages for database administration tasks.
• Strong problem-solving abilities and a proactive approach to system optimization.
• Excellent communication skills and the ability to collaborate effectively with cross-functional teams.
• Commitment to continuous learning and staying updated with the latest technologies and best practices in database administration.

Desired skills:

• Conduct regular reviews of the database infrastructure to ensure compliance with industry standards and business requirements.
• Develop and maintain Docker images and containers, integrating them with CI/CD pipelines.
• Create and maintain Jenkins pipelines for continuous integration and delivery.
• Troubleshoot and optimize Oracle EBS environments, including patching, cloning, and upgrades.