Job Role: Oracle DBA
Job Location: Singapore
Experience: 2+ Yrs
Job description for Oracle DBA
Experience- Minimum 2+ years of hands-on experience as a DBA
- Strong experience working with Oracle Database and at least one additional RDBMS.
Technical Skills- 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
Additional Skills (Preferred)- 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.
