Sodagar Ali personal email
- Valid
- Valid
15+ Years of IT Experience as an Oracle DBA in a Linux environment. As a Database Administrator (DBA), I am responsible for managing and maintaining the organization's databases to ensure optimal performance, availability, and data integrity. I am working closely with development teams, system administrators, and other stakeholders to design, implement, and support database systems. My role involving tasks such as database installation, configuration, security, backup and recovery, performance tuning, and troubleshooting.- Good understanding of Linux Administration with respect to supporting oracle database- Proficient in shell scripting and job scheduling- Expertise in Production Oracle 19c environments including PL/SQL, OEM, RMAN, Data Guard- Expertise with Loading data using sql* Loader / Data Pump utilities- Expertise in Oracle database performance tuning and troubleshooting- Strong experience in Backup and Recovery of large databases from RMAN online backups- Working knowledge of Tablespace Encryption and Oracle Advanced security tools- Proficient with using sqldeveloper / TOAD and Grid control tools- Create and manage database objects, including tables, indexes, views, procedures and triggers- Implement and manage database security measures, including user authentication, authorization, and role-based access controls- Monitor and audit database activities to detect and mitigate potential security breaches- Perform regular backups and implement disaster recovery strategies to protect data against loss or corruption- Develop and implement backup and recovery strategies to ensure data availability- Perform regular database backups and validate restoration processes- Conduct periodic disaster recovery drills to test and refine recovery procedures- Monitor database performance and identify opportunities for optimization- Analyze query execution plans, index usage, and system resource utilization to improve query performance- Tune database parameters and configurations for optimal performance- Implement and maintain database monitoring tools to proactively identify performance bottlenecks- Diagnose and resolve database-related issues with quick response- Maintain accurate and up-to-date documentation of database configurations, procedures, and guidelines- Document troubleshooting procedures and resolutions for future reference- Stay up-to-date with the latest database technologies, trends, and best practices- Participate in database-related projects and initiatives, such as upgrades or migrations
Government Of Punjab
View- Website:
- irrigation.punjab.gov.pk
- Employees:
- 560
-
System Software ManagerGovernment Of PunjabLahore, Pk -
Database AdministratorPunjab Public Service Commission (Ppsc) Aug 2014 - PresentLahore, Punjab, PakistanOracle DBA Responsibilities:- Install, configure, and upgrade Oracle database software.- Monitor and optimize Oracle database performance.- Design and implement HA and DR solutions using Oracle RAC and Data Guard.- Develop Real Time Monitoring System (dash board) health check Oracle databases.- Troubleshoot and resolve Oracle database issues.- Automate tasks using Shell scripting.- Perform security assessments and implement necessary security measures.- Managing online backups of servers, testing, validating and storing to keep historical Data safe- Automate Oracle Data-guard Switchover/Failover, using Shell Scripting- Managing 24x7 Database servers using oracle 12c R1 RAC and Data-guard- Installing, Configuring, patching, upgrading and migrating live DB servers with minimal Downtime.- Managing online backups of servers, testing, validating and storing on tape to keep historical Data safe.- DR setup for all critical application, performed switch-over to test DR- Cross-Platform database migration from Windows Server to RHEL Server.- Database upgrades and migrations.- Have experience in data Extraction, Loading and Transformation.- Govern the development, including operational procedures of the IT infrastructure services- Install, Configure and Administer Oracle Cluster-ware / Grid Infra Structure- Plane and Configure RMAN backups. - Migrated MS SQL Server 2016 on Windows Server 2012 to Oracle 12C on RHEL 7 using Oracle GoldenGate.- Helping Developers in develop and tuning custom forms and reports.- Automate Oracle Data-guard Switchover/Failover, using Shell Scripting.- Providing high availability solutions to business by deploying Data GuardRHEL Server Administration Responsibilities:- Install and configure RHEL Server on Dell Server machine.- Run commands and view shell environments.- Configure remote access using VNC and Putty.- Automate tasks using Shell scripting with crontab.- View and analysis logs to resolve warning and errors. -
Database AdministratorPsshmc (Govt. Of The Punjab) Sep 2009 - May 2014LahoarePSSHMC (Govt. Of The Punjab) is an institution to manage social security hospitals in Punjab. It helped transform the medical facilities to the industrial workers to an excellent level. HMIS(Hospital Management Information System) is an Enterprise Application developed using Oracle tools and technologies. The HMIS in two Hospitals is being implemented for last three years and is very mature, effective and giving excellent results. I am responsible for the smooth operational activities of HMIS in different department of Hospital.Day today support, capacity planning and performance tuning for Oracle Databases.Backup and Recovery Administration.Govern the development, including operational procedures of the IT infrastructure servicesProviding advice and leadership regarding the development and improvement of IT servicesInstall, Configure and Administer Oracle Cluster-ware / Grid Infra StructurePlane and Configure RMAN backups. End to end Configuration, Management and Maintenance Replication using Oracle Streams.Helping Developers in develop and tuning custom forms and reports.Automate Oracle Data-guard Switchover/Failover, using Shell Scripting.Data Center Management.Providing high availability solutions to business by deploying Data Guard refining operating procedures to enable switchovers and failovers in less than the agreed SLA of 5 minutes for key business systems.
-
Assistant Database AdministratorPunjab Transport Company Mar 2007 - Sep 2009Lahore, Punjab, PakistanDuties and Responsibilities : Responsible for ensuring availability and performance of the databases that support the system at region level, Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues. To ensure the Implementation and monitoring of the database backup policies. Configuration, monitoring and troubleshooting of production and standby databases at NSCs. Monitor the Data Replication of online sites of his region. Monitor the database growth and system utilization, trend analysis and predicting future database resource requirements. Install and configure standby on Oracle Standard Edition. Install and configure application server Tomcat 5. Analysing daily Cron jobs on production for extracting data from different environments and load that data to different environments. Writing shell script for automating different jobs, checking availability of listener agent control and database. Import and export old archives and then retransform it to again export dump using data pump. Collecting statistics for database objects daily and weekly basis. Shell scripts for different database recovery purposes. Deploying Oracle 10g Data-Guard on a Red-Hat Linux v5. Backup & recovery using RMAN with command mode & Enterprise manager.
Sodagar Ali Skills
Sodagar Ali Education Details
Frequently Asked Questions about Sodagar Ali
What company does Sodagar Ali work for?
Sodagar Ali works for Government Of Punjab
What is Sodagar Ali's role at the current company?
Sodagar Ali's current role is System Software Manager.
What is Sodagar Ali's email address?
Sodagar Ali's email address is so****@****ail.com
What schools did Sodagar Ali attend?
Sodagar Ali attended University Of The Punjab, Lahore.
What skills is Sodagar Ali known for?
Sodagar Ali has skills like Oracle, Sqlplus.
Not the Sodagar Ali you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial