Umaid Qureshi

Oracle professional with 5 years of experience in relational database installation, configuration, creation, tuning, and maintenance and user management. Working as Oracle Database administrator on LINUX and windows.

Experience with client-server-based databases on a 24x7 basis for Production, Development and Test Environments. Specialize in Oracle upgrade, patching, advanced PL/SQL queries & performance tuning.

Managed

Export & Import, Data pump. Used SQL Loader for text files, flat file to load data.

Experience as a Database Administrator for Oracle 11g/12c/19c under UNIX, Linux, Windows NT. Involved in monitoring, tuning, and prioritizing multiple projects and held responsibility for scheduling by deadlines.

Managing Database

Structure, Storage Allocation, Building objects Tables Index segments, Views, Constraints, Security Roles and Privileges. Strong technical and leadership working as Database Administrator. Ability to work and manage projects independently, with a proven ability to meet and exceed set goals and deadlines.

Work effectively with colleagues and clients at all levels. Detail oriented multi-faceted skill set, with exemplary organization and project management skills. Strategic thinker and planner, skilled in the design and execution of effective IT solutions.

Strong skills in business process analysis, relationship development and strategic alliances building.

Experience in RAC (Real Application Clustering) and expert in RMAN (Oracle recovery Manager)

Oracle Database Administrator at Techno Service (2024-11 – Present)

Involved in design, oracle install, patch, upgrading Oracle databases and support on Oracle 12c/19c.

• Plan and implement backup and recovery strategies using RMAN, Data Pump.
• Monitor and tune database performance. Manage capacity planning, storage allocation, and growth forecasting for databases.
• Apply security best practices: user/role management, least-privilege access, encryption, auditing, and compliance controls.
• Automate routine tasks (patching, backups, monitoring) using scripts.
• Troubleshoot production incidents, perform root-cause analysis, and drive remediation.
• Support database provisioning for development, test, and production environments.
• Collaborate with development teams on schema design, SQL tuning, and deployment best practices.
• Participate in on-call rotation for after-hours support.
• Involved in data migration, data replication, user administration, backup and recovery, performance tuning, issue investigation, issue resolution, and general administration.
• Good Experience in Oracle SQL/PLSQL, and shell scripting.
• Experience working in PeopleSoft Environments.
• Working closely with infrastructure teams (servers, network, etc.) to troubleshoot and resolve problems.
• Coordinated with other team members to ensure software consistency across the Oracle landscape.
• Participated in the IT Change Management process and validated/approval all Oracle database related changes.
• Worked in 24X7-distributed environment ready to support any time required by the IT team.
• Developed scripts to execute and automate to run Sql loader & pl/sql packages and added in crontab file for daily, weekly and Monthly cronjobs
• Modified and added new database triggers, packages, procedures, functions, utilities for application development for the applications for better performance.
• Wrote scripts for scheduling hot backups and table space management.
• Changed passwords for privilege users and changing links (Dropping & recreating) with new passwords for security.
• Writing SQL and Shell scripts to automate batch jobs and performance monitoring.
• Created Queries reports as requested by department managers. Migration of different applications from development database to test database, production database, working in agile environment.
• Managing Table spaces, adding data files/resizing for the Table spaces filling up, coalesce the table space, managed extents.
• Using RMAN for backup/Database Recovery, and extensive use of Data pump.
• Performing data loads using SQL*Loader, and using EXTERNAL tables reading data from files.
• Maintaining user accounts and their passwords.
• Building table indexes for improving performance. Involved in creating/customizing PLSQL programs (Package, Procedure, Functions, and Triggers).
• Involved in maintaining oracle databases on RAC environment on Oracle.
• Scheduled jobs through crontab with various schedules daily, weekly, and monthly.

Oracle Database Administrator at Capgemini (2022-05 – 2024-10)

• Involved in Installation, Upgrade & Patching of different components in Oracle.
• Experience with Replication including setup, troubleshooting issues and failovers - (Goldengate)
• Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).
• Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security
• Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management
• Experience with Schema creation, deployment, and maintenance.
• Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms
• Knowledge of Disaster Recovery setup and maintenance. Experience with Performance analysis, monitoring of queries and platform specific tuning.
• Involved in design, development, enhancement and maintenance of Oracle code including interfaces, Conversions, Migrations and Reporting.
• Oracle developer handling different versions of Oracle from 10g/11g/12c. Involved in running DDL statement, DML statement, stored procedures, import data into tables from flat file and extract data from tables into files or reports.
• As oracle developer developing/maintaining/customizing oracle procedure, function, packages, triggers. Supporting Java applications and involved in performance tuning.
• Involved in oracle partitioning and creating materialized views. Used SQL*LOADER for loading data.
• Experience in hot and cold backup and recovery procedures.
• Experience in schema management, tablespace, data file and extent management, as well as user and privilege management.
• Installations of Oracle11G, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Configuring RMAN and refreshing/Cloning databases using RMAN.
• Migration of system and applications code. Install and maintain the application software at server and client end.
• Create and maintain multiple databases. Extensive experience in working in multi-site environments
• Used IMP/EXP, IMPDP/EXPDP utility for export and import.
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines and resolved client connectivity issues. Constant monitoring of database space and space management. Installing/configuring Grid Infrastructure 11g/12c.Involved in monitoring databases via enterprise manager (11g/12c).
• Involved in development/maintenance/tuning of oracle sub programs including stored packages/procedures/functions.
• Setting up of Oracle user accounts and passwords, monitoring security. Involved in scheduling/monitoring jobs through AUTOSYS, Oracle Scheduler, and crontab.
• Table Partitioning, materialized views for performance. Creating Index Organized tables.
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (RMAN)
• Performing recovery in cases of system crashes.
• Table space creation, adding data files, allocated quotas to user and managed Disk space
• Writing database triggers, packages, procedures, functions, utilities for application development for the applications.

Oracle Database Administrator at VARIQ (2021-12 – 2022-04)

• Involved in oracle upgrades. Database backup and recovery using RMAN. Applying quarterly patches.
• Monitor database health/performance using OEM on daily basis and monitor table-space growth periodically.
• Involved in database patching and bug fixes using oracle utility opatch.
• Coded conversion packages using PL/SQL stored procedures, functions and views to convert the data. SQL tuning includes PL/SQL programming, stored packages/procedures/functions.
• Implemented materialized views in Oracle databases for performance improvement. Oracle DB developer creating tables, procedures, functions, triggers. Data Migration using SQL Loader. Developed Database packages, procedures, functions, and database triggers.
• Working on multiple databases supporting oracle streams for replication