Avinash Kumar Pandey

Administer, monitor, and maintain Oracle Database 12c/19c and Microsoft SQL Server 2012/2019 environments across Linux and Windows platforms.
Plan and execute database installations, upgrades, patch deployments, migrations, and cloning activities while ensuring minimal downtime.
Design, implement, and support High Availability (HA) and Disaster Recovery (DR) solutions using Oracle RAC, Data Guard, ASM, and SQL Server Failover Clustering technologies.
Manage backup, recovery, and disaster recovery strategies utilizing Oracle RMAN, Data Pump, and SQL Server Maintenance Plans to ensure data integrity and business continuity.
Perform proactive database performance monitoring and tuning using AWR, ASH, execution plans, wait-event analysis, indexing strategies, and query optimization techniques.
Troubleshoot and resolve complex production issues, including database outages, blocking and locking conflicts, deadlocks and performance bottlenecks.
Implement and maintain database security controls, including Transparent Data Encryption (TDE), user and role management, privilege administration, auditing, and compliance requirements.
Collaborate with application, infrastructure, and development teams to support deployment activities, performance improvements, and database-related projects.
Develop and maintain operational documentation, standard operating procedures (SOPs), backup/recovery procedures, and database health-check reports.
Automate routine DBA tasks through scripting and monitoring tools to improve operational efficiency and system reliability.
Ensure to organizational standards, security policies, and best practices for database administration and governance.
Provide 24×7 production support, incident management, root cause analysis (RCA), and timely resolution of critical database issues in mission-critical environments.

Project: Diwan of His Highness the Crown Prince Environment: Oracle 12c/19c RAC, MS SQL Server 2012/2014/2019, RHEL 7/8
Managed secure government databases across Oracle and SQL Server platforms.
Executed database upgrades, migrations, replication, and DR setups.
Administered RMAN backups, Data Guard and recovery operations.
Ensured high availability, data integrity, and performance for critical applications.
Supported development teams with database design reviews and performance optimization.

Roles and Responsibilities as “Oracle DBA”:

• Installation, Configuration and Administration of oracle 12c/19c on RHEL- 7/8, Solaris 11, Windows Server 12/19 for Production (RAC)/Development/Test environment.
• Database Up-gradation, Cloning, Migration and Replication.
• Schema Management, Space Management, Performance Tuning.
• Backup Monitoring and performing Database Recovery using RMAN & User managed.
• Logical backup using data pump & export/import.
• Scheduling RMAN job, monitoring RMAN Backup report & troubleshooting RMAN backup issue.
• Managing database security, backup and recovery strategies.
• Monitoring of Alert Log file, Oracle Wait Events.
• Troubleshooting RAC & ASM issue.
• Maintaining the physical standby database server & troubleshooting.
• Configuring and managing Data Guard between primary and disaster recovery site.
• Checking CPU/Memory utilization and review top SQL query.
• Managing Oracle Automatic Storage Management.
• Managing Oracle E Business Site Database and Application and Database Warehousing
• Applying oracle database software Patching.
• Database health checkup Co-ordinate interaction with vendors/oracle support in critical database problem situations.
• Work with development team and development DBA's to review new databases changes and designs.
• Providing primary support on critical and complex production oracle databases 12c/19c, in RAC environment on (24/7) high volume OLTP systems.
• Handling all resource management, vendor management and budget planning for all database projects.

Roles and Responsibilities as “MS SQL DBA”:

• Installation, configuration, Administration and Maintenance of SQL Server for Testing, Development and Production Environments.
• Create Users and assign permissions based on the level of database access the user (Security).
• Create Linked Servers to SQL Servers and other databases such as Oracle etc. (Security and General Administration).
• Design database including complex data models and logical database designs.
• Backup and Restoration Strategy (Database Backups and SQL Server Agent).
• Perform and maintain backups, monitor backups regularly.
• Setup High-Availability as per Disaster Recovery Strategy for the Databases (Failover Clustering, Database Mirroring, Log
Shipping and Replication.
• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring Error Logs).
• Plans and conducts structured testing of database designs to confirm functionality and performance.
• Performs routine and customary operational and monitoring activities to ensure database integrity, stability, availability and capable of meeting ongoing business needs.
• Evaluates technology and techniques to implement and maintain databases.
• Accepts the lead for projects as assigned and contributes as a team member to other projects in an ongoing manner.
• Work directly with development groups helping design DB to interact efficiently with the database.
• Documenting major changes to the SQL Servers and providing reports to management.
• Apply Service Packs and updates as needed.

Additional Roles and Responsibilities:

• Window Administration, Windows Active Directory, EMC Networker Backup, VMware-Vcenter.

Roles and Responsibilities as Oracle DBA:

• Installation, configuration and administration of oracle 11g on RHEL-5/6, Solaris-10/11 with RAC environment.
• Handling issues related to Oracle Architecture.
• Monitoring of Alert Log file.
• Database up-gradation, Cloning, migration and replication.
• Schema Management, Space Management, Performance Tuning.
• Backup Monitoring and performing Database Recovery using RMAN & User managed.
• Scheduling RMAN job, monitoring RMAN Backup report & troubleshooting RMAN backup issue.
• Logical Backup using Data pump & Export/Import.
• Support of Backup and recovery strategies.
• Database performance Tuning.
• Applying oracle database software Patching.
• Troubleshooting RAC & ASM issue.
• Maintaining the physical standby database & troubleshoot.
• Database test servers configuration, maintenance and support.
• Implementation of physical standby database.
• Check CPU/Memory utilization and review top SQL query.
• Configuring and managing Data Guard between primary and disaster recovery site.
• Managing ASM storage with monitoring tool like EMC storage technology.
• Database health checkup Co-ordinate interaction with vendors/oracle support in critical database problem situations.
• Work with development team and development DBA's to review new databases changes or designs.
• Providing primary support on critical and complex production oracle databases 11g, in RAC environment on (24/7) high volume OLTP systems.
• Handling all resource management, vendor management and budget planning for all database projects.

Roles and Responsibilities as SQL DBA:

• Installation, configuration, Administration and Maintenance of SQL Server for Testing, Development and Production Environments.
• Create Users and assign permissions based on the level of database access the user (Security).
• Create Linked Servers to SQL Servers and other databases such as Oracle etc. (Security and General Administration).
• Design database including complex data models and logical database designs.
• Backup and Restoration Strategy (Database Backups and SQL Server Agent).
• Perform and maintain backups, monitor backups regularly.
• Setup High-Availability as per Disaster Recovery Strategy for the Databases (Failover Clustering, Database Mirroring, Log
Shipping and Replication.
• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring Error Logs).
• Plans and conducts structured testing of database designs to confirm functionality and performance.
• Performs routine and customary operational and monitoring activities to ensure database integrity, stability, availability and capable of meeting ongoing business needs.
• Evaluates technology and techniques to implement and maintain databases.
• Accepts the lead for projects as assigned and contributes as a team member to other projects in an ongoing manner.
• Work directly with development groups helping design DB to interact efficiently with the database.
• Documenting major changes to the SQL Servers, and providing reports to management.
• Apply Service Packs and updates as needed.
• Support local staff in improving their skills and expertise.
• Prepare and Conduct technical presentations.

Additional Roles and Responsibilities:

• Windows Active Directory, EMC storage- VMAX, Centera, EMC Networker, DATA Domain, VMware-Vcentre.

• Installation of oracle 10g, 11g and creating database for production/testing and development.
• Controlling resource use with profiles, granting and revoking privileges, creating roles.
• Creating and managing the physical and logical database structure.
• Multiplexing and mirroring of data files, control files, redo log files and archived log files.
• Allocating and de-allocating segments and extents.
• Creating, reorganizing, truncating, dropping tables, indexes.
• Migration and upgradation activity of databases.
• Configuring the database in archiving mode, taking hot, cold or logical backups, incomplete or
complete recovery using user managed backups or RMAN (Recovery Manager).
• Configuring standby database to provide high level of security to the database.
• Checking the health and performance of the servers by checking logs, alert log file, Oracle wait events, AWR, Statspack.
• Tuning most resource intensive SQL queries.
• Configuring the YUM, LVM, RAID, DNS, DHCP, SAMBA and Apache Server on RHEL-5.
• Using shell script to make better system and database.
• Handling troubleshooting for RHEL issues.

• Installation of oracle 9i, 10g creating database for production/testing and development.
• Carrying out the installation of oracle software and developing a database for production, testing and development.
• Handling the database security against any unauthorized access and executing monthly review of database.
• Conducting a follow-up of the web application database.
• Taking physical backup and tape backup of oracle database.
• Applying LINUX operating system updates and configuration changes.
• Adding/Creating/Modifying/Deleting LINUX user account information, resetting password.
• Tune system performance and keep network up and running.
• YUM, LVM, RAID, DNS and Apache configuration on Redhat Linux.

• Installing oracle database on Linux and Windows.
• Generating Forms and Reports using Developer 2000 tool.
• Creating new users and manage roles and privileges.
• Installing and configuring oracle 9i database.
• Creating as well as modifying the structure of table, index and sequence.
• Take a backup of database and monitoring the performance of database.
• Carrying out Oracle Application Development using PL/SQL.