Senior Oracle/PostgreSQL Database Administrator
Resume:
Moiduddin Muhammad
Sr. Oracle DBA
Ph: 224-***-****
Email: *********@*****.***
www.linkedin.com/in/moidmuhammad
TECHNICAL SUMMARY:
Expertise in the following areas of Database Administration:
RAC
AWS / EC2 / RDS
SQL Advisor
Active Standby
Data Guard
Database Upgrades
Dictionary Tables
SQL Server 2008 / 2012
PostgreSQL
PostgreSQL Upgrades
PostgreSQL Tuning
PostgreSQL Migrations
ASM
Migrations
Dynamic Views
Log shipping
Bulk loading
Percona XtraBackup
SSL encryption
SQL Server Profiler
13c
19c, 21c pluggable database
Performance Tuning
Linux, OEL, RHEL, CentOS
Silent Install
Backup and Recovery
SQL Tuning
Windows, AIX, Solaris
RMAN
Storage Management
Instance Tuning
VMware, Oracle Virtual Box
RAT
Oracle GoldenGate
Rolling Upgrades
Table Partitioning
Exadata
13c Cloud Control
Shell Scripting
Export Import, Data Pump
ASH Report
Baselines, Outlines, Profiles
AWR report
ADDM Reports
SQL Advisor
RAC OneNode
SQL Plan Management
Table Compression
Replication
Materialize Views
Exadata
OMA, OMS, OMR
AWS Cloud
Azure Cloud
RDS
EC2
PROFESSIONAL SUMMARY:
•Over 15 years of IT experience and 14 plus years of Oracle DBA experience
•Over 5 years in PostgreSQL and MSSQL database Administration.
•Installed, Managed and Administered 9i to 21c databases and 2008, 2012 and 2019 MSQL databases.
•Installed PostgreSQL on Linux and Windows.
•Administered MySQL databases.
•Implemented Advance indexing to managed Oracle and
•Build and manage 13c Cloud Control, OEM.
•Worked as a lead in Data Center Consolidation on large database systems.
•Worked as a Primary support for database related issues with clients.
•Worked on multiple projects in parallel to daily DBA activities.
•Worked extensively on ASM Builds and management of ASM Filesystem.
•Implemented Disaster Recover Site with Data Guard and maintained Active Data Guard.
•Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
•Performed various databases encryption tasks.
•Assisted in management and database administration on Exadata platforms.
•Worked on Hybrid Columnar Compression (HCC) that provides reductions in database size.
•Participated in analysis and designing of Oracle Exadata Server
•Assisted in integration of Exadata applications into current IT actionable events and solutions.
•Migrating databases to Oracle Exadata Database Machine for different clients
•Used tools like putty, TOAD, MySQL Workbench, MSSQL Management Studio, pgAdmin etc.
•Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
•Implemented robust access controls, including authentication, authorization, and encryption
•Configured and managed database firewalls and intrusion detection systems
•Conducted regular security audits and vulnerability assessments
•SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay
•Build and manage container and pluggable 12c, 18c and 19c databases.
•Worked on Upgrade projects and Migration projects.
•Participated in design, document and deployment of database
•Backup and restored databases on SQL Server.
•Managed Oracle Database deployments on Microsoft Azure using Azure Virtual Machines, ensuring high availability, scalability, and performance optimization.
•Administered Oracle databases hosted on Azure infrastructure, including installation, configuration, patching, upgrades, and maintenance.
•Implemented backup and disaster recovery solutions using Azure Backup, Azure Storage, and Oracle RMAN to meet business continuity requirements.
•Configured and managed Oracle Data Guard environments on Azure for high availability and disaster recovery.
•Managed and applied database patches and updates in a timely manner
•Tested and validated patches before deployment to production environments
•Implemented automated patching processes using tools like SQL Server Update Services
•Implemented data backup and recovery procedures, including regular backups and disaster recovery plans
•Conducted regular database maintenance, including indexing, statistics, and fragmentation analysis
•Developed and enforced database naming conventions, coding standards, and documentation practices
PROFESSIONAL EXPERIENCE:
NasFar Systems Bolingbrook,IL
Oracle DBA
Feb 2025 to present
Responsibilities:
·Administered mission-critical Oracle databases (10g, 11g, 12c, 18c, 19c) for backup, recovery, performance tuning, security, and capacity planning.
·Designed and developed databases using SQL, stored procedures, triggers, dimensional modeling, and indexing strategies.
·Ensured system performance, availability, and security while optimizing server resource usage in UNIX and virtual environments.
·Conducted capacity planning for corporate databases and processing demands, diagnosing and resolving storage, performance, and data integrity issues.
·Scripted system maintenance, monitoring, and automation tasks using shell scripts and PL/SQL.
·Served as a technical expert for Oracle RDBMS, troubleshooting database, application, and tool issues, and supporting development teams.
·Managed 24/7 on-call rotation, working outside business hours as needed for corporate support.
·Implemented and troubleshot Oracle GoldenGate replication, including extract, pump, and replication processes.
·Developed scripts to perform system maintenance, monitor systems, automate tasks, etc.
·Utilized Commvault for database backups and point-in-time restores, and OEM for performance tuning and reporting.
·Collaborated with infrastructure and application teams on projects, POCs, and troubleshooting.
·Build and maintained the ongoing operational functionality and efficiency of Client’s databases ensuring system performance, availability, reliability, security, recoverability and efficient usage of server infrastructure resources.
·Troubleshoot issues associated with databases, applications and development tools and provides technical support to application development teams.
·Migrated Oracle Database to Exadata
•Managed Oracle Database deployments on Microsoft Azure using Azure Virtual Machines, ensuring high availability, scalability, and performance optimization.
•Administered Oracle databases hosted on Azure infrastructure, including installation, configuration, patching, upgrades, and maintenance.
•Implemented backup and disaster recovery solutions using Azure Backup, Azure Storage, and Oracle RMAN to meet business continuity requirements.
•Configured and managed Oracle Data Guard environments on Azure for high availability and disaster recovery.
•Worked with Oracle to get Exadata on premises.
•Setup OVMs on Exadata.
•Setup ZFS for Backups from Exadata.
•Migrated database from AIX to 2-Node Linux Cluster.
•Single node to RAC
•AIX to Linux
•Non-ASM to ASM
•11g to 12c RDBMS and 19c Grid Infrastructure.
•Set up 13c Cloud Control, OEM.
•Used XTTS cross platform migration method to migration from AIX to Linux.
•Setup Backup jobs
•Written shell scripts to automate jobs.
•Load balanced connection strings.
•Converted database to use TDE
•Worked with Oracle to schedule Exadata patching.
•Worked with Oracle on ODA for Exadata setup.
•Automated system administration tasks using PowerShell scripts
•Created custom modules and functions for reuse in multiple scripts
•Worked on performance related issues
•Used Data pump to migrate smaller databases.
•Worked on various restores using RMAN duplicate.
•Restore databases using RMAN backups.
•Rework on data Guard.
WPS, Madison, WI
Sr. Oracle, MySQL DBA
Nov 2018 to Jan 2025
Responsibilities:
•Provided day to day Oracle and PostgreSQL DBA support.
•Moved standalone database to Exadata X7.
•Build and managed Active Data Guard.
•Assisted in Disaster Recovery practices.
•Build RAC Clusters on Exadata OVMs.
•Applied PSU patches.
•Performed Re syncing of standby databases.
•Oracle Database Migration from AIX to Linux using transportable tablespaces.
•Performed SQL and PL/SQL tuning and Application tuning
•Developed UNIX Shell scripts to automate table creation and execute procedures.
•Install 13c Cloud control OEM.
•Designed and implemented indexing strategies for optimal query performance, including clustered and non-clustered indexes, covering indexes, and composite indexes
•Worked on STIG and compliance documents.
•Setup and Managed database on Amazon Web Services (AWS) using EC2.
•Build configured and managed multi node RAC Cluster on RHEL.
•Upgraded databases from Oracle Versions 12c to 19c to 21c.
•Experience in using DBMS_SCHEDULER to run jobs in parallel to improve performance.
•Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
•Contributed with database designs and assisted in increasing response time for APEX reports.
•Designed application framework and developed Oracle APEX Application.
•Developed data model, SQL Queries, SQL Query tuning process and Schemas.
•Expertise in loading data from legacy systems using SQL*Loader.
•Tuned SQL Queries in Oracle and PostgreSQL databases.
•Tuned Instance for better performance.
•Performed in-depth analysis of database performance bottlenecks using tools like SQL Server Profiler, Oracle Enterprise Manager, and MySQL Workbench
•Implemented database configuration changes to optimize performance, including buffer pool sizing, log file management, and storage optimization
•Worked on Migration project.
•Setup and manage Oracle GoldenGate Replication
•Developed scripts to automate data processing, analysis, and visualization tasks
•Backup / Restore / Recovered database using RMAN from ZFS.
•Migrated database from AIX to Exadata X7 using Transportable tablespace.
•Used SQL tuning advisor for performance tuning.
•Develop standards and procedures for all aspects of Database/Warehouses in the Cloud.
•Design, test and support solutions for Disaster Recovery on premises and in the Cloud.
•Diagram and document database Cloud implementations.
•Provide mentoring, knowledge transfer and assist in training for other members of the team.
•Build and manage RAC databases on Exadata.
•Migrated databases on Exadata.
•Performed silent installation of databases on Exadata.
•Patched grid home, RDBMS home on cells.
•Strong experience in SQL, PostgreSQL, MySQL and cloud platforms.
•Successfully managed and optimized PostgreSQL databases
•Expertise in PostgreSQL Architecture, Database Backup & Recovery, User and Role Management, Performance Tuning, Upgradation environment and High availability environments.
• Installed, configured, and managed MySQL databases on Linux and Windows platforms
•Performed database backups, restores, and cloning using mysqldump and MySQL Enterprise Backup
•Managed database security, including user authentication, access control, and encryption
•Automated the upgrade process from earlier PostgreSQL versions to 15, utilizing pg_upgrade and other migration tools.
•Automated routine maintenance tasks in PostgreSQL, including VACUUM, ANALYZE, and reindexing operations, to maintain the best performance.
•Analyzed and optimized complex SQL queries in PostgreSQL using EXPLAIN and E
•Worked on various restores using RMAN duplicate.
•Restore databases using RMAN backups.
•Backup and restored databases on SQL Server.
•Participated in design, document and deployment of database
•Managed and applied database patches and updates in a timely manner
•Tested and validated patches before deployment to production environments
•Implemented automated patching processes using tools like SQL Server Update Services
•Implemented data backup and recovery procedures, including regular backups and disaster recovery plans
•Conducted regular database maintenance, including indexing, statistics, and fragmentation analysis
•Developed and enforced database naming conventions, coding standards, and documentation practices
•Used native tools like pg_dump and pg_basebackup, minimizing downtime and ensuring data integrity.
•Check Log errors and take necessary actions to rectify them.
•Experienced in backup & restore using pg_dump and pg_dumpall Binary tools.
•Experienced in full backup using pg_basebackup setting up WAL archiving, Point in time recovery.
•Creating child partitions tables for every month in PostgreSQL.
•Creating index and monitoring index using Explain Plan to make better Performance of Queries.
•Experience in Vacuum, Vacuum Full and Reindex in Production Database for Maintenance Activities.
•Worked on Streaming Replication and Log shipping for PostgreSQL Server High Availability.
•Install and configure Backup and Recovery Tool (BART) and configure Prod and Testing Server.
•Install and configure pgbadger reporting tool for monitoring purposes.
•Worked with Oracle to get Exadata on premises.
•Created custom modules and functions for reuse in multiple scripts
•Worked on performance related issues
•Used Data pump to migrate smaller databases.
•Worked on various restores using RMAN duplicate.
•Restore databases using RMAN backups.
•Rework on data Guard.
•Added new nodes to existing standby.
•Applying Oracle quarterly PSU and bundle patches.
•Provided day to day support in managing standalone and ASM Database servers
•Maintaining Security protocols on User Privileges
•Regularly change passwords on DB accounts to be compliant
•Worked on TDE and HSM with the DBA Team
•Implemented and worked on stored procedures
•Implementing scripts for data extraction.
•Import/export & Data Pump for DB/schema/table level imp/exports.
NasFar Systems Bolingbrook,IL
Lead Oracle and MySQL DBA
Jan 2016 to Nov 2018
•Managed database on Amazon Web Services (AWS)
•Build Physical and Active Standby Database
•Written Shell Scripts to automate tasks.
•SQL Server Integration Services (SSIS)
•Data Quality Services (DQS)
•Optimized MySQL databases by selecting appropriate storage engines (InnoDB, MyISAM, MEMORY) based on workload requirements, balancing performance and reliability
•Backup / Restore / Recovered database using RMAN on Rubric
•Managed and configured SharePoint farms, including server settings, security, and permissions
• Created and managed SharePoint sites, libraries, and lists
•Migrated database to AWS RDS instances.
•Design, test and support solutions for Disaster Recovery on premises and in the Cloud.
•Diagram and document database Cloud implementations.
•Provide mentoring, knowledge transfer and assist in training for other members of the database team
•Build and managed RAC databases on Exadata
•Migrated databases on Exadata
HP, Chicago,IL 60559
June 13 – Dec 2015
Lead Oracle DBA
•Administered Oracle Databases
•Lead the migration of oracle databases to AWS EC2.
Fry Inc Micros Retail Oracle Corp. IL
May 2012– June 2013
Oracle and SQL Server DBA
•Administered 2 node and 4 node Oracle RAC clusters for e-commerce sites.
•Administered SQL Server 2005 and 2008 database servers.
•Provided day to day DBA operations support.
•Written batch scripts to automate jobs and refreshing databases.
•Setup log shipping to provide standby databases for Higher availability.
•Developed and executed backup strategies using SQL Server’s native tools, such as Full, Differential, and Transaction Log backups, ensuring data integrity and quick recovery
EDUCATION:
•Bachelors in Technical Management 2009
DeVry University
Addison, Illinois, USA
•Master’s in Information System Management 2011
Keller Graduate School of Management
Downers Grove, Illinois, USA
Contact this candidate