Summary
Overview
Work History
Education
Skills
Timeline
Generic

Akshay Adhatrao

Vadodara

Summary

Dynamic Database Engineer with a proven track record at I3 Verticals, excelling in T-SQL and PL/SQL to optimize performance and enhance data integrity. Adept at strategic planning and database design, I thrive in fast-paced environments, ensuring seamless data management and recovery while fostering collaboration across teams.

Overview

4
4
years of professional experience

Work History

Database Engineer

I3 Verticals
Vadodara
11.2021 - Current
  • Created table structures based on application requirements, ensuring they met functional specifications and business needs.
  • Developed comprehensive data models and data dictionaries using ERWIN Data Modeler to ensure data consistency and clarity across systems.
  • Handled complex SQL operations including DDL, DML commands, joins, GROUP BY, functions, views, and stored procedures to optimize data management and retrieval.
  • Demonstrated PL/SQL scripting proficiency, tuning scripts for enhanced performance and system efficiency.
  • Created and maintained database standards, ensuring updates were in alignment with product requirements and business goals.
  • Validated and executed SQL scripts across respective databases, ensuring seamless integration and error-free execution.
  • Developed and maintained SQL Maintenance Plans, including regular database optimization tasks, backups, and index rebuilds.
  • Led the downgrade process of SQL Server 2016 to SQL Server 2008 R2, ensuring data compatibility and integrity.
  • Managed backup and recovery processes for application databases, including the creation and restoration of pluggable databases within Oracle environments.
  • Applied Oracle security measures and backup/recovery procedures to ensure system data confidentiality and recovery in case of failure.
  • Proficient in data transfer using import/export utilities and datapump (both command-line and interactive mode), enabling efficient data migration.
  • Led efforts in rebuilding and reorganizing tables and indexes to enhance performance and query efficiency.
  • Performed daily DBA tasks, including database backup and recovery procedures, to ensure continuous availability and reliability.
  • Fulfilled essential DBA activities, including user management, creating tablespaces, synonyms, indexes, sequences, and managing space allocation and monitoring database performance.
  • Configured and managed Oracle multitenant container databases (CDB) and pluggable databases (PDB) in Oracle 19c, optimizing database performance and scalability.
  • Engaged in performance strategic planning, focusing on both logical and physical data modeling for optimal database performance.
  • Experienced in cloning databases from production to test and development environments, ensuring seamless transition and data consistency during migrations.
  • Installed and configured Oracle 19c servers for efficient database management, ensuring high availability and robust database operations.

Education

Bachelor of Engineering (BE) - Mechanical Engineering

Neotech Institute of Technology
Vadodara
12.2019

Skills

  • T-SQL
  • PL/SQL
  • Oracle SQL Developer
  • SQL Plus
  • SSMS
  • Erwin Data Modeler
  • Oracle Data Modeler
  • JIRA
  • SSIS
  • Database Management & Design
  • PL/SQL & Tuning
  • Database Performance & Optimization
  • Database Security & Recovery
  • SQL Server & Oracle Environment Management
  • Development & Support
  • Database Maintenance & Monitoring

Timeline

Database Engineer

I3 Verticals
11.2021 - Current

Bachelor of Engineering (BE) - Mechanical Engineering

Neotech Institute of Technology

Similar Profiles

CREATE PROFILE
Akshay Adhatrao