Officer (Apps / Database Administrator) for Public Sector Organization in Lahore
Ncbms
Published Date: • Lahore, Pakistan (On-Site)
Description
This role demands a thorough understanding of database architecture, system capacity planning, and performance tuning across multiple platforms including Linux, AIX, and Oracle Exadata. The candidate manages installation, migration, and upgrades of database servers and application servers, ensuring seamless execution of change requests from the development team. Strong analytical abilities and team collaboration are vital in troubleshooting, documentation, and maintaining a secure and efficient database environment. Candidates should have hands-on experience upgrading Oracle databases from versions 11g/12c to 19c and administering enterprise-level applications such as Oracle ERP and CC&B. Certification in Oracle Database administration is preferred, supporting the candidate's expertise in database and application server management.
Responsibilities
- Proactively monitor database and application server systems to ensure security and minimal downtime.
- Install, upgrade, migrate, and configure Oracle and SQL Server databases and application servers.
- Manage backup and recovery operations including RMAN, cold backups, and hot backups to maintain data integrity.
- Implement and administer high availability solutions such as Golden Gate and Data Guard.
- Perform database cloning, patching, and troubleshooting to resolve bugs and performance issues.
- Collaborate with hardware teams to allocate and optimize hardware resources for databases and application servers.
- Ensure 24x7 availability and optimal performance of test, UAT, and production databases and application servers.
- Oversee the rollout and implementation of database and application server updates and change requests from the development team.
- Design system architecture with strong focus on security, scalability, and disaster recovery capabilities.
- Conduct capacity planning, system health checks, patching, and continuous performance monitoring.
- Document and present technical information effectively using Microsoft Office tools.
- Escalate complex issues to Oracle Development team or other third-party support as necessary.
- Maintain deep understanding of database concepts to support high-quality administration and troubleshooting activities.
- Support cross-functional team collaboration to improve database administration standards and practices.
Experience
2 Years
Apply By
Required Skills
- Oracle Exadata
- Disaster Recovery Planning
- Change Management
- Database Security Management
- Performance Tuning
- Backup and Recovery Procedures
- Database Upgrade
- Oracle Database Administration
- AIX
- Linux
- Database Patching
- Database Cloning
- Data Guard
- Golden Gate
- Database Performance
- Database monitoring
- Database recovery
- Database Backups
- Application servers
- SQL Server
Nice to Have Skills
- Oracle Database certification
- Microsoft Office
- Capacity Planning
- System Architecture Design
- Troubleshooting
- Team Collaboration