WORK EXPERIENCE- 8 Years
Jul’2016 to Present
Software Lead Engineer
Rolta India Ltd,Mumbai
Domain- HR Module
Mar'2015 to June’2016
Sr. DBA
Tech Mahindra ,Pune
Domain-Telecom Industry
Sep'2011 to Mar'2015
Database Administrator
ITSource Technologies Ltd, Mumbai
Domain- Banking Data Centre
Aug'2009 to Mar'2010
Assist Programmer
IAP Company Ltd, Gurgaon
Domain- Government office
PERSONAL DETAILS
Voice : +36 307237805
Email-rahmataliocp@gmail.com
Nationality-INDIAN
Language Skills-English, Hindi, Urdu
Present Address: - Premium Apartment, room no 202. Budapest, Országbíró u. 44-46, 1139.
PERSONAL SKILLS
Attention to detail
Good analytical skills
Goals orientated
ACADEMIC EDUCATION
B.Sc (Engg) in I. T from Maulana Azad College of Engg & Tech, Patna with 74%.
Approved by AICTE, New Delhi and af-filiated to Magadh University, Bodh Gaya
PROFESSIONAL EDUCATION
Oracle Certified Professional (OCP 9i DBA).
Oracle Certified Professional (OCP10g DBA)
Rahamtullah Alam
Oracle Database administrator
PERSONAL SUMMARY
An experienced IT professional with database & Unix administration skills across Oracle database. A self-motivated Database Administrator with a wide range of experience in the Banking data Centre, Telecom domain & HR Module. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. Currently working in a demanding production support environment managing large volumes of business critical data. A committed team player, self motivated with the ability to communicate at all levels.
Presently looking for a suitable database administrator position with a responsible company.
TECHNICAL SKILLS
Databases : Oracle10g/11gr2/12c, Oracle 11gR2 RAC , SAP HANA database
Operating Systems : AIX, Sun Solaris, RHEL, OEL, HP-UX, WIN SERVER 2003.
Languages : SQL, UNIX Scripting (Shell).
GUI : AOTS (AT&T OneTicketing System),Insight tool, Servicenow, Solarwind.
Tools : Oracle Golden Gate, Oracle Enterprise Manager, SQL *Loader for
Bulk data, Export /Import and expdp / Impdp, RMAN,
SQLTRACE, TKPROF, AWR Report.
PROFESSIONAL SUMMARY
? Currently working on Onsite (SAP Hungary kft, Budapest) for Goldengate RAC Implementation Project.
? Experienced in Oracle RAC and Non RAC database support in production, development and UAT environment
? Experience in database (Oracle 10g/11g/12c) software installation, upgrades, bug patching, database monitoring, database backup/recovery, high availability, disaster recovery, data replication etc.
? Experience in 11gR2 ASM, RAC build, RAC Physical Standby Creation, node addition and deletion from cluster.
? Oracle Golden Gate setup for Single instance and for RAC Instances.
? Goldengate processes (extract, pump, mgr and replicat) troubleshooting in case process gets abended.
? Experienced in Golden Gate replication (Oracle - Oracle & Oracle-Ms-SQL).
? Experienced in Customer/Schema migration through Oracle Goldengate.
? Switchover/ Switchback of physical Standby databases.
? Checking long running Query and Full Table Scan query, generating explain plan, ADDM reports and Analysis.
? Monitoring and scheduling database backups using export/import, expdp/impdp, online Backup/Offline Backup, RMAN consistent/RMAN inconsistent backup.
? Provided 24x7x365 System DBA on-call support for Production databases, catering to applications including mission-critical and priority 1 OLTP/Online systems. Also supported development and test instances.
? Serving user’s requests through emails and ticketing system.
? Knowledge of change management and incident management & SLAs.
? Create , review and implement database changes.
? Communicated and worked proactively and reactively with practically all the groups in the organization which include management, development and testing teams, application DBAs, capacity planners, backup planners, storage planners, vendors and their technical support teams, system administrators, security administrators, end users, veritas Netback up and EMC ddboost administrators,etc.
? UNIX Shell Scripting.
? Installation, upgradation, Failover-Failback(master-slave), Production support, Monitoring locking, blocking expensive statements in HANA database.
PROJECT DETAILS
PROJECT# 4
Name SAP - Success Factor
Client - SAP – Hungary Kft.
Organization ROLTA India Ltd
Role Software lead Engineer
Domain HR Module.
Team Size 20
Duration Jul’16 to Till Date
PROJECT #3
Name AT & T
Organization Tech Mahindra Pvt
Ltd, Pune
Role Sr. DBA
Domain Telecom Industry.
Team Size 70
Duration Mar’15 to Jul’16
PROJECT DESCRIPTION:
The project is based on HR Module and Learning module. SAP is a German-based European multinational software corporation that makes enterprise software to manage business operations and customer relations. SAP is headquartered in Walldorf, Baden Württemberg , Germany with regional offices in 180 countries. The company has over 335,000 customers in over 180 countries.
Responsibilities Handled:
? Handle P1 and P2 calls for Oracle Database and cluster related issue
? Adding luns to ASM in Linux and SunOS environment
? Enable golden gate replication for oracle to SQL and oracle to oracle environment
? Fix golden gate replication issues in case of abended or stopped state
? Setup goldengate for single instance and RAC.
? Customer/Schema migration through goldengate.
? Failover and failback of cluster resources within oracle cluster
? Perform Cluster and Database health check in every two hours
? Bring Standby DB in sync via SCN based RMAN incremental backup in case of huge arch lag
? Rebuilding indexes & shrinking tables to remove fragmentation in the tables weekly.
? Work on Jira tickets (COSR, COSD) and provide solution to customer
? Monitor Solar wind, dashboard, email alerts and take necessary action in case of any issue
? Create & Execute changes after approval in weekends
? Monitor, Acknowledge and Resolve tickets of HP- service now Ticketing Tool.
? Check RMAN Level 0, Level 1 and archive backups on daily basis and provide resolution in case of issue
? Create Service Requests (SR) with Oracle support and take follow ups
? Build RAC Setup , Standby Setup , Goldengate setup, add node and delete node from cluster.
? Checking long running Queries and Full Table Scan queries, generating explain plan, AWR, ADDM reports and analyse those.
? Managing Table spaces, archive locations and DC-DR Sync.
Project description:
The project is based on telecom domain. AT&T Inc. is an American multinational telecommunications corporation, AT&T is the second largest provider of mobile telephone and the largest provider of fixed telephone in the United States, and also provides broadband subscription television services.
Responsibilities Handled:
? Installing and maintaining databases
? creating, managing and monitoring Table space usage and deal with space related issues
? Monitoring daily backups and suggest the changes in backup strategy if required
? Having experience in applying database patches and patch set upgrades
? Applied patches to upgrade oracle databases
? Serving user’s requests through emails and ticketing system
? Backup database using export/import and performing data transfer across databases on different hosts
? Implementation of backup the databases using RMAN
? Monitoring and optimizing the performance of the Database through
AWR Report
? User creation and providing necessary Roles, Privileges and quota as per the
Requirement
? Resolving user’s day-to-day issues
? Consistently interacted with client and team in resolving the queries
? Checking DB locks, resizing of table spaces, data files, allocating quota for users
? Installing and configuration of 11gR2 (11.2.0.3) Grid Infrastructure (2 node Architecture) on linux Server.
? Two node RAC patching.
? Configuaration of one or two node RAC data Guard.
? Maintenance of RAC components using SRVCTL and CRSCTL.(db start/stop/relocate .....)
? Refresh of One or two node RAC in lower environments(TEST and Development) from Production.
? Troubleshooting in RAC Environment.
PROJECT# 2
Hewlett Packard India Sales Pvt Ltd, Mumbai, Outsourced by IT Source Technology Pvt, Ltd.
Client Bank of Baroda
Data Centre,BKC
(Bandra Kurla complex),
Mumbai,Bandra(E)
Role Database Administrator
Team Size 12
Duration Sep 2011-Mar’15
Domain Banking
PROJECT #1
IAP Company Ltd, Delhi
Client: National Informatics Centre (NIC).
Role: Assist Programmer Team Size: 4
Duration : Aug 2009- March 2010
PROJECT DESCRIPTION:
The project is based on Banking domain. Bank of Baroda is an Indian state-owned banking and financial services company headquartered in Vadodara (earlier known as Baroda) in Gujarat, India. It is the second-largest bank in India, after State Bank of India, and offers a range of banking products and financial services to corporate and retail customers through its branches and through its specialised subsidiaries and affiliates. In addition to its headquarters in its home state of Gujarat, it has a corporate headquarters in the Bandra Kurla Complex in Mumbai.Based on 2014 data, it is ranked 801 on Forbes Global 2000 list.[2][3] BoB has total assets in excess of ? 3.58 trillion, a network of 5307 branches in India and abroad, and over 8000 ATMs.
Responsibilities Handled:
? Creating and maintaining the databases
? Oracle Binaries (software) Installation.
? Up gradation from Oracle version 10.2.0.1 to 10.2.0.5 in Data Guard environment.
? Allocating system storage and planning future storage requirements for the database system.
? Managing primary database structures (Table space).
? Managing primary objects (Table, Views, Indexes),Purging of tables(LGT,SOD etc).
? Rebuilding indexes & shrinking tables to remove fragmentation in the tables regularly and before running Batch jobs.
? Controlling and monitoring user access to the database.
? Exporting and importing data in various schemas and full database during Migration.
? Backup’s tasks- Using operating system backup (Hot backup and Cold backup).
? Backup and Recovery using RMAN Utility.
? Configuration of Data Guard in physical standby database Using RMAN backup.
? Switchover and switchback of DC-DR databases as a part of quarterly activity.
? Creation of Report Server(clone databases) daily.
? Managing Table space, archive locations and DC-DR Sync.
? Make DC-DR Sync using RMAN incremental backup.
? Generating AWR report and ADDM reports.
? Checking active and inactive session’s sessions details if load is high on server.
? Raising Service Requests (SR) with Oracle support and taking follow ups for the same
Responsibilities Handled:
? Creating Database and maintaining database in windows environment
? Managing Oracle database users: Creating and dropping users, granting and revoking privileges, creating roles/profiles
? Managing physical database structure: Maintaining and multiplexing control files, redo log files, data files, archive log file, password file and spfile/pfile.
? Perform the database Cloning using users managed.
? Cold backup of the database.
I, hereby declare that the information given in this CV is true to the best of my knowledge and belief. I have not knowingly withheld any facts or circumstances which would, if disclosed affect my application unfavourably.
Date :
Signature:-
.