Technical Summary:

• Abdul has 9 years of IT experience which includes hands on 5 years of experience as an Oracle DBA, 3 years as a Greenplum DBA/Engineer and as 2 years as a PostgreSQL DBA on Production servers.
• Installing/Creating Greenplum DCA on 1/4 , 1/2 , Full RACK on RHEL.
• Vendor Coordination EMC .
• 11g Golden Gate Flat file to Greenplum Data migration.
• Upgrading Greenplum DCA 4.2.1.0 to 4.2.5.1.
• Installing Greenplum Command Center 1.2.0.0.
• Installing Greenplum DCA 1.2.0.0.
• Managing Monitoring Greenplum DCA using Command Center.
• Configuring ESRS Dialhome with Greenplum DCA.
• Managing Routine Maintenance activity such as reindexing, partition monitoring, vacuum , runing gpcheckperf.
• Daily Maintenance using gpstate, pg acitivity stat, gpssh, pg locks, gp bloat, gp skew.
• Tuning Greenplum Database using gpcheckpef, gpexplorer utilities.
• Backing up Greenplum tables, Database parallel, non-parallel to Data Domain.
• Data Loading using noparallel COPY, parallel Loading using gpfdist gpload.
• Configuring LDAP, PgAdmin, SMTP on Greenplum DCA.
• Greenplum Database Segment recovery.
• Expertise in Oracle 11g, 10g, 9i, 8i specializing in installation on Red hat, OEL, CentOS SUSE 10 Linux, SUN Solaris Unix configuration.
• Good command and expertise on Oracle Architecture, RMAN, Data Pump, Flash Back, and ASM.
• Experienced in configuring Oracle Advanced/Multi Master Replication on 10g.
• Good understanding and knowledge of Oracle 10g/11g multi node RAC on OEL 5.6 CentOS, Dataguard.
• Worked on Data migration Project with SRIT SOBHA Renaissance IT India for HIS Hospital Information System on Oracle 9 to 10g and Tricore Solutions from SQL Server to Greenplum.
• Experience in Installation and Administration of Greenplum/ PostgreSQL on RedHat, SUSE, Fedora CentOS Linux.
• Expertise working as Linux Administrator Red hat-RHEL 4/5 , OEL 5.6, CentOS 5/6, Fedora 12 SUSE 10 Linux including Installation, Administration, Middle Level Performance Monitoring etc.
• Experience working with T V Rheinland Japan Ltd as a PostgreSQL 8.3/9.1 and Oracle DBA.
• Experience working with Brace bridge MA as a Greenplum DBA.
• Experience working with DTCC Texas as a Greenplum DBA.
• Provided 24/7 On-call support for production databases.
• Experience Working on VMware Server 2.0 on Linux and Windows workstation.
• Knowledge of Cassandra architecture.
• Knowledge NoSQL Databases and Cassandra 1.2.
• Knowledge on monitoring solutions for Cassandra.
• Knowledge on backup and high availability strategy for Cassandra based on our specific workloads.
• Experience in setting up HortonWork/Apache Hadoop Installation.

PROFESSIONAL EXPERIENCE

Client : Confidential

Role : Greenplum DBA, Oracle DBA, MySQL DBA

Environment : Greenplum DCA 1.2.0.0 FULL RACK DCA 4.2.7.0 4.3 , Oracle 11.2.3.0, RHEL 5.6 on all Dev, QA, PSE, PROD.

Responsibilities:

• Installing/Creating Greenplum DCA on 1/4 , 1/2 , Full RACK on RHEL.
• Vendor Coordination EMC and Raising SR.
• 11g Golden Gate Flat file to Greenplum Data migration.
• Upgrading Greenplum Database Software DCA 4.2.1.0 to 4.2.5.1.
• Upgrading Greenplum Database Software DCA 4.2.5.7 to 4.3.0.0
• Installing Greenplum Command Center 1.2.0.0.
• Installing Greenplum DCA 1.2.0.0.
• Upgrade Greenplum Appliance.
• Managing Monitoring Greenplum DCA using Command Center.
• Monitoring Database and performance using Pivotal MoreVRP.
• Configuring ESRS Dialhome with Greenplum DCA.
• Weekly Maintenance activity such as reindexing, partition monitoring, vacuum, running gpcheckperf.
• Daily Maintenance using gpstate, pg acitivity stat, gpssh, pg locks, gp bloat, gp skew, gp logs, gpcmdr.
• Installing/Configure Attunity 3.1.1.163 Replicate Client.
• Installing/Configure Attunity 3.1.1.161 Replicate Server.
• Extensive knowledge on Big Data Technology.
• Experience working on Greenplum Attunity replication, migrating Oracle 45TB to Greenplum DCA.

Client : Confidential

Role : Greenplum DBA, Oracle DBA, MySQL DBA

Environment : Greenplum DCA 1.2.0.0 RACK, RACK DCA Database 4.2.1.0 4.2.5.1, Oracle 11.2.3.0, RHEL 5.6 on all Dev, QA, PSE, PROD.

Responsibilities:

• Installing/Creating Greenplum DCA on 1/4 ,1/2 , Full RACK on RHEL.
• Vendor Coordination EMC and Raising SR.
• 11g Golden Gate Flat file to Greenplum Data migration.
• Upgrading Greenplum Database Software DCA 4.2.1.0 to 4.2.5.1.
• Upgrading Greenplum Database Software DCA 4.2.5.7 to 4.3.0.0
• Installing Greenplum Command Center 1.2.0.0.
• Installing Greenplum DCA 1.2.0.0.
• Upgrade Greenplum Appliance.
• Managing Monitoring Greenplum DCA using Command Center.
• Monitoring Database and performance using Pivotal MoreVRP.
• Configuring ESRS Dialhome with Greenplum DCA.
• Weekly Maintenance activity such as reindexing, partition monitoring, vacuum, running gpcheckperf.
• Daily Maintenance using gpstate, pg acitivity stat, gpssh, pg locks, gp bloat, gp skew, gp logs, gpcmdr.
• Tuning Greenplum Database using gpcheckperf, gpexplorer utilities, explain query.
• Managing routine Maintenance activity gpcheckcat, vacuum, backups, segment monitor
• Backing up Greenplum tables, Database parallel, non-parallel to Data Domain.
• Data loading using noparallel COPY, parallel Loading using gpfdist gpload.
• Routine password management using dca setup.
• Configuring LDAP, PgAdmin using pg hba.conf.
• Configuring LDAP, PgAdmin, SMTP on Greenplum DCA.
• Greenplum Database Segment recovery.
• Checking omreport for disks, memory, chassis system events.
• ITIL Skill set requirement Problem Management/Incident Management/Chain Management etc .

Clients : Confidential

Role : Oracle DBA, Greenplum Engineer, PostgreSQL, Oracle BI Apps DBA

Environment : CentOS 5/6, RHEL 5/6, Postgresql 8.3/9.0, Greenplum 4.1

Responsibilities:

• Installed, Configured and Administered Greenplum/PostgreSQL Databases in Dev, Test and Production environments.
• Monitoring Greenplum Systems Enabling System Alerts Notifications, Checking System State, Checking Disk Space Usage, and Checking of Data Distribution skew .
• Upgraded Greenplum Database from 4.1.1 to 4.1.2.
• Setup Greenplum Database Backup and tested out Restore strategies gpdump/gprestore using gpcrondump and used gpdetective tool.
• Created System Specific Procedures for managing Greenplum Database Administration Activities.
• Setting up of monitoring scripts to make sure database is in running 24 7.
• Worked with Developers in tuning Greenplum Database Queries/Procedures.
• Configured Greenplum Perfmon Tools.
• Monitoring Workload Data distribution Greenplum Database.
• Installation, configuration of Oracle 10g and 11g on Oracle Enterprise Linux 5.6 OEL
• Oracle 11g Administration and support.
• Monitoring Backup Recovery RMAN Differential, Cumulative , Export/Import, Data Pump, User Managed Backups.
• Created, Managed, Monitored Configured Network Settings, Archive logs, Undo segments, Control Files, Standby by, Tablespaces, Data file, Alert log, Trace log, RMAN, Enrolling User Management Security, DBVerify Utility, Monitoring Multimaster Replication, Online backup, logical backup.
• Installed and setup Oracle BIApps 11g environment OBIEE 11G, OBIA 7.9.6.3, DAC 10.1.3.4.1, INFORMATICA 9.1 on Linux and windows servers.
• Setup and helped design database for ETL Testing Tool developed using Perl and PHP.
• Basic Monitoring of Oracle 11g RAC and DataGuard environments.

Confidential

Role : Oracle 9i,10g Database Administrator , PostgreSQL 8.3/9.1 Administrator Linux SUSE 10, RHEL Server 4.0 and Fedora 12 Administrator

Responsibilities:

• Worked on Projects Brand Risk Management, T V Rheinland STAR, SecureShipment System, NIKE GOLF, BrandProtection System, HIS, Rconstruct System.
• Installation, Configure, Managing , Monitor for all Production and UAT servers.
• Oracle 10g/11g Administration, Installation, configuration on Linux and Windows 2003 servers.
• Other responsibilities included Creating, Managing, Monitoring Configuring Network Settings, Archive logs, Undo segments, Control Files, Standby by, Tablespaces, Data file, Alert log, Trace log, Enrolling User Management Security, DBVerify Utility.
• Monitoring Multimaster Replication.
• Managing Monitoring RMAN Hot/Online backups, logical backup running on 24/7 .
• Postgresql Administration: Installation, Configuration Postgresql Standy Server, Scheduling Hot backup, pg dump, pg restore, Managing Slony Replication, Ruby Replication, Vacuum analyze.
• Check and Verify all instances are up/running using Nagios.
• Checking Email alerts on Daily/Montly and Hourly basis for all running on Production/UAT instances.
• Linux Administration: Installation, Scheduling Cronjobs, writing shell scripts, monitoring logs, Basic Performance Linux.

Confidential

Role : Oracle 10g Database Administrator/Engineer.

Greenpeace India is a environmental Non Profit Organization with presence in 40 countries across Europe, Americas, Asia and Pacific. Greenpeace's work in India is focused on four broad campaigns namely, stop climate change, sustainable agriculture, preserving the oceans and preventing another nuclear catastrophe.

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g on Linux, Windows Server 2003.
• Creating, Managing, Monitoring Configuring Network Settings, Archive logs, Undo segments, Control Files, Tablespaces, Data file, Alert log, Trace log, RMAN, Enrolling User Management Security, DBVerify Utility.

Confidential

Advinus Therapeutics is a research-based Pharmaceutical Company founded by leading global pharmaceutical executives and promoted by the TATA Group. The company is the first of its kind in India to offer end-to-end development services to the global Pharma, Agro and Biotech industries and at the same time creating long-term value through internal and collaborative innovative Drug Discovery.

Responsibilities:

• Project Worked on Accelrys, SDMS Scientific Database Management Systems .
• Installed, setup and maintained Oracle 10g on Linux, Windows XP.
• Wrote SQL Queries, PL SQL Procedure, Packages, Cursors.
• Creating, Managing, Monitoring Configuring Network Settings, Archive logs, Undo segments, Control Files, Standby by Database, ASM, Flash Recovery Area, LOGMNR utility, Tablespaces, Data file, Alert log, Trace log, RMAN, Enrolling User Management Security, DBVerify Utility.
• Backup Recovery RMAN Differential, Cumulative , Export/Import, Data Pump, User Managed Backups.
• Managed and installed Third Party Tool Accord Client software on Pharma instrument machines.
• Setup Symentac 10d Backups.

Confidential

Role : Junior PostgreSQL, Oracle 9i DBA, Red Hat Linux 4

National Informatics Centre NIC is a premier Software Technology institution of the Government of India, established in 1976, for providing e-Government / e- Governance Solutions adopting best practices, integrated services and global solutions in Government/Pubic Sector.

Responsibilities:

• Installation, configuration of MySQL/PostgreSQL, Oracle 9i on Linux, Windows XP. Writing SQL Queries, Client Installations etc.
• Monitoring the Database Space, Memory using Oracle Enterprise Manager and handling maintenance of archive redo log files.
• Creation of Tablespace. Performing Regular DBA Activities such as Backups, Modifying Database Structures, reading Alert logs, troubleshooting errors, Space Management, etc.. Enrolling users and maintaining system security by defining privileges.

Confidential

Technologies : MYSQL, Oracle 8i, SQL, Windows Server 2000.

Description :

My role required me to handle requests for new Oracle 8i, MYSQL database creation, designing databases, backups restore of database. Creating USERS, assigning privileges, Writing SQL Queries PL-SQL Programs.