Current jobs related to Oracle DBA - O'Fallon - Talent Groups
-
Principal Oracle DBA
7 days ago
O'Fallon, MO, United States MasterCard Full timeAbout the RoleWe are seeking a highly skilled Principal Oracle DBA to join our team. As a key member of our Site Reliability Engineering team, you will be responsible for ensuring the stability, scalability, and visibility of our highly available, mission-critical database systems and applications.You will work closely with our customers to understand their...
Oracle DBA
3 months ago
O'Fallon, United States
Talent Groups
Full time
Required Skills:
- Handled large database estates and managed TB size of databases
- Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers
- Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)Install, configure and manage ASM instances in oracle
- Plan and execute major migrations and upgrades
- Define and configure the disk and diskgroups in ASM and troubleshoot
- Manage and administer the databases on Exadata machine
- Plan the database upgrade, migration and patching
- Plan and implement the backup/recovery on need basis
- Coordinate and work with database vendors for resolution on major incidents
- Database refresh, re-org, backup using RMAN and 3rd party tools
- Install and configure grid control database monitoring tools
- Install, Administer, manage and troubleshoot Oracle grid control
- Define performance benchmarks and metrics
- Periodic database instance performance review and tuning recommendation
- Implement and Periodical check on Automation
- Implement and Periodical check on DB Security
- Write and troubleshoot shell scripting, SQL and PL/SQL scripts
- Technical and Process guidance to L2 and L1 DBA
- Provide 24x7 and on call support for critical application databases
Technical Skills
- Strong database administration
- Database upgrades on multiple versions and releases
- High availability (RAC) setup and administration
- Disaster recovery design, planning, setup and administer the Dataguard (standby)
- Install, configure, maintain and troubleshooting on Golden Gate
- Knowledge on ExaData
- OEM Configuration and management
- Automation through scripting
- Strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views
- Experience on OS, Storage, Network and Virtualization activities
- Certification on Primary Technology
- Handled database estate of various technologies
Process & Tools
- Service Request and Incident, Problem, Change managements
- Configuration, Capacity planning and Knowledge management
- Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool
- Identify the service improvement plan
Secondary Skill
- OS- Solaris/Linux/AIX/HP UNIX & Windows
- Database - MySQL/MS SQL & Windows OS / Sybase /DB2 / PostgreSQL/MongoDB/SAP HANA