Job Description:
• Experience with Oracle database design, implementation, and maintenance.
• Provides technical support to application development teams and assists with impact analysis of changes due to development, testing, and production usage.
• Good knowledge of operating systems, physical database design, Oracle tools, code migration, database changes and data and menus through the various stages of the development life cycle.
• Alert and performance troubleshooting
• Security Management (new users, user audits etc.) and password resets
• Space Management (monitoring tablespace and datafile space needs etc.)
• Database upgrade and software patch management
• Audit support and mitigations
• Database assessment, optimization, and documentation of outcomes and recommendations from assessment
• Development support (code reviews, code refactoring, tuning, data fixes, data refreshes, materialized view etc.)
• Data migrations
• Partitioning (as needed)
• General tasks related to advanced database concepts (e.g., RMAN, queue processing, database parameters, Oracle and SQL server job management, data guard, etc.)