Azmul Haque

• Responsible for Installation, Upgradation, Migration, database refresh, applying Patches, Trouble shooting, SQL Tuning using AWR reports
• Worked as Oracle DBA in Production Support
• Handled DBA tasks, Profiles, Custom Module and ETL deployment, Patching, Cloning and Upgradation
• Worked in setting up dataguard, DB links, Disaster recovery exercises
• Conducted a comprehensive system analysis resulting in a strategic plan that decreased database response times by 20% for customer-facing applications
• Migrated 50+ databases from Onpremise to Azure cloud IAAS by creating standalone database platform.
• Optimized system storage by regularly evaluating and purging obsolete data, reclaiming over 15% of server storage space
• Provided critical support for Oracle database applications, earning a commendation for 98% issue resolution rate within SLAs

Plans and coordinates the administration of Oracle databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines. Taking datapump backup physical as well as through RMAN utility Worked with development and operations teams to tune production queries for optimal performance. Working with Development and Application team on blocking and Deadlock sessions. Working with Development and Application team to fix broken jobs. Wroking with Development team to create and manage Materialized View, View, Procedure and functions as provide scripts to run in the database. Review new database schema changes and apply it in database through manual and automated method. Working with Development team to deploy changes in Github and Flyway migration tools. Monitor and manage database indexes for optimal performance. Monitoring Alert logs, Backing and restoring the database, recovering standby database Configuring RMAN for backup and automate the jobs of backup through scheduling the jobs using cron jobs. Patching on Production and test environments for security purpose. Applying patch in RAC environment in rolling fashion method. Working on ASM storage for managing the space and adding new disk when needed. Working on managing the tablespace usage and adding datafiles. Working on table partitions as on demand of Application/Development team. Database refresh on test, acceptance & Dev instance from Production servers.

• Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
• Monitoring Oracle and MSSQL database
• Applying PSU patches using Opatch utility and autopacth
• Increasing the performance of the database through gathering statistics at schema and table level, managing tables and indexes, compiling invalid objects
• Replication of Production environment to Non Production environment for testing and development purpose
• Performing DB backup using Datapump/RMAN and ensuring backups are performed
• Creation of User Schema and granting privileges
• Monitoring the growth of Databases and taking proper actions like adding datafiles and resizing the data files
• Optimizing queries for better performance
• Creating proper documentation which helps in Knowledge transfer sessions for team members
• Participating in daily meetings to discuss about the new database level changes, users based on requirements of customer and users team
• Providing response for database related issues on 24 x 7 schedule responding to critical events and situations outside normal work hours
• Working during new releases and deployments for DB maintain support
• Working on ASM storage and good understanding of ASM
• Working with development team and implementing changes in the test environment before applying in production environment
• Manage and maintain the routine Oracle Database administration activities in critical production environments
• Creating and maintaining databases activities required for development, testing, and Production servers
• Planning and implementing backup and recovery of the Oracle database (RMAN and Datapump)
• Managing primary and standby database in dataguard setup
• Working knowledge of Golden gate and managing GG services
• Working with Security team to apply patches if any vulnerabilities reported
• Schema refresh and Full database refresh on regular intervals based on requirements
• Hands on knowledge in datapump backup and recover procedures
• Experienced of managing and administrating 24 X 7 running databases
• Working knowledge of physical dataguard in Oracle Database
• Working knowledge of Datapump utilities for taking backup of physical servers
• Datapump backup for taking across shared mount point and importing tables in different Oracle Database
• Possess good analytical and communication skills with the Clients and within an Organization
• Installation and configuration of SQL server software
• Monitoring system performance and identifying potential issues
• Backing up and restoring databases
• Optimizing SQL queries and database performance
• Implementing and maintaining security measures
• Ensuring data integrity and availability
• Providing technical support to users and developers
• Managing user access and permissions
• Planning and implementing database upgrades and migrations
• Documenting database structure and processes
• Streamlined database operations for efficient use of resources, applying patches and upgrades when necessary.
• Enhanced data security by implementing backup and recovery strategies, ensuring minimal data loss.
• Provided technical support during application development processes to ensure seamless integration with existing databases.
• Implemented disaster recovery plans to safeguard against unexpected events, minimizing potential losses.
• Worked closely with developers to optimize SQL queries for better query performance across various applications utilizing Oracle databases.
• Communicated effectively with key stakeholders regarding database changes or improvements that affected their responsibilities within the organization.
• Diagnosed and resolved critical database issues promptly, minimizing the impact on business operations.
• Assisted in database migration efforts, resulting in a seamless transition to a more efficient system.

• Replication of Production environment to Non Production environment for testing and development purpose.
  Performing DB backup using Datapump/RMAN and ensuring backups are performed .
  Creation of User Schema and granting privileges.
  Monitoring the growth of Databases and taking proper actions like adding datafiles and resizing the data files.
  Optimizing queries for better performance.
  Creating proper documentation which helps in Knowledge transfer sessions for team members.
  Participating in daily meetings to discuss about the new database level changes, users based on requirements of customer and users team.
  Providing response for database related issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
  Working during new releases and deployments for DB maintain support.
  Worked on ASM storage and good understanding of ASM.
  Manage and maintain the routine Oracle Database administration activities in critical production environments.
  Creating and maintaining databases activities required for development, testing, and Production servers.
  Planning and implementing backup and recovery of the Oracle database (RMAN and Datapump).
  Managing primary and standby database in dataguard setup.
  Working knowledge of Golden gate and managing GG services.
  Working with Security team to apply patches if any vulnerabilities reported.
  Schema refresh and Full database refresh on regular intervals based on requirements.
  Hands on knowledge in datapump backup and recover procedures.
  Experienced of managing and administrating 24 X 7 running databases.
  Working knowledge of physical dataguard in Oracle Database.
  Working knowledge of Datapump utilities for taking backup of physical servers.
  Datapump backup for taking across shared mount point and importing tables in different Oracle Database.
  Possess good analytical and communication skills with the Clients and within an Organization.