Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Timeline
Generic

Ajit Kumar Subudhi

Bangalore

Summary

Supportive Team Lead with 8 years of experience leading teams. Expert in following detailed production schedules with distinguished history of maximizing productivity. Committed to proactive reorganization for optimized safety and efficiency.

Overview

18
18
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
2
2
Languages

Work History

Team Lead

Neovia Logistics Services India Pvt. Ltd
01.2015 - Current
  • 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.
  • Monitor database security,implement DBSAT to mitigate security related risks.
  • Upgraded OEM to 13.5 and implement to monitor SQL server DBs.
  • Installed and maintained MS SQL Server 2008/2012/2014/2016 on Windows 2007/2010 Server.
  • 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.
  • Migrate database Using datapump between different versions.
    •Implemented Transportable Tablespace option for migration.
    •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.
  • Installed and maintained postgres database as per application requirements with help of Postgres .
  • Maintain postgres backups and perform disaster recovery in case a disaster destroys the database.
    •Monitor security and prevent any unauthorized access to the postgres database.
    •Resolve any production data issues, Tablespace management and Role management in postgres DB environment.
    •Develop automation technologies to accelerate the process of data loading.
    •Worked on creating, backing up and restoring database in aws EC2 instance and managing monitoring cloud tail.
    •Migrated data from oracle to postgres and maintained backup and restore of postgres database.
  • Clone PostgreSQL instance using Pgdump and snapshots.
  • Create and maintain database replication on AWS RDS using GUI and CLI.
  • Developed procedure to create Postgres instance on AWS EC2 server..
  • Provides hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary.

Technical Services Specialist

IBM India Pvt ltd
10.2011 - 09.2014
  • Oracle 11g 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 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.

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.
  • Worked for a team responsible for 24 x 7 on-call support as well as product development.
  • 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).
  • Mentoring team members to handle day to day oracle activities.

Oracle DBA

Softenger India Pvt Ltd
10.2006 - 11.2007
  • Worked for team responsible for 24*7 on call support.
  • 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 and used DataGuard to Migrate huge and critical databases with 99% uptime.
    •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.

Education

B.E - Electrical & Electronics Engg

NIST College(Affiliated To Berhampur Univ)
Berhampur, Odisha
09.2001 - 06.2005

Skills

    Database: Oracle 19c,12c, 11gR2, Oracle 10gR2, Oracle 9i, Postgresql, SQL server 2008 R2, 2012, 2014 and 2016

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, Oracle to PostgreSQL

Oracle Products: OEM 13c, 12C, 11g (Grid Control), Oracle cluster ware, RMAN, Data pumps, ASM, AWR, ASH, ADDM, and CRSCTLOperating System: Red Hat Enterprise Linux (RHEL) 4x, 5x, 6x, Sun Solaris 58, 59, 510, Windows /XP/2003/2008, IBM AIX, HP UNIX 11i

Cloud/Azure/AWS

SQL, PL/SQL, UNIX shell scripting

Tools: OEM, TOAD, Fog light, Zabbix, Grafana, Ticketing Tools Service Now, ILMT,DBSAT

Certification

Oracle Certified Professional (OCP-DBA) in Oracle 9i/11g.

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. OEM 13.4 upgrades and implement on SQL server. 12c Data guard implementation and maintenance.
  • Automated Database health check alert mechanism and backup recovery using Shell scripting for Oracle,PostgreSL 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.

Timeline

Team Lead

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(Affiliated To Berhampur Univ)
09.2001 - 06.2005
Ajit Kumar Subudhi