Description
keyboard_arrow_downCurious, Cautious, Confident and Committed to fast product development with emphasis on database stability and combined with strong skills to produce positive results in an efficient and effective manner. Also possesses the skills to adapt to any environment quickly at any point of the project cycle. As an individual, I am a very motivated and disciplined person, extremely eager to prove my potential. I enjoy collaborating with like-minded and talented individuals, and I am happy both to assist and provide valuable support, but also to take initiative and adopt a responsible role, should the occasion and the need arise, always bearing in mind the overall goal and ensuring the most optimal result for the task at hand. Main Skills
keyboard_arrow_down ORACLE 10g/11g
DB Oracle
ORACLE RAC
Other Skills
keyboard_arrow_down SQL queries
database tuning
Oracle WebLogic Server
Oracle 7
Sun Solaris
databases
OLAP
12c
disaster recovery
Oracle 8i
Oracle Linux
banking software
Real Application Clusters
9i
backups
UNIX
shell scripts
Windows NT Server
database administration
WebLogic Server
Grid Control
shell scripting
ZENITH
Fedora
Oracle database
SQL scripts
data access
Korn
Oracle Enterprise Manager
SUSE
IBM AIX
Computer Science
servers
RedHat
MS SQL
MS SQL Server
database design
Oracle Databases
MySQL
OCFS2
Exadata
Unix Shell
HP-UX
Data Guard
Windows Operating System
IT projects
shell programming
Oracle 9i
database performance
scripting
Database Administrator
Oracle
UNIX shell scripts
database security
SQL tuning
Solaris
PL/SQL
UNIX System
SQL
SCADA
Oracle 10g/11g
AIX
Application Software
Virtual machines
database designs
Windows server
Database Analyst
HP UNIX
performance tuning
Programming
Linux
RMAN
Linux Operating System
high availability
database systems
Windows
RHEL
Web Services
RedHat Linux
Database backups
Oracle database administration
Oracle 8
stored procedures
Oracle RAC
UNIX Operating System
Linux OS
Cassandra
OLTP
Mobile Network
database server
Oracle 10g
Oracle Data Guard
data centres
MS-SQL
JavaScript
Solaris Operating System
web server
Java applications
SQL*PLUS
WebLogic
HTML
failover
database
XML
Work & Experience
keyboard_arrow_down 04.07.2022 — Now
Perform core DBA activities and Support various clients. 01.01.2007 — 05.11.2020
Oracle/SCADA Database Administrator Performed CORE DBA tasks, configured and installed Oracle/SCADA database (>10TB) in multi-site
complex (Single Instance, RAC and Data Guard) and large environment running 140 instances, to
meet all functional, performance and quality objectives. Took the leading initiative to gather our
client requirements and implemented the work process solutions, database backup and recovery
solutions and database operation, trouble-shooting and planning with quality objectives in mission
critical databases (10g/11g). Trouble-shoot the problems of Oracle database as per ITIL procedure.
Installed and implemented RAC and Data Guard database. Enhanced database performance, tested
and performed backup and recovery procedures on various disaster scenarios. Ensured technical and
functional designs of the database and application programs meet business requirements.
Responsibility (Verantwortung):
? Installed and configured of Oracle server (RAC/Data Guard/ASM/Grid Control/Data
Pump/RMAN) on 11g on Solaris/Linux/Windows OS. Designed and implemented the new
mission critical engineering application projects of IICATS and performed migration of data
from old SCADA within the time frame on Solaris/Linux OS on production, development and
test servers running Oracle 10g/11g Database. Installed and configured Oracle Application
Software, Oracle WebLogic Server, Forms and Reports. Prepared technical documentation.
? Responsible for installation, upgrades, patches, database tuning, cloning. Duties included
database creation, SQL tuning, backup/recovery, general troubleshooting, script
development and documentation.
? Responsible for Critical resource in Database team that worked on migrating ORACLE 12c,
11g, 10g, 9i on a high-profile and large scale oracle databases to different data centres on
heterogeneous operating systems.
? Performed installation/upgrades/cloning/Migration of oracle software and related products.
Resolving Oracle database performance issues by analysing Automatic Workload Repository
(AWR), Automatic Database Diagnostic Monitoring (ADDM), Active Session History (ASH)
reports. Implemented capacity planning procedures, written and developed shell scripts to
monitor growth procedures.
? Tuning SQL Statements by Creating SQL profiles, Restructuring SQL statements, creating
materialized views, refreshing optimizer statistics, Managing SQL Profiles, Managing SQL
Plan Baselines etc.
? To Monitor, performance analysis as well as permanent improvement of current systems
and their performance. Collaborate and improve valid service-level agreements and
processes. Creation and development of emergency concepts and operating manuals. To
ensure recovery management in accordance with the Business Continuity Plan. To answer all
technical questions in the area of databases and database infrastructure.
? Implemented capacity planning procedures, written and developed shell scripts to monitor
growth procedures.
? Performed the database's migrations and upgrades from !IX/Solaris to RedHat Linux
platforms as a cost-effective measure.
? Designed and developed database infrastructure and identified and resolved technical issues
of database problems along with development team. Improved the process and business
requirement for IICATS engineering applications by contributing viable solution.
? Responsible for Installation, Configuration, Tuning and troubleshooting of WebLogic Server
and migration of applications from WebLogic 11g to 12C.
? Developed. Maintained and implemented UNIX shell scripts, PL/SQL scripts and SQL scripts
to carry out routine checks on databases. This includes performance analysis, checking
whether all databases are running, listener is running, Unix error messages, disk space
availability, segments with greater than 10 extents, segments nearing max extents, checking
for errors in alert logs and trace files, etc. to avoid any unnecessary downtime.
Environment (Umwelt): Oracle 9i/10g/11g/12c, Windows/Linux, Solaris, Linux RHEL 6, 5.x, RMAN,
OEM Grid Control 11g/12c Oracle RAC 11g/12c, Weblogic10g/11g/12c/, OEL Virtual machines,
Oracle GoldenGate 11gR2, Oracle Data Guard 11gR2, IBM AIX 6.0, RHEL 5.5, Solaris, HP-UX, OEM
12c/13c. 01.03.2006 — 31.01.2007
Oracle Database Administrator Perform CORE DBA tasks. Managed Oracle database (>3TB) assignments (Single and RAC) running
100 instances, for University clients and troubleshooting of database problems as per ITIL procedure.
Managed student database and mission critical applications of three campus and able to bring the
upgraded database well before the closing time of the application. Enhanced database performance,
performed restores, implemented backup and recovery procedures, handled performance tuning
and conducted regular system backups. Ensured technical and functional designs of the application
and database meet Universities requirements for new student's enrolments.
Responsibility (Verantwortung):
? Installed and configured of Oracle 8i/9i/10g server and creation of databases (RAC/EM/GC)
on Solaris/Linux Operating System. Installed and configured web server logic.
? Responsible for installation, upgrades, patches, database tuning, cloning. Duties included
database creation, SQL tuning, backup/recovery, general troubleshooting, script
development and documentation.
? Installed/Configured/Administered Oracle Enterprise Manager Grid Control (10g). Applied
interim patches to Oracle using Installer and Opatch utility.
? Tuning SQL Statements by Creating SQL profiles, Restructuring SQL statements, creating
materialized views, refreshing optimizer statistics, Managing SQL Profiles, Managing SQL
Plan Baselines etc.
? Implemented capacity planning procedures, written and developed shell scripts to monitor
growth procedures.
? Installed Oracle 10g on Linux/Solaris OS. Performed migration of Oracle 9i from AIX to Linux
? Performed Recovery on Database for various scenarios of disaster or failure.
? Installed and Implemented Students Applications on Oracle 9iAS on Solaris and Linux.
? Refreshed development/test database from production using Export/Import and RMAN. This
is done so that the latest data is available in the development/test database.
? Developed UNIX shell scripts, SQL scripts and Complex SQL queries on OLAP to carry out
routine checks on databases. This includes checking whether all databases are running,
listener is running, Unix error messages, disk space availability, segments with greater than
10 extents, segments nearing max extents, checking for errors in alert logs and trace files,
etc. to avoid any unnecessary downtime. Prepared technical documentation
Environment (Umwelt): Oracle 8i/9i/10g, Oracle RAC 10g, Oracle RMAN, Linux RHEL 5.x,4.x, OEM
10g, Linux, Solaris, Oracle 9iAS. 01.02.2005 — 31.03.2005
Oracle Database Administrator Provided DBA Services and improved the performance on Mobile Network Portability (MNP) for
Hutchison Telecom. They are a Tele-Communication company that works with Oracle on a highly
OLTP environment. Implemented Disaster Recovery solutions, Tuning Code, Resolved bottleneck
problems, Installed Patches, Backup and Recovery (RMAN and Shell Scripts) over highly volume
Terabyte Databases. Implemented and configured Oracle RAC and help them to migrate from Oracle
8i to Oracle 9i.
Responsibility (Verantwortung):
? Created of database for large MNP (Mobile Network Portability) application on Solaris
Operating System. Prepared technical documentation
? Data extracted from various sources, transformed and loaded into the target Oracle
database.
? Opening and tracking of SR ticket on Oracle via Metalink for Production Server and
escalating. Preparing and Submitting reports and status of the ticket to the management.
? Planned the location of data and created tablespaces, index and rollback tablespaces redo
log files and control files in adherence to the Optimal Flex Architecture.
? Implemented database security. Created and assigned appropriate roles and privileges to
users depending on the user activity.
? Performed Database tuning to improve performance of loads and achieved the response
time. Optimised database for stability, speed and high availability.
? Made structural changes to the database objects.
? Re-sized database objects for effective space management and optimal performance.
? Implemented Database backups and recovery (RMAN).
Environment (Umwelt): Oracle 8i/9i, Solaris, OEM 11g, Sun Solaris 01.04.1997 — 30.09.2004
UNIX System/Oracle Database Administrator Performed CORE DBA tasks and configured/installed Oracle 7, 8, and 8i database on Tru64 Unix
environments, performance tuning, Schema creation, maintenance, and troubleshooting. Also
Administered, maintained, developed and implemented policies and procedures for ensuring the
security and integrity of the Ministry of Education database. Implemented data models and database
designs, data access and table maintenance codes; resolved database performance issues, database
capacity issues, backups, replication, and other distributed data issues over a highly volume
Database.
Responsibility (Verantwortung):
? Installed of Oracle 7.3/8.0/8i database server on Digital Unix/Windows NT Server and
created new databases. Upgraded Oracle 8 to Oracle 8i on Tru64 Cluster.
? Carried out upgrade of databases using the Oracle Installer.
? Refreshed development database from production using RMAN.
? Planned the location of data and created tablespaces, index and rollback tablespaces redo
log files and control files in adherence to the Oracle recommended standard.
? Reorganised the Database to meet standards and improve and resolved performance issues.
? Implemented database security by assigning appropriate roles and privileges depending on
the user activity.
? Performed SQL tuning by using Explain Plan, Tkprof, Trace facility and Statpack.
? Sizing database objects for effective space management and optimal performance.
? Capacity planning for changes in the size of databases due to business growth.
? Installed and administrated MS-SQL Server 2000.
? Database backup and recovery. Used hot and cold backups. Involved in development of
scripts to automate backup and recovery procedures for development databases.
? Monitoring rollback segments. Adopting proactive maintenance strategies to curb extensive
shrinking and wrapping of rollback segments. Migrated Oracle 7.3 to Oracle 8i
Environment (Umwelt): Oracle 8/8i/9i, Oracle RMAN, Tru64 UNIX. 01.10.1995 — 30.04.1997
environments, performance tuning, Schema creation, maintenance, and troubleshooting. Also
Administered, maintained, developed and implemented policies and procedures for ensuring the
security and integrity of the Bank for all the branches in Bombay, India.
Responsibility (Leistung):
? Installed of Oracle 7.3.4 database server on HP-UX and created a new target database.
? Interconnected the servers of the different branches of the bank successfully.
? Implemented database security and created and assigned appropriate roles and privileges as
required by the application. Enforced to perform day end operation and prepare the
database for next day business transactions to avoid any fraud and discrepancy.
? Implemented successfully all the banking software, application and the changes in the
database design and modified stored procedures.
? Re-sized database objects for effective space management and optimal performance.
? Implemented Database backups and recovery. Developed scripts for cold backup.
Environment (Umwelt): Oracle 7, HP UNIX. 01.09.1993 — 31.08.1995
Sr. Software Support Engineer Support UNIX and Novel LAN Operating System for various clients. Enhance system performance,
perform restores, implement recovery procedures, handle performance tuning and conduct regular
system backups. 01.08.1989 — 31.07.1993
Support and install UNIX Operating System for various clients. Enhance system performance,
perform restores, implement recovery procedures and conduct regular system backups. Oracle/SCADA Database Administrator Performed CORE DBA tasks, configured and installed Oracle/SCADA database (>10TB) in multi-site
complex (Single Instance, RAC and Data Guard) and large environment running 140 instances, to
meet all functional, performance and quality objectives. Took the leading initiative to gather our
client requirements and implemented the work process solutions, database backup and recovery
solutions and database operation, trouble-shooting and planning with quality objectives in mission
critical databases (10g/11g). Trouble-shoot the problems of Oracle database as per ITIL procedure.
Installed and implemented RAC and Data Guard database. Enhanced database performance, tested
and performed backup and recovery procedures on various disaster scenarios. Ensured technical and
functional designs of the database and application programs meet business requirements.
Responsibility (Verantwortung):
? Installed and configured of Oracle server (RAC/Data Guard/ASM/Grid Control/Data
Pump/RMAN) on 11g on Solaris/Linux/Windows OS. Designed and implemented the new
mission critical engineering application projects of IICATS and performed migration of data
from old SCADA within the time frame on Solaris/Linux OS on production, development and
test servers running Oracle 10g/11g Database. Installed and configured Oracle Application
Software, Oracle WebLogic Server, Forms and Reports. Prepared technical documentation.
? Responsible for installation, upgrades, patches, database tuning, cloning. Duties included
database creation, SQL tuning, backup/recovery, general troubleshooting, script
development and documentation.
? Responsible for Critical resource in Database team that worked on migrating ORACLE 12c,
11g, 10g, 9i on a high-profile and large scale oracle databases to different data centres on
heterogeneous operating systems.
? Performed installation/upgrades/cloning/Migration of oracle software and related products.
Resolving Oracle database performance issues by analysing Automatic Workload Repository
(AWR), Automatic Database Diagnostic Monitoring (ADDM), Active Session History (ASH)
reports. Implemented capacity planning procedures, written and developed shell scripts to
monitor growth procedures.
? Tuning SQL Statements by Creating SQL profiles, Restructuring SQL statements, creating
materialized views, refreshing optimizer statistics, Managing SQL Profiles, Managing SQL
Plan Baselines etc.
? To Monitor, performance analysis as well as permanent improvement of current systems
and their performance. Collaborate and improve valid service-level agreements and
processes. Creation and development of emergency concepts and operating manuals. To
ensure recovery management in accordance with the Business Continuity Plan. To answer all
technical questions in the area of databases and database infrastructure.
? Implemented capacity planning procedures, written and developed shell scripts to monitor
growth procedures.
? Performed the database's migrations and upgrades from !IX/Solaris to RedHat Linux
platforms as a cost-effective measure.
? Designed and developed database infrastructure and identified and resolved technical issues
of database problems along with development team. Improved the process and business
requirement for IICATS engineering applications by contributing viable solution.
? Responsible for Installation, Configuration, Tuning and troubleshooting of WebLogic Server
and migration of applications from WebLogic 11g to 12C.
? Developed. Maintained and implemented UNIX shell scripts, PL/SQL scripts and SQL scripts
to carry out routine checks on databases. This includes performance analysis, checking
whether all databases are running, listener is running, Unix error messages, disk space
availability, segments with greater than 10 extents, segments nearing max extents, checking
for errors in alert logs and trace files, etc. to avoid any unnecessary downtime.
Environment (Umwelt): Oracle 9i/10g/11g/12c, Windows/Linux, Solaris, Linux RHEL 6, 5.x, RMAN,
OEM Grid Control 11g/12c Oracle RAC 11g/12c, Weblogic10g/11g/12c/, OEL Virtual machines,
Oracle GoldenGate 11gR2, Oracle Data Guard 11gR2, IBM AIX 6.0, RHEL 5.5, Solaris, HP-UX, OEM
12c/13c. Oracle Database Administrator Perform CORE DBA tasks. Managed Oracle database (>3TB) assignments (Single and RAC) running
100 instances, for University clients and troubleshooting of database problems as per ITIL procedure.
Managed student database and mission critical applications of three campus and able to bring the
upgraded database well before the closing time of the application. Enhanced database performance,
performed restores, implemented backup and recovery procedures, handled performance tuning
and conducted regular system backups. Ensured technical and functional designs of the application
and database meet Universities requirements for new student's enrolments.
Responsibility (Verantwortung):
? Installed and configured of Oracle 8i/9i/10g server and creation of databases (RAC/EM/GC)
on Solaris/Linux Operating System. Installed and configured web server logic.
? Responsible for installation, upgrades, patches, database tuning, cloning. Duties included
database creation, SQL tuning, backup/recovery, general troubleshooting, script
development and documentation.
? Installed/Configured/Administered Oracle Enterprise Manager Grid Control (10g). Applied
interim patches to Oracle using Installer and Opatch utility.
? Tuning SQL Statements by Creating SQL profiles, Restructuring SQL statements, creating
materialized views, refreshing optimizer statistics, Managing SQL Profiles, Managing SQL
Plan Baselines etc.
? Implemented capacity planning procedures, written and developed shell scripts to monitor
growth procedures.
? Installed Oracle 10g on Linux/Solaris OS. Performed migration of Oracle 9i from AIX to Linux
? Performed Recovery on Database for various scenarios of disaster or failure.
? Installed and Implemented Students Applications on Oracle 9iAS on Solaris and Linux.
? Refreshed development/test database from production using Export/Import and RMAN. This
is done so that the latest data is available in the development/test database.
? Developed UNIX shell scripts, SQL scripts and Complex SQL queries on OLAP to carry out
routine checks on databases. This includes checking whether all databases are running,
listener is running, Unix error messages, disk space availability, segments with greater than
10 extents, segments nearing max extents, checking for errors in alert logs and trace files,
etc. to avoid any unnecessary downtime. Prepared technical documentation
Environment (Umwelt): Oracle 8i/9i/10g, Oracle RAC 10g, Oracle RMAN, Linux RHEL 5.x,4.x, OEM
10g, Linux, Solaris, Oracle 9iAS. Oracle Database Administrator Provided DBA Services and improved the performance on Mobile Network Portability (MNP) for
Hutchison Telecom. They are a Tele-Communication company that works with Oracle on a highly
OLTP environment. Implemented Disaster Recovery solutions, Tuning Code, Resolved bottleneck
problems, Installed Patches, Backup and Recovery (RMAN and Shell Scripts) over highly volume
Terabyte Databases. Implemented and configured Oracle RAC and help them to migrate from Oracle
8i to Oracle 9i.
Responsibility (Verantwortung):
? Created of database for large MNP (Mobile Network Portability) application on Solaris
Operating System. Prepared technical documentation
? Data extracted from various sources, transformed and loaded into the target Oracle
database.
? Opening and tracking of SR ticket on Oracle via Metalink for Production Server and
escalating. Preparing and Submitting reports and status of the ticket to the management.
? Planned the location of data and created tablespaces, index and rollback tablespaces redo
log files and control files in adherence to the Optimal Flex Architecture.
? Implemented database security. Created and assigned appropriate roles and privileges to
users depending on the user activity.
? Performed Database tuning to improve performance of loads and achieved the response
time. Optimised database for stability, speed and high availability.
? Made structural changes to the database objects.
? Re-sized database objects for effective space management and optimal performance.
? Implemented Database backups and recovery (RMAN).
Environment (Umwelt): Oracle 8i/9i, Solaris, OEM 11g, Sun Solaris UNIX System/Oracle Database Administrator Performed CORE DBA tasks and configured/installed Oracle 7, 8, and 8i database on Tru64 Unix
environments, performance tuning, Schema creation, maintenance, and troubleshooting. Also
Administered, maintained, developed and implemented policies and procedures for ensuring the
security and integrity of the Ministry of Education database. Implemented data models and database
designs, data access and table maintenance codes; resolved database performance issues, database
capacity issues, backups, replication, and other distributed data issues over a highly volume
Database.
Responsibility (Verantwortung):
? Installed of Oracle 7.3/8.0/8i database server on Digital Unix/Windows NT Server and
created new databases. Upgraded Oracle 8 to Oracle 8i on Tru64 Cluster.
? Carried out upgrade of databases using the Oracle Installer.
? Refreshed development database from production using RMAN.
? Planned the location of data and created tablespaces, index and rollback tablespaces redo
log files and control files in adherence to the Oracle recommended standard.
? Reorganised the Database to meet standards and improve and resolved performance issues.
? Implemented database security by assigning appropriate roles and privileges depending on
the user activity.
? Performed SQL tuning by using Explain Plan, Tkprof, Trace facility and Statpack.
? Sizing database objects for effective space management and optimal performance.
? Capacity planning for changes in the size of databases due to business growth.
? Installed and administrated MS-SQL Server 2000.
? Database backup and recovery. Used hot and cold backups. Involved in development of
scripts to automate backup and recovery procedures for development databases.
? Monitoring rollback segments. Adopting proactive maintenance strategies to curb extensive
shrinking and wrapping of rollback segments. Migrated Oracle 7.3 to Oracle 8i
Environment (Umwelt): Oracle 8/8i/9i, Oracle RMAN, Tru64 UNIX. environments, performance tuning, Schema creation, maintenance, and troubleshooting. Also
Administered, maintained, developed and implemented policies and procedures for ensuring the
security and integrity of the Bank for all the branches in Bombay, India.
Responsibility (Leistung):
? Installed of Oracle 7.3.4 database server on HP-UX and created a new target database.
? Interconnected the servers of the different branches of the bank successfully.
? Implemented database security and created and assigned appropriate roles and privileges as
required by the application. Enforced to perform day end operation and prepare the
database for next day business transactions to avoid any fraud and discrepancy.
? Implemented successfully all the banking software, application and the changes in the
database design and modified stored procedures.
? Re-sized database objects for effective space management and optimal performance.
? Implemented Database backups and recovery. Developed scripts for cold backup.
Environment (Umwelt): Oracle 7, HP UNIX. Sr. Software Support Engineer Support UNIX and Novel LAN Operating System for various clients. Enhance system performance,
perform restores, implement recovery procedures, handle performance tuning and conduct regular
system backups. Support and install UNIX Operating System for various clients. Enhance system performance,
perform restores, implement recovery procedures and conduct regular system backups. Attachments
keyboard_arrow_down
