HIGH LEVEL JOB DESCRIPTION / SCOPE :
Responsibilities for this position :
Responsible for the delivery of technical specifications, test plans, code & unit testing of technical solutions through the development life cycle.
Ensures all deliverables adhere to Chevron technical standards
Corrects defects found during functional, integration, performance, and user acceptance test cycles.
Ensure adherence to IT Service Management (ITSM) incident and change management processes for application delivery
Implements or modify database table structures, views, indexes and stored procedures, packages and scheduled jobs
Analyze queries for performance improvement opportunities
Be available to monitor scheduled DBA level tasks for Oracle like database migration, patch management, monitoring services and uptime.
Participating in weekly and monthly meeting calls with other teams / remote locations. Able to co-ordinate among the geographically distributed stakeholders like business analyst, development team, quality assurance team and project manager.
Works with Developers, Systems and Business Analysts to gather detailed business requirements, identify preferred solutions, develop functional specifications with the support team, implement, and test new functionality
Balance priorities to ensure both SLAs and project commitments are met.
Knowledgeable with PL / SQL
Scheduling jobs for Space monitoring and Database memory utilization.
Hands-on experience in Oracle Enterprise Manager, DB cloning, commissioning, migrations
SQL Performance tuning and Scheduling Daily Backups.
Familiarity with Oracle Recovery Manger (RMAN) backup, recovery and Oracle Utilities like Export and Import Data pump