سيد سميع الله

 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.