Senior DBA

Mohammad Perwez Alam Cell phone: 408-***-****/*****16

Santa Clara, CA ************@*******.***

Objective:

Looking for the challenging position as a Senior Oracle DBA (Database Administrator).

Summary:

• Senior DBA/Oracle Database Administrator with around 17+ years of experience in Enterprise solution, Telecommunications & Wireless, Engineering & Construction and Software companies.

• Well and in-depth experience in Management/Administration, Tuning, Development and Support of very large volume and multiple Databases in Production, Lab/Test and Development environments on 24x7 basis.

• In-depth experience in Database Design, Installation, Upgrade, Patches, Migration, Cloning, Partitioning, Data Archival, Data Load, Backup & Recovery by scripts/RMAN.

• Broad experience in Fail-over/High Availability solutions like Replication (Advanced/Multi Master, Basic, Hot Standby, Streams), Data Guard (Physical and Logical), Active Data Guard, Snapshot Standby, Real Application Cluster (RAC) and ASM.

• In-depth experience in Performance Tuning of Database: Memory, I/O, Contention, Locking, SQL, PL/SQL, Applications.

• Database SOX Compliant, Auditing, OS, Applications Baselines.

• Experience in Administration and Support of Systems, Applications and Software Development.

• Strong communication and analytical skills with very good experience in problem solving.

• Also worked as PostgreSQL and MySQL Database Administrator.

Technical Skills:

Server: Sun-T5240/Fire-V490/V445/V440/V245, Sun Ultra Enterprise-6000/5000/4000 /3000/1000, Sun Sparc 20/10, Dell PowerEdge, Linux 2.6, VMware Server 2.0, RDI, HP-9000/782/A180C, IBM RS-6000 (F50/F40), HP NetServer/Lx-Pro, Compaq Proliant- 6500R /6000R / 5000R/2500R, Dell PowerEdge 2300, NCR System, DEC Alpha 2000/500/300.

Workstation: Sun Ultra Enterprise 10/5/2/1, Dell Workstation 170L/400/Optiplex, Digital Prioris HX 590DR/XL Server 5133, Compaq Deskpro XL 5133.

Client: PC: Dell Dimension 4550/XPS T450, Digital Venturis FX, Compaq Deskpro 2000/Presario 5150, Datamini, HD, Dell Vostro, Latitude, ToshibaCDT.

Operating System: Sun Solaris 2.10/2.9/2.8/2.x, Ubuntu 10.04, Red Hat Enterprise Linux 4, HP-UX 11.0 /10.20, IBM AIX 4.x/3.2.5, MS Windows 7/XP/2003/2000/NT/, SCO UNIX 3.0, Open VMS AXP 6.1.

RDBMS:

Oracle: Oracle Enterprise Edition 11g Rel1/2, 10g Rel1/2, 9i, 8i/8.0.x/7.3.x/6.0, Oracle Grid Control, Database Control, Oracle Enterprise Manager 10g /9i, Oracle Diagnostics/Tuning/Change Management Packs, Oracle Multi Master Replication Manager, Oracle Streams, Oracle RAC, Oracle ASM, Oracle Data Guard, Active Data Guard, RMAN, SQL, PL/SQL, SQLJ, Forms 11g/10g /9.x/6i, Reports 11g/10g/9.x/6i, Oracle Application Server 11g/ 10g/9i, Discoverer 11g/10g/9i, Portal 11g/10g, Pro*C, Oracle Financials R12/R11, Developer/2000, Designer9.x/2000, ODI 10.1.3.

Postgres/MySQL: PostgreSQL 8.4, PgAdminIII, MySQL 5.1, MySQL Workbench 5.1.

SQL Server: MS SQL Server 7.0/6.5 Enterprise Edition, SQL Enterprise Manager.

Scripts: SQL Script, PL/SQL, UNIX Shells Script, Perl Script, MS NT DOS Script.

S/W and Tools: Toad 8.0, Brio 6.6.4, BSCS 9X, Visual Basic 5.0, C++ 5.0, Unix C++ 4.2, E/R Win, MS JDeveloper 3.0, Perl, Java JDK, JPA, Hibenate, Clear Case, Subversion,ARS Remedy 4.0,Reflection for Unix,Exceed on Demand,putty.

Professional Experience:

Company: Globalstar Inc, Milpitas, CA 08/99 – Till Date

Role: Sr. DBA

Responsibilities: Responsible for the following Management/Administration, Tuning, Development and Support activities for Production, Lab/Test and Development Databases on 24x7 basis for Business Software Systems, Engineering Ground Operations Control Center, Globalstar Systems Planning Center, Accounting Finance & Billing, Data Warehouse departments.

• Database Fail-over/High Availability Solutions:

• Data Guard/Active Data Guard: Installation and setting up of databases in Data Guard environment by physical/logical/ snapshot standby option – as primary database in primary site, physical standby database in alternate site, logical standby database in alternate site and switchover from primary to physical, logical and vice-versa, convert physical database to snapshot standby database and vice-versa.

• Oracle database RAC (Real Application Cluster) and Oracle ASM: Installation and setting up of databases in RAC environment on multiple nodes and administration.

• Database Advanced Symmetric Multi Master Replication/Streams: Installation and setting up of databases in a replicated environment by advanced symmetric multi master replication option, providing fail-over security. Replicating data and file system from primary site to alternate site, synchronization of databases, switch over from primary site to alternate site and vice-versa.

• Database Hot Standby Replication: Installation and setting up of databases in a Replicated environment by Hot standby option –as primary site and alternate site and activate hot standby database and open it in read or read & write mode.

• Database Tuning:

• Tuning of database Performance like database Memory tuning, I/O tuning, Contention tuning, Locking, SQL Tuning, PL/SQL application tuning, etc by using Scripts and Tools: Database Grid Control, AWR reports, dbms_stats, statspack and other packages, SQL Performance Analyzer, etc.

• Database Table and Index Partitioning and maintenance to enhance the database performance.

• Monitoring of database status and performance by scripts and Database Control/Grid control

• Database Backup and Recovery Strategies and Procedures:

• Hot/Online backup, Cold/Offline backup and Export/Export Data Pump backup from the Scripts and RMAN utility. Monitoring of database backup and maintaining the status of database backup logs.

• Database Recovery strategies and procedures. Recovery of database incase of database crash, CPU/memory crash, disk/media failure, block corruption, database server failure, disasters, etc.

• Database Cloning: Move/create database from existing database to new database on same server or to same database on different server by cold backup or by hot backup, archived redo logs and from primary to physical / logical/snapshot standby database by Scripts and RMAN utility.

• Database Security and Access: Establishing and maintaining database access rights, security, profiles, roles and assign privileges to roles/users. Resource allocation, user validation, password management, etc. through profiles. Database auditing for SOX Compliant.

• Data Load and Conversion: Creating/populating data-based on the requirements. Data load/conversion from flat-file etc. to Oracle database by the tools: Stored procedure, Sql*loader, Perl, etc.

• Data archival/deletion: Data archival/deletion procedures based on the requirements by triggers, ETL process, etc.

• Database Space Utilization: Management and tracking of space utilization of databases, tablespaces, tables, indexes and disk spaces. Oracle Advanced Compression.

• Database Upgrade and Migration: Database Upgrade and Migration from Oracle 9i/10g to 11g, from 8i/9i to 10g, from 7.3.4/8.0.5/8i to 9i and from 7.3.4 to 8.0.5/8i/9i.

• Database Installation and Patches: Installation and patches of Oracle database software 11g, 10g Rel 2,1/9i/8i /8.0.x/7.3.x and also for PostgreSQL 8.4and MySQL 5.1 databases.

• Application Server and Business Intelligent Tools Installation and patches: Installation and patches of Oracle 11g/10g/9i Application Server,Web logic server,Forms 11g/10g/9.x, Reports 11g/10g/9.x, Discoverer 11g/10g/9.x, Portal 11g/10g/9.x, Oracle Financials R12.

• Mastersaf, ODI & Oracle Financials R12: Installation and setting up of Mastersaf application, ODI (Oracle Data Integrator), Oracle Financials R12 and interface for Taxation purpose.

• Other Activities:

• Planning and evaluating Oracle and also PostgreSQL/MySQLdatabase server hardware, database software, licenses.

• Database design and development. Planning for logical database and physical layout.

• Creation and maintenance of databases, tablespaces/datafiles, users, roles, schemas, tables, indexes, views, synonyms, sequences, procedures, packages, functions, links and other database objects.

• Configure database as dedicated or multi-threaded server (MTS), Primary/Physical/Logical Data Guard, RAC databases.

• Support in S/w Development and maintenance in Forms/Reports 11g/10g/9.x, SQL, PL/SQL and Shell scripts. Support and maintenance of different Applications.

• Conducting ORT (operations readiness test) for databases as per S/w release basis.

• Co-ordination with software developers, testers and other personnel for different database issues.

• Co-ordination with SOX Compliant Team to make the database SOX Compliant with different procedures, Database, UNIX, Applications baselines. Support to developers and end-users/testers.

• Managing and co-ordination with other DBAs.

• Also worked as PostgreSQL and MySQL Database Administrator.

Environment:

Server: Sun-Fire- T5240/V490/V445/V440/V245, Sun Ultra Enterprise-6000/5000/4000/ 3000/1000, Dell PowerEdge, Linux 2.6, VMware Server 2.0, Compaq Proliant 2500R.

Workstation: Sun Ultra Enterprise 10/5/2/1, Dell Workstation 170L/400/Optiplex

Client: Dell Dimension 4550/XPS T450, Compaq Presario 5150, Dell Latitude CPi.

Operating System: Sun Solaris 2.10/2.9/2.8/2.x, Ubuntu 10.04, Red Hat Enterprise Linux 4, HP-UX 11.0, MS Windows 7/XP/2003/2000/NT.

RDBMS:

Oracle: Oracle Enterprise Edition 11g Rel1/2, 10g Rel1/2, 9i, 8i, 8.0.x, 7.3.x, Oracle Grid Control, Database Control , Oracle Enterprise Manager, Oracle Diagnostics/Tuning /Change Management Packs, Oracle Multi Master Replication Manager, Oracle Streams, Oracle RAC, Oracle ASM, Oracle Data Guard, Active Data Guard, RMAN, SQL, PL/SQL, SQLJ, Pro*C, Forms 10g/9.x /6i/4.5, Reports 10g/9.x/6i/4.5, Oracle 10g/9i Application Server 9.0.2/1.0.2, Oracle Discoverer 11g/10g/9i/3.0.x, Oracle Portal 11g/10g, Oracle Designer 9.x, Developer/2000, Oracle Financials R12/R11, Web Server, Oracle Jserver, ODI 10.1.3.

Postgres/MySQL: PostgreSQL 8.4, PgAdminIII, MySQL 5.1, MySQL Workbench 5.1.

Scripts: SQL Script, PL/SQL, UNIX Shells Script, Perl Script, MS NT DOS Script.

S/W and Tools: Toad 8.0, Brio 6.6.4, BSCS 9X, MS Vis. C++ 5.0,Unix C++ 4.2,Motif 1.2.5, MS JDeveloper 3.0,JDK-1.x/1.2, JPA, Hibernate,E/R Win,Persistence7/3.5, Perl, JDK, Rendezvous 4.2, ARS (Remedy) 4.0, Reflection for Unix, Exceed on Demand, putty.

Company: JBAS Systems Inc, Santa Clara, CA 05/98 – 08/99

Role: DBA Consultant

Clients: Per-Se Technologies, San Jose, CA, NetForce Inc, San Francisco, CA, Quantum Corporation, Colorado Springs, CO

Responsibilities: Responsible for the following Oracle Database Management/Administration activities for development, test and production databases at different client sites.

• Planning and evaluating Oracle database server hardware, Oracle database software.

• Database design and development. Planning for logical database and physical layout.

• Installation, upgrade and patches of Oracle database software.

• Creation and maintenance of databases, tablespaces/datafiles, users, schemas, tables, indexes, procedures, links and other objects.

• Configure database as dedicated or multi-threaded server (MTS).

• Database access rights, security, roles and assign privileges.

• Creating/populating data based on the requirement. Data conversion from flat-file to Oracle database.

• Database Cloning: move/create database from existing database to new database on same/different server or to same database on different server by cold backup or by hot backup and archived redo logs.

• Database Migration from Oracle 7.3.4 to 8.0.5, from 8.0.4 to 8.0.5.

• Database Backup procedures: Hot/Online backup, Cold/Offline backup and Export backup. Monitoring of database backup. System backup.

• Database Recovery strategies and procedures. Recovery of database incase of database crash, disk/media failure, etc.

• Database Basic Replication: Installation and setting up of databases in a replicated environment by basic replication option. Replicating data from master site to snapshot site through snapshots and updatable snapshots.

• Management of space utilization of databases, tablespaces, tables, indexes and disk spaces.

• Monitoring of database status and performance.

• Tuning of database Performance memory, I/O, Contention, Locking, SQL and PL/SQLTuning.

• Co-ordination with software developers, testers and other personnel for different database issues. Support to developers and end-users/testers.

• Also worked as MS SQL Server Administrator and Systems (NT/UNIX) Administrator.

Environment:

Server: Sun Ultra Enterprise-5000/4000, Sun Sparc Server 1000E, Sun Sparc 20/10, RDI, HP-9000/782/A180C, IBM RS-6000 (F50/F40), HP NetServer/Lx-Pro, Compaq Proliant 6500R/6000R/5000R/2500R, Dell PowerEdge 2300.

Workstation: Dell Workstation 400, Digital Prioris HX 590DR, XL Server 5133.

Client: Dell-PC, HD-PC, Digital Venturis FX PC, Compaq Deskpro 2000PC, Compaq Presario 5150, Datamini, Laptop-Toshiba 4020 CDT.

Operating System: Sun Solaris 2.6/2.5.1, HP-UX 11.0/10.20, IBM AIX 4.3/4.2/4.0, MS Windows NT 4.0, Win NT Server Enterprise Edition 4.0, Service Pack 4/3, Resource Kit for NT 4.0, MS Win. 95/98.

RDBMS:

Oracle: : Oracle 8.1.5/8.0.5/8.0.4/8.0.3/7.3.4 Enterprise Edition, Oracle 7.3.3/7.3.2 Server, Oracle Enterprise Manager (OEM), Oracle Diagnostics/Tuning/ Change Management Packs 1.6/1.5, Oracle Network Manager 3.1.0, SQL, PL/SQL, Oracle Developer/2000, Forms 3.0, ReportWriter 1.1, Pro*C, Oracle Designer/2000, Oracle Discoverer 3.0.8.

SQL Server: MS SQL Server 7.0/6.5 Enterprise Edition, SQL Enterprise Manager.

Scripts: UNIX shells script, Perl 5.0, MS NT Dos script, SQL script, PL/SQL.

S/W and Tools: MS Visual Basic 5.0, MS Visual C++ Prof. 5.0, MS Access 7.0/97.

Company: Bechtel India Pvt. Ltd., Gurgaon (New Delhi), India. 10/96 - 05/98

Project/Client: Reliance Refinery Project for Reliance Petroleum Ltd. (RPL), Jamnagar, India

Magic-World Theme Park Project, Dubai, UAE, Redhill/Millennium Power Project, Philippines.

Responsibility: Oracle DBA/ Automation Technologist.

Company: PT Infotimur Sistimatama, Jakarta, Indonesia. 07/96 - 08/96

Client: PT Unilever, Jakarta, Indonesia.

Responsibility: Oracle Database Consultant/DBA.

Company: Global Technology Solution Inc, Sacramento, CA, USA 12/95 - 04/96

Responsibility: Computer Software Consultant/Oracle DBA.

Company: King Abdulaziz City for Science & Technology, Riyadh, Saudi Arabia 05/95 - 10/95

Responsibility: Computer Systems Administrator/Oracle DBA.

Company: National Company for Co-operative Insurance, Riyadh, Saudi Arabia 05/93 - 04/95

Projects: Insurance System software packages (In-house development).

Responsibility: Oracle DBA/ Systems Analyst.

Company: The Indian Steel & Wires Products Ltd., Jamshedpur, India 10/90 - 05/93

Projects: Company software packages (In-house development).

Responsibility: Senior Computer Programmer/Analyst.

Company: Computel Systems & Services, New Delhi, India. 07/89 - 08/90

Projects: Office Automation, Payroll.

Responsibility: Computer Programmer/Software Engineer

Status: U.S. Citizen

Awards & Promotions:

Promoted as a Senior DBA in 2002. Recognition Award for Outstanding Achievement in Globalstar Inc.

Education/General : Master of Computer Science & Applications (MCA) in 1989.

Oracle 11g Rel1 DBA seminar/workshop done from Oracle University in March, 2009.

Oracle 11g Rel2 upgrade DBA seminar done from Oracle University in November, 2010.

Oracle 10g Rel2 RAC Administration course done from Oracle University in May, 2008.

Oracle Database 10g Administrator course done from Oracle University in December, 2004.

Contact this candidate