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
Tax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private LimitedTax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private Limited
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Finance Executive at AIX Connect India Private Limited (Formerly Known as Airasia India Private Limited)Finance Executive at AIX Connect India Private Limited (Formerly Known as Airasia India Private Limited)