Summary
Overview
Work History
Education
Skills
Certification
LNGG
Timeline
Additional Information
PROJECT HIGHLIGHTS
Generic

Ajit Kumar Subudhi

Bangalore

Summary

Database Supervisor with 17+ years of experience managing Oracle and PostgreSQL database environments in enterprise settings. Proven expertise in database administration, migration, security management, and capacity planning. Strong background in leading cross-functional teams, project management, and implementing process improvements. PMP-certified professional skilled at aligning database operations with organizational goals.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Database supervisor

Neovia Logistics Services India Pvt. Ltd
01.2015 - Current
  • Lead a team of 12+ DBAs managing Oracle and PostgreSQL databases across development, UAT, and production environments.
  • Oversaw Oracle 19c upgrade projects and PostgreSQL migrations from Oracle, achieving 99.9% uptime.
  • Implemented monitoring and alerting using OEM 13c and custom scripts, reducing unplanned downtime by 30%.
  • Coordinated capacity planning and storage forecasting in collaboration with infrastructure teams.
  • Managed security audits using DBSAT, pg_audit, and implemented encryption policies.
  • Mentored junior DBAs and conducted quarterly training on PostgreSQL administration and Oracle patching.
  • Developed SOPs for backup, disaster recovery, and patch management processes.
  • Installation, Configuration and update of Oracle 11g,12c & 19c using DBCA, DBUA, Backup and Recovery using RMAN, Data Guard administered for High Availability: Disaster Recovery, Database upgrade from 11g,12c to 19c
  • Database automation using Shell scripting for Oracle, PostgreSQL database maintenance and backups
  • Maintenance of Azure Databases
  • Comprehensive knowledge of SQL server deployment, migration, patching, troubleshooting optimization, maintenance (High Availability (HA) and Disaster Recovery (DR)
  • Configured High availability solution –Clustering, Always-On, Database mirroring and Log Shipping
  • Performed Database Migration from On-Premises SQL environment to Azure Database in cloud
  • Migrated Oracle Db to SQL server DB, My SQL to MariaDB
  • Handling License Management for Oracle/SQL server and DB2 to reduce cost to company and saved $2.5M
  • Process documentation and preparation of Root Cause Analysis (RCA) reports
  • Incremental TTS option has been used for less down time migration for huge database
  • Ensure database has security standards implemented and complies with Risk and Audit requirements
  • Monitor security and prevent any unauthorized access to the Postgresql database
  • Resolve any production data issues, Tablespace management and Role management in Postgresql DB environment
  • Worked on creating, backing up and restoring database in AWS EC2 instance and managing monitoring cloud tail
  • Create and maintain database replication on AWS RDS using GUI and CLI
  • Developed procedure to create Postgresql instance on AWS EC2 server.
  • Provides hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary.
  • Developed comprehensive documentation for database procedures, policies, and troubleshooting guidelines.
  • Led successful migration of databases to new platforms, ensuring seamless transition for end users.
  • Collaborated with cross-functional teams to gather requirements for new database systems or modifications to existing ones.
  • Increased system stability by proactively identifying potential issues and resolving them before they escalated into major problems.
  • Streamlined data reporting processes by automating routine tasks and creating custom queries for unique requests.
  • Implemented BI solution framework for business intelligence projects.

Technical Services Specialist

IBM India Pvt ltd
10.2011 - 09.2014
  • Worked for a team responsible for24 x 7 on-call support as well as product development support of 850+ production databases and 1200+ non-production databases running on oracle 10gR2/11gR2 including RAC database and physical standby
  • Automation of Database RMAN backup, Threshold alerts like (Space issues, CPU Utilization, tuning reports, Backup alerts), TDPO Configuration using shell script
  • Installing & Upgrading Oracle 10g,11g on top of AIX, Solaris & Windows
  • Database monitoring automation using Shell scripting for Oracle database maintenance and backups.
  • Reduced downtime, maintaining thorough documentation of incidents and resolutions to prevent future issues.
  • Improved overall system reliability by proactively identifying vulnerabilities and taking corrective actions promptly.
  • Diagnosed severity of customer issues, escalating tickets to appropriate personnel for intervention.

Senior Specialist

HCL Comnet Ltd
01.2011 - 10.2011
  • Installing & Upgrading Oracle 10g,11g on top of AIX, Solaris & Windows
  • Oracle 11gR2 RAC implementation, adding cluster nodes, Applying CPU and security patch to cluster, databases refresh using Data pump-online backup, database maintenance and administration
  • Worked for a team responsible for 24 x 7 on-call support as well as product development support of 40+ production databases and 20+ non-production databases running on oracle 11gR2 including RAC database and physical standby
  • Coordinating with Oracle for bug fixes (P1- SR)
  • Applying patches Oracle database according to the recommendations from oracle
  • Maintaining standby database (DATA GUARD) server and checking periodically for continuity of business.

IT Analyst

TATA Consultancy Services Ltd
11.2007 - 12.2010
  • Installing & Upgrading Oracle 9i, 10g on top of AIX, Solaris & Windows
  • Oracle 10g Data guard implementation, databases refresh using Data pump-online backup, database maintenance and administration
  • Database automation using Shell scripting for database health check and regular DB backups (Logical and Physical).
  • Applying CPU and security patch to cluster, databases refresh using Data pump-online backup, database maintenance and administration
  • Mentoring team members to handle day to day oracle activities.
  • Reduced manual processes, automating routine tasks to free up resources for strategic initiatives.
  • Reduced system downtime, ensuring timely backups and disaster recovery plans were in place.

Oracle DBA

Softenger India Pvt Ltd
10.2006 - 11.2007
  • Installing & Upgrading Oracle 9i, 10g on top of AIX, Solaris & Windows
  • Oracle 9i Data guard implementation, databases refresh using Datapump-online backup, database maintenance and administration
  • Maintaining standby database (DATA GUARD) server and checking periodically for continuity of business
  • Responsible for EOD and BOD process working in parallel with Application vendor
  • Managed tablespaces and datafiles, creating, altering tablespaces, moving, renaming datafiles
  • Migrated using Datapump Export/Import for small databases and non-critical databases
  • Planed and documented all migration steps and coordinated with different teams during the deployments
  • Tested Switchover and failover between data centers before migration of production databases using Dataguard
  • Worked with business units to define data retention, archiving/purging policy and implementation of the same to control database growth.
  • Managed Oracle databases, maintaining high levels of performance, availability, and security.

Education

B.E - Electrical & Electronics Engg

NIST College
Berhampur, Odisha
05.2005

Skills

  • Database: Oracle 19c,12c, 11gR2, Oracle 10gR2, Oracle 9i, PostgreSQL, SQL server 2008 R2, 2012, 2014 and 2016
  • Cross-platform database migration
  • Oracle Products: OEM 13c, 12C, 11g (Grid Control), Oracle cluster ware, RMAN, Data pumps, ASM, AWR, ASH, ADDM, and CRSCTL
  • Operating System: Red Hat Enterprise Linux (RHEL) 4x, 5x, 6x, Sun Solaris 58, 59, 510, Windows /XP/2003/2008, IBM AIX, HP UNIX 11i
  • Cloud database management
  • UNIX shell scripting expertise
  • Tools: OEM, TOAD, Fog light, Zabbix, Grafana, Ticketing Tools Service Now, DGbroker, ILMT, DBSAT
  • Team Leadership & Mentoring
  • ITIL & Change Management Processes
  • Languages: English, Hindi, Oriya
  • Valid Indian Passport holder
  • NoSQL databases

Certification

  • PMP (Project Management Professional), PMI
  • Oracle Certified Professional (OCP-DBA) in Oracle 9i/11g.
  • Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator.
  • PostgreSQL Administration Certified
  • Completed certification 2016-Administering a SQL Database Infrastructure (70-764).
  • Microsoft Certified: Azure Administrator Associate.

LNGG

English
Hindi
Oriya

Timeline

Database supervisor

Neovia Logistics Services India Pvt. Ltd
01.2015 - Current

Technical Services Specialist

IBM India Pvt ltd
10.2011 - 09.2014

Senior Specialist

HCL Comnet Ltd
01.2011 - 10.2011

IT Analyst

TATA Consultancy Services Ltd
11.2007 - 12.2010

Oracle DBA

Softenger India Pvt Ltd
10.2006 - 11.2007

B.E - Electrical & Electronics Engg

NIST College

Additional Information

  • Implementing ITIL processes - Incident management, Problem management, Change and Release management, and Request Fulfillment and Continuous service improvement.
  • Sound understating of project Management and currently leading team and handling projects in onsite onsite-offshore model.
  • Takes care of Customer escalation, attends weekly meeting with to ensure smooth customer delivery is in progress.
  • Worked on License Management for Oracle/SQL server and DB2 to reduce cost to company.
  • Experience of Database Administration in Oracle, SQL Server,PostgresQL, design, development, maintenance and production support of relational databases, business applications, new server setup, SQL Server installation, upgrade, migration.
  • Strong knowledge of High Availability in 11g/12c such as RAC, DATA GUARD. Have successfully implemented 2/4 Node 11gR2/12cR2 RAC Database on LINUX, AIX environment.
  • Strong knowledge of Oracle DB Upgrade from 11g to 12c, 12c to 19c.. Database Encryption – TDE and implement DBSAT.
  • Automated Database health check alert mechanism and backup recovery using Shell scripting for Oracle,PostgreSQL and DB2 database maintenance.
  • Migration of current data center customer environments to Azure and develop appropriate processes such as change management for the Cloud. Knowledge of Azure Database Migration Service: Migration of on - premises SQL Server database with Microsoft Data Migration.

PROJECT HIGHLIGHTS

  • Oracle to PostgreSQL Migration: Successfully migrated 10+ critical applications from Oracle 12c to PostgreSQL 13, reducing licensing costs by 25%.
  • Capacity Planning via OEM 13c: Implemented predictive capacity planning dashboards integrated with executive reporting.
  • Database Consolidation: Reduced database sprawl by consolidating 50+ databases into shared environments while maintaining performance SLAs.

Similar Profiles

CREATE PROFILE
Ajit Kumar Subudhi