Akshay Kumar
Patna
Summary
Want to work in dynamic and stimulating organization with stimulating and professional colleagues, where I can use my capability to achieve the organizational goal and to grow personally and professionally. I want to earn more and more of knowledge which is my first priority in life.
Overview
21
21
years of professional experience
Work History
Rackspace India private limited
01.2010 - Current
- Handling team members and several high end customer projects.
- Database upgrade from 11g to 12c, 18c and 19c.
- Database migration from one platform to another.
- Troubleshooting day today errors.
- Performance tuning of database and stream lining several database environment.
- Creation of several standby databases including cascade standby database.
- Storage migration from asm to non-asm with zero downtime.
- Worked on exadata and oci patching scaling and maintenance.
- Worked on Amazon RDS and EC2 instances and their parching and upgrade.
- Worked on backup configuration and troubleshooting backup issues.
- Worked on science logic monitoring and configuration.
- Worked on deployment of OEM grid control and active passive em configuration.
- Worked on auditing and implementation of fine grained auditing for database.
- Worked on RMAN refreshes and have sound knowledge of doing recovery in worst scenarios.
- Worked on Data guard broker configuration with multiple standby databases.
- Generating database health check report and orachk report.
- Load testing with database monitoring and awr reports review.
- Joined call with customer on planning code execution and migration projects and upgrades.
- Worked on several database failover and switchover scenarios.
- Worked hard on getting customers on board and attended meetings for smoothful transition.
- Worked on several data ware house projects as well involving business intelligence.
- Participated in several dr drill project involving real time application testing.
- Handled several telecoms, pharmaceuticals and banking domain project.
- Worked on oci cloud database management and migration and patching.
- Worked on exadata patching and exadata database management.
- Worked as team lead and team mentor for several years and worked on several technologies involving golden gate projects and several migration/upgrade projects.
Engineer-database administrator
WIPRO INFOTECH
08.2006 - Current
- Monitoring database using various views.
- Alert log file monitoring for database errors.
- User traces files monitoring.
- Creation of database objects as needed.
- Writing various database health monitoring scripts.
- Made oracle session tracing scripts using shell scripting.
- Monitoring daily reports to minimize the load.
- Taking object backup as needed and requested.
- Creation of database link and monitoring them. Needed for revenue data.
- Index monitoring and rebuilding them as needed.
- Applying application patches.
- Troubleshooting database errors.
- Solving client request.
- Running various database health checkup scripts and OS health scripts and analyzing them.
- Following daily database CHECKLIST for DBA.
- Installed oracle7, oracle 8i, and oracle9i and oracle 10g server here on different sun Solaris and Linux Platform which are used in production servers.
- Created one module in Oracle to connect to mysql database, take its backup and successfully tested the Recovery of mysql tables through oracle.
- Managing Oracle 8i Parallel server (OPS) with 2 nodes.
- Wipro is among the top IT companies of INDIA. It has got large customer base having more than 30000 thousand technical staff all over the country. It is one of the top company in providing value added services and ensure complete customer satisfaction.
Bharti ICS (Airtel)
01.2008 - 08.2008
- Testing and configuration of 10g RAC on Solaris 10.
- Installation and configuration of Oracle 10g in active-passive mode on Linux cluster.
- Configured load balancer and switchover on 10g RAC.
- Created and implemented RMAN backup script on veritas netbackup.
- Hardening of all the Oracle production server.
- Initial level of performance tuning before go-live.
- Created and implemented automated backup, report and monitoring scripts.
- Created and implemented automated Backup Script for Oracle Clusterware like OCR & Voting disks and SRVCTL Config file.
- Monitoring of cluster, ASM and Oracle services.
- Upgrade of Oracle 10g RAC Database.
- Patching of CRS and oracle 10g RAC database.
- Migration of Standalone DB to ASM instance.
- Migration of RAC database from 1 server to another RAC server.
- Following daily DBA checklist.
- Primarily look after all major escalations there.
Vijaya Bank
Bangalore
01.2008 - 02.2008
- Monitoring database using various views.
- Alert log file monitoring for database errors.
- User trace file monitoring.
- Creation of database objects as needed.
- Monitoring daily reports to minimize the load.
- Taking object backup as needed and requested.
- Applying application patches.
- Index monitoring and rebuilding them as needed.
- Running various database health checkup scripts and OS health scripts and analyzing them.
- Troubleshooting database errors.
- Solving client request.
- Following daily database CHECKLIST for DBA.
- Also looking after FINNACLE application and was running and generating reports for all branches.
- Then mailing the reports using batch mailer software.
Oriental bank of commerce
Mumbai
01.2008 - 01.2008
- Monitoring database using various views.
- Alert log file monitoring for database errors.
- User traces file monitoring.
- Creation of database objects as needed.
- Daily backup using tape library. Changing of tape on regular basis and labeling new tape. Additional backup on data cartridges.
- Running synchronization script for cluster database.
- Taking object backup as needed and requested.
- Monitoring daily reports to minimize the load.
- Index monitoring and rebuilding them as needed.
- Troubleshooting database errors.
- Solving client request.
- Running various database health checkup scripts and OS health scripts and analyzing them.
- Following daily database CHECKLIST for DBA.
DBA
Tacker Technologies LTD
01.2005 - 07.2006
- Installation and configuration of Oracle database.
- Upgradation and migration of database using Import/Export and database upgrade assistant.
- Creation of Tablespace, Resizing Tablespace and moving to different location.
- Creating & Managing Users, assigning role & privileges to user, assigning password security and resources.
- Managing Tables, Indexes, views, sequences & Constraints.
- Auditing using triggers and FGA package.
- Writing scripts for monitoring and automation of job.
- Troubleshooting using Alert log and Trace file.
- Loading data into Database through SQL Loader.
- Devising strategy for database security.
- Listener configuration, Dedicated & Shared server configuration.
- Backup & Recovery (User managed), RMAN, Tablespace point in time recovery (TSPITR), Database point in time recovery (DBPITR), Block-level Recovery.
- Import & Export of user, table, Tablespace. Export of data from Excel and Access and SQL to Oracle and vice versa using ODBC and DSN.
- Report generation (Statspack) using UTLBSTAT & UTLESTAT, using SPCREATE.sql and analysis.
- Checking integrity of database using DBVERIFY and identifying any block corruption.
- Creation of Clone database for testing and as a backup strategy.
- Tacker Technology LTD is fast growing company with client all over India. It basically deals in Networking and database support for the Clients and has group of about 400 technical people. Tacker is among best IT companies with projects going on all over India. It has emerged as one of the best Networking Company using advance technology in providing network solutions and database services to provide complete customer satisfaction.
Education
Bachelor in Information Technology -
IGNOU
HND - higher national diploma in computing
edexcel international
UKDoeacc ‘O’ level -
OCP oracle 9i - Oracle certified professional
OCP oracle 10g - Oracle certified professional
ORACLE 10g RAC certified Expert -
Oracle 18c and 19c RAC certified -
MCA -
Manipal
Skills
- Oracle 7
- Oracle 8i
- Oracle 9i
- Oracle 10g
- Oracle 11g
- Oracle 12c
- Oracle 18c
- Oracle 19c
- RAC
- Data Guard
- Troubleshooting
- Performance Tuning
- Windows
- Linux
- Aix
- Solaris
- Toad
- Knowledge Expert
- OEM
- EBS
- Veritas Netbackup
- Putty
- Xmanager
- XShell
- Xsftp
- VNC Viewer
- WinSCP
- Remote Desktop
- Commvault
- Rubrik
- SL Monitoring
- Data Store
- Batch Mailer
- UNIX
- SUN Solaris
- Installation
- Configuration
- Upgradation
- Migration
- Basic Administration
- Creation of Tablespaces
- Rollback Segment
- Resizing Tablespaces
- Managing Users
- Assigning Role
- Privileges
- Password Security
- Database Security
- Managing Tables
- Indexes
- Views
- Sequences
- Constraints
- Managing Extents
- Datafiles
- Partitioning
- Auditing
- Triggers
- FGA Package
- Writing Shell Scripts
- SQL
- PL/SQL
- Loading Data
- Listener Configuration
- Dedicated Server Configuration
- Shared Server Configuration
- Creation of Database Link
- Backup & Recovery
- User Managed
- RMAN
- Recovery Catalog
- Tablespace Point in Time Recovery
- Database Point in Time Recovery
- Block-Level Recovery
- Backup Script
- RMAN Script
- Automail Utility
- Applying Database Patches
- CPU Patches
- Import & Export Utility
- Tablespace Import & Export
- Database Import & Export
- Export of Data
- ODBC
- DSN
- Oracle 10g DATAPUMP
- Logical Backup
- Interconnecting Oracle with MySQL
- Microsoft SQL
- Access
- Checking Integrity
- DBVERIFY
- Block Corruption
- Alert Log File
- Trace File
- Report Generation
- Statspack
- UTLBSTAT
- UTLESTAT
- SPCREATEsql
- Gathering Statistics
- DBMS_STATS Package
- Plan Table
- ANALYZE
- ESTIMATE Command
Hardware Skills
NA
Os Familiarity
- Windows
- Linux
- Aix
- Solaris
Tools Familiarity
- Toad (for oracle monitoring)
- Knowledge expert (For oracle monitoring)
- OEM (for oracle monitoring)
- EBS 'Enterprise backup solution' (LAGATO) (For taking backup)
- Veritas Netbackup
- Putty
- Xmanager
- XShell
- Xsftp
- VNC viewer
- Winscp
- Remote desktop for telnet and connection to server or remote server
- VERITAS net back up
- Commvault
- Rubrik
- SL monitoring
- Data store
- EBS
- Batch mailer (to mail reports to multiple clients at once quickly)
Personal Skill Areas
- Having good concepts of UNIX, SUN SOLARIS and LINUX for Oracle administration
- Installation, configuration and upgradation and migration of Oracle database
- Basic administration of Linux and Sun Solaris Servers
- Creation of Tablespaces, Rollback segment, Resizing Tablespaces and moving to different location
- Creating & Managing Users, assigning role & privileges to user, assigning password security and resources
- Managing database security
- Managing Tables, Indexes, views, sequences & Constraints
- Managing & allocating extents, datafiles, partitioning table & indexes
- Auditing using triggers and FGA package
- Writing shell scripts for automation of job
- Writing scripts using SQL and PL/SQL for Automatic Report and monitoring
- Loading data into Database through SQL Loader
- Listener configuration, Dedicated & Shared server configuration
- Creation of database Link
- Backup & Recovery (User managed), RMAN, Recovery catalog creation and maintenance, Tablespace point in time recovery (TSPITR), Database point in time recovery (DBPITR), Block-level Recovery
- Creation of backup script or RMAN script for automation of backup
- Creation of automail utility through oracle
- Applying database patches and CPU patches
- Import & Export utility with good command over Tablespace import & export (with both methods), Database import & export
- Export of data from Excel, Access, MySql and SQL to Oracle and vice versa using ODBC and DSN
- Oracle 10g DATAPUMP for logical backup
- Logical Backup through Oracle 10g Data pump Utility
- Interconnecting Oracle with Mysql, Microsoft sql, Access
- Checking integrity of database using DBVERIFY and identifying any block corruption
- Troubleshooting using Alert Log file and Trace file
- Report generation (Statspack) using UTLBSTAT & UTLESTAT, using SPCREATE.sql
- Gathering Statistics, analyzing it through dbms_stats package, Plan table, ANALYZE and ESTIMATE command, and through Autotrace utility
- Creation of Physical standby database and maintenance, Switchover
- DR DRILL Planning, implementation
- Creation of clone database for testing and UAT
- Oracle Home Cloning
- Active-passive oracle configuration on SUN and LINUX Cluster
- Oracle 10g RAC designing, installation, maintenance
- Monitoring of CRS, ASM, OCR AND Voting Disk backup and integrity check
- Addition and deletion of RAC node
- Oracle Load Balancer configuration, Failover configuration client side and server side
- Implementation of Oracle ASM on RAC and NON-RAC database
- Installation of Oracle 10G Grid Control, installation of agents, Addition of servers and maintenance
- Oracle Advance security configuration, Implementation of Encrypted data flow over network
- Hardening of Oracle server
Languages
- English
- Hindi
- English
Hobbies and Interests
- Reading IT Related Books
- Watching documentaries
Desired Job
Oracle Database Administrator
Personal Information
- Total Experience: 20 yrs (as Oracle DBA)
- Date of Birth: 05/28/80
- Gender: Male
- Marital Status: Married
Languages
English
Upper Intermediate
B2
Timeline
Rackspace India private limited
01.2010 - Current
Bharti ICS (Airtel)
01.2008 - 08.2008
Vijaya Bank
01.2008 - 02.2008
Oriental bank of commerce
01.2008 - 01.2008
Engineer-database administrator
WIPRO INFOTECH
08.2006 - Current
DBA
Tacker Technologies LTD
01.2005 - 07.2006
Bachelor in Information Technology -
IGNOU
HND - higher national diploma in computing
edexcel international
Doeacc ‘O’ level -
OCP oracle 9i - Oracle certified professional
OCP oracle 10g - Oracle certified professional
ORACLE 10g RAC certified Expert -
Oracle 18c and 19c RAC certified -
MCA -
Manipal