Oracle Database Administrator (DBA)
RasGas
Total years of experience :17 years, 6 months
Ali Bin Ali March 2013 - Present
Client: RasGas, Doha, Qatar
Role: IT System Analyst (DBA)
Responsibilities:
• Implemented OEM 12c for Oracle Database patching and monitoring.
• Focal point to co-ordinate and implement CPU patches on all oracle databases
• Upgrade critical Petroleum Engineering oracle databases from 9i to 11g.
• Moved Oracle Enterprise edition databases to standard edition for Cost optimization
• Implemented High Availability using Data Guard for critical production database
• Implemented oracle database security controls to secure the database from internal and external
attacks.
• Part of core team to design and implement database security controls as per the RasGas security
policy.
• Implemented Oracle Windows Failsafe for 10g and 11g databases.
• Support RasGas Intranet databases day-to-day activities.
Environment: Solaris 9, 10, RedHat Linux, Oracle RDBMS 9i, 10g & 11g, OEM 12c, Data Guard,
Failsafe, DbProtect, RMAN, Windows 2003/2008
Domain: Oil and Gas.
Client: State Bank of India - Jeddah Nov 2012 - Feb 2013
Location: Jeddah, KSA
Role: Sr. Oracle DBA
Responsibilities:
• Data Center experience with daily health checks of the physical servers, switches, routers etc.
• Database upgrade from 9.2.0.8 to 10.2.0.4
• Identified and tuned the SQL statements performing badly after upgrade.
• Configured Data Guard for all Production databases.
• Streamlined the alerting mechanism for all Production databases with shell scripts viz. alert log
monitoring, Data Guard monitoring, DB and listener health checks, housekeeping scripts etc..
• Architect Backup & Recovery scenario using RMAN.
• Tuned long running batch jobs using systematic methodological approach.
• SAMA - SARIE guidelines compliant. SYBASE is the database for SARIE systems. Primary
responsibility is to do daily, weekly and monthly health checks as L1 support.
Environment: IBM AIX, HP-Unix 11.31, Oracle RDBMS 9i, 10g & 11g, Data Guard, HP-Data Protector,
RMAN, Windows 2003,
Domain: Banking
Wipro Infotech Feb 2012 - Nov 2012
Hyderabad
Role: Consultant - Oracle Database Administrator
Responsibilities:
• Currently working on Telecom project with custom inbuilt applications namely Reflex and CRS
• Production support and provide assistance to development team.
• Troubleshoot SQL queries using SQLTXPLAIN, SQLHC
• Tracing the session and analyzing the trace files; tools used tkprof, tvdxtat (custom script by
Antognini)
• Streamlined CRS application jobs within SLA by constantly tuning SQL and recommendation to add extra SAN memory as there were huge IO contentions.
• Recommended weekly stats collection job instead on daily job.
• Segregated tables that are used with 'direct path load' in separate tablespace with autoallocate
option.
• Identified packet drop/loss on interconnect with wireshark protocol analyzer.
Environment: IBM AIX, Redhat Linux AS5, Data Guard, RMAN, asmlib, Oracle clusterware 10gR2,
Oracle RDBMS 10gR2, 11gR2, OEM 11g, TOAD, wireshark, tkprof, tvdxtat, MOAT (Tanel's custom tool)
Domain: Telecom
.
Projects: 2-Node RAC DB patch from 10.2.0.4 to 10.2.0.5
• Successfully patched 10.2.0.4 Clusterware, ASM and RAC DB to 10.2.0.5.
CSC India Pvt. Ltd. Jan 2009 - Jan 2012
Hyderabad
Role: Senior Engineer - Oracle Database Admin
Responsibilities:
• Worked on Banking and Insurance, Logistics, Minerals and Natural Resources and
Healthcare domains during the tenure.
• Creating, Maintaining, Designing and Planning Oracle database on Linux/Windows
platform and assign work to team member
• Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile,
Role, Privileges
• Troubleshoot the issues related to client / server connectivity
• Monitoring Alert log file clearing use less trace file, audit file etc
• Experience in creation and administration of database users and objects as per
requirement
• Experience in cloning an existing user to create new user
• Active involvement in database storage migration
• Liaise extensively with Capacity manager and storage administrator to planning SAN
storage requirement for databases
• Experience in database space management
• Enable Flashback on single and RAC environments
• Improve import performance by modifying the init parameters
• Monitor Remedy 4 and Remedy 7 queues for trouble tickets and service requests
• Raise Remedy 7 Change for production critical changes
• Written Unix shell script for ASM volume threshold breach to run from crontab and raise
sev 2 ticket through IMT
• Perform Data Guard Health checks and resolve the gap if any
• Rebuild Physical standby database using incremental backups from primary
• Restore Production copy on DR server with different file structure
• Improve RMAN backups to tapes by optimizing netbackup configuration
• Restore database using RMAN to same servers and to different servers at many
occasions
• Periodic refresh from Prod to non-prod environment using RMAN cloning and exp/imp and data pump
• Restore OCR on ASM when OCR got corrupted
• Liaise extensively with Server Ops team, network team and Storage team on Oracle RAC
project implementation
• Oracle Home cloning and create databases on Veritas Cluster environment. (3-node
veritas cluster)
• Upgrade Oracle database from 9.2.0.8 to 10.2.0.4
• Apply Timezone DST patch and bug fix patches on single and RAC environment
• Migrate Oracle database from Solaris Single instance to Oracle RAC on Linux.
• Analysis of statistics / checking the fragmentation level of a table / index
• Analysis of DB statistics generated through Statspack, SQL Analyzer, SQL Trace & TKPROF
• Performance tuning: SQL Query tuning, High CPU load
• Proposing suitable high availability method based on the business requirements
• Upgrade GRID infrastructure from 11.2.0.1 to 11.2.0.2
• Troubleshooting Cluster issues
• Working on New business deals & providing technical assistance to managers whenever
required
• Formulating/Review of backup strategies based on business needs
• Based on business needs, performing the validation of archived backups
• Developing database related monitoring scripts
• Applying patches related to bugs, security patches and critical patches when released by the vendor
• Implemented Oracle HA on windows using Oracle Failsafe.
• Implemented Oracle Streams at schema level within same database.
Environment: Solaris, Windows 2003/2008, Redhat Linux AS5, asmlib, AIX, Veritas Cluster, windows
failsafe, Oracle clusterware 11gR2, Oracle RDBMS 11gR2 and 10gR2, netbackup oracle client 6.5
Domains: Banking and Insurance, Logistics, Minerals and Natural Resources and Healthcare
Project: Oracle Streams at schema level within same database
Project Description: Business requires separating schema within same database for report generation
excluding some of the tables from the main schema.
Project: Oracle RAC 11gR2 Implementation
Project Description: As part of overall transformation of work, implement two 3 node Oracle 11gR2 RAC and two 1 node
Oracle 11gR2 RAC on ASM across different Data Centres
Role/Responsibilities:
• Provided technical inputs for the design of PTM
• Prepared extensive documentation on the implementation of 11gR2 clusterware
• SAN allocation inputs and asmlib configuration
• Create ASM disk and create diskgroups using asmca
• Run pre crs installation, hwos and ssa check using cluvfy
• Oracle Clusterware 11gR2 installation.
• Run post crs installation, hwos and ssa check using cluvfy
• Oracle RDMS 11gR2 and 10gR2 installation
• Database creation.
• Apply opatch to 10gR2 for bug fixing
• Troubleshoot installation issues
• Configure TAF for load balancing
Environment: Redhat Linux AS5, asmlib, Oracle clusterware 11gR2, Oracle RDBMS 11gR2 and 10gR2,
netbackup oracle client 6.5
Project: Database Migration (Single to RAC)
Project Description: Existing prod/qa/test/dev instances migrate to Oracle RAC
Role / Responsibilities:
• SAN allocation inputs to create database
• Data pump export on single instance and copy to target environment
• Create ASM disk and create diskgroups
• Create database using DBCA and create tablespaces
• Data pump import and post migration checks
• Configure xml db and ult_mail on the newly migrated database
Environment: Redhat Linux AS5, Oracle RDBMS 10gR2, Oracle Clusterware 11gR2
Project: SMTP Remediation
Project Description: To remediate all applications, services, tools and devices currently relying on existing SMTP Services
provided by a CSG to a new Enterprise Service hosting in Dallas
Role / Responsibilities: • Changing perl and shell scipts from current SMTP services to new Service
• Testing the new the SMTP services
Environment: Solaris 8, 9, Redhat Linux AS5, Windows NT/2003, Perl and shell scripting
Project: 3-node Veritas Cluster Implementation for HA Oracle Databases
Project Description: RPG project program to implement HA for Oracle databases using Veritas Cluster on Solaris
Role / Responsibilities:
• Provided technical inputs for the design of PTM
• Prepared extensive documentation on the implementation of HA oracle databases
• Liaise extensively with Server Ops team on the mount point creation and its sizing
• Oracle software installation and database creation.
• Configure database alert and monitor scripts using cron
• Formulated backup strategy on the business need.
Environment: Solaris 8, Oracle RDBSM 10gR2
Global ERP Solutions Inc Oct 2006 - Jan 2009
Hyderabad
Role: Oracle Database Administrator
Responsibilities:
• Performed production database maintenance and modifications to ensure databases are
operational, as well as diagnosed and corrected any database environment problems; monitored
database usage, and reported on database performance and system availability
• Creating, Maintaining, Designing and Planning Oracle database on Linux/Windows platform and assign work to team member
• Configured Data Guard setup.
• Creation, Configuration and Setting up of RMAN catalog Databases and Registering Databases with Catalog.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring,
bottleneck elimination and the wait event interface to identify issues.
• Initiated 10g new feature implementations such as Automatic Storage Management, Flashback
features, ASSM and ASMM to improve performance and manageability.
• Upgrade Databases from Oracle 8i to Oracle 9i/10g as per the client requirement
• Generated weekly performance reports to identify and solve the problems with performance.
• Performed replication using Materialized Views.
• Diagnosing performance issues with Statspack reports and customized scripts
• Tuned SQL queries using AWR, ADDM, Statspack and Execution Plans.
• Applied Patches (Patchsets and CPU patches) on Standalone and Standby databases.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented,
tested and documented various backup/recovery scenarios.
• Automated the processes by using CRONTAB
• Wrote scripts for Backup of databases, export of databases and maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster
recovery.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Managed undo segments, processes, memory, online redo log files, data files.
• Created logical and physical design; installed and upgrade databases.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Documented the Standard Processes for peers to follow.
Environment: Red Hat Linux AS4, Oracle 9i/10g Databases, Windows NT/2003, RMAN, ASM, Data
Guard, OEM
Personal Detail
Email: raheelhashmi.syed@gmail.com
Mobile Number: +974-5535 7445 - Qatar
: +91-9989634378 - India
Passport#: J2206800
Bachelor of Computer Application, Osmania University, Hyderabad Oracle 10g RAC Training from Oracle University Course Oracle Certified Professional 10g Administrator Projects Summary • Implemented Oracle security database controls to secure the database for RasGas - Qatar • Implemented OEM 12c for patching and monitoring the databases for RasGas - Qatar • Upgraded Oracle databases from 9i to 11g for RasGas - Qatar • Implemented High Availability (Data Guard and Windows Failsafe) for RasGas - Qatar • Oracle database upgrade from 9i to 10g for SBI - Jeddah • Implemented Oracle HA using Veritas (3 - node Veritas cluster) for Australian client • Implemented Oracle HA using Oracle RAC 11gR2 (3-node cluster) as part new infrastructure build for Australian Client • Implemented Oracle HA using Oracle Failsafe for Japanese Client • Migrated Single instance to Oracle RAC • SMTP Relay Remediation from current service to new enterprise service • Oracle 11gR1 and 11gR2 new installation on Oracle RAC • Disaster Recovery Test for one of the leading Australian Iron ore client using true copy replication and data guard Domains • Oil and Gas, Banking and Insurance, Logistics, Minerals and Natural Resources, Healthcare and Telecom