Database Specialist
Etisalat
مجموع سنوات الخبرة :24 years, 10 أشهر
Over 12 plus years of IT experience focusing on Oracle/SQL Server Database Management and Administration with experience in the Telecommunication, Financials, Procurement, HR, Aviation Service Industry and IT Service Company as Senior DBA.
Experience in PMP and ITIL technical solutions.
Involved in vital planning for infrastructure setup.
Management and Administration of ORACLE RAC system from design architecture.
High Availability: Implemented Disaster Recovery site
Manage team of DBA’s (Infra structure). DBA categorized for Administration, Application, Operation, Production, Change Management, On-Call Support and Performance Optimization, in absence of DBA Manager.
Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects.
Involved actively in technical solutions in bidding proposal for future Business development.
Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.
Experience in Oracle versions from Oracle 11g\10g\9i\8i.
Security and Privacy of database.
Extensive experience in the architecture of Data warehouse, VLDB (over 5 TB), OLTP, DSS and OLAP. Implemented ETL tools like ODI.
Migration from legacy servers to ORACLE
Administered full phase cycle of the database. Administered Development, QA, Integration, UAT, Pre Production and Production environments including the legacy conversion and interface environment.
RMAN for Cold and Hot backups and Recovery including Point in time recovery. FRA and Flashback Technology was implemented using Symantec Net backup.
Excellent Communication skills and customer relation
Implementation of SIEM -- ETISALAT - 2014
Implementation of DLP -- ETISALAT - 2014
In-Progress implementation of Big Data Appliance -- ETISALAT - 2014
Implementation of SubVersion -- ETISALAT - 2014
Up gradation of Service Desk to 12.6 -- ETISALAT - 2014
In-Progress Network Restructuring -- ETISALAT - 2014
In-Progress Database Optimization -- ETISALAT - 2014
ONLINE Portal Re Designing - ETISALAT -- 2013
Integration of Mission Critical Application - ETISALAT -- 2013
Implementation of Disaster Recovery Site -- ETISALAT - 2013
Storage Upgrade - ETISALAT -- 2012
Service Desk Application - ETISALAT - 2012
Mobile Money -- ETISALAT -- 2012
ORACLE Fusion Middleware Implementation -- ETISALAT -- 2012
Implementation of Microsoft Exchange Vault - ETISALAT -- 2012
IDASHBOARD Application - ETISALAT -- 2012
Migration of Mission Critical Application to New Hardware - ETISALAT -- 2011
Implementation of Clustering for all Mission Critical Application - ETISALAT -- 2011
Centralized Backup - ETISALAT -- 2010
Migration of All Databases to 11g - ETISALAT - 2010
India Data Center Setup - ETISALAT - 2010
ORACLE Application Server Upgrade -- ETISALAT -- 2010
Revenue Assurance Application - ETISALAT - 2009
Centralized Alerting System - ETISALAT -- 2009
NRTRDE Application - ETISALAT -- 2008
ONLINE Application - ETISALAT - 2008
Automation of manual jobs -- ETISALAT -- 2008
Design and Implementation of OLAP Application - ETISALAT -- 2008
Data Clearing Application Re Designing - ETISALAT -- 2007
Financial Clearing Application - ETISALAT - 2007
Archiving Policy Implementation -- ETISALAT -- 2007
ETRAVEL Application - Omeir Travel Agency -- 2006
Ingress to ORACLE Migration - ETISALAT -- 2006
SABER / Amadeus Ticking Software Integration with Front Desk CRM - Omeir Travel Agency -- 2005
Travel Portal - Omeir Travel Agency -- 2004
Finance / HR Module Re Designing - Omeir Travel Agency -- 2004
Finance / HR Module Integration with Real Estate CRM - ONYX Interactive(P) Ltd - 2003
Call Center CRM - Omeir Travel Agency -- 2003
Travel Holiday CRM - Omeir Travel Agency -- 2003
Real Estate CRM - ONYX Interactive(P) Ltd - 2002
Company Portal - ONYX Interactive(P) Ltd - 2002
Major Role as ORACLE DBA
Plan and implement Installation / Configuration / Creating / Patching ORACLE Environments (8i/9i/10g/11g) using OS via. HP Itanium, Sun Solaris, SCO-Unix & WINDOWS Servers.
Experience with database backup, restore and disaster recovery procedures.
Well versed with RMAN / Hot backup / Cold Backup / Import / Export / Data pump / SQL * Loader.
Hands on experience of Database backups and recovery strategies using HP Media Protector / Symantec Net Backup.
Hands on experience of ORACLE Real Application Clusters (RAC) on HP Itanium of 4 Instances
Knowledge of Disaster Recovery Site using ORACLE Data Guard.
Experience as On-Call 24*5 production DBA support service request using helpdesk Service Desk Request..
Experience in all facts of the systems development lifecycle from requirement, development, architecture design, testing and post implementation revisions.
Strong knowledge of 9i/10g/11g/12c release.
Strong in knowledge of oracle data-dictionary, configuration of ORACLE Enterprise Manager (OEM) tools for monitoring, performance enhancement and debugging.
Experience in implementation of enterprise database on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).
Working experience with Very-Large Terabytes Databases.
Practical solutions to problem solving with creative ideas, identify patterns, linkages and underlying situations, consider development team / customer needs in evaluation of solutions.
Migration of 50+ databases in development, test to Production Environments.
Migration of 30+ databases from 9i to 10g and 10g to 11g.
Moving Data on different database using ORACLE Data Integrator 11g.
Writing alerts scripts for production databases for UNIX / Windows environment.
Experience in Managing security of schemas at varies levels.
Creation / Modifying / Maintenance of ORACLE schedule Jobs.
Monitoring database growth / Logs / ADDM / AWR.
Creation of database link across different databases.
Performance Tuning of database.
Design and Implement Database Table Archiving.
Keeping History of ADDM and implement the required suggestions.
SQL Statement Tuning / Online Index Rebuilding.
Experience of archiving production / master tables on monthly basis.
Works closely with system administrator while Server Maintenance is done. Eg( patching of operating system, Failover testing, Package Movement, disk addition, clustering, security port management, Storage Up gradation, Server Migration, Timezone settings etc)
Coordinating with ORACLE Meta Link - Vender for support
Maintenance of ORACLE Database Licenses.
Documentation of databases.
Reporting to Operation Manager.
SQL Server DBA Experience
Installation / Patching of SQL Server 2008.
Reorganization of processing server.
SSIS Jobs Maintenances.
Alters configuration.
Scheduling Jobs.
Space Management.
Security Management.
Archiving of yearly based data on Processing Server.
Backup of databases using HP Media Protector / Symantec Netbackup.
Checking Logs / Process.
Monitoring database growth.
Truncation log.
Managing Analysis Service.
Created disaster recovery plan.
Tuning of database.
Running trace for recording database activity.
Tuning long running SQL Queries.
Checking www.edch.com website report for performance.
Documentation of database.
Reporting the activities to Operations Manager.
INGRESS DBA Experiences
Checking alerts of Ingress Database on regular basis.
Software Installation.
Client configuration.
Involved in monthly archiving of database.
Creating new database and data transfer.
Involved in database patching.
Granting roles.
Calls tables creation.
Exporting / Importing Tables.
Transferring data to ORACLE / SQL Server.
Reorganization of disk space.
Performance Tuning
Documentation of database.
Reporting the activities to Operation Manager
ORACLE APPLICATION Server Experiences
Installation / Patching of ORACLE APPLICATION SERVER using Fail Safe.
Installing / Configuration / Patching of ORACLE Fusion Middleware 11g.
Managing FORM Server / Report Server.
Troubleshooting OAS issues
Alert Configuration
Backup and Restore
Hosting New Forms / Reports / Services
Performance Tuning
Change Documentation.
Goal :
1. Implementation of Omeir Accounting Software using ORACLE 9i. (Size 40GB)
2. Implementation of Omeir Call Center CRM, Omeir Holidays Application using SQL Server 2000. (Size 24 GB)
3. Implementation of ETRAVEL 2000 Software using ORACLE 10g. (Size 3 GB)
Responsibilities Involving
System Analyst
Designing Workflow
User-Interface Designing
Database Designing
Module In charge
Module/System Testing and Debugging
Database Administrator
Responsibilities involving User-Interface Designing, Database Designing, Module in-charge, Database Administrator, Module/System Testing and Debugging.
Maintenance of the projects, involves addition of Form / Reports / Change of Business Rule as and when required by clients.
Worked on the projects using C++, Visual Basic 6.0, MS Access, SQL Server and ORACLE.
Note: Involved in complete Life Cycle of Invoicing System, Video Library, Online Banking projects as a Software Developer.
Graduate Tutor (Part Time)
Responsibilities included teaching BCA and Engineering Students in C, C++, Java and ORACLE DBA.
EXADATA DB Machine Administration Workshop ED 1.
Project Management
ORACLE CERTIFIED DBA - Introduction to ORACLE 9i: SQL - ORACLE 9i Database: Fundamentals I - ORACLE 9i Database: Fundamentals I - ORACLE 9i Database: Performance Tuning
Master of Computer Application First Division with Distinction Aggregate 78.6%
Professional Diploma in Network Centered Computing Excellent Performance with Aggregate 82%
B.Sc. With First Division Aggregate: 64.2%