Quality Assurance Oracle

MOHD EKRAMULLAH

E mail: aboinm@r.postjobfree.com

Mobile Personal: 91-970*******

Mobile Office: 91-978*******

Career Objective:

Intend to build a career with leading corporate of hi tech environment with

Committed & dedicated people, which will help me to explore myself fully and realize my

Potential. Willing to work as a key player in challenging & creative environment.

Experience Summary:

•Having 4.2 years of experience as Oracle DBA.

•Worked under the prestigious Agile Scrum Methodology.

•Good in analytical, problem solving and learning new skills.

•Ability to handle different versions of Oracle databases 10g and 11g.

•Good team player with excellent communication, interpersonal and writing skills.

•Experience in Installing and configuring oracle 10g and 11g on Linux operating systems.

•Strong skills in Handling Client Request, User Management, Cloning, troubleshooting.

•Creation and Management of Tablespace.

•Creating new users with quotas and maintaining security (profiles) and roles.

•Experience in Cloning software and database.

•Maintaining Control file, Redo log file, Data file, Data Tablespace, Undo Tablespace and Temporary

Tablespace.

•Working experience on Upgradation of different version of databases.

• Patching using Opatch utility of CPU and PSU .

•Ability to take backups as per the corporate policy and perform restore & recovery as when required.

•Performed different methods of backups like hot, cold and logical.

•Designing the Backup and Recovery strategy, and taking hot backups manually on need basis.

•Strategizing database using RMAN backup and recovery tool .

•Implemented and tested RMAN Backup strategies in production, testing environment for backup and

recovery.

•Provide support for Development and test databases.

•Checking alert log and trace files for errors.

•Analyze and Rebuild Index to rectify segment fragmentation.

•Monitoring the unwanted User Session and killing them if needed.

•Monitoring physical and logical backup strategies.

•Logical backup of database using DATAPUMP and EXPORT / IMPORT utility.

•Monitoring database and collecting statistics by using EXPLAIN PLAN, SQL Trace.

•Generating reports using STATSPACK and TKPROF,AWR,ADDM whenever necessary.

•Knowledge in Shell Scripting.

•Installing and configuring database on ASM with large diskgroups.

•Installing and maintaining database on RAC environment.

•Configuring DATAGUARD and maintaining database on both standby and primary databases.

•Migrating database from one server to another.

•Migration of NON RAC database to RAC ASM.

•Centralized monitoring of databases using OEM.

Skills:

Language : SQL

Database : Oracle 10g, Oracle11g and Enterprise DB.

Oracle Utilities : Export & Import, Datapump, SQL loader,

RMAN, OEM 12c Cloud control, Oracle Grid Control,

Toad, SQL Developer, RAC, ASM.

Environment Oracle10g, 11g, Red Hat Enterprise Linux4.x, 5.x

:

Operating system : RHEL & OEL (4.x, 5.x), Windows.

Network tools : VNC server, Putty, VPN.

Professional Experience

Currently employed as :

Oracle Database Administrator, Sphata Systems Pvt. Ltd, Chennai, INDIA.

May 2012 Till Date

Project 1: Quantros

Quantros is a leading provider of software and services to advance healthcare quality and safety

performance. Its Software as a Service (SaaS) based applications help over 2,000 healthcare facilities

improve their care environment, resource productivity and financial performance.

•Configuring RMAN backups .

•Creation of Tablespace and data files for the project requirement.

•Monitoring alert log file.

•Managing database storage structure.

•Resizing the datafiles and adding datafiles to Tablespace as per the requirement.

•Creating Users with Quota Management.

•Logical Backup Using Export & Import utility.

•Creating user Profiles.

•Monitoring unwanted sessions and killing them if needed.

•Monitor physical and logical backup and Recovery Strategies.

•Resolving issues and bugs related to databases.

•Applying CPU and PSU patches using Opatch utility.

•Database and Health checks and performing cleanup jobs.

•Managing database storage structure.

•Performed backups, recoveries and cloning using RMAN.

•Configuring Dataguard and maintaining database on both standby and primary databases.

•Managing Enterprisedb.

•Configuring RAC and monitoring databases over Cluster.

•Migration of databases on to different servers incase of server failures

Project 2: Wal Mart

Wal Mart Stores, Inc., branded as Wal Mart, is an American multinational retail corporation that runs

chains of large discount department stores and warehouse stores. Database record and update each

and every product in detail along with product registrations and customer ids through various

applications and ERP interfaces, multiple Oracle databases in development integration test, user

acceptance test, quality assurance, performance and production environments, deliver seamless

information to the operational teams helping them to focus on innovate solutions that reduce cycle

times for our customer and accelerate the delivery of life enhancing distribution departments

Client : Quantros

Technical Environment : Oracle 11g

Time period : May 2012 – Till date.

Role : Oracle DBA.

2) Oracle Database Administrator, Intranz Solutions, Hyderabad, INDIA.

Dec 2008 – April 2012

Project 1:

Client : Ericsson

Project name : Ericsson Dataservices.

Technical Environment : Oracle 10g & 11g

Time period : Dec 2008 to June 2011.

Role : Oracle DBA

Description:

Ericsson is a world leading provider of telecommunications equipment and services to mobile

and fixed network operators. Over 1,000 networks in more than 180 countries use our network

equipment, and more than 40 percent of the world's mobile traffic passes through Ericsson networks.

Project 2 :

Client : K line Logistic services

Technical Environment : Oracle 10g & 11g

Time period : July 2011 to April 2012.

Role : Oracle DBA

Kline is a transportation/logistics company. The company devotes extensive of air freight, sea freight,

logistics and passenger service. Database record and update each and every delivery in detail along

with product registrations and customer ids. through various applications and ERP interfaces, multiple

Oracle databases in development, integration test, user acceptance test, quality assurance,

performance and production environments, deliver seamless information to the operational teams

helping them to focus on innovate solutions that reduce cycle times for our customer and accelerate the

delivery of life enhancing distribution departments to fetch the details of the containment to be

delivered.

My role and Project synopsis:

•Creation of new databases as required by the client.

•Installation of Oracle software 10g/11g on Linux.

•Capacity planning to organize the more databases.

•Monitoring alert log file.

•Resizing the datafiles and adding datafiles to Tablespace as per the requirement.

•Security management and creating Users with Quota

•Monitor physical and logical backup and RMAN Recovery Strategies.

•Documenting RMAN backup report and Emailing across all the DBA’s.

•Logical Backup Using Export & Import utility.

•Monitoring the object growth and space management.

•Analyze and Rebuild Indexes.

•Monitoring the database using Grid control.

•Working as a team and as an Individual Upgraded database from 11.1.0.6 to 11.1.0.7 on Linux.

•Daily monitoring the database alert log file and trace file for errors/Issues.

•Killing Oracle sessions as well as OS processes

•Resolving issues and bugs related to databases.

•Upgraded database from 10g to 11g on the test System.

•Supported backup and recovery using cold backup, hot backup and RMAN in 11g in Linux environment.

•Cloning database from production to test on adhoc basis.

•Creating Tablespace, adding datafiles to the Tablespace and monitoring their usage.

•Generation of AWR, ADDM reports and Statspacks for performance tuning.

•Configuring RMAN Daily and Weekly backups.

•Proactive Health checks of databases.

Educational Qualification:

•Bachelor of technology in Computer Science and Information Technology (CSIT) from Sree

Visveswarayya Institute of technology and science, JNTU Hyderabad in 2006.

•Board of Intermediate 2002.

•Board of Secondary School Education in 2000

Oracle Certification:

•10g Oracle Certified Associate (OCA)

Personal Details:

Name : Ekramullah.Mohammed

Marital status : Single

Nationality : Indian

Languages : English, Hindi, Telugu.

(MOHD EKRAMULLAH)

Contact this candidate