Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Mohammed Faisal Chemmala

Mohammed Faisal Chemmala

Dubai, Dubai

Message
MENU ☰

Emaratech fz LLC.

It infrastructure administrator

Projects:

​EGATE(Electronic Gate):
​emaratech eGates is a user friendly access gate developed for the processing of people in areas such as ​passenger terminals and other secure areas. emaratech Immigration e-Gate has integrated smart card and ​biometric technologies offering high speed, accurate, secure and user friendly interface to automate the ​traditional passenger clearance at the immigration counters.
FAWRI:
​FAWRI is a flagship application addressing the immigration domain market. The application provides a web ​interface for the immigration back office with an optional back office approval system. FAWRI application ​addresses the following business areas of the immigration business: entry permit section, residence section, ​establishment section, passport section, ports and control and investigation.
eServices:
GDRFA-D eServices is a fully integrated immigration processing system designed to minimize the time you spend on managing your application and other transactions with GDRFA-D

Jobs & Responsibilities handled

• Responsible for the day-to-day monitoring of the systems for 24 x 7 call support of the production application database environments
• Extensively worked on Real Application Cluster (RAC).
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Maintaining archive data on appropriate storage devices.
• Tracing, troubleshooting with database performance and tuning issues.
• Export/Import of oracle databases.
• Tuning SQL queries.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Analyzing and validating database objects.
• Coordinating with team members.
• Monitor regular database backups and disaster recovery sites(RMAN and OS backup)
• Database health check in daily basis(Oracle , SQL server).
• Maintain staging databases
• Resolve issues with the database and escalate the issues to Team Lead in a timely and accurate manner
• Test the update request coming from Developers in stage environment and deploy in production.
• Take logical backup(EXPDP/IMPDP) after each production deployment .
• Generating reports/data upon user/developer request.
• User administration and security implementation in user level as per business policy.
• Production support for SQL server 2000 DB.
• Resolving issues/failures related to replication.
• Backup planning
• Space monitoring and cleaning the backup sites to avoid future backup failures.
• Clearing the database locks.
• Checking the server health in specific intervals(RHEL5,AIX).

Career medium 04
Career
Career medium 01

Adarsh solutions pvt ltd.

DBA

Client: ​IHS Inc.​​​​​​​​​
Bangalore, Karnataka.
Project: CATS-Docs, IRIS-21, UK Regulatory.

CATS-Docs: Which deals the data syndication from catalog data to E-Document related to US military equipments.
IRIS-21: The IFDU (IRIS21 Frequent Data Update) system allows IHS to provide rapid updates to the IRIS21 databases installed at remote client sites, including the Hosting Centre. The system collects updates made to the IRIS21 Production (PROD) database instance on salamander in Tetbury. These updates are then processed by the delivery group, and posted the IHS Energy web site for download by a client. The client then runs a procedure that updates their local database.
UK Regulatory: This is an ETL Project (UKRegulatory) which read the data from file which is kept in particular place (Arrival folder) then validates, cleanse, transform and load into the database.


Jobs & Responsibilities handled

• Creating users & privileges with appropriate roles and levels of security.
• Performing Logical backups and recovering specific object or schema using Data pump utility.
• Monitoring and performing daily incremental backups, weekly backups using RMAN.
• Backup of the Production & Development Databases, based on business requirements.
• Schema, Table, Database refreshes on demand for dev teams.
• Interaction with client/users on various issues.
• Working under the environment of 24/7 DBA support.
• Creating and monitoring the different tablespaces like user, Undo, temporary Tablespaces.
• Transported tablespace from production database and plugged-in it in development database for the usage of developers.
• Taking Differential backups of the database using Recovery Manager.
• Monitoring Alert log & System log files.
• Planning and performing ONLINE (HOT BACKUP) as well as OFFLINE (COLD BACKUP) backup and LOGICAL BACKUP (EXPDP/IMPDP).
• Adding the roles, profiles to the user upon request.
• Troubleshooting Oracle connectivity issues.
• Moving data between databases using utilities like Data Pump and Transportable Tablespace.
• Taking care of all other daily routine DBA tasks like creating users, roles, Tablespaces, addressing alerts triggered from monitoring tools etc.
• Handled database server tuning, maintaining documentation, capacity planning and database security
• Monitoring of stored procedures and jobs in MS-SQL 2005 for data transfer from MS SQL to Oracle 8i
• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts.
• Closely working with ETL developers and giving technical support for them.

Career

RISCE Systems pvt ltd

DBA

Project: RHMS (RISCE Hospital Management System).

RHSMS: This project deals with all kind of data which related to a hospital system like Patients are admitted to the hospital and assigned beds, and discharged once their treatment is completed. Patients are treated by doctors and nurses. Doctors may recommend tests for each patient to be conducted in labs performed by other doctors who are specialists. Each test conducted would show results, which would be tracked. Patients and their insurance companies may be charged fees for various services rendered, including consultations with the doctor, tests conducted, and the stay at the hospital. Set up and track a billing account for each patient for each visit. Propose reasonable extensions to this basic set of functions, such as tracking the medications prescribed, tracking outpatients, and departmental information for doctors and nurses indicating their respective specializations etc.


Jobs & Responsibilities handled

• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Daily verifying that all instances are up & archive old log entries to keep manageable log size.
• Resolving database errors encountered by users, database connection issues, schedule maintenance to resolve any issues found through monitoring.
• Hot backups using a combination of incremental, differential and full RMAN backups according to the retention policy.
• Work as part of a team and provide 24/7 support when required.
• Maintaining archive data on appropriate storage devices.
• Adding the roles, profiles to the user upon request
• Handling issues on development and production databases.
• Check whether database is running, check network connectivity to database.
• Export/Import of oracle databases.
• Troubleshooting Oracle connectivity issues.

Career medium 03
Career

Anjuman engineering college

Bachelor of engineering, Computer science and engineering