Support and Maintain Oracle EBS (R12.1 & R12.2) and Database Production and Non Production instances.
Troubleshoot and resolve database performance issues, database capacity issues, replication and other distributed data issues.
Assist in analyzing proposed systems and recommending improvements to existing systems.
Participate in releasing database changes, related to application deployments and Monthly maintenance cycles.
Implement data models and database designs, data access and table maintenance codes.
Produce and maintain complete database systems documentation.
Design, implement and maintain databases to support the goals and strategies of the division.
Install and stand up database and maintain operations across divisions.
Excellent knowledge of database backup & recovery, cloning, security and Patching.
Qualifications
Bachelor's Degree in computer discipline or relevant certification.
3 - 5 years of relevant experience.
SQL Server Security: User security best practices Database Encryption Audit Change management.
Database Availability: Understand backup and Recovery Replication AlwaysOn DB Maintenance DB Tuning & Optimization Troubleshooting Oncall
SQL Server Management: Windows OS Monitoring Powershell Storage VM Memory Patching Job Management Extended Events
Data Architect: T-SQL Database creation Database Design SPs
Change Tracking Change Data CaptureJob management
Other DBA Tasks: SSIS SSRS SSAS data imports and extracts
Additional Information
Disclaimer
The information about this job description given above has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.
Full time