Database Administrator and Oracle/Exadata/MS SQL Server / Cassandra certified with over 14 years of IT experience. Technical strengths in the area of Oracle/MySQL/MS SQL Server/Cassandra Database Administrator committed team player with excellent written and verbal communication skills.
• Managing 24/7 Live databases.
• Migration Database on-Premises to RDS cloud.
• Setup Mongo DB three node replica set
• SQL Server Installation, configuration with Microsoft best practices
• Implemented Always-On High Availability configuration on SQL Server database instance (s)
• Implement SQL Server Clustering
• Implement SQL Server log shipping
• Windows Failover Cluster (WFC) Management
• Experience with Performance Tuning / Index Management & maintenance
• Implemented backup and disaster recovery solution as per business requirements
• Manage DBA team deploy on different clients.
· Responsible for management of large size of Oracle databases running on Exadata· Working on Exadata X4-2, included half and quarter rack.· Migration oracle database from different platform· Coordinate with Oracle support for early resolution of issues· Manage oracle database team deploy on different clients.
· Responsible for management of large size instances of Oracle databases.· Responsible for performance management and optimization of live oracle databases.· Accountable for capacity and resource planning from operational perspective.· Conduct backups and restoration of backups.· Configure and Manage Oracle streams,Data Guard, Real Application cluster (RAC) and ASM environment.· Upgrade databases from 11g to 12c,18c· Configure and Manage MYSQL cluster and standalone database.· Coordinate with Oracle support and vendors for early resolution of issues.
· Responsible for management of large size instances of Oracle databases· Responsible for performance management and optimization of live oracle database· Accountable for capacity and resource planning from operational perspective· Conduct backups and restoration of backups.· Manage & administer Oracle streams, Data Guard and ASM environment.· oordinate with Oracle support and vendors for early resolution of issues.
· Implement Schema level replication through Oracle Golden Gate· Configure Oracle Steaming for table level replication.· Configure Oracle Active Data guard on Linux environment· Identify Oracle and MS SQL Server long running Quires/Store Procedures.· Import Export Oracle Database Schema through Data Pump.· Enable MS SQL Server log shipping· Optimization of Complex queries/ procedures/ functions (Oracle/ MS SQL)· R&D for optimal database solutions· Performance Troubleshooting of offshore client’s DB Servers [Mercedes, BMW, Nissan, etc]· SQL Server Administration (2008, 2012)
· Oracle software installation.· Configure Oracle 10g Data Guard.· Write and execute SQL statement against database and its objects.· Performing backup and recovery.· Supervise the automation (Punjab Gateway Project) of Higher Education Department Punjab.· Focal Person/Master Trainer of Bio Metric Attendance system and online admission system of Higher Education Department Punjab.
· Oracle software installation.· Managing tablespaces, data files, redo logs, tables and its segments.· Write and execute SQL statement against database and its objects.· Performing backup and recovery.· Import and Export Data using oracle utility.· Controlling and monitoring user access to the database.· Configuration network local naming and host naming Services.· Unload data from oracle tables using Procedure and batch file.· Configuration network local naming and host naming Services.· Monitring Application (TRACER local application) Services.