Summary
Overview
Work history
Education
Skills
Languages
Timeline
Generic
Haripriyan Vijayakumar

Haripriyan Vijayakumar

Cloud Operations Engineer
HIGH WYCOMBE,Buckinghamshire

Summary

A logical, analytical thinker with exceptional Cloud administration and database skills with 15+ years of IT experience. Have worked in AWS, Azure, Enterprise Cloud and Mongo, MySQL, Oracle database and 2 years of experience in MS-SQL database administration. An AWS certified Associate Architect and also a Data Engineering Nanodegree graduate from Udacity .

Overview

15
15
years of professional experience

Work history

Cloud Operations Engineer & Database Administrator

Cognizant Technology Solutions
10.2020 - Current
  • Creating a Landing zone for each application in AWS & Azure cloud for new projects using the custom-built landing zone approach, allocating CIDR's and configuring budgets as per the OpEx approval
  • Working with the application team, reviewing their design and implementing the design on a consultant basis
  • Defining Service Control Policies in the AWS Organization to apply for all child accounts
  • Configuring Direct connect/Express route by working with Network service provider for enabling the applications in On-premises to connect to Public Cloud so that data can be transferred in a secured, low latency way
  • Configured AWS Guard duty in the Organization account and all child accounts for continuous monitoring and anomalous behavior of the underlying resources which includes reporting the S3 buckets which are changed for public access from private, EC2 Instances which are open to the internet on unintended ports, Instances which are getting continuous probes outside the trusted network and from Malicious IP's
  • Configured AWS Inspector in the Organization account and enabled SSM agent for the Guest OS in few accounts to enable monitoring them for open vulnerabilities
  • Reduced the Operational cost by 8% by identifying the areas for improvement, modified the disks from GP2 to GP3 for the EC2 instances which were running in GP2, created life cycle policies for S3 buckets etc
  • Creating and configuring WAF rules for few application accounts
  • I have configured AWS Managed rules, enabled CVE specific rules to identify the ongoing CVE's (like Log4j) across the globe and working towards resolving them
  • Also periodically updating the IP Blocklist from the Malicious IP which are identified in the Guard duty which makes continuous probes
  • Configured and enabled VPC flow logs to continuously log the traffic and inspect periodically
  • Also configured CloudWatch alarms whenever any unusual traffic patterns are observed
  • Working with application teams on reviewing the IAM privileges/policies configured
  • Creating custom inline policies as per the application requirement with restricted privileges as per application design to ensure Zero trust model is enforced
  • Periodically reviewing the application designs and implementing security best practices to ensure traffic flows via private endpoint and gateway endpoints wherever possible
  • Monitoring the instance usage from the Central monitoring tool and advising the best usage of Instance types to application teams to either stop when the instances are unused and also planning to decommission/terminate when the instances are no longer required
  • Co-ordinating with all the application teams and gathering the inputs to purchase AWS RI plan yearly twice for the different resources used across the estate
  • Working with security team and closing the open items which arises as part of weekly scan in the EC2 Instances
  • Working closely with the DevOps team and helping them sorting out any operational issues arising when deploying the monthly releases and AMI patching
  • Periodically checking the AWS Trusted advisor for the open points in 5 pillars and working with DevOps team to implement the recommendations
  • Carrying out OAT before the go-live event and supporting application team on the day of go-live
  • Planning for the scalability of the application and the underlying instances and coordinating with supplier management for the big events like iPhone launch, Black Friday and Christmas sales
  • DBA Responsibilities
  • Responsible for creating new project in Mongo Atlas Organization account and creating new database clusters for new project requirements, creating the users, restricting their access specific to database clusters or project as per the requirement
  • Responsible for upgrading the Mongo databases and keeping them in the latest supported version for the databases that comes under our scope
  • Also responsible for taking care of few databases hosted in RDS MySQL and taking care of DBA activities along with other core activities
  • Automated the stop and start of the lower environment AWS RDS instances to reduce the Operational cost whenever they are not in use and on the weekends
  • Leading a team of 6 Cloud engineers in both Onshore and offshore.

Analyst

Royal Bank of Scotland
10.2015 - 10.2020
  • (specialism) for the RBS internal in-house projects
  • Supported close to 40+ internal projects where the requirement includes building Cloud based solutions and migration data from on-premise environments to Cloud environments with the volume varied from 300 GB - 7 TB
  • Building the Cloud solutions in AWS platforms which includes Oracle RDS, Redshift with S3 and Mongo hosted in EC2 instances
  • Built the Oracle database versions from 11g, 12c, 18c and 19c with & without RAC for Dev to Prod environment in AWS & also in Enterprise Cloud as per the TSDD requirements from project along with Unix and Storage administrators
  • Performing periodic patching and up-gradation of databases from existing version to newer version
  • Lastly upgraded the databases for 2 projects, one from 11g to 12c and the later from 10.2.0.3 to 10.2.0.5 for a legacy environment
  • Configuring and scheduling database backups using RMAN in Autosys and performing database restore and recovery activities
  • Carrying out performance tuning assistance via AWR, ADDM & SQL Tuning advisor, SQL Access Advisor, implementing SQL Profiles and defining benchmark for application issues
  • Consulting the database issues with Oracle by raising a SR and fixing the performance issues by checking & implementing indexes, Table partitions etc
  • Alert log monitoring, backup monitoring, table space monitoring, ASM disk usage monitoring, RAC high availability monitoring, checking deadlocks, node eviction and replication monitoring
  • Implementing DR site databases for applications which don't have a DR solution in place
  • Working closely with RBS Engineering team for engineering build issues and the solutions
  • Work closely with Unix and Storage teams for allocating the file system space and space to ASM databases and fixing space related issues
  • Supporting project changes with Backout scripts and Flashback database/table feature
  • Installation, Configuration and troubleshooting of Oracle GoldenGate
  • Performing maintenance activities and resolved GoldenGate issues such like abend, hung and excessive lag
  • Monitor the golden gate configured databases daily and fixing the issues
  • Responsible for performing the testing's in lower environments & Implementing changes on production by following the change governance process
  • Monitoring the databases via OEM and Cloud Control
  • Copying data from one environment to another environment as per the project need using EXPDP or RMAN backup
  • Configuring Oracle Database housekeeping jobs, RMAN full and Archive backup jobs via Autosys scheduler and also scheduling archive logs deletion via shell script for lower environments
  • Assisting development team in SQL query writing and query tuning for optimal performance of database(s)
  • Responsible for analyzing, highlighting data build/operational issues with engineering team by creating defect report template
  • Performing root cause analysis investigations and fixing the issue while migrating data between environments and database backups when it fails
  • Experience with deploying database security patches and remediation of database vulnerabilities
  • Performing Fit for Production tasks to newly built Oracle Cloud databases and handing over to Production team as part of Agile DevOps process (in 7 days SLA)

WIPRO TECHNOLOGIES Nestle
10.2012 - 10.2015
  • The Oracle team supports 24
  • 5
  • We are supporting around 530 11gR2 RAC databases out of which 380 production databases and other databases are split into Pre-production, development and testing hosted in AIX servers of version 7.1
  • I was playing the role of a Team lead managing 13 DBA's reporting primarily and traveled Switzerland twice for customer governance meet
  • As a Team lead my responsibilities were:
  • Conducting Daily operational review as part of Agile Kanban with team on Total tickets inflow, total tickets assigned/handled, pending tickets and unassigned tickets and creating a scrum tasks
  • Reviewing Weekly deliverables on tickets and changes handled with the customer onshore team
  • Tracking KPI's & SLA's on weekly basis and maintaining those as per the target agreed with the customer
  • Similarly conducting weekly and monthly governance calls
  • Responsible for maintaining the database parameters as per Nestle compliance standards
  • Planning and roasting the shifts
  • Planning the Experienced vs Fresher's ratio in the team
  • Planning team member's rotation as per the organization policy and refilling the open positions by conducting Interview's
  • As a Technical SME involving in the escalated calls and guiding team on what needs to be performed further
  • Gathering the business requirement document (BRD) from the customer and preparing roadmap to deliver it
  • Creating the Standard Operating procedures and Standard routines documentations to help the team in understanding and adhering follow the customer standards
  • Also proposed a model for changing the billing type to Managed services model from T&M
  • Carrying out PIR (Post implementation Review) Check
  • As an Oracle DBA my responsibilities were:
  • Administrating 24X7 Production support for core production 10g/11g RAC Databases
  • Handling day to day incident tickets of Database Backup failures, Housekeeping jobs
  • Handling User raised requests of Granting/Revoking privileges, assigning profiles, Schema export/import and creation of Database objects
  • Allocating space to ASM, monitoring ASM disk groups and checking database alert logs periodically
  • Monitoring the Daily ASM status, Database status and sending Health checkup report
  • Generating EXPLAIN PLAN, AWR Reports for SQL Queries which are giving Performance issues, SQL tuning
  • Checking Daily backup status and statistics collection job
  • Executing the scripts which will be provided by Application teams and sharing the output
  • Handling database switchover activities between primary and standby databases
  • Handling the CR's raised by application team & development team for migration of an application from one environment to other
  • Monitoring the database performance when an application job/implementation is executing
  • Providing Hot & Cold Standby support whenever any implementation tasks are planned

ACCENTURE SERVICES PVT LTD
07.2012 - 10.2012
  • The team consists of 13 DBA's and provided 24/7 support
  • I was taking care of Oracle Database L2 issues and Exadata support
  • Creating flashback restore points in the database and handling Database FRA and archive log issues
  • Doing Export/import schema from Production database to Acceptance or Testing databases and vice-versa
  • Allocating ASM space to the Database servers and handling the Data guard sync issues
  • Monitoring the Daily ASM status, Database status and sending Health checkup report
  • Performing database cloning through OEM and if its failed re-initiating through RMAN utility
  • Carrying out the scheduled tasks like Database Cold standby support or hot standby support

COGNIZANT TECHNOLOGY SOLUTIONS, MartketRX
08.2008 - 06.2012
  • I was working in a team of 13 members which supports 24
  • 7
  • The project supported 350+ production databases which are configured with Oracle Data guard RAC along with 30 development databases
  • The Database size varies from 300 GB - 1.5Tb and they are backed up using RMAN utility of Oracle
  • Oracle
  • Creating the Oracle databases using DBCA and manual scripts through command line
  • Configuring the listener and Tnsnames for user connections and sharing with end-users
  • Scheduling Daily and weekly backups through export/import, Data pump and RMAN using crontab scheduler in Linux and Task scheduler in windows
  • Creating schema's, allocating space and maintaining quota limits
  • Granting privileges and roles to the database users and managing user profiles, resources and password security
  • Creating and managing table spaces, maintaining redo logs, pfile and control files
  • Checking database alert logs for error messages and resolving the issues by raising SR with Oracle or working internally with team members
  • Applying patches to the Databases when they are hit by bugs and Upgrading the Oracle software
  • Performing table spaces re-organization activities
  • Migrating the schemas from development to production databases once the application testing is successful
  • Monitoring the production database's growth and sharing with project teams
  • Monitoring the database's usage and performance issues through both command line and Oracle Grid infrastructure tool
  • Gathering periodic statistics for schema and database level and generating AWR reports for production and development databases
  • Setting up standby databases using Oracle Data guard and monitoring the Data guard log apply process in standby databases, DATA ENGINEERING
  • Github profile: https://github.com/haripriyanharry?tab=repositories
  • Technologies
  • Jobs Scheduling Tools
  • Ticketing tools
  • Hadoop, Kafka, Hive & AWS S3, Redshift, Security group
  • Airflow for pipelines, Oozie, Autosys & Crontab
  • JIRA, Service now & HPSM
  • Data Gathering
  • Gathering data from HTML, TXT files, CSV and TSV files using Python Pandas
  • Also have knowledge in using API's to download streaming data
  • Data assessing
  • Handling Data Quality and Untidiness issues
  • Cleaning
  • Cleaning data using Python Pandas, NumPy
  • Visualization
  • Using Pandas built-in functions like pie-chart, plots, bar diagram and listing top N rows, performing descriptive analysis using Tableau
  • Data Upload
  • Cleaned data is uploaded to Cassandra, PostgreSQL databases
  • Automating data loads via ETL jobs
  • AWARDS & ACCOMPLISHMENTS
  • Received “Living Our Values award” in RBS multiple times for successfully completing many projects
  • Conducted a session in Hadoop-Bigdata & AWS Basics to Oracle projects offshore team
  • Received 2 awards as “Next-Gen leader” and “Best Sub-Tower lead” while I was with Wipro team
  • Travelled Switzerland twice for knowledge transfer and Holding Business Visa for USA

Education

B.Sc - IT

Alagappa University
India
2011

Diploma - Electrical & Electronics Sandwich

PSG Polytechnic College
India
2008

Skills


  • Cloud
  • AWS & Azure
  • Linux, Red-Hat Linux & CentOS
  • Mongo, MySQL, Oracle & MS-SQL
  • Databases
  • Operating System
  • Job Scheduling Tools
  • MS Applications
  • Autosys & Crontab
  • MS Excel, Visio, PowerPoint, Word & SharePoint
  • Helix, JIRA, Service now & HPSM

Languages

English
Fluent

Timeline

Cloud Operations Engineer & Database Administrator

Cognizant Technology Solutions
10.2020 - Current

Analyst

Royal Bank of Scotland
10.2015 - 10.2020

WIPRO TECHNOLOGIES Nestle
10.2012 - 10.2015

ACCENTURE SERVICES PVT LTD
07.2012 - 10.2012

COGNIZANT TECHNOLOGY SOLUTIONS, MartketRX
08.2008 - 06.2012

B.Sc - IT

Alagappa University

Diploma - Electrical & Electronics Sandwich

PSG Polytechnic College

Similar Profiles

Create profile
Haripriyan VijayakumarCloud Operations Engineer