Sql Developer Oracle

Sagar Maram

Mobile: +1-437-***-**** Email: ***************.*****@*****.***

SUMMARY

Oracle Database Administrator experienced in various domains such as finance, banking and retail across administration, development, support and build projects. The focus of my career has been in Oracle 10, 11g and 12c RAC Standalone Database Administration, performance tuning, installations, upgrades, configuration and documentation, Operation Support and RMAN Backup and Recovery. I have strong skills in data centre migrations, database troubleshooting, patching, disaster recovery and database hardening. I also specialize in other Oracle tools like Toad, SQL developer and Oracle Enterprise Manager.

I am proficient in applying Oracle Patches (PSU and CPU), Database Tuning and Oracle version upgrades. I am also proficient in supporting Oracle RAC, Oracle Standby databases and Golden Gate configurations and have worked on Data guard and Datapump. Lead a team of 6 members with onsite-offshore model and working with the application development team in providing constructive input design.

SKILLS

Programming Languages : SQL, Shell,

Database : Oracle 9i, 10g, 11gR2,12.1,12.2, 19c

Other tools : Oracle SQL Developer, Toad, SQL plus, OEM

Operating System : Sun Solaris, IBM AIX, Linux

Certifications : Oracle Golden Gate Essentials, Oracle Cloud Architecture Associate

Trainings : Oracle Autonomous Database

PROFESSIONAL EXPERIENCE

Senior Oracle Consultant. May 2021 – Present Client: TD Bank, Toronto

Responsibilities:

Troubleshoot Gird Infrasturcture issues and ASM cluster issues.

Check the status of database for archivelog, tablespace and disk issues.

Performance Tuning from the DB and Query Level

Perform Data Centre migration activities with the use of Oracle tools like Datapump, RMAN or tapes restoration techniques.

Database Backup (Export, Hot backup, RMAN).

Check Cluster status and troubleshoot network issues.

Allocating system storage and planning future storage requirements for database system

MS-SQL activities like backup and troubleshoot user permissions.

Perform Data Centre migration activities with the use of Oracle tools like Datapump, RMAN or tapes restoration techniques.

Altering and reporting experience and MS SQL server

Environment- Sun OS, Red Hat Linux, Oracle 11g, 12c,19c (RAC), OEM, ASM, RMAN

Senior Oracle Consultant. February 2021 – May 2021 Client: BMO, Toronto

Responsibilities:

Monitor and troubleshoot Dataguard environments. Recover standby databases to keep them in-sync with primary databases.

Rebuild of standby databases.

Performance Tuning from the DB and Query Level

Perform Data Centre migration activities with the use of Oracle tools like Datapump, RMAN or tapes restoration techniques.

Database Backup (Export, Hot backup, RMAN).

Perform patching activity for the Goldengate replication setup whenever required.

Document GoldenGate technical steps which needs to be performed for setting up a new configuration.

Allocating system storage and planning future storage requirements for database system

Backup/restore and upgrade of Oracle databases from 12c to 19c on UNIX/Linux with Automatic Storage Management (ASM).

Perform Data Centre migration activities with the use of Oracle tools like Datapump, RMAN or tapes restoration techniques.

Environment- Sun OS, Red Hat Linux, Oracle 11g, 12c (RAC), OEM, ASM, RMAN

Senior Oracle Consultant. March 2019 – July 2020 Client: PNC Bank, Pittsburgh

The project involves Design, Build, Testing, Implementation of Oracle databases. The environment has over 1000 Oracle 11g/12c/19c instances. These databases run high performing critical financial applications (like Online Banking, Wire transfers etc). The databases are complex in nature and have high availability and disaster recovery built into their architecture. Activities includes architecture design, capacity planning, installing database software, backup and recovery, database performance tuning, high availability solutions, implementation and Business Continuity Planning (BCP).

Responsibilities:

Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11g, 12c RAC environments

Adding new table to the existing Goldengate configuration with the use of Specialrun mechanism or Datapump as required.

Perform patching activity for the Goldengate replication setup whenever required.

Document GoldenGate technical steps which needs to be performed for setting up a new configuration.

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.

Backup/restore and upgrade of Oracle databases from 12c to 19c on UNIX/Linux with Automatic Storage Management (ASM).

Perform 12c Installations &19c binary Installations and configure standalone/dataguard databases.

Monitor and troubleshoot dataguard environments. Recover standby databases to keep them in-sync with primary databases.

Perform Data Centre migration activities with the use of Oracle tools like Datapump, RMAN or tapes restoration techniques.

Environment- Sun OS, Red Hat Linux, Oracle 11g, 12c (RAC), OEM, ASM, RMAN

Senior Oracle DBA June 2013 – March 2019 Client: Lloyds Banking Group, United Kingdom.

For this project, database service team is responsible for providing consultative inputs design and lead the Database Support services in Lloyds bank. It involves extensive technical expertise in the area of Database service with wide exposure to various tools and technologies.

Responsibilities:

Responsible routine DBA jobs like Backups and Restores and performing Disaster Recovery testing for Oracle database.

Administration of Oracle APEX tool and troubleshoot in case of any issues in its configuration.

Keep track on the goldengate incidents and troubleshoot in case of any network, trail files issues.

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.

Incident and Problem Resolution. Raising the Service Request and working with Oracle Team

Handling RAC server with ASM and handling ASM space Management

Handling Data guard without archive gap. Monitoring PR and DR Server.

Rebuild of standby databases.

Automate tiny database jobs using shell scripting and PL/SQL programming whenever required.

Installation of 12c binaries and create standalone database as per the requests.

Capacity management for database on needs basis

Research and recommend operating parameters, which may need to modify to ensure availability of system resources

Allocating system storage and planning future storage requirements for database system

Environment- AIX, Red Hat Linux, Oracle 11g, 12c (RAC), OEM, ASM, RMAN

Oracle DBA June 2012 - May 2013 Client: CA Technologies (BROADCOM), Texas.

Responsibilities:

Install Oracle Security Patches to all the databases when released

Perform upgrade and Migration when required.

Process, Schema and Log maintenance and Auditing

Database Backup (Export, OFFLINE and ONLINE backups using RMAN)

Performing Query and DB Level Performance tuning whenever required

Setting and monitoring password file authentication.

Monitoring mirroring of Redo log files/ Control files / Init file on OS level

Maintaining archived data on appropriate storage device

Customization/Maintenance of Init Parameters as peruse / requirement

Created shell scripts to monitor table space size and user actions

Ensuring compliance with Oracle license agreement.

Performed periodic health checks and achieved the databases highest performance

Environment- Sun Solaris 9 &10, AIX, Oracle 10g, Linux

Oracle DBA March 2008- May 2012 Client: T-Systems(T-Mobile), Germany

Responsibilities:

Provided 24x7 supports for 10g Oracle databases

Created primary database for Development/UAT/Production for GE Commercial finance on Solaris servers

Implemented RMAN, Export Backup Strategies for corresponding Dev, Test and Production Databases

Database Backup (Export using Data Pump, OFFLINE and ONLINE backups using RMAN)

Provided production support to maintain data integrity, performance, security and availability of the production environment database

Process, Schema and Log maintenance and Auditing

Database Backup (Export, Hot backup, RMAN)

Mirroring of Redo log files/ Control files / Init file on OS level

Maintained archived log data on appropriate storage device

Customization /Maintenance of Init Parameters as per user requirement

Created views, materialized views and indexes on tables as a matter of performance improvement and optimization.

Created shell scripts to refresh the Materialized views.

Environment- Sun Solaris 8 & 9, AIX, Oracle 10g

Education Qualification

Bachelor’s of Computer Science Engineering, Jawaharlal Nehru Technological University, India

Certification/Trainings

ITIL Foundation

ITIL V3 Foundation

Oracle 9i,10g, 11g, 12c, 18c

Employer

Cognizant Technology Solutions (2008- 2012)

CA Technologies (BROADCOM) (2012-2013)

Wipro Technologies (2013-2020)

Value Labs (2020-2021)

Virtusa Polaris – Canada (2021-2021)

TCS (2021- PRESENT)

Contact this candidate