SUSHIL KUMAR M R
BANGALORE
Summary
Highly accomplished, deeply-driven, professional Oracle Database Administrator with over 8 years of experience, with a profound knowledge in database security and user management, backup and recovery, database design, performance monitoring and tuning, migration, upgrades, cloning, and replication. Proficient in an assortment of technologies including Oracle 10g, 11g, 12c, MySQL and MS SQL server. Exceeds ongoing and overlapping deadlines in fast-paced environments.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Oracle Database Administrator
WIPRO CLIENT ;CITI
07.2020 - Current
- Providing administrative support and maintenance on Oracle 10g, 11g and 12c installations, database creation, database security, database optimization and tuning.
- Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD.
- Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.
- Performing other Security related tasks including Transparent Data Encryption (TDE).
- Implementing Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
- Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.
- Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
- Upgrading databases from 10g to 11g and 11g to 12c. Appling PSU and bug fix patch.
- Implementing, tuning and maintaining Oracle database using OEM.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Participating in the 24/7 on-call DBA rotation schedule.
- Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
- Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM
- Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases
- Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.
- 24x7 remote support and on call rotation
- Proposed database changes to ease monitoring and administrative effort.
- Troubleshot database issues to create and resolve trouble tickets.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
Database Administrator
HPE(MINDTECK), DXC
10.2015 - 08.2020
- Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
- System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
- Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
- Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.
- Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
- Worked on user management mainly on grants, privileges, roles, and profiles.
- Performed hot and cold backup and recovery using RMAN
- Worked on application and database security (data access, passwords, network, etc.).
- Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
- Tuning test and production database by altering the parameters.
- Export and Import of database objects to copy from one database to another database.
- Investigating suspicious database activity using Fine-Grain Auditing.
- Write database documentation, including data standards, procedures, and definitions.
- Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
Oracle Database Administrator
Sri Akshay Technologies
02.2014 - 10.2015
- Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
- System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
- Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
- Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.
- Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
- Worked on user management mainly on grants, privileges, roles, and profiles.
- Performed hot and cold backup and recovery using RMAN
- Worked on application and database security (data access, passwords, network, etc.).
- Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
- Tuning test and production database by altering the parameters.
- Export and Import of database objects to copy from one database to another database.
- Investigating suspicious database activity using Fine-Grain Auditing.
- Write database documentation, including data standards, procedures, and definitions.
- Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
- 24x7 remote support and on call rotation
Order Management Specialist
DELL
05.2013 - 01.2014
- Reviewed orders for accuracy, errors and omissions to minimize incorrect shipments.
- Maintained knowledge of new product offerings and changes for order provisioning processes.
- Sent emails to communicate order status and informed customers of back-orders or shipping delays.
- Liaised with management to resolve complex order issues and problems to maximize customer satisfaction.
- Reviewed order terms and conditions with customers to comply with company policy.
- Handled customer credit applications and partnered with credit manager for approval and account setup.
- Researched and addressed customer inquiries, questions and issues within business days to promote optimal customer service.
Order Management Analyst
Seaton & Concentrix
05.2011 - 05.2013
- Reviewed order terms and conditions with customers to comply with company policy.
- Interfaced with sales, operations and functional groups to facilitate order flow and meet processing metrics.
- Sent emails to communicate order status and informed customers of back-orders or shipping delays.
- Liaised with management to resolve complex order issues and problems to maximize customer satisfaction.
- Maintained knowledge of new product offerings and changes for order provisioning processes.
- Reviewed orders for accuracy, errors and omissions to minimize incorrect shipments.
- Leveraged on-site observation and personal interviews to identify team and individual strengths.
- Restructured procedures through coordination with compliance director to create and execute projects.
Store Associate
MANPOWER(VODAFONE)
10.2008 - 10.2010
- Answered questions about store policies and addressed customer concerns.
- Greeted customers, helped locate merchandise, and suggested suitable options.
- Balanced and organized cash register by handling cash, counting change, and storing coupons.
- Coordinated restocking of sales floor with current merchandise and accurate signage for current promotions.
- Checked pricing, scanned items, applied discounts, and printed receipts to ring up customers.
- Monitored sales floor and merchandise displays for presentable condition, taking corrective action such as restocking or reorganizing products.
- Located merchandise across various stores to address customer needs.
- Evaluated prices and conducted audits to detect and correct price discrepancies.
Education
Master of Science - Chemistry
BANAGLORE UNIVERSITY
BANGALORE06.2024
Bachelor of Science - Chemistry
GOVERMENT SCIENECE COLLEGE
BANGALORE06.2005
Skills
- Backup and Recovery
- Data Pump and Export/Import
- Transparent Database Encryption
- Database Security
- Database Upgrade and Migration
- Oracle Performance Tuning
- Patch Set Management
- Oracle RAC
- Oracle Data Guard
- TOAD
- SQL Developer
- SQL Loader
- Oracle Enterprise Manager
- Oracle VM Virtual Box
Certification
Oracle Certified Professional (12c OCA)
Timeline
Senior Oracle Database Administrator
WIPRO CLIENT ;CITI
07.2020 - Current
Database Administrator
HPE(MINDTECK), DXC
10.2015 - 08.2020
Oracle Database Administrator
Sri Akshay Technologies
02.2014 - 10.2015
Order Management Specialist
DELL
05.2013 - 01.2014
Order Management Analyst
Seaton & Concentrix
05.2011 - 05.2013
Store Associate
MANPOWER(VODAFONE)
10.2008 - 10.2010
Master of Science - Chemistry
BANAGLORE UNIVERSITY
Bachelor of Science - Chemistry
GOVERMENT SCIENECE COLLEGE
Similar Profiles
Vijaykumar KananiVijaykumar Kanani
Investment Technology SME at Oracle | Client: Citi Bank Wealth Technology -CIMInvestment Technology SME at Oracle | Client: Citi Bank Wealth Technology -CIM
Srajan LadSrajan Lad
Technology Lead & Project Manager at LTIMindtree (Client: Citi)Technology Lead & Project Manager at LTIMindtree (Client: Citi)
Aditya BoraAditya Bora
B. Analyst Apr22-Jun24, Consultant I Jul24-Present at EXL Services Pvt Ltd (Client: Citi Bank)B. Analyst Apr22-Jun24, Consultant I Jul24-Present at EXL Services Pvt Ltd (Client: Citi Bank)