Usman Qadir
Summary
Oracle Database Administrator with over 9 years of experience supporting enterprise Oracle database environments in regulated industries including aerospace. Extensive experience administering Oracle 11g, 12c, and 19c databases on Linux platforms with expertise in RAC, Data Guard, RMAN, ASM, and performance tuning. Proven experience supporting mission critical ERP and engineering systems, implementing backup and disaster recovery strategies, and maintaining strict compliance and audit documentation. Skilled in command line administration, scripting automation using shell and Python, and collaborating with infrastructure, security, and application teams to ensure high availability and operational reliability.
Overview
1
1
Certification
9
9
years of professional experience
Work History
Oracle Database Administrator
Tata Consultancy Services | South Jersey Industries Project
Remote
11.2023 - 09.2024
- Migrated Oracle databases from 12c to 19c across Linux and Exadata environments with minimal downtime.
- Configured and maintained Oracle RAC and Data Guard environments for high availability and disaster recovery.
- Automated routine DBA monitoring and maintenance tasks using shell and Python scripting.
- Applied Oracle CPU and PSU patches using OPatch utilities under controlled change management procedures.
- Monitored database health and performance using Oracle Enterprise Manager and AWR reports.
- Performed SQL performance tuning to improve query execution time and database efficiency.
- Implemented database security controls including Transparent Data Encryption and auditing policies.
- Collaborated with DevOps and application teams to support CI CD deployments and database changes.
- Environment: Oracle 11g 12c 19c, Exadata, RAC, ASM, Data Guard, RMAN, OEM, Red Hat Linux, Azure
- Supported the Oracle Applications team by resolving application-related issues and ensuring high system availability.
- Assisted developers by creating and refreshing development and test environments through application cloning.
- Worked with the application team to troubleshoot concurrent request failures, workflow issues, and application performance problems.
- Provided database and application support during production deployments and scheduled maintenance windows.
- Installed, configured, upgraded, and maintained Oracle APEX environments.
- Installed and configured Oracle REST Data Services (ORDS) with Oracle APEX.
- Configured Oracle HTTP Server (OHS) or Apache/Tomcat for APEX access.
- Created and managed APEX workspaces, users, and application security.
- Managed APEX authentication methods, authorization schemes, and user roles.
- Tuned SQL queries, indexes, and PL/SQL packages used by APEX applications.
Oracle Database Administrator
Tata Consultancy Services | Boeing Project
Troy, Michigan
10.2015 - 10.2023
- Supported mission critical Oracle databases powering ERP and engineering systems in a regulated aerospace environment.
- Administered Oracle 11g 12c and 19c databases on Linux including RAC cluster environments.
- Performed database provisioning, schema deployments, cloning, and environment refresh activities.
- Implemented RMAN backup and recovery strategies including full and incremental backups and disaster recovery testing.
- Used Data Pump utilities expdp and impdp for logical backups and data migration tasks.
- Monitored database performance and performed SQL tuning and index optimization to resolve bottlenecks.
- Managed database users, roles, and audit logging to maintain security and compliance standards.
- Assisted with Oracle patching and upgrades using OPatch utilities.
- Collaborated with Oracle Support and internal application teams to analyze and resolve production incidents.
- Performed root cause analysis for recurring application issues and implemented preventive solutions.
- Maintained documentation for standard operating procedures, patching activities, cloning, and troubleshooting.
- Participated in on call production support and incident response for enterprise database systems.
- Collaborated with infrastructure, cloud, application, and security teams to maintain high availability systems.
- Environment: Oracle 11g 12c 19c, RAC, ASM, RMAN, OEM, Data Pump, Grid Control, Red Hat Linux
- Installed, configured, and administered Oracle WebLogic Server in development, test, and production environments.
Deployed and managed Java EE applications (EAR, WAR, and JAR files) on Oracle WebLogic Server. - Worked with Oracle Fusion Middleware components such as:
Oracle WebLogic Server
Oracle HTTP Server (OHS)
Oracle Enterprise Manager (OEM). - Managed log rotation, JVM tuning, heap analysis, and performance optimization.
- Performed incident resolution and root cause analysis for production middleware issues.
Education
Master of Science - Management Information Systems
Glasgow Caledonian University
United KingdomSkills
- Oracle Database Administration 11g 12c 19c
- Oracle RAC and ASM Administration
- Oracle Data Guard High Availability and Disaster Recovery
- RMAN Backup Recovery and Disaster Recovery Testing
- Oracle Enterprise Manager Monitoring
- Data Pump expdp impdp Data Migration
- SQL Performance Tuning and Query Optimization
- Database Security TDE Wallet Auditing
- Linux Unix Command Line Administration
- Shell and Python Scripting Automation
- Database Provisioning and Schema Deployment
- Capacity Planning and Resource Optimization
- Change Management and SOX Compliant Procedures
- Databases: Oracle 10g 11g 12c 19c, Microsoft SQL Server
- Tools: Oracle Enterprise Manager, TOAD, RMAN, Data Pump, SQL Loader, Grid Control
- Operating Systems: Red Hat Linux, Unix, Windows, Microsoft Azure
- Scripting: Shell scripting and Python
Certification
- Safe Certified Scrum Master
- Certified Scrum Master (CSM)
- Microsoft Certified Azure Administrator Associate
Timeline
Oracle Database Administrator
Tata Consultancy Services | South Jersey Industries Project
11.2023 - 09.2024
Oracle Database Administrator
Tata Consultancy Services | Boeing Project
10.2015 - 10.2023
Master of Science - Management Information Systems
Glasgow Caledonian University