Summary
Overview
Work History
Profiles
Timeline
Generic

Surendra Sharma

Muscat,Oman

Summary

  • PL/SQL Developer Profile – Client: SITA, Muscat, Oman - Over 10 years of experience in PL/SQL development with Oracle 11g/12c/19c. - Developed stored procedures, packages, triggers, and functions to implement business logic. - Used TOAD, SQL Developer, SQL
  • Loader, and Explain Plan for tuning. - Performed performance tuning using AWR, ADDM, and TKPROF. - Implemented ETL using PL/SQL and Talend. - Worked on exception handling, query optimization, and error logging. Oracle DBA Profile – Client: SITA, Muscat, Oman - Extensive experience with Oracle RAC, Data Guard, GoldenGate, and RMAN. - Performed upgrades from 11g to 19c, PSU patching, cloning, and OEM monitoring. - Configured Transparent Data Encryption (TDE) and user access controls. - Used OEM Grid Control, AWR, ASH, and ADDM for performance monitoring. - Created and maintained SOPs, backup strategies, and 24x7 support. - Managed storage, partitioning, roles/privileges, and troubleshooting. MS SQL DBA Profile – Client: SITA, Muscat, Oman - Managed MS SQL Server environments including high availability and backups. - Worked on Azure SQL and Amazon RDS for SQL Server, including failover setup. - Implemented security, encryption, and access management policies. - Handled provisioning, performance tuning, and maintenance jobs. - Automated tasks using T-SQL and PowerShell. MongoDB DBA Profile – Client: SITA, Muscat, Oman - Administered MongoDB (Atlas) environments including sharding and replication. - Designed schemas, managed indexes, backups, and access control. - Integrated MongoDB with AWS RDS and Azure environments. - Implemented performance tuning and real-time monitoring solutions. - Ensured data security and availability through DR and backup strategies.

Overview

12
12
years of professional experience

Work History

PL/SQL Developer

SITA
Muscat, Oman
05.2013 - Current
  • Over 12 years of experience in PL/SQL development with Oracle 11g/12c/19c.
  • Developed stored procedures, packages, triggers, and functions to implement business logic.
  • Used TOAD, SQL Developer, SQL
  • Loader, and Explain Plan for tuning.
  • Performed performance tuning using AWR, ADDM, and TKPROF.
  • Implemented ETL using PL/SQL and Talend.
  • Worked on exception handling, query optimization, and error logging.

Oracle DBA

SITA
Muscat, Oman
  • Extensive experience with Oracle RAC, Data Guard, GoldenGate, and RMAN.
  • Performed upgrades from 11g to 19c, PSU patching, cloning, and OEM monitoring.
  • Configured Transparent Data Encryption (TDE) and user access controls.
  • Used OEM Grid Control, AWR, ASH, and ADDM for performance monitoring.
  • Created and maintained SOPs, backup strategies, and 24x7 support.
  • Managed storage, partitioning, roles/privileges, and troubleshooting.

MS SQL DBA

SITA
Muscat, Oman
  • Managed MS SQL Server environments including high availability and backups.
  • Worked on Azure SQL and Amazon RDS for SQL Server, including failover setup.
  • Implemented security, encryption, and access management policies.
  • Handled provisioning, performance tuning, and maintenance jobs.
  • Automated tasks using T-SQL and PowerShell.

MongoDB DBA

SITA
Muscat, Oman
  • Administered MongoDB (Atlas) environments including sharding and replication.
  • Designed schemas, managed indexes, backups, and access control.
  • Integrated MongoDB with AWS RDS and Azure environments.
  • Implemented performance tuning and real-time monitoring solutions.
  • Ensured data security and availability through DR and backup strategies.

Profiles

  • PL/SQL Developer, SITA, Muscat, Oman, Over 10 years of experience in PL/SQL development with Oracle 11g/12c/19c., Developed stored procedures, packages, triggers, and functions to implement business logic., Used TOAD, SQL Developer, SQL
  • Loader, and Explain Plan for tuning., Performed performance tuning using AWR, ADDM, and TKPROF., Implemented ETL using PL/SQL and Talend., Worked on exception handling, query optimization, and error logging.
  • Oracle DBA, SITA, Muscat, Oman, Extensive experience with Oracle RAC, Data Guard, GoldenGate, and RMAN., Performed upgrades from 11g to 19c, PSU patching, cloning, and OEM monitoring., Configured Transparent Data Encryption (TDE) and user access controls., Used OEM Grid Control, AWR, ASH, and ADDM for performance monitoring., Created and maintained SOPs, backup strategies, and 24x7 support., Managed storage, partitioning, roles/privileges, and troubleshooting.
  • MS SQL DBA, SITA, Muscat, Oman, Managed MS SQL Server environments including high availability and backups., Worked on Azure SQL and Amazon RDS for SQL Server, including failover setup., Implemented security, encryption, and access management policies., Handled provisioning, performance tuning, and maintenance jobs., Automated tasks using T-SQL and PowerShell.
  • MongoDB DBA, SITA, Muscat, Oman, Administered MongoDB (Atlas) environments including sharding and replication., Designed schemas, managed indexes, backups, and access control., Integrated MongoDB with AWS RDS and Azure environments., Implemented performance tuning and real-time monitoring solutions., Ensured data security and availability through DR and backup strategies.

Timeline

PL/SQL Developer

SITA
05.2013 - Current

Oracle DBA

SITA

MS SQL DBA

SITA

MongoDB DBA

SITA
Surendra Sharma