Job Role: Database Administrator
Experience: 11+ Years
Location: Alpharetta, GA (Only Locals)
Skills:
- Expertise in Installation, Upgrade & Patching of different components in Oracle like -RAC,Data-Guard,RMAN,OEM,ASM,Partitioning etc,. and experience with the other platforms we manage listed in the Duties and Responsibilities.
- Experience with Replication including setup, troubleshooting issues and failovers - (Goldengate or HVR)
- Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).
- Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security
- Provide data cleansing services, verify data integrity, and implement access controls
- Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management
- Experience with Schema creation, deployment, and maintenance
- Experience with Setting up and configuration of Auditing, audit trails
- Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms
- Should have knowledge of Disaster Recovery setup and maintenance
- Automation using shell-script, python, Ansible, go, etc.
- Performance & Tuning Related Expertise
- Experience with Performance analysis, monitoring of queries and platform specific tuning.