Oracle DBA

Job Role: Oracle DBA

Job Location: Singapore

Experience: 2+ Yrs

Job description for Oracle DBA

• Minimum 2+ years of hands-on experience as a DBA
• Strong experience working with Oracle Database and at least one additional RDBMS.
• 
  

• Extensive experience with:
• Oracle RAC and Oracle Data Guard (mandatory)
• Oracle database installation, administration, and troubleshooting
• Performance tuning and optimization of database-driven applications
• Backup, restore, and recovery strategies
• Clustering, database mirroring, and replication technologies
• Deep architectural understanding of Oracle Database engines
• Proficiency in database development, including:
• Functions, procedures, stored procedures, and triggers
• Strong operating system knowledge with hands-on experience in:
• Linux (RedHat, Fedora, CentOS)
• Windows Server
• Proven ability to detect and troubleshoot Oracle server resource contention, including:
• CPU, memory, I/O, disk space, and system-level performance issues

• Experience with large-scale OLAP systems
• Exposure to data warehousing concepts, including star schema modeling

• Design, implement, and manage robust database administration solutions, including:
• Resource management, security, backup & recovery
• Performance monitoring, tuning, and optimization
• Data management, capacity planning, multi-threading, and parallel processing
• High availability and disaster recovery, including failover between database instances
• Provide architectural oversight for all database-related implementations, enhancements, and changes across supported environments.
• Participate in and support internal and client-initiated audits, periodic reviews, and delivery assurance activities by providing recommendations and technical guidance.
• Drive automation initiatives across the database lifecyclefrom design and development to deployment and operations.
• Create and maintain comprehensive technical documentation, including architecture diagrams, operational procedures, and implementation plans.
• Act as a technical mentor, sharing domain knowledge and providing cross-training to peers and team members.
• Collaborate closely with development teams to:
• Tune complex SQL queries
• Optimize database schemas
• Improve overall application performance
• Play a key role in new database implementation projects, including:
• Preparing detailed pre-implementation plans
• Supporting internal and external deployments alongside implementation teams
• Independently analyze, troubleshoot, and resolve critical production issues in real time, delivering end-to-end problem resolution.
• Apply advanced data modeling techniques to ensure integration, scalability, and performance requirements are met.