Infrastructure Architect Solution

thyagarajan kanakasabapathy

**** ***** ** ** ***:425-***-****

Everett WA-98208 E-mail:********@*****.***

PROFILE

●As an experienced professional in a reputable organization, I would like to utilize all my experience in technology and critical decision-making. I would also like to lead a team and display my leadership qualities.

●18+ years of experience as an Oracle DBA/Architect on various platforms.

●Handled roles such as DBA, Solution Architect, and Infrastructure Architect.

●As an Infrastructure Architect, lead the strategic technical planning and architecture definition, build blueprints and roadmaps, and deliver innovative solutions that elevate the efficiency and effectiveness of Oracle solution infrastructure and delivery.

●Provided critical thought leadership and drove strategic digital initiatives from discovery/planning through implementation/delivery.

●Worked with external vendors to ensure the system architectures are robust, scalable, open, and secure, with appropriate integration points/APIs that deliver a high-quality user experience.

●Certifications

oAWS -Solution Architect

oOCI – Certified

Solution Architecting (Associate, Professional)

DevOps

Observability and Monitoring

oCertified Cassandra DBA/Architect.

oCertified MongoDB DBA/Architect.

●Extensive experience in leading teams for implementation, upgrades, cross-platform migration, and maintenance/support projects for 11i and R12.

●Experience in architecting and implementing High Availability solutions, Disaster Recovery implementation, and Maximum Availability Architecture (MAA)

●Experience in managing large and complex projects.

●Develop creative solutions to complex problems related to Infrastructure/Database management projects through in-depth analysis, critical thinking, coordination with key stakeholders and team members, and the generation of options.

TECHNICAL EXPERTISE

●RDBMS - Oracle 12c, 11g, 10g, 9i MS SQL MariaDB

●NoSQL - Postgres MongoDB Redshift Cassandra

●ERP & Applications - Oracle E-Business Suite Demantra APEX

●Middleware - Oracle ESB/SOA/BPEL Suite Oracle ODI Fusion Middleware

●Storage Architectures - EMC BCV Oracle ASM NetApp Hitachi HDS IBM DS

●Infrastructure as Code(IaC) – Ansible, Terraform, ARM,Vagrant

●Cloud - OCI, Azure, GCP, PCM

●Scripting - SQL & PL/SQL UNIX Shell

●Project Management Tools - MS Office Tools, Jira,

Experience

Client: Oregon County, OR (July 2023-)

Environment: Oracle EBS, Oracle Application Analytics, WorkDay, Azure, OCI

ROLE: Oracle Apps DBA/Data migration/ Performance Tuning

Oracle ERP 12.2.10 migration to Workday and sunset Oracle ERP

Automation – Observability and Backup and database replication and Database clone to Test and DEV environments.

Building Data archival solution for ERP after retirement

EBS maintenance – Patching, Cloning and operational activities.

Troubleshooting connectivity issues and ensuring consistency in network connectivity.

Client: Ciena Corporation (May2022- June 2023)

Environment: Oracle EBS, Azure, OCI, snowflake, Oracle SOA

ROLE: Oracle Apps TPM (Technical Project Manager)

Over architectural principles, Cloud transformation, and high availability benchmarking.

Co-ordinated post-OCI go-live migration from on-perm

oIncident management

oManaged external stakeholders for Data Integration

oEstablished offshore support team and streamlined the 24/7 support operations

oOverseen Database upgradation initiative – Gap analysis, worked with stakeholders, fitment analysis.

Client: Charles Schwab, (July 2021 – Mar 2022) Denver, CO

Environment: OEL 7.4 (Oracle Integrated Platform), Oracle Virtual platform, AIX, FCCM(Financial Crime and Compliance Management) 8.4, Informatica, mantas, ERP R12.2.x, TOAD performance tools

ROLE: Oracle Integration Architect

Objective: The client was experiencing slow performance with ETL workflow (Pipeline) in identifying fraudulent stock trading transactions. Batch processing is a nightly job and must be completed and available in the morning.

●Performance optimization of nearly 180 data integration pipelines and reduced overall processing time from 18+ to 12 -13 hours.

●Implemented Data warehouse performance tuning measures utilizing DOP (Degree of parallelism), partitioning, purging, and materialized views.

●Implemented changes at the infrastructure/ Unix platform level for better performance.

●Performance improvement with “mantas” jobs and fine-tuning mantas performance.

●Performance enhancements at Informatica workflow (pipelines)

●Database Multi-tenant-architecture implementation for non-prod databases.

●Consulted with storage management to boost infrastructure performance.

●Worked with the Oracle OFSAA team for further improvements.

Client: Gilead Science Inc, (Oct2018 – June2021 ) Foster City,CA

Environment: OEL 7.4, Oracle 11g, 12cR1, Cassandra 3.x, Oracle application R12.2.8

Modules – Finance, Order Management, Supply Chain, ASCP

ROLE: R12.2.x upgrade TPM (Project Management)

Oracle application upgrade to the latest version (12.2.8), Lease accounting implementation and Security remediation for vulnerabilities

●Upgrade 12.1.1/11gr2 to 12.2.8 version.

oNine nodes (Three nodes internal, three nodes external with DMZ configuration) and three nodes RAC database

oDesign, Plan, and Implement infrastructure solutions such as landscape restructuring MAA (Maximum Availability Architecture) with a high degree of testing for planned and unplanned outages.

oHigh Availability testing, DR configuration

oDeveloped roadmap with multiple milestone deliverables, steering the team to meet the deliverables

oEstablished communication channels and optimized project execution.

oResource planning, work allocation and in-charge of technical deliverables.

Client: Hydro Extrusions, (Apr2018 – Oct 2018) Moontownship,PA

Environnent: AIX 7.1, Oracle 11g, Oracle application R12.1.3, 11gR2

Modules – Finance, Order Management, Supply Chain

ROLE: Oracle Apps DBA/Performance Tuning Specialist

Information Life cycle Management (ILM) – This project is intended to address data volume growth by Data archive, Partition, Purge and Prune data objects

●Analyze and develop strategy for data management.

●Design Archival and reporting instance along with production instance to distribute the load from reporting and various 3rd party tools.

●Data compression for selected custom tables.

●CRP the strategy and promote through various stages to production implementation.

●Analyze other areas for performance improvement and implement.

●Developed monitoring system with Unix shell scripts and automate monitoring solution through Oracle Enterprise Manager, defining metrics for threshold, Alert and Notification.

Client: CVS Healthcare, (Aug2016 – Mar2018) Cincinnati, OH

Environment: Oracle application R12.1.3/R12.2.6, 11gR2,Linux x86-64, AIX 7.1, Oracle 11g, MariaDB, PostgresSQL, Weblogic 12c, OEM 12c, TIBCO, 12c, SQL data modeler, Weblogic

Modules – Finance, Supply Chain, MDM

ROLE: Oracle Apps DBA Lead/Solution Architect

Part of major data center migration and data migration project. Am responsible for the database track as lead/Architect.

These are the sub-projects implemented part of the major effort.

●PIM R12.1.3 with 6TB size migrated across data centers with minimal downtime.

●MDM application 12.1.3 application upgrade to 12.2.6

●Oracle Cloud Infrastructure – Infrastructure migration planning and ERP cloud implementation.

●Postgres Database upgrade and performance tuning

oDatabase upgrade to 9.6 and performance tuning

oData replication

oPerformance tuning

Client: Milgard, (Nov2015 – Aug2016) Tacoma, WA

Environment: Linux x86-64, R12.2.4, R12.2.5, OEM 12c, Infor, SOA, Sabrix, Docuware, Nagios, Loftware, OBIEE/OBIA, OTM 6.3.6

Modules – Finance, Order Management, Supply Chain, MOM, Retail Applications

ROLE: Oracle Application DBA Lead/Solution Architect

Oracle Finance, Order Management, Supply Chain Planning (ASCP) Implementation on PaaS cloud

Lead the DBA team through the implementation phases.

●System architecting, Performance tuning, and Solution architecting for high availability and disaster recovery

●Process development for Support, Maintenance, Code Migration, Upgradation

●Lead initiatives such as Cloning automation, Workflow administration, Security, Data masking

●Integrating EBS with Infor configurator

●Retail Applications – Proof of Concept for future rollout.

●SSO Implementation with OAM/OID 11.1.2 and Access gate for Enterprise users

oDesign, Install and configuration components such as EBS patching, OAM, OID,

Client: United Health Care, (Jul2015 – Nov2015) Santa Ana, CA

Environment: Linux x86-64, Solaris 10, R12.0.6, R12.2.4, OEM 12c, Panaya, SVN, Exadata,Exalogic

ROLE: Oracle Application DBA Lead

Oracle EBS upgrade from 12.0.6 to 12.2.4 with 11gr2 database upgrade with very large database (~30TB)

●Database upgrade 11.2.0.2 – 11.2.0.4

● EBS upgrade 12.0.6 to 12.2.4

Clients : Activision Blizzard, PwC, Expedia (July 2012 – Jun 2015)

Environment: Linux x86-64, R12.2.3, Exadata, Exalogic, OEM, OAM, Perforce

ROLE: Oracle Application DBA Lead

Oracle EBS upgrade version from 11.5.10.2 to R12.2.4

●Instance strategy

●Upgrade path planning

●Setting up R12.2.4 environments such as Development, Test,UAT

●Patching using ADOP and cloning

●Weblogic administration and troubleshooting

●SSO implementation with OAM 11.1.2 and OID.

●Performance tuning –oacore, DB, scripts

●Establish process for change management using Perforce tool

●Knowledge transfer to client DBA team.

Clienst: Boeing, Amazon.com (Mar 2010- July 2012) Seattle,WA

Environment: Linux, E-biz 12.1.3

ROLE: Oracle Application DBA

At this position, I am responsible for Global Financial Systems maintenance and support

●Support recently upgraded R12 (12.1.3) instance with financial modules. It is four application node with active standby instance.

●Working on other initiatives like ACMP implementation along with grid installation, High availability architecture implementation

●Support activity extends upto 100+ non-EBS databases that includes database creation, cloning, recovery and standby creation, failover and monitoring for space allocation

●Participating in pilot projects which are at design phase like exadata and RAC.

●Implementation Support for Oracle SSO integration with EBS R12

Client: Cartus, CT (June 2009 – Mar2010) New Haven,CT

Client: Harvard Pilgrim Health Care, MA (Dec 2004 – June 2009) Boston,MA

Environment: H/w: IBM O/s: AIX,Windows S/w: Oracle Applications 11i, Oracle 10g Tools: Oracle Grid control, Modules : Finance, HR, Payroll and CRM modules

ROLE: Oracle Application DBA team lead

DBA for Oracle applications,10g databases. Responsibilities include daily maintenance review, Patching, Cloning, Optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA's to ensure 24 hour x 7 day a week support of all corporate databases.

●Lead the team of 4 to support oracle 11.5.10.2 instance which caters Finance, Manufacturing,HR/Payroll and CRM modules

●We take care of patching, backup/recovery and maintenance support of all ERP instances

●We are responsible for reproducing the production issues and deriving solutions

●HR application maintenance and patching, Vertex quantum updates, CRM module

●We are also responsible for architectural changes and certifying any changes before it goes to production.

●Am responsible for all the team lead activities like resourcing the team, Client interaction, user interaction and coordinating discussions with vendors.

Education

●Master of Business Administration, Washington State University WA (Pursuing)

●Diploma in Advanced Computing from the University of Pune 1999

●Bachelor of Engineering from Bharathiyar University Coimbatore 1998

Professional Training and Continuing Education

●ITIL v3

●TOGAF

●Data platform – Snowflake, Databricks

●Cloud architecting- Azure, GCP, OCI

Contact this candidate