About me
I am proficient database design, application development, query optimization in both Oracle and PostgreSQL . Skilled in SQL/PL-SQL programming for effective query optimization. Hands-on experience in managing databases, performing backups, and executing recovery operations. In Oracle, specialized in PL/SQL programming, database design, query optimization, Oracle Data Guard, and Real Application Clusters (RAC) configuration. Similarly, excelling in PostgreSQL with query optimization, high availability, and backup/recovery operations specific to PostgreSQL databases. Additionally, advanced skills in geodatabase administration.
STRENGTHS AND EXPERTISE
-
Experience in Linux system administration, bash Shell scripting, including crontab usage and automation.
-
Skill in managing high availability with PostgreSQL, including tools like HAProxy, etcd, and Patroni.
-
Well-versed in Oracle Real Application Clusters (RAC) architecture and management.
-
Hands-on experience in Oracle Recovery Manager (RMAN) for backup and data recovery operations.
-
Proficiency in various network protocols, including TCP, FTP, SMTP, HTTP, and HTTPS, and knowledge in network administration.
-
Worked with virtualization technologies like VirtualBox and VMware.
-
Proficiency in programming languages such as Python, C, Java, and web technologies.
-
Experience in geodatabase design and implementation in both Oracle and PostgreSQL, integrating spatial and non-spatial data, and geospatial data modeling and indexing.