DBA Technical Associate fromMarch
SM Networks & Solutions Pvt Ltd
Skills
Data, Installation of 2node,4 node RAC 11g, 12c, CRSCTL, SRVCTL utilities, OCR backup, Oracle Database, RMAN utility, Oracle Architecture, Importing database backups, Exp, Imp, EXPDP/IMPDP utilities, Oracle, Linux, Logic, RDBMS, Operating System, Database, 10g, 11g, Active data guard, ASM, RAC Windows, Toad, DBCA, DBUA, NETCA, NETMGR, RMAN, ASMCA, SQL LOADER, DATAPUMP. SQL developer, Putty, WinSCP Windows, AIX, 9i, 11g, 12c (Standard & Enterprise Edition) RAC, Data Guard, Golden Gate, Shell Scripting, Upgradation, Migration, RHEL, DB, backup, PROD, binaries, log files, backups, SCP, FTP, databases, database security, Crontab, 10g, 11g, 12c, Windows, HP, Solaris, OS platforms, Oracle Version, OEM, Oracle Mail Server Configuration, Dataguard, web logic server, Windows 2003 server, Oracle 11g, file system, UAT, RHEL 7.5, UNIX, Installation, Diskparttions, UnixFileSystems, Patch/PackageInstallation, file system backup and administration
Project history
05/2020
-
05/2020
05/2020
-
05/2020
DBA Consultant
State Bank Of India
PROJECT DETAILS Retail Loan
CLIENT State Bank Of India, Mumbai
ROLE DBA Consultant
DATABASE VERSION 12cR2(Enterprise Edition)
ENVIRONEMENT RHEL 7.6
CLIENT State Bank Of India, Mumbai
ROLE DBA Consultant
DATABASE VERSION 12cR2(Enterprise Edition)
ENVIRONEMENT RHEL 7.6
05/2020
-
05/2020
DBA Technical Associate
Duration Details: March 2017 to Aug 2018.
PROJECT DETAILS Remote Support
CLIENT Multiple clients across various sectors
ROLE DBA Technical Associate
DATABASE VERSION 10g, 11g, 12c
ENVIRONEMENT Linux, Windows, AIX,HP,Solaris
DOMIAN BFSI, Pharma, Utilities,Banking
Responsibilities: -
* Installation and creation of Oracle Software and database.
* Cross OS platforms & Oracle Version migration to desired levels in Critical Environment.
* Database purging Activities.
* Database Cloning.
* OEM Setup.
* Oracle Mail Server Configuration.
* Designing physical storage clause for tables/indexes and creatingdatabase objects.
* Creating Physical layout of database and placement of files on various diskdevices.
* Migrated two production databases from 10g (10.2.0.4) to 12c Linux with minimum
down time.
* Configuring Dataguard setup.
* Configured Golden Gate.
* Alert configuration for multiple clients.
* Applying PSU patches on PROD and DR on quarterly basis.
* Frequent monitoring of Tablespace Usage, ASM Usage, Archival Usage, Database &
Instance connectivity check, sessions.
* Restart of application services and modules.
* EAR (Patch) deployment in application.(web logic server).
* Oracle Dataguard/Standby implementation according to business criticality onUNIX,
Windows 2003 server.
* Server Sizing and n/w bandwidth planning for DR database.
* Trouble shooting errors in Dataguard Environment.
* Dataguard Management -Switchover, Switch Back and fail over in criticalsituations.
* Oracle 11g logical Standby database implementation.
* Converting DR database to Snapshot DB on Client Requirement.
* Reinstalled XDB components to make valid from dba registry.
PROJECT DETAILS Remote Support
CLIENT Multiple clients across various sectors
ROLE DBA Technical Associate
DATABASE VERSION 10g, 11g, 12c
ENVIRONEMENT Linux, Windows, AIX,HP,Solaris
DOMIAN BFSI, Pharma, Utilities,Banking
Responsibilities: -
* Installation and creation of Oracle Software and database.
* Cross OS platforms & Oracle Version migration to desired levels in Critical Environment.
* Database purging Activities.
* Database Cloning.
* OEM Setup.
* Oracle Mail Server Configuration.
* Designing physical storage clause for tables/indexes and creatingdatabase objects.
* Creating Physical layout of database and placement of files on various diskdevices.
* Migrated two production databases from 10g (10.2.0.4) to 12c Linux with minimum
down time.
* Configuring Dataguard setup.
* Configured Golden Gate.
* Alert configuration for multiple clients.
* Applying PSU patches on PROD and DR on quarterly basis.
* Frequent monitoring of Tablespace Usage, ASM Usage, Archival Usage, Database &
Instance connectivity check, sessions.
* Restart of application services and modules.
* EAR (Patch) deployment in application.(web logic server).
* Oracle Dataguard/Standby implementation according to business criticality onUNIX,
Windows 2003 server.
* Server Sizing and n/w bandwidth planning for DR database.
* Trouble shooting errors in Dataguard Environment.
* Dataguard Management -Switchover, Switch Back and fail over in criticalsituations.
* Oracle 11g logical Standby database implementation.
* Converting DR database to Snapshot DB on Client Requirement.
* Reinstalled XDB components to make valid from dba registry.
05/2020
-
05/2020
DBA Technical Associate
Project Information:
PROJECT DETAILS MahaTransco,Power Line
CLIENT Maharashtra State Electricity
Transmission Company.
ROLE DBA Technical Associate
DATABASE VERSION 10gR2(Enterprise Edition)
ENVIRONEMENT RHEL 7.5
Responsibilities: -
* Monitoring tablespace usage, growth analysis and adding/resizing data files depending
on the growth rate so as to avoid any application load Job failure due to insufficient
space.
* Monitoring the log files, backups, database space usage and the use of
system resources.
* Viewing the Alert log file to analyze the ORA errors on daily basis.
* Using SCP or FTP for transferring the dump files from one server to other.
* Creating AWR report which helps in comparing the bad run AWR reports with it and
figure out the difference causing any issues.
* Working with Oracle Support for any database related issue therebygetting
recommendations for any patch or solution/fix for it.
* Frequent monitoring of tablespace Usage, ASM Usage, Archival Usage, Database &
Instance connectivity check, sessions.
* Performing Exports/Imports operation of important schemas on daily basis which
changes frequently.
PROJECT DETAILS MahaTransco,Power Line
CLIENT Maharashtra State Electricity
Transmission Company.
ROLE DBA Technical Associate
DATABASE VERSION 10gR2(Enterprise Edition)
ENVIRONEMENT RHEL 7.5
Responsibilities: -
* Monitoring tablespace usage, growth analysis and adding/resizing data files depending
on the growth rate so as to avoid any application load Job failure due to insufficient
space.
* Monitoring the log files, backups, database space usage and the use of
system resources.
* Viewing the Alert log file to analyze the ORA errors on daily basis.
* Using SCP or FTP for transferring the dump files from one server to other.
* Creating AWR report which helps in comparing the bad run AWR reports with it and
figure out the difference causing any issues.
* Working with Oracle Support for any database related issue therebygetting
recommendations for any patch or solution/fix for it.
* Frequent monitoring of tablespace Usage, ASM Usage, Archival Usage, Database &
Instance connectivity check, sessions.
* Performing Exports/Imports operation of important schemas on daily basis which
changes frequently.
03/2017
-
08/2018
Associate Technical Consultant
Simple Logic IT Pvt. Ltd
12/2015
-
01/2017
DBA Technical Associate
Mphasis Ltd
12/2015
-
01/2017
DBA Technical Associate
State Bank Of India; DOMIAN Banking
PROJECT DETAILS NEFT/RTGS/Prepaid Card/PHUB
CLIENT State Bank Of India, Mumbai
ROLE DBA Technical Associate
DATABASE VERSION 11gR2(Enterprise Edition)
ENVIRONEMENT Linux, Windows, AIX
DOMIAN Banking
Duration Details: Dec 2015 - Jan 2017
Responsibilities: -
* Standby DB Restoration using incremental backup from SCN.
* Fragmentation Activities/Index rebuilding.
* Applying PSU patches on PROD and DR on quarterly basis.
* Tuned multiple select queries and minimized the cost and CPUutilization.
* Archiving the data from production and moving to different server for auditing purpose.
* Reorg of database for few of the clients.
* Taking file system and DB backup through Net vaulttool.
* Moved the files from file system to ASM by configuring ASM.
* Restart of application services and modules.
* Reinstalled oracle binaries for server crash.
* Reinstalled XDB components to make valid from dba registry.
* EXP/IMP and Expdp/Impdp done for many clients.
* Applying listener related patches.
* Monitoring tablespace usage, growth analysis and adding/resizing data files depending
on the growth rate so as to avoid any application load Job failure due to insufficient
space.
* Monitoring the log files, backups, database space usage andthe use of system
resources.
* Viewing the Alert log file to analyze the ORA errors on daily basis.
* Using SCP or FTP for transferring the dump files from one server to other.
* pply patch and Upgrade databases depending on application requirement & client's
database security policy.
* Migrating Database using Data pump and Transportable Tablespace Approach.
* Creating AWR report which helps in comparing the bad run AWR reports with it and
figure out the difference causing any issues.
* Working with Oracle Support for any database related issue therebygetting
recommendations for any patch or solution/fix for it.
* Frequent monitoring of tablespace Usage, ASM Usage, Archival Usage, Database &
Instance connectivity check, sessions.
* Performing Exports/Imports operation of important schemas on daily basis which
changes frequently.
* Taking daily Full RMAN backups after production hours.
* Cloning the Databases through RMAN as per the requirement.
* Partially restoration of tables in UAT.
* Raising SR with oracle support and following up with it.
* Scheduling Database jobs in Crontab.
CLIENT State Bank Of India, Mumbai
ROLE DBA Technical Associate
DATABASE VERSION 11gR2(Enterprise Edition)
ENVIRONEMENT Linux, Windows, AIX
DOMIAN Banking
Duration Details: Dec 2015 - Jan 2017
Responsibilities: -
* Standby DB Restoration using incremental backup from SCN.
* Fragmentation Activities/Index rebuilding.
* Applying PSU patches on PROD and DR on quarterly basis.
* Tuned multiple select queries and minimized the cost and CPUutilization.
* Archiving the data from production and moving to different server for auditing purpose.
* Reorg of database for few of the clients.
* Taking file system and DB backup through Net vaulttool.
* Moved the files from file system to ASM by configuring ASM.
* Restart of application services and modules.
* Reinstalled oracle binaries for server crash.
* Reinstalled XDB components to make valid from dba registry.
* EXP/IMP and Expdp/Impdp done for many clients.
* Applying listener related patches.
* Monitoring tablespace usage, growth analysis and adding/resizing data files depending
on the growth rate so as to avoid any application load Job failure due to insufficient
space.
* Monitoring the log files, backups, database space usage andthe use of system
resources.
* Viewing the Alert log file to analyze the ORA errors on daily basis.
* Using SCP or FTP for transferring the dump files from one server to other.
* pply patch and Upgrade databases depending on application requirement & client's
database security policy.
* Migrating Database using Data pump and Transportable Tablespace Approach.
* Creating AWR report which helps in comparing the bad run AWR reports with it and
figure out the difference causing any issues.
* Working with Oracle Support for any database related issue therebygetting
recommendations for any patch or solution/fix for it.
* Frequent monitoring of tablespace Usage, ASM Usage, Archival Usage, Database &
Instance connectivity check, sessions.
* Performing Exports/Imports operation of important schemas on daily basis which
changes frequently.
* Taking daily Full RMAN backups after production hours.
* Cloning the Databases through RMAN as per the requirement.
* Partially restoration of tables in UAT.
* Raising SR with oracle support and following up with it.
* Scheduling Database jobs in Crontab.
Local Availability
Only available in these countries:
India
