ANURAG TIWARI
Oracle DBA
Bangalore
Summary
With over a decade of experience as a Core and Apps Database Administrator, I bring a wealth of expertise to the table. My skill set is further enhanced by my proficiency in Data Analysis, leveraging cutting-edge AWS and Python technologies. Additionally, I possess a solid year of hands-on experience in Manual Testing, which complements my comprehensive database management capabilities. My technical acumen ensures that I can deliver exceptional results in a range of IT environments.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Oracle Database Administrator
ContinuServe Softech India Pvt. Ltd.
08.2015 - Current
- Currently employed at ContinuServe Softech India Pvt. Ltd. as an Oracle Core and Apps DBA since August 2015, bringing over 10 years of experience in the field.
- Hold an AWS Associate Architect Certificate with 2 years of hands-on experience in AWS cloud technologies, including Lambda, EC2, CloudWatch, S3, IAM, VPN, and VPC.
- Skilled in data analysis with 2 years of experience in ETL processes and proficient in creating Python scripts for AWS Lambda functions.
- Proficient in performing database and application refreshes or clones using RMAN, Actifio, and Commvault from production to non-production environments upon request.
- Experienced in managing backup solutions such as RMAN and data-dump utilities for both cold and hot backup processes.
- Extensively involved in applying application patches (R12.1) and using configuration updating tools like VERTEX for tax updates.
- Competent in custom administration tasks, including creating and managing concurrent programs.
- Adept in system administration responsibilities such as creating users and assigning responsibilities within Oracle applications.
- Proficient in writing and optimizing SQL and PL/SQL code to enhance database performance and functionality.
- Conducted regular database performance monitoring and tuning, including the use of AWR reports for analysis.
- Executed backup and recovery operations with RMAN and managed user accounts, supporting systems within complex Oracle database and cloud environments.
- Scheduled and performed maintenance activities, including index rebuilding, to ensure database efficiency.
- Maintained database security by creating user accounts, profiles, and granting appropriate privileges.
- Delivered technical support to users for resolving database-related issues and deployed patches and upgrades following best practices.
- Provided 24x7 on-call support for critical database incidents, ensuring high availability and minimal downtime.
- Developed scripts for task automation using PL/SQL and shell scripting languages to streamline database management processes.
Project 1#
Brinks Inc.
09.2015 - Current
- Managed Oracle Applications (E-Business Suite) environments, focusing on patching and cloning.
- Provided 24/7 on-call support for critical database issues, ensuring prompt outage resolutions.
- Documented database configurations and procedures to facilitate internal knowledge sharing.
- Developed and maintained PL/SQL scripts for database task automation and routine operations.
- Implemented and maintained Oracle Real Application Clusters (RAC) to ensure high availability.
- Spearheaded the development and maintenance of Brinks, a critical system for revenue and order tracking, enabling precise market analysis and sales agent compensation.
- Expertly extracted and integrated data from multiple homogeneous sources to enhance reporting capabilities.
- Conducted comprehensive requirement analysis to create and manage database schemas, users, tables, constraints, indexes, triggers, privileges, and roles.
- Executed database and application cloning from production to non-production environments, ensuring data consistency and reliability.
- Applied patches to the application to address bugs, improving system stability and performance.
- Facilitated code migration in production environments using the STAT tool, enhancing operational efficiency.
- Managed APEX migration in production with the STAT tool, ensuring seamless application updates.
- Performed regular month-end activities to meet specific business requirements and support financial closing processes.
- Updated vertex tax monthly, maintaining compliance with tax regulations and supporting accurate financial reporting.
- Successfully updated the Quality Assurance System (QAS) to ensure uninterrupted business order processing.
- Provided critical production support and collaborated with the testing team to resolve high-priority defects, improving system reliability.
- Utilized a diverse technology stack including SQL, PL/SQL, Putty, SQLDEVELOPER, Toad, Vertex, STAT, QAS, Cloud, AWS, Python, ETL, and Data Analysis to deliver high-quality database solutions.
Project 2#
Rheem Manufacturing Company
09.2015 - Current
- Spearheaded Oracle package development to streamline Order Value record processing, meeting business requirements.
- Managed daily system feed integration using the Rules Engine for validation and processing into the Order Value stage table.
- Collaborated with clients to document database object requirements, ensuring seamless integration with existing systems.
- Executed database schema creation, user setup, and object management including tables, constraints, indexes, and triggers.
- Performed cloning and patching of Oracle 19c databases and E-Business Suite 12.3 applications to enhance system performance.
- Provided expertise in thread management for database operation optimization.
- Performed all task related weblogic server, ODI, ODI and SOA
- Facilitated the application of regular updates, such as monthly Vertex tax updates, to ensure compliance and system accuracy.
- Supported production and testing teams by resolving critical defects, thereby improving system stability.
- Generated custom reports to fulfill specific business needs, supporting strategic decision-making.
- Utilized SQL, PL/SQL, Linux shell scripting, Putty, SQL Developer, Toad, and Vertex for efficient task execution.
- Ensured adherence to best practices in database and application cloning to minimize downtime and maintain data integrity.
- Applied critical patches to applications to address bugs and improve user experience.
- Managed comprehensive Oracle database administration tasks including installation, configuration, and upgrades.
- Conducted regular backups and recovery procedures to safeguard data integrity and availability.
- Monitored and tuned database performance to ensure system efficiency.
Data Analyst
MSI
02.2024 - Current
- Spearheaded the ETL process for the MSI DATA ANALYSIS Project using AWS services and Python programming.
- Developed and deployed Python scripts to AWS Lambda for automated data transformation tasks.
- Managed data storage and ETL operations utilizing AWS S3 and Lambda functions to ensure efficient data processing.
- Collaborated with cross-functional teams to identify and implement ETL solutions that meet project requirements.
- Maintained and optimized ETL processes to improve data quality and workflow efficiency.
- Troubleshoot and resolved issues related to ETL operations, ensuring minimal downtime and adherence to project timelines.
Education
Bachelor of Technology -
Mahatma Gandhi Chitrakoot Gramoday Vishwavidyalay
01.2014
Skills
- Database Administration
Certification
AWS Certified Solution Architect - Associate
Timeline
Data Analyst
MSI
02.2024 - Current
Project 1#
Brinks Inc.
09.2015 - Current
Project 2#
Rheem Manufacturing Company
09.2015 - Current
Oracle Database Administrator
ContinuServe Softech India Pvt. Ltd.
08.2015 - Current
Bachelor of Technology -
Mahatma Gandhi Chitrakoot Gramoday Vishwavidyalay