Parixit Dixit

• Migrated Oracle databases from on-premises infrastructure to the Azure cloud environment.
• Created and managed Oracle RAC, and standalone databases (12c, 18c, and 19c versions).
• Provisioned EC2 instances and configured Oracle databases in cloud environments.
• Restored databases from on-premises to cloud using Oracle Data Pump.
• Performed database refreshes from Production to PPD, DEV, and UAT environments.
• Strong scripting skills for automation and database task optimization.
• Implemented Kerberos authentication for DBA access using Active Directory (AD) credentials.
• Integrated Oracle Enterprise Manager (OEM) with AD for secure console access.
• Administered Oracle 12c databases, including installation, configuration, upgrades, and maintenance.
• Provided 24x7 on-call production support for critical database incidents.
• Designed and implemented high-availability database solutions using clustering technologies.
• Ensured data integrity through regular quality and consistency validation checks.
• Handled Oracle Enterprise Manager (OEM) administration, upgrades, and patching.
• Delivered complex problem resolution for production database issues with 24/7 support coverage.
• Implemented Oracle Grid Infrastructure and RAC version upgrades.
• Applied 12c Patch Set Updates (PSU) and critical security patches.
• Created Plans of Action (POA) for complex database activities and change management.
• Conducted Disaster Recovery (DR) drills, switchovers, and failovers for both single-instance and RAC databases.
• Tuned database performance and optimized configuration settings for improved efficiency.
• Performed index rebuilds and collected statistics for schemas and stale tables regularly.
• Managed ASM (Automatic Storage Management): created disk groups, and added/removed disks.

Key Strengths:

• Strong analytical and technical skills with proven leadership ability.
• Effective problem-solver with a focus on stability, performance, and automation.
• Excellent communication and collaboration in cross-functional team environments.

• Provided 24x7 on-call support for critical incidents related to production databases.
• Designed and implemented high availability solutions for mission-critical systems using Oracle RAC and clustering technologies.
• Administered and maintained 50+ Oracle databases (11g, 12c, 19c) across production, test, UAT, and DR environments.
• Configured and managed Oracle RAC and ASM to ensure system availability and fault tolerance.
• Implemented Oracle Data Guard for physical standby databases with real-time apply.
• Automated RMAN backup scripts, recovery strategies, and scheduled jobs using cron.
• Conducted regular database performance monitoring and SQL tuning using AWR and ASH reports.
• Applied quarterly PSU patching and performed version upgrades with zero data loss.
• Migrated Oracle databases to Oracle Cloud Infrastructure (OCI) with minimal downtime.
• Managed user accounts, roles, profiles, and implemented auditing for security and compliance.
• Handled database cloning, environment refreshes, and data migrations using Data Pump utilities.
• Migrated 5+ TB Oracle 12c database from on-premises to AWS using RMAN and Data Pump.
• Assisted in capacity planning, schema changes, and implemented proactive alert monitoring.
• Created and maintained Unix shell scripts for database health checks and alert notifications.
• Supported patching activities and collaborated with OS teams during maintenance windows.
• Performed incident management, root cause analysis (RCA), and resolved performance bottlenecks.

• Company Overview: Client: SCI (SHIPPING CORPORATION OF INDIA)
• Administration/Monitoring oracle 11g, 10g, 9i database on UNIX/Sun Solaris/Windows
• Working on 2 Node RAC database in 10gR2/11G on Solaris environment.
• Installation of oracle 10g/11g/12C in Solari,Linux and Windows Server.
• Creation of Physical Standby Database as per the requirement.
• Database cloning, Migration, Upgrading and install required oracle patches.
• Creation of new database for Application and T&D purpose.
• Server load monitoring.
• Managing table-spaces and storage.
• Add and Resizing of data files according to the requirement.
• ASM disk group monitoring
• Add the data files in ASM disk group.
• Unix shell scripting (ODG break, synching, sequence check) and as per database requirement.
• RAC DB and single db restoration using RMAN.
• Monitoring of database health checkup.
• Creation, lock and unlock of users.
• Managing role and database security.
• Managing Oracle networking and troubleshooting.
• Managing backup of databases (Cold, Hot, Export/Import and Rman).
• Recovery of databases with the help of archive and redologs.
• Basic knowledge of RMAN backup and Restoration.
• Configured Confidential for active-active configuration in a multi master replication environment
• Tuned GG to handle large volumes of data for high transaction tables
• Monitored real-time bidirectional data movement
• Conflict detection and resolution
• Provided Heterogeneous environment support
• Used Oracle 11gR2 to resolve complexity of configuring conflict detection and resolution
• Setting up Before and After Image captures for Conflict Detection and Resolution
• Active monitoring of Conflict Detection and Stats verified after hourly run
• Configure GG delivery
• Implemented DDL replication using GG
• Switch Over and switch Back activity.
• Export/Import for all the parameter
• Table partitioning as per user requirement
• Application (CA spectrum, CA ehealth, CA Automation) and DB deployment
• Creating shell script for application requirement
• Client: SCI (SHIPPING CORPORATION OF INDIA)

Role & Responsibilities:

• Administered and monitored Oracle databases (11g, 10g, 9i) on UNIX/Sun Solaris platforms.
• Managed a 2-node Oracle RAC database environment (10gR2) on Solaris.
• Installed Oracle database software on both Solaris and Windows Server platforms.
• Created physical standby databases as per business and DR requirements.
• Performed database cloning, migration, upgrades, and applied necessary Oracle patches.
• Created new databases for application and testing & development (T&D) purposes.
• Monitored server performance and load.
• Managed tablespaces and storage, including resizing and adding datafiles.
• Monitored and maintained ASM disk groups; added datafiles in ASM as needed.
• Developed and maintained Unix shell scripts for database tasks (ODG break, syncing, sequence checks, etc.).
• Restored RAC and standalone databases using RMAN.
• Conducted routine database health checks and performance monitoring.
• Managed user accounts – creation, locking/unlocking, and privilege assignments.
• Controlled roles and implemented database security policies.
• Managed Oracle networking and resolved connectivity issues.
• Handled database backups: cold, hot, RMAN, and export/import.
• Performed database recovery using archive logs and redo logs.
• Executed switch-over and switch-back activities for standby setups.
• Utilized RMAN for backup and restoration (basic to intermediate level).
• Exported/imported full database schemas and specific parameters as needed.
• Implemented table partitioning based on user and application requirements.
• Deployed applications (WebLogic, UBS, FLEXCUBE) and databases.
• Monitored EOD batch processes using Autosys and PL/SQL.
• Created and maintained scripts for EOD batch jobs in the Autosys scheduler.

• Administered and monitored Oracle 11g, 10g, and 9i databases on UNIX (HP-UX, Sun Solaris), Linux (Red Hat), and Windows Server platforms.
• Managed 2-node Oracle RAC databases (10gR2) in Linux environments.
• Installed Oracle software on Linux, UNIX, and Windows systems.
• Created physical standby databases using Oracle Data Guard based on project and DR requirements.
• Performed database cloning, migration, upgrades, and applied Oracle patches.
• Created new databases for application deployments and testing (T&D).
• Monitored server load, database performance, and health checks.
• Managed tablespaces and storage, including adding and resizing datafiles.
• Created, locked, and unlocked user accounts; managed roles and database security.
• Configured and troubleshot Oracle network connectivity issues.
• Managed database backups (Cold, Hot, Export/Import, and RMAN) and recoveries using archive and redo logs.

• Company Overview: Client: HDFC BANK LTD.
• Form Ware (EMC Captiva-Formware 5.3.1) is an application developed by EMC for HDFC bank. This is a customized application which processes the batch definition files created by Kodak application after the account opening forms are scanned. The scope of account opening team is to handle the application related queries faced by the end users till the account number is generated for the customers.
• Connect Direct: Connect Direct is an application which is used to transfer the images/Files Between windows and AIX servers.
• Clearly understanding the Requirement Document.
• Clearly understanding the functionality of the application.
• Creating test plan and reviewing test cases. Complete Testing and final approval of the code, prior to its final production release.
• Participating review meetings and providing suggestions and inputs.
• Communicating and publishing daily test status report to the Business Partners and Project Teams.
• Co-coordinating with the Vendor in problem solving for production environment.
• Interacting with testing team members and developers on a regular basis to maintain the quality of the application.
• Enable or Disable task using crontab and handling HDFC Branch User’s ID related issues.
• Handling Administration activities involving Open and shutdown database, Kill active sessions.
• To forcefully shutdown database with confirmation from application owners.
• Having 1 years of experience as SQL Server Database Administrator.
• Installation & configuration of SQL Servers and up gradation of service pack.
• Implementation of SQL Logins, Roles and Authentication modes as a part of security.
• Implementing successful backup strategies based on Recovery models.
• Monitor database, Imaging servers and background servers and take necessary actions.
• Pro-actively resolve the issues by executing SQL queries.
• Prepare the daily reports required by the customer with the help of stored procedures and queries.
• Maintain the smooth flow and high availability of the application.
• Manually routing the files to application flow if they are stuck in between.
• Co-ordinate with vendor for patches to fix the bugs in application.
• Maintain the knowledge base for FormWare and Connect Direct application.
• Providing induction and training new Engineer joined in team.
• Scheduling and presenting monthly review to the Customer & Seniors.
• Providing monthly MIS to the customers & seniors.
• Preparing shift schedule of the team.
• Perform call analysis.
• Updating USD calls and resolving the incident calls.
• Installation and configuration of the application.
• Handling the queries of user’s inside the company regarding the application.
• Educating new user’s in the company to run the application.
• Resolving the issue’s using backend SQL Server 2000.
• Escalating the application issues to vendor and co-ordinate with them to resolve the issue.
• Monitoring the products going abroad from company and making Dispatch Reports.
• Generating product Code.
• Helping Export Manager in making Product Order Summary through application.
• Making Customer Enquiries for products according to the Customer requirements sent on mails.
• Making tags applied on the product containing the raw material used.
• Taking weekly backup.
• Client: HDFC BANK LTD.