Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Timeline
MongoDB DBA Experience
Oracle DBA Experience
MS SQL, PostgreSQL, And MySQL DBA Experience
Work Availability
Hobbies and Interests
Work Preference
Generic
Hemalatha Venkatesan

Hemalatha Venkatesan

Chennai

Summary

Skilled Database Administrator with 7+ years extensive experience in designing, implementing, and maintaining high-availability database systems across multiple platforms including MSSQL, Oracle DB, PostgreSQL, MySQL and MongoDB. Proven track record of optimizing database performance through effective query tuning, capacity planning, and architecture enhancements to meet dynamic business needs. Adept at ensuring data integrity, security, and availability while supporting seamless operations in fast-paced environments.

Overview

7
7
years of professional experience
2
2
Certification

Work History

Database Administrator

EPAM systems
10.2024 - Current
  • Managing and providing end-to-end database technical support, along with migration support, archival solution planning and HA solution architect planning and implementation on varied RDBMS systems: MSSQL, PostgreSQL, Oracle DB, and Oracle Exadata.
  • Analyze and optimize database queries and indexes, develop technical and functional specifications for different flavors of the database, and resolve complex database and system issues promptly.
  • Install new software releases, patches and upgrades on production servers as required.
  • Conducts regular database capacity planning to accommodate business growth.
  • Developing redundant systems and procedures for HA, disaster recovery, and archiving to maintain data protection.
  • Work on the installation and maintenance of database software and updates.
  • Analyze each database application and make necessary adjustments to parameters and architecture to improve performance-based OEM and SolarWinds metrics and tuning.
  • Automating database various alerts and day to day tasks and reports with Ansible open source IT engine for automation.

Senior Database Administrator

Bahrain Financing Holding Groups LTD - BFC
06.2023 - 10.2024
  • Managed and provided production technical support, along with migration support, on varied RDBMS systems (MSSQL, ORACLE, MYSQL, POSTGRESQL).
  • Hands-on with non-RDBMS-flavored database, MongoDB.
  • Set up and controlled user access levels across databases to protect important data.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.
  • Resolved complex technical issues promptly, minimizing disruptions to daily operations of the organization.
  • Hands-on with advanced tools such as DMS, S3, and AWS Glue for data warehousing solutions.

Database Administrator

FORD MOTORS LTD
04.2023 - 05.2023
  • Worked as a DBA managing MSSQL and Oracle.
  • Created technical documentation including architecture diagrams and user manuals related to database management systems.
  • Aligned systems with business needs to enhance scalability of database structures and recommend improvements.

Database Administrator

TATA CONSULTANCY SERVICES
07.2018 - 04.2023
  • Worked as a DBA resource for MSSQL, Oracle, MySQL, and PostgreSQL, with hands-on experience in on-premises, AWS, and Azure cloud environments.
  • Collaborated with stakeholders to gather business requirements for enhancements and change requests.

Education

Bachelor of Engineering - Electrical, Electronics Engineering

Rajalakshmi Institute of Management
05.2018

Skills

  • Microsoft SQL Server
  • PostgreSQL
  • Oracle 11g, 12c, 19c, 21c
  • MySQL
  • AWS
  • Azure SQL
  • Azure
  • MongoDB
  • MongoDB Atlas
  • Azure Data Studio
  • SQL Server Data Tools (SSDT)
  • Oracle Cloud Infrastructure
  • Ansible - Automation
  • Query optimization and Database troubleshooting
  • Backup and recovery
  • Patch management
  • Disaster recovery and High availability solutions
  • TSQL
  • PL/SQL
  • Python
  • Windows 2012 R2, 2016, 2017, 2019
  • Linux shell
  • Red hat LINUX
  • AWS Linux
  • Oracle Linux

Accomplishments

Database Migration projects across different Homogenous and Heterogenous DBs and also worked of Cloud Db migration planning and implementations.


  • Oracle Certified Database SQL Associate
  • Oracle Cloud Infrastructure Foundations 2021 Certified Associate

Certification

  • Oracle Certified Database SQL Associate
  • Oracle Cloud Infrastructure Foundations 2021 Certified Associate

Languages

English
Advanced (C1)
Tamil
Bilingual or Proficient (C2)
Hindi
Intermediate (B1)

Timeline

Database Administrator

EPAM systems
10.2024 - Current

Senior Database Administrator

Bahrain Financing Holding Groups LTD - BFC
06.2023 - 10.2024

Database Administrator

FORD MOTORS LTD
04.2023 - 05.2023

Database Administrator

TATA CONSULTANCY SERVICES
07.2018 - 04.2023

Bachelor of Engineering - Electrical, Electronics Engineering

Rajalakshmi Institute of Management

MongoDB DBA Experience

  • Configuration and management of the MongoDB database server on AWS Cloud, hosted on EC2 Linux servers, and the MongoDB dedicated cloud data provider, Atlas.
  • Worked on the migration from EC2 to the ATLAS Cloud Data Platform, having knowledge of the architectural overview setup of the MongoDB database, and using Python scripting and the Mongo shell for migrating data from RDBMS to MongoDB for archival purposes with the Moresql tool.
  • Managing the HA solution replication configuration on on-premises.
  • Configuring and Backup solutions and retention policy.

Oracle DBA Experience

  • Installation and administration of Oracle 11g, 12c, and 19c on Linux and Windows in the environment, and good knowledge of the architectural overview.
  • Planning and implementation of archiving logs with capacity planning, upgrading Oracle Database from 11g to 12c versions, and from 12c to 19c.
  • Creating and managing single-instance RAC databases using the DBCA utility.
  • Experience in applying patches on standalone Oracle and RAC binary environments.
  • Experience in physical backups (hot and cold) and restoration procedures, experience in logical backup (Export/Import), Data Pump, and backup management with the Veeam Tool, and knowledge in tablespace management, extent, and segment management.
  • Handling the Data Guard setup, replication, and failover operations, both in production and in DR sites.
  • Experience in providing security, user management, privileges, roles, profiling, and authentication.
  • Experience in handling different ticketing tools, like ServiceNow, and storage tools, Commvault, as well as understanding and working with EXADATA-based Oracle systems at a basic level.
  • Performance tuning and managing alerts with OEM, and configuration.

MS SQL, PostgreSQL, And MySQL DBA Experience

  • An extensive understanding and knowledge of the internals of MSSQL 2008, 2012, 2014, 2018, 2019, PostgreSQL, and MySQL Server architecture, along with licensing concepts.
  • Extensive knowledge of querying and database objects in MS SQL, PostgreSQL, and MySQL.
  • Installation of MSSQL, PostgreSQL, and MySQL editions with best practices, prechecks, and post-checks, along with support system planning, configuration, and uninstalling them.
  • Upgrading MSSQL Server from 2008, 2012, and 2014 to higher versions.
  • Managing and troubleshooting the database engines around the different environments.
  • Automating database servers for backups, maintenance, and vacuum cleanup (on PostgreSQL), and snapshot configuration with AWS cloud technology.
  • Managing and securing the database instances, users, and roles.
  • Configuring the server for optimal performance and monitoring, along with performance tuning, with the SolarWinds DPA tool and Zabbix.
  • Quarterly database refresh activities with major application support on MS SQL Server, PostgreSQL, and MySQL servers on EC2, Aurora, and RDS instances on AWS.
  • Managing backups and recovery with the Commvault tool, and disk-level support for on-premises MS SQL servers.
  • Deployments, along with BI associates supporting MSSQL integration administration for framing clients' trend analysis, also have knowledge of reporting services administration, and have worked with Power BI solution implementation.
  • Configuration and management of SQL Server high availability and disaster recovery solutions, such as log shipping, database mirroring, availability groups, and SQL clusters, having knowledge of Windows, both on-premises and Azure, for SQL RDBMS setup.
  • Configuring and working with Azure and AWS cloud solutions for SQL Database.
  • Setting up, monitoring, and troubleshooting Always on Availability Groups on SQL Servers.
  • Migration support for PostgreSQL instances from SQL servers and MySQL Dbs.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Hobbies and Interests

Reading, Traveling, Gardening

Work Preference

Work Type

Full TimePart TimeContract Work

Work Location

On-Site
Hemalatha Venkatesan