• Seasoned Oracle/PostgreSQL DBA with 6+ years of comprehensive experience in Oracle installations, upgrades, migrations, and designing logical/physical database architectures. Proficient in SQL*Net, performance tuning, capacity planning, database access, security, and auditing.• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, and data manipulation.• Performance Tuning production databases using tools like Statspack, Explain Plan, DBVerify, TKPROF, and SQL Analyze, creating/maintaining indexes, table partitioning, using locally managed table spaces.• Collaborated with ETL, BI, and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.• Experience in building a new 3-node RAC and migrating the existing database to the newly built servers including ASM storage migration.• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g, and 11g in UNIX/LINUX/AIX and Windows environments.• Implemented recovery strategies whenever required and successfully recovered databases in case of database crashes and media/disk failures using RMAN.• Supported MS SQL Server 2005/2008/2012/2014, MySQL 5.7, and PostgreSQL 10/13/15 databases, providing comprehensive database administration, performance tuning, and troubleshooting.• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability, and Performance by determining the best Cluster architecture, and choosing the best hardware configuration for Oracle RAC.• Efficiently performed installation, setup, and creation of two-node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 6.8.• Set up and configure Oracle Enterprise Manager (OEM) 13c, TOAD, and Grid Control 10g to monitor database health, performance, and security.• Working with other IT professionals for database designs and reviews; troubleshooting database issues and deploying timely fixes; maintaining regular and proactive database patches, updates, and performance enhancement.• Administered Oracle databases on HP-UX, Linux, AIX, and Windows, optimizing performance and availability through OS-level tuning and automation.
-
Oracle And Postgresql DbaFifth Third BankRichmond, Tx, Us -
Oracle/Postgresql DbaDxc Technology Mar 2024 - Nov 2024Richardson, Tx• Execute Datapump and conventional export/import utilities in Oracle 12c, 11g, and 10g for reorganizing databases, schemas, and tables to enhance performance.• Succeed in installing and maintaining Physical Standby databases using Oracle Data Guard for Oracle 10g to 12c RAC environments.• Automate routine database maintenance tasks using Bash/Unix Shell Scripting and Python, cutting manual workload by 50%.• Streamline daily Oracle RMAN backup jobs, reducing backup time by 25% and ensuring a 100% data retrieval success rate.• Enhance application performance by refining PL/SQL scripts and stored procedures, achieving a 35% improvement in response time and boosting user satisfaction.• Provision and manage AWS instances by creating, snapshotting, and terminating them, while also migrating databases from on-premise Oracle to Amazon RDS/Aurora Postgres.• Generate AWR/ASH/ADDM reports and leverage Optimizer/Execution Plans to diagnose and resolve SQL and PL/SQL issues, driving better database performance and recommending application code rewrites.• Ensure data availability, integrity, consistency, and optimal performance for all databases and EBS applications.• Led the implementation of Oracle Exadata Database Machine, significantly enhancing performance for high-volume transaction processing.• Deploy proactive monitoring strategies using Tuning Pack, Diagnostics Pack, STATSPACK, SQL Trace & TKPROF, and EXPLAIN PLAN to maintain peak database performance.• Install, configure, and create container databases and pluggable databases as part of Multi-tenant Oracle 12c/19c environments.• Implement and monitor Data Guard, GoldenGate, and RMAN solutions to ensure high availability, disaster recovery, and data replication with minimal downtime and data consistency. -
Oracle\Postgresql DbaPnc Jul 2022 - Feb 2024Raleigh, North Carolina, United States• Monitored scheduled jobs for backups, gathering statistics, AWR reports, and data guard status reports, disk space utilization reports.• Identifying the poorly performing queries using Explain Plan, and TKPROF, and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.• Supporting multiple databases for production, development, test, and staging purposes on Sun Solaris, Linux, UNIX, and HP environments.• Configured Oracle Data Guard to ensure disaster recovery, high availability, and data protection.• Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 11G, 12C,19C) in production, testing, and development of RAC environments hosted on Solaris, and Linux servers.• Created advanced queries for data models and sophisticated template data arraignments for complex reports. Assisted the Business Intelligence (BI) team and OBIEE developers in report preparation.• Directed large database replications using GoldenGate Extract, Manager, and Replicate processes.• Spearheaded a team to implement Oracle RAC for high availability and scalability, resulting in a 99.9% improvement in server uptime.• Conducted routine database health checks, monitored performance, and tuned SQL queries to improve efficiency.• Deployed and managed databases on AWS and Oracle Cloud platforms, optimizing cloud resource utilization and ensuring data security through backup and disaster recovery strategies.• Monitored Oracle databases using Oracle Enterprise Grid Control 11g and 12c cloud control.• Performed upgrading database from file system to EMC environment. Also upgraded from 11g R2 to 12c R1 from Net app file system to EMC storage.• Restored and recovered database and ARCHIVLOG using RMAN from backup on the same servers and different servers. -
Oracle DbaDell Technologies Feb 2020 - Jun 2022Round Rock, Tx• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability, and Performance by determining the best Cluster architecture, and choosing the best hardware configuration for Oracle RAC.• Created, modified, and deployed script for Database objects such as database tables, indexes, and triggers, based on TDD.• Utilized SQL & PL/SQL to create and optimize complex database queries, stored procedures, and triggers, improving database performance and efficiency.• Troubleshoot Performance issues by putting a session trace on the AWS RDS instance review the trace file and fix the issue.• Developed and integrated JavaScript-based web applications with Oracle databases, enabling dynamic data retrieval and real-time updates for user interfaces.• Engineered the automation of routine tasks using Shell Scripts, PL/SQL, and SQL*Loader, boosting productivity and minimizing manual errors.• Demonstrated proficiency in performance tuning by leveraging Explain Plan and SQL*Trace to pinpoint and resolve intricate performance issues.• Configured and administered Real Application Cluster (RAC) and ASM environments, ensuring seamless integration, data integrity, and optimized storage management.• Executed database migrations and upgrades using SQL * Loader, Exp/Imp, Expdp, and Impdp, ensuring smooth transitions with minimal downtime and data integrity.• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches. -
Oracle DbaEpsilon Mar 2018 - Jan 2020Irving, Tx• Used Oracle Enterprise Manager (OEM) 11g and 12C Grid Control for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.• Designed and developed table structures, PL*SQL stored procedures and database triggers to implement business rules• Worked with Data Pump to take the logical backups of databases. Load and Transform data using SQL*Loader and External Tables• Created database users, profiles, and roles to set up the database environment on Amazon RDS, EC2, and local Linux Servers.• Wrote and implemented PL/SQL, SQL Loader, and Bash Shell Scripts to automate databasechanges.• Diagnosed and resolved database performance issues by analyzing Automated Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostics Monitor (ADDM) reports.• Measure database performance and troubleshoot complex database issues, I/O bottlenecks, and SQL Tuning. Used AWS RDS Performance Insights for RDS instances.• Performed database cloning using RMAN, Data Pump, and manual methods, enabling rapid environment provisioning and supporting development and testing activities.• Managed database backups, recovery, and replication processes through RMAN, Oracle Data Guard, and GoldenGate, safeguarding data against loss and ensuring business continuity.• Applied patched on standalone and RAC database using OPatch utility 11g R2 and 12C R1 container and pluggable databases.
Ameen A. Education Details
-
Biology/Biological Sciences, General
Frequently Asked Questions about Ameen A.
What company does Ameen A. work for?
Ameen A. works for Fifth Third Bank
What is Ameen A.'s role at the current company?
Ameen A.'s current role is Oracle and PostgreSQL DBA.
What schools did Ameen A. attend?
Ameen A. attended Ned University Of Engineering And Technology.
Who are Ameen A.'s colleagues?
Ameen A.'s colleagues are Amber Jahovaj, Linda Turcotte, Davone Shinkle, Thomas Arnott, Mckenna Ramsey, Sheppard, Shelby, Donramon Singleton.
Not the Ameen A. you were looking for?
-
Mohamed Ameen A. Azeez
Aviation Consultant / Flight Safety Specialist/ Part Time Lecturer Bba, Bsc, Mba, MscIrving, Tx
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial