MD
Oracle Database Administrator
Macpower Digital Assets Edge Private Limited
๐บ๐ธ United States
On-site
5 days ago
- Oracle Database
- Oracle
- Data Architecture
- Change Management
- PL/SQL
- Disaster Recovery
- ETL
- GLBA
- SOX
- SQL
- Unix
- Linux
- Windows
- Data Modeling
- Visio
- .NET
5 days ago
Key Responsibilities:
- Evaluate and implement Oracle patch releases while ensuring seamless deployment.
- Oversee change management across multiple development, test, QA, and production environments.
- Provide24x7 rotational on-call support, conduct root cause analysis (RCA), and participate in weekly operations reviews.
- Implement proactive monitoring and troubleshooting of database-related issues.
- Perform database performance tuning, query optimization, and PL/SQL debugging.
- Support enterprise system enhancements and collaborate with project teams on database solutions.
- Deploy and managehigh availability architectures, includingData Guard, RAC, and hot standby databases.
- Maintain database security, retention policies, and disaster recovery strategies.
- Document database architecture, configurations, and operational procedures.
- Support nightlyETL processing and ensure efficient data flow.
- Conduct capacity planning, resource allocation reviews, and provide regular reports.
- Ensure compliance with corporate security policies and regulatory requirements (PCI, GLBA, SOX).
- Participate in database design decisions, troubleshooting, and optimization processes.
- Bachelor's degree in a relevant technical discipline.
- 8+ years of experience as an Oracle DBA (10g, 11g, 12c).
- Proficiency inRMAN, Data Guard, OEM/Grid Control.
- StrongPL/SQL, SQL tuning, and Unix/Linux shell scripting skills.
- Experience inbackup, recovery, and performance tuning.
- Expertise inhigh availability (RAC, standby databases) & disaster recovery.
- Ability to support a24x7 on-call rotation.
- Knowledge ofWindows and Linux operating systems.
- Strong analytical, troubleshooting, and organizational skills.
- Excellent communication and collaboration abilities.
- Oracle Certified Professional (OCP) certification.
- Experience with OracleStreams or database replication.
- Familiarity withOracle RAC environments, ASM, and encryption/security protocols.
- Knowledge ofdata modeling tools (Oracle Data Modeler, Erwin, Toad, Visio).
- Experience with.NET application support.
Oracle Database Administrator ยท Macpower Digital Assets Edge Private Limited