Developer Dba

Taher Khokhar

Oracle & Sql Sercver DBA

Mobile: +974-********

Address: -Al-wukair -Qatar

E-mail: *************@**********.***

About Me

A database administrator (DBA) with extensive experience designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments. Proficient in an assortment of technologies, including Oracle 11gr2, MS SQL Server, Windows and Linux.

Working Experience

Database administartor at Hamad International Airport(QATAR) (May-2018 to till date)

SQL Server DBA at Processware Systems Pvt Ltd(INDIA) (June-2017To May 2018)

ORACLE and SQL Server DBA at Intronicomunications (INDIA) (June-2016 To May-2017)

ORACLE DBA at Jain Hydraulics Pvt ltd (INDIA) (May-2015 To June-2016)

ORACLE DBA at WIT Solution(INDIA) (May-2013 to April 2015)

Roles and Responsibilities Under Taken

As a SQL Server DBA.

Installing SQL Server with Minimal Access Service Account to improve security.

Configured Log shipping, Replication and Mirroring.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as Database Backup, Integrity Verification, Replication Verification, Indexing and Statistics updates.

Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.

Managing and scheduling daily jobs relating to data transfers, backup and recovery and transaction log dumps.

Administration and Deployment of SQL Server Always On Availability Group and FCI Instance for HA solution.

Worked on Daily Email Reports, this notifies about the Database files Growth, Server Information and sql server agent job’s notifications.

Configured Reporting Services, Scheduling the Reports for Auto Generation.

Provide 24x7 supports for critical production systems.

Monitor the ticketing system and ensure resolving tickets with in the stipulated timeframe defined.

Ensure high levels of performance, availability, sustainability and security.

Analyze, solve, and correct issues in real time.

As an ORACLE DBA

Installation and Configuration of oracle 10g/11g on Linux OS and Windows environment

RMAN backup strategies.

Performance tuning including application tuning, Database tuning, OS tuning.

Rebuilding indexes and gathering stats for table, indexes, database.

Adding data files and resizing data files as per requirement.

Managing user profiles & Roles.

Management of control file, parameter file and Password file

Checking the status of the nodes and services

Managing backups (Hot, Cold & Datapump)

Interacting with client and team to resolve queries

Monitor the ticketing system and ensure resolving tickets with in the stipulated timeframe defined.

Projects Undertaken

Employees’ Provident Fund Organization(May-15 To June-2016)

E.P.F.O. (epfindia.gov.in) is the main project for labor ministry which involves Provident fund and pension fund for employers and employees. A project delivers fund to members which contributing money in the form of provident fund and pension for last age.

Client Employees’ Provident Fund Organization (EPFO)

Role Jr. Oracle DBA

Team Size 3

Databases & Tools Oracle 11g R2, SQL Developer.

Core Banking Solutions(June 2017 – May-2018)

CBS is a comprehensive solution aimed at meeting the requirements of the financial institutions. Built on latest technology platform, the solution offers unparalleled scalability and security to banks. it supports all the features and functionalities for smooth banking transactions for Client from the different part of world.

Client 150+ Urban Co-Operative Banks in Karnataka

Role Database Administrator

Team Size 25

Databases & Tools SQL Server 2008R2/2014/2016, SSMS.

ProdMaster(June 2017 – May-2018)

ProdMaster is a web based application which is providing all the Purchase Order, Sales and Inventory Information. This is used to record and retrieve different list of items information.

Client Repair And Return Technologies Pvt Ltd, Bangalore

Role Database Administrator

Team Size 25

Databases & Tools SQL Server 2008R2, SSMS.

Gate management System (May 2018 – Till Date)

G.M.S. planning of resources by analysing the active and seasonal flight schedules,Planning of flight and aircraft demand, Real – time access and visualization of pax, flight, airport dataReal – time alerting of allocators.

Client Hamad International Airport

Role Database Administrator

Team Size 20

Databases & Tools Oracle 11g R2, Putty, SQL Developer.

Access Control System (May 2018 – Till Date)

A.C.S is a application which is providing information related to access for all the available employees for particular regions on Airport, Manages the Cameras and Screens, Alarm Monitoring when unauthorized Access Happens and many more.

Client Hamad International Airport

Role Database Administrator

Team Size 20

Databases & Tools SQL Server 2008R2,SSMS.

Airport Operational Database(May 2018 – Till Date)

AODB intelligently governs seasonal, historic and live operational flight schedules and supports industry standard data sets, including IATA and ICAO airline and airport codes; aircraft types and irregularity codes; and airport standard reference data such as terminal IDs, gates and stand numbers, check-in desks and baggage carousels.Complex flight handling, such as managing and operating code share flights as well as inbound to outbound flight linkage, is handled reliably and efficiently.

Client Hamad International Airport

Role Database Administrator

Team Size 25

Databases & Tools Oracle 11g R2,SQL 2014,SSMS, Putty, SQL Developer.

Qualification

Gujarat Technological University.

Bachelor of Engineering: Information Technology. (Feb-2013)

Contact this candidate