Senior DBA

Responsibilities:

• Document daily checks and status updates.
• Develop and update all necessary DB documentation (including checklist, operations manual, and relevant changes to configuration settings) and DR setup.
• Report monthly on database size, DB uptime, and performance.
• Generate ad-hoc non-standard reports for incident/problem investigations, DB capacity planning, or audit purposes.
• Create new DB creations, database network configuration, determine/adhere to guidelines for database structures and file layout, review and enhance scripts and procedures, and manage transaction and redo/archive logs properly.
• Assist in database purging and collaborate with Solutions Team to define the purging policy for each individual system, database re-indexing, and database tuning, if required.
• Review daily log irregularities and follow-up actions.
• Maintain regular database maintenance schedules.
• Monitor performance to discover and detect possible system anomalies that may impact business operations, including system resource usage, CPU utilization, Disk I/O, network I/O, memory utilization of database buffers, shared pool, memory cache, inefficient SQL, long-running queries, in-doubt transactions, temporary table space usage, job query analysis, lock and latch analysis, alert log errors, and availability of required start-up services/components for low disk space/archive logs.
• Monitor backups, recovery, and replication for successful completion.
• Data management.
• Monitor object fragmentation, invalid objects, and extent of failure detection.
• Perform Disaster Recovery (DR) for all critical systems and ensure successful rebuilding of Production or DR servers, if necessary.
• Incident detection and confirmation of production database systems, including timely escalation to the Managed Helpdesk, and performing DBA onsite services on physical database facilities to rectify incidents with root cause analysis to ensure permanent resolution.
• Verify and validate database backup, recovery, and replication status.
• Review, improve, and document the database administration and operational guide on new or revised processes and procedures regularly.
• Work with customers/clients, service desk, and third-party solutions vendor to resolve disrupted services and rectify database integrity for users promptly to minimize business impact, including applications undergoing upgrades.
• Assist the Operations and Project Lead on issues related to databases in daily operations or new project implementations.
• Any other ad-hoc duties as required or assigned.

Job Requirements:

• Diploma/Degree in Information Technology, Computer Science, or equivalent.
• 7 - 10 years of experience in Oracle DBA or Microsoft SQL Server.
• Possess hands-on technical experience for L1 - L3 support.