Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Senthil Kumar Mani

Senthil Kumar Mani

Chennai

Summary

Seasoned IT Professional with 15+ years of Expertise in Oracle DBA, Cloud Computing, and Data Governance

Highly accomplished IT professional with over 15 years of hands-on experience in Oracle Database Administration, Cloud Computing, and recent expertise in Data Governance. Proven track record in optimizing Oracle databases for performance and reliability in cloud and on premise environments. Skilled in implementing and managing data governance frameworks to ensure data quality, security, and compliance with regulatory requirements. Recognized for strategic leadership, adept at driving cross-functional teams, and delivering solutions that align with business objectives.

Seeking to leverage comprehensive experience and expertise to contribute to the success and growth of a progressive organization.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Sr. IO Engineering Consultant

OptumInsight India Private Limited
Chennai
12.2021 - Current
  • Created detailed migration plans for transitioning applications from on-premises to the cloud platform.
  • Migrated 31 production oracle database from on prem to AWS RDS instance.
  • Optimized costs associated with running applications in public clouds by leveraging reserved instances and spot pricing models.
  • Successfully managed data center migration projects, achieving substantial cost savings around $240,000 through efficient planning and execution.
  • Monitored system performance metrics such as CPU utilization rate, memory usage, disk I and O using monitoring services like CloudWatch or Prometheus.
  • Performed regular audits of cloud resources to ensure that all configurations are compliant with industry standards and best practices.
  • Analyzed existing application architecture and identified areas where changes were required to optimize performance in the cloud environment.
  • Resolved complex problems related to infrastructure scalability, availability, latency, and cost optimization in the cloud environment.
  • Developed cloud-based solutions for a variety of customer requirements, including scalability, reliability, and performance.
  • Designed automated processes using Infrastructure as Code tools such as Terraform or CloudFormation for provisioning resources in AWS or Azure environments.
  • Built custom automation tools using scripting language PowerShell for automating routine tasks related to managing resources in a public cloud environment.
  • Collaborated with developers and other stakeholders to ensure successful deployment of applications on the cloud platform.
  • Increased performance and scalability by sizing solutions to meet system workload requirements.
  • Analyzed existing model and created Data Governance maturity assessment framework.
  • Implemented operating model using Collibra tool for Data Governance.

IO Engineering Consultant

OptumInsight India Private Limited
Chennai
05.2018 - 11.2021
  • Developed and implemented cloud migration strategy for transitioning existing on premise Oracle database to AWS environment.
  • Capacity planning for the new project requirement and initiation.
  • Installed and configured VPCs, subnets, gateways, NATs, VPNs, and security groups.
  • Created documentation outlining the architecture of deployed systems in the cloud.
  • Performed troubleshooting of various issues related to AWS services.
  • Monitored, configured, and managed EC2 instances for optimal performance. To cut down the cost, identified the database which are not required were decommissioned with the plan initiation of Data center migration.
  • Automated operations tasks using CloudWatch alarms and Lambda functions.
  • Set up backups for databases hosted in RDS according to customer requirements.
  • Created IAM users and roles with appropriate access control policies.
  • Implemented auto-scaling strategies to ensure high availability of services.
  • Analyzed cost reports generated from Cost Explorer or other cost management tools.
  • Managed storage options including S3 buckets and Glacier archives.
  • Successfully managed a team of Database Administrators specializing in SQL Server, PostgreSQL, and Oracle databases.

Senior Database Administrator

OptumInsight India Private Limited
Chennai
01.2015 - 04.2018
  • Automated daily DBA tasks using shell scripting and cron jobs.
  • Implemented database auto-restart automation, which helped reduce the manual effort of DBAs during monthly server maintenance.
  • Migrated databases from one platform to another using oracle datapump utility tool.
  • Developed scripts for automation of various DBA activities like adding disk space, reorganizing table spaces, index maintenance which reduced weekend on calls.
  • Developed backup strategies using RMAN to ensure data protection and recovery.
  • Performed trouble shooting of any issues related to Oracle Database server or applications accessing it.
    Evaluated new technologies and products related to Oracle Database Administration and implemented them when necessary.
  • Generated periodic reports about system performance and resource utilization trends.
  • Monitored database performance and tuned SQL statements for optimal performance.
  • Utilization of OEM for monitoring, diagnosing and resolving problems quickly.
  • Managed user accounts and support systems within complex Oracle database and cloud systems as per standards and policies.
  • Analyzed workflows and established priorities for daily operations.
  • Involved in capacity planning activities by analyzing current usage patterns and predicting future growth trends.
  • Provided technical support during project implementations by troubleshooting complex production issues.
  • Worked closely with Application teams in identifying and fixing application related issues due to inefficient SQL queries.
  • Deployed patches and upgrades on existing installations as per best practices guidelines.

Database Administrator

OptumInsight India Private Limited
Chennai
05.2012 - 12.2014
  • Installed and configured Oracle Database software, components, and tools.
  • Maintained database security by creating user accounts and profiles and granting appropriate privileges.
  • Performed backup and recovery operations using RMAN utility.
  • Deployed patches and upgrades on existing installations as per best practices guidelines.
  • Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
  • Provided 24x7 on-call support for critical incidents related to databases.
  • Monitored database performance and tuned accordingly.
  • Provided technical assistance to users in resolving database related issues.
  • Analyzed existing ETL processes and identified areas where improvements could be made.
  • Tuned sessions for optimal performance by modifying session parameters such as commit intervals, buffer size.
  • Monitored performance of ETL jobs and provided timely resolution to issues encountered during job execution.
  • Managed day-to-day operations related to Informatica services including system startup and shutdown activities.
  • Installed, configured and maintained Informatica PowerCenter tools on multiple platforms.
  • Involved in release activities and supported with Oracle, Informatica and Microstrategy steps.

Team Lead - Business Development

Photon Infotech Pvt Ltd
Chennai
08.2008 - 05.2012
  • Researched potential clients in designated markets, pursued leads, and successfully closed deals.
  • Applied expert understanding of target markets to implement highly successful client attraction strategies.
  • Successfully achieved project objectives through close coordination with technical and sales teams.
  • Exhibited a deep understanding of our offerings, industry rivals, and marketplace standing.
  • Developed informative presentations demonstrating the value of our products and services.
  • Built physical databases in Oracle 11g environments with knowledge of Oracle features such as tablespaces, indexes, constraints.
  • Achieved optimal utilization of resources by monitoring system resource consumption.
  • Assisted developers with complex query tuning and schema refinement for better application performance.
  • Analyzed existing databases and identified areas of improvement for performance, scalability and reliability.
  • Performed regular backups of all critical data files and maintained detailed documentation about all changes made to the database environment.
  • Optimized SQL queries for better performance by creating necessary indexes on tables or by rewriting the query itself.
  • Monitored team performance and provided feedback on areas of improvement.
  • Facilitated weekly meetings with team members to assess progress and define objectives.
  • Ensured proper user access by managing database permissions and assigning privileges according to organizational roles.
  • Installed, configured and maintained Informatica PowerCenter tools on multiple platforms.
  • Implemented change management processes for ETL code changes and data migrations across development, test and production environments.

Education

Master of Computer Applications - Computers

ICFAI University
04-2007

Bachelor of Science - Computers

Madras University
Chennai
04-2004

Skills

  • Database Administration & Management
  • Informatica Administration
  • Oracle on premise to AWS RDS instance migration
  • Cloud Computing
  • AWS Setup & Architecture
  • Requirement Gathering
  • Agile Methodology
  • Hadoop & Big Data Administration
  • Troubleshooting
  • SQL query performance tuning
  • Backup & Recovery
  • User Authentication & Access
  • Stakeholder Management
  • Automation
  • Terraform
  • Collibra Data Governance
  • Oracle 11g/12c, PostgreSQL
  • Windows, Linux
  • AWS & AZURE

Certification

  • Oracle Certified Associate (OCA) 11g
  • ITIL® 2011 Foundation Course Certified
  • Hadoop Admin Training Certified
  • Terraform Training Certified
  • AWS Certified Solutions Architect - Associate
  • Microsoft Azure Administrator Certified
  • Administering Relational Databases on Microsoft Azure Certified

Timeline

Sr. IO Engineering Consultant

OptumInsight India Private Limited
12.2021 - Current

IO Engineering Consultant

OptumInsight India Private Limited
05.2018 - 11.2021

Senior Database Administrator

OptumInsight India Private Limited
01.2015 - 04.2018

Database Administrator

OptumInsight India Private Limited
05.2012 - 12.2014

Team Lead - Business Development

Photon Infotech Pvt Ltd
08.2008 - 05.2012

Master of Computer Applications - Computers

ICFAI University

Bachelor of Science - Computers

Madras University
Senthil Kumar Mani