ARUN KUMAR
Noida
Summary
Dynamic Architect with a proven track record at Persistent System, excelling in Oracle BI Publisher reporting and SQL optimization. Adept at leading teams and driving continuous improvement initiatives, I enhance database performance while ensuring compliance and scalability. My strong communication skills and technical expertise deliver impactful reporting solutions that meet enterprise needs.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Architect
Persistent System
Noida
12.2023 - Current
- Led end-to-end Oracle BI Publisher (BIP) reporting for the CLS project, supporting enterprise-scale reporting requirements across Finance, Procurement, and Supply Chain modules.
- Owned report architecture and design standards, ensuring scalability, performance, and compliance with Oracle Fusion best practices.
- Designed and reviewed highly complex SQL data templates, including multi-module joins, effective-dated logic, approval workflows, and historical/versioned data.
- Architected and governed RTF and Excel templates, implementing advanced formatting, conditional logic, bursting control, and localization requirements.
- Implemented and optimized report bursting strategies to distribute reports to multiple stakeholders (approvers, requestors, project managers) via email, FTP, and content server.
- Led ESS job configuration, scheduling, and monitoring, ensuring reliable automated report execution in high-volume production environments.
- Performed root-cause analysis for report failures, performance degradation, and data discrepancies, providing permanent fixes and preventive controls.
- Ensured data accuracy and reconciliation between BIP outputs, OTBI reports, and Oracle Fusion transactional screens.
- Acted as primary escalation point for production issues, managing SLAs and coordinating with Oracle Support when required.
- Guided junior developers and analysts through code reviews, SQL optimization, and reporting best practices.
- Partnered with functional leads, business users, and program management to translate business requirements into robust reporting solutions.
- Managed environment migrations (DEV → TEST → UAT → PROD), including impact analysis, validation, and release sign-off.
- Defined and maintained documentation, SOPs, and reporting governance standards for long-term support and audit readiness.
- Supported regulatory, audit, and management reporting, ensuring consistency, traceability, and controlled access.
- Played a key role in continuous improvement initiatives, reducing report execution time and manual effort through automation and SQL tuning.
Sr. Devops Lead/SQL Administrator/Developer
PCS Infinity
Noida
07.2023 - 12.2023
- Working on SQL Installation/Migrations, Setting up infrastructure different and Projects to deliver them within a time frame.
- Managing Backup and Recovery, Comvault database backup and restore, Cluster Setup (Windows/SQL Server), Code review and implementation on production server.
- Developed logins, roles and providing authentication modes and granting permissions.
- Performing Daily checks for assigned/unassigned tickets and tasks and resolve them on priority level.
- Executing Database Backup, Restores/Refreshes and Disaster Recovery procedures.
- Creating Database /migration/restoration on Azure IAAS/PAAS Analyzing and Resolving Locking, Blocking and Deadlocking issues.
- Working with Developers to improve Query performance and Database Performance.
- Deploy project code on Devops.
- Conducting Client meeting like Planning for Storage/DR DR Drill/Project Meeting.
- Work with server Infra team to improve performance of database server and Database.
- Work on storage drives and configuration with azure cloud.
- Work on data security, using encryption and Decryption.
Sr. Database Administrator
Apex
Gurugram
08.2022 - 07.2023
- Working on SQL Installation/Migrations, Setting up infrastructure different and Projects to deliver them within a time frame.
- Managing Backup and Recovery, Comvault database backup and restore, Cluster Setup (Windows/SQL Server), Code review and implementation on production server.
- Developed logins, roles and providing authentication modes and granting permissions.
- Performing Daily checks for assigned/unassigned tickets and tasks and resolve them on priority level.
- Executing Database Backup, Restores/Refreshes and Disaster Recovery procedures.
- Creating Database /migration/restoration on Azure IAAS/PAAS and Data Eddo documentation.
- Analyzing and Resolving Locking, Blocking and Deadlocking issues.
- Resolving and Identifying the SSIS packages and SSRS security issues.
- Participating in all kind of High Sev Calls, if issue not resolved then Involve to MS for prompt support.
- Conducting Client meeting like Planning for Storage/DR DR Drill/Project Meeting.
- Organized Migration & upgrade for large database and Migration of Database on azure Cloud.
- Deploying MS SQL Server to MS SQL Server Migration On-premise to On-premise & On-premise to Cloud MySql Data migration to SQL Server.
- Performing data refresh activities from Production to QA/Dev environments, PostGres Administration and Postgress data migration to snowflaks.
- Protecting the dbs by taking different kind of backups via different backup tools.
- Scheduling and implementing backup plans, individual backups and restorations using Idera SQL safe tools.
- Upgrading SQL Server and Patching in both standalone as well as on clustered environments.
- Liaising on Migration i.e. Databases, jobs, logins, packages and SPs to 2012/2016/2019.
Consultant (SQL Server 2014/2016 DBA Manager)
HCL Technology
Noida
01.2019 - 08.2022
- Worked as DBA Manager on MS-SQL-Server 2012/2016/2017.
- Administered all the database related production/UAT/DEV/SIT/DIT.
- Participated in different kind of Client meeting like Planning for Storage/DR DR Drill/Project Meeting.
- Performed SQL Server upgrades and Patching in both standalone as well as on clustered environments.
- Conducted Database Backup, Restores/Refreshes and Disaster Recovery procedures.
- Piloted around 200 databases across dev, test and production environment with different instance size.
- Reviewed Code review and implemented on production server.
- Implemented and Scheduled backup plans, individual backups and restorations using Idera SQL safe tools.
- Managed Database server up gradation to SQL 2016. Database migrations.
- Maintained Daily Database Backup strategy/LS design and Implementation Job monitoring/resolving.
- Monitored and Tuning SQL Server performance.
- Provided On Call support for All databases related Issues.
- Developed SSRS/SSIS Report and Package.
- Assisted in MySQL/Oracle DBA activity for skill up gradation.
- Coordinated with MySQL/MSSQL DBA Team, Involved in administrative related task.
- Communicated Shift Management/Discuss performance and team progress with Managements.
- Supported in Hiring process for technical and Non-technical discussion.
IT Analyst II ( DBA Support/Application Support)
iQor India Pvt. Ltd
New Delhi
07.2008 - 01.2019
- Boosted application deployment and joint effort deployments.
- Established the SLA (Service Level Agreement).
- Implemented and Designed comprehensive Backup plan and disaster recovery strategies.
- Implemented and Scheduled Replication process for updating our parallel servers.
- Executed Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
- Performed Table partitioning to improve I/O access.
- Created ad-hoc report query using SQL server 2008/2014/2016.
- Provided backend DB support for finance and HR application FitraQ /ProQor.
- Participated in finding the root cause for any failure in application writing adhoc report script for business and client users.
- Involved in debugging complex SQL query to full fill the business requirement and facilitated easy implementation to the front end application.
- Examined active batch jobs and involved in finding the reason for failure.
- Managed Data analysis and Report dashboard preparation.
- Involved with QA and Business user to test and analyses the new enhancement and changes.
Software Eng (Application Support)
Avenues International
New Delhi
04.2008 - 06.2008
- Created User Interface using ASP.Net Web Form controls.
- Developed and Designed user controls and Master Pages using ASP.NET and C#.
- Participated in designed and developed Web Services using C#, ADO. Net and XML.
- Executed Object-Oriented Programming concepts of interfaces, inheritance, abstraction and polymorphism.
- Designed web pages using a combination of HTML and JavaScript/DHTML, and developed Web Forms in ASP.NET.
- Used ASP.Net Validation controls for Input validation.
Software Eng (Application Support)
BMR Info Tech
Noida
01.2008 - 03.2008
- Created User Interface using VB.NET Windows form.
- Developed and Designed User Interface and functionality.
Education
Post Graduate - MCA
IEC College of Eng & Tech
UP, India01.2007
Graduation - BCA
Asian Institute of Management and Information Tech (AIMIT)
MCRPV, India01.2004
Intermediate -
St. Columbus College
Hazaribagh, India01.1999
BSEB -
High School Mugma
Dhanbad, India01.1997
Skills
- Database administration and design
- Business analysis
- Disaster recovery planning
- MS SQL and Sybase administration
- ETL processes
- Security and backup management
- Team management and leadership
- Azure DevOps and Jira
- Python programming
- Data science methodologies
- Hadoop ecosystem (HDFS, Hive)
- Snowflake data warehousing
- Business intelligence reporting tools
- Oracle Fusion modules (HCM, SCM)
- ServiceNow tracking system
- Cloud solutions (Oracle Fusion, AWS, Azure)
- Effective communication skills
- Decision making and collaboration
- Motivational leadership
- SQL optimization techniques
- Database performance tuning strategies
- Stakeholder engagement and management
- Project management principles
- Continuous improvement initiatives
Certification
- Six Sigma executive Black Belt certification, 5455/IND/2090, 06/05/21, https://www.henryharvin.com/
- Oracle Cloud Infrastructure Foundations Certified Associate, 289547279OCIBF2021, 12/30/21
- First LAP Learning Journey Certification at HCL
Accomplishments
- Successfully configured peer to peer Transaction Replication with Zero Data loss in Disaster recovery.
- Track record of Released more than 100 DB versions with consistency, accuracy and without error.
- Raised the highest money for donation as part of Leadership activity held by Human Resource Team.
- Configured the SQL Server reporting service, and automated various manual reports.
- Automated regular process for monitoring database and user management using Power-Shell.
- Configured High availability on multiple servers.
- Proficient in Automated log-shipping auto configuration for new database on any prod server using Power-Shell.
- Expertise in Automated monitoring process for missing SQL Jobs on Prod/DR to sync.
- Proficient in Automated monitoring process for missing database on DR or PRD.
Personal Information
Date of Birth: 11/14/82
Languages
- Hindi
- English
Timeline
Architect
Persistent System
12.2023 - Current
Sr. Devops Lead/SQL Administrator/Developer
PCS Infinity
07.2023 - 12.2023
Sr. Database Administrator
Apex
08.2022 - 07.2023
Consultant (SQL Server 2014/2016 DBA Manager)
HCL Technology
01.2019 - 08.2022
IT Analyst II ( DBA Support/Application Support)
iQor India Pvt. Ltd
07.2008 - 01.2019
Software Eng (Application Support)
Avenues International
04.2008 - 06.2008
Software Eng (Application Support)
BMR Info Tech
01.2008 - 03.2008
Post Graduate - MCA
IEC College of Eng & Tech
Graduation - BCA
Asian Institute of Management and Information Tech (AIMIT)
Intermediate -
St. Columbus College
BSEB -
High School Mugma