Senior Database Administrator
Afiniti
Total des années d'expérience :10 years, 11 Mois
• Provision and supporting MySQL instances, both in clustered and non-clustered configurations in production and archival system.
• upgrade, backup, recovery, migration, portioning, optimization, archiving of Databases.
• Supporting Production, Archival, Innodb Clustering and Reporting database system of different technologies.(Oracle, MySQL + Greenplum) in Linux/Window environment.
• Responsible for managing high performing databases including end user activity pertaining to the design, development, testing and implementation of database services.
• Proactive monitoring of database to establish a secure service with minimum downtime and resolution within SLAs.
• Performa database backup (both logical and physical), manual and scheduled.
• Master slave replication configuration and troubleshooting.
• Provided technical assistance on installation and maintenance of database software components and related upgrades.
• Data archiving and purging as per policy for space management.
• Managing Database related alerts and escalations.
• Perform database installation, configuration, upgrade and patching.
• Queries optimization, catching locking/blocking and fix.
• Database Performance tuning.
• Create users, roles policies and procedure and data archiving asp SOP’s to ensure effective protection and integrity.
Database Administration
Installation & configuration of Oracle 12c database server on Windows 2k12 OS platform.
perform both database and operating system performance tuning and monitoring
Manage schedule and manual backups both Hot and Cold and check its validity by restoring
Test environment.
Implement and maintain database security (create and maintain users and roles, assign privileges)
Patch Management and Version Control
handle multiple databases and applications
Monitoring the database server to identify any Performance issues or bottlenecks.
Troubleshoot day-to-day database issues to ensure system availability.
Databases replica creation and configuration for new location;
Creation of user, role, privilege, profile Management as per the requirement.
Data transfer via Replication process from master to slave and backward replication and trouble shoot in case of any errors.
Data integration while processing replication process.
Application support
Create, configured and maintain Web Logic server on server 2k12.
Oracle Fusion Middleware Repository creation and configuration as per application requirements.
Resolve IT application-related incidents, service requests and problems in a timely and efficient manner in line with Business requirements
Employ appropriate application maintenance, support and incident management processes and procedures to support and maintain IT applications, and to investigate and resolve IT application-related incidents.
As required, provide timely communication to users on the status of their service requests and incidents.
As necessary, liaise with IT suppliers to ensure IT application-related incidents and problems are resolved in a timely and professional manner.
Maintain IT application support technical documentation.
Ensure Technical Change Controls are developed, tested & released according to an agreed schedule and ensure all high business impact changes are escalated as appropriate
Ensure all the Incidents and Service requests are addressed within the SLA.
Regression and Unit testing
Creation of test case scenarios of new developments made
Work with the Business/System Analysts to review and impact new business requirements.
Implement, test and monitor required IT application changes in line with change implementation plans.
Ensure IT application changes meet the agreed service acceptance criteria.
Creation of DR server.
Installation, Configuration of supporting software’s as a pre-requisite for oracle server Forms&Reoprts and web logic.
Application configuration, regression and Unit testing
Perform general technical trouble shooting and give consultation to development teams
Patch Management and Version Control
Leading IT team (5 members).
Co-ordination with vendors globally.
Deployment of each module in application and database process under SOX controls.
Incident management using portal TechDeck online and Cherwell.
a) Ensure 100% SLA and PLA compliance
b) Responsible for driving all P1, P2, incidents, change requests and Service request
c) Mangaging Service Request, Changge Request,
IT Administrator, ERP Application support/IT Analyst (CSH -Centeral Security Hospital) KSA
1. Supporting ERP(Hospital management system).
a. Application Implementation and maintenance.
b. Patches inhalation.
c. SQL server 2008 installation.
d. New user training and registration.
e. Assign role to users.
f. User and Management feedback,
g. Analyzing new requirements.
2. Co-ordination with development teams Remotely Support for all Sites.
3. Supporting Application.
a. Client Connectivity/ Installing new system.
b. New user training and registration.
c. Assign role to users.
d. User and Management feedback,
e. Analyzing new requirements.
4. Co-ordination with development teams
a. through IP VPN
b. Team Viewer.
5. 100 Users(Approximately).
6. Manage Biometric Attendance System.
a. Create New User in Basma.
b. Monthly attendance preparation.
c. Trouble shooting.
d. Manage the database and connectivity.
7. Complete IT Support including Printers, Scanners, Photocopier Machine.
a. Desktop + Laptop installation and TS.
b. Acronics Image.
c. Network printer/ Scanner installation and user access.
d. Dot-matrix printer.
e. Datacard Card printer.
8. Co-ordination with IT Vendors.
a. Co-ordination with Service provider.
b. Co-ordination with suppliers.
c. Purchasing new IT equipments.
Computer Science, Programming. Database. Networking. Development of Inventory control system