Sunitha Jakkamsetti
*******.****@*****.***
Appian Architect/Infra admin /Apps DBA
Professional Summary:
** + years of experience in IT Infra/Appian administration on Cloud solutions and DevOps with a demonstrated history of working in the information technology and Financial industry. Highly skilled DevOps Engineer with advanced abilities in database administration, cloud systems and infrastructure management. Articulate in communicating solutions to team members and decisive in handling technical issues. Background in working successfully with Agile methodologies.
Experience on working with Docker containers infrastructure and Continuous Integration for building & deploying Docker containers. Experience in branching, tagging, and maintaining the version control and source code management tools like GIT(GitHub/Gitlab), SVN (subversion) on Linux and windows platforms. Monitoring applications using Splunk and AppDynamics.
Led POC implementation of Appian on Azure Red Hat OpenShift, migrating from on-premises to cloud-native architecture for Appian platform.
Worked as Solution Architecture for RPA applications ie Appian, boardwalk and Automation Anywhere. Active members of PAS Infra Engineering team to gather requirements from technical product managers for any new deployment changes and modifications.
Expert in Installing, configuring and Administering Appian 23.1.x/22.4.x/22.3.x in different environments like Development, Performance, UAT, Production and COB on Linux.
Expertise in installation, Configuration and Administration of Apache, IBM-HTTP, IIS, Webservers and Integrated them with WebLogic, Tomcat and WebSphere Application Servers.
Good knowledge in creating, configuring Clusters, Load balancing, high availability and fail-over solutions for Application servers across different platforms.
Subject matter expert for mark view implementation within P2P application. Professional knowledge on Oracle E-Business suit third party integration like Markview and Vertex.
Worked on branching strategy and CI/CD Process and automation and security prospect on implementing application on container and orchestration and security and monitoring with zero down time.
Managed Bitbucket repositories for version control, ensuring code integrity and collaboration among team members. Conducted regular GitLab server maintenance, including backups, upgrades, and performance tuning, ensuring optimal system reliability.
Proven strong experience in R12.2.4, R12.1.3 Oracle Applications upgrade and production Support Experience in Oracle Database 10G, 11g and 12c upgrade and Administration. Experience in Middleware Technologies WebLogic 12c 11g, HTTP Server and Oracle 10G AS
Worked on 6 major oracle E-Business suit 12.2.4, 12.1.3 upgrades, and database 11g Upgrade in commodity and RAC environment.
Education Details:
Masters in Computer applications from Andhra University.
Certifications:
AWS Certified Solution Architect- Professional.
Oracle Certified Associate in Oracle Applications 11i
10g Oracle Certified Associate (OCA)
Certified on Web logic, OID and OAM by Oracle University
Technical Skills:
Cloud technology
Amazon Web Services (AWS), Azure
Containerization
Docker
Operating Systems
Linux, Unix and Windows
CI/CD Tool
Jenkins, Bitbucket, GitHub, GitLab,Maven
Configuration Tools
Ansible, Terraform, CyberArk
GRID & RDBMS
Oracle R12, 19C RAC, ASM GRID, MYSQL
Application Servers
Tomcat, WebSphere, WebLogic, Oracle Fusion middleware
Scripting
Shell Script,Python, SQL, PL/SQL
ETL TOOLS
TOAD, Tectia, BMC RLM, Putty, Win SCP, VNC Viewer, Exceed, SQL Developer, MSSQL Server Manager Studio.
Employment Details:
TCS
Client: Bank Of America. USA Oct 2024 – Till Date
Wall Street Consulting.
Client: Citi Group Inc. USA May 2024 – Oct 2024
Virtusa Consulting Inc & Services Ltd, Nov, 2015 - Mar, 2024
Client: Citi Group Inc., USA
Wipro Technologies, USA Dec, 2014 - Nov,2015
Client: Williams Energy, USA
Wipro Technologies, India Feb, 2012 – Dec 2014
Client: BP International Ltd. United Kingdom
Architect Info Systems
Client: Wipro Technologies Oct 2011 to Feb 2012
ASM Technologies, Apps 11i Administration Aug 2007 - Oct, 2011
Client: Oracle India Pvt Ltd, India
Professional Experience
PROJECT 8: Credit Tool Kit
TCS
Client: Bank of America. Location: Plano, Texas
Installed, configured and Administered Appian 23.4x/22.2.x/19.4.x in different environments like Development, Performance, LLE, DR and Production on Linux.
Appian Upgrade from 19.4 to 22.2 and 22.2 to 24.4.
Designed and architected a cloud-native deployment model for Appian on Azure Red Hat OpenShift (ARO), replacing legacy on-premises infrastructure.
Containerized Appian components (Webapp, Data Server, Kafka, Search Server) using Docker and orchestrated deployment via OpenShift/Kubernetes manifests.
Established CI/CD pipelines using GitHub Actions/Azure DevOps for container builds, image scanning, and OpenShift deployments.
Platform Build activities for new Business such as Appian Installation, configuration and administration on prem VMs.
Platform run activities such as Apply the appian hotfix, Appian upgradation, Data source creation and Ldap configuration and SSO configurations.
3rd party application integration/certificate installation required for any API calls. Certificate renewal for webserver and IDP certificate.
Change path Script for archival folder path changes and cleanup for archival files.
Send mail and receive mail setup and issues. Static domain configuration, disk/memory management/system utilization report cleanup failed process instance follow up with dev team on failed instance.
Troubleshooting Appian issues and supporting dev teams on their going activities.
PROJECT 7: PAS INFRA Devops Engineering
Virtusa Consulting Inc
Client: Citi Group Inc. Location: Tampa, FL
Active members of Engineering team to gather requirement from Technical product managers for any new deployments changes and modifications
Installed, configured and Administered Appian 23.4x/22.4.x/21.3.x in different environments like Development, Performance, UAT, DR and Production on Linux.
Involved in migration of Appian 22.1.x to 22.2.x, 22.3.x, and 23.4.x
Involved in designing Architecture for the environments and participated in the new Build of the servers.
Platform Build activities for new Business such as Appian Installation, configuration and administration on prem VMs
Platform run activities such as Apply the appian hotfix, Appian upgradation, Data source creation and Ldap configuration and SSO configurations.
3rd party application integration/certificate installation required for any API calls. Certificate renewal for webserver and IDP certificate.
Send mail and receive mail setup and issues. Static domain configuration, disk/memory management/system utilization report cleanup failed process instance follow up with dev team on failed instance.
Business functionality deployments from On-prem VM's to Containerization model for Appian, Boardwalk applications.
Installed configured Boardwalk application with Tomcat 9 on RHEL8 hosts. Implemented Clustering solution for HA with SSO in DEV, SIT, UAT and Prod/COB Environments.
Introduced the automated CI/CD pipelines to build and deploy applications on Apache Tomcat applications Appian, Boardwalk.
Repositories creation and Configuration in Bitbucket and Jenkins, Plugins installation in Jenkins
Worked on branching strategy and CI/CD Process and automation and security prospect on implementing application on container and orchestration and security and monitoring with zero down time.
Versioning and Artifactory Repository Management. Keeping track of all builds and versioning the builds for the backup strategy.
Developed and designed Jenkins pipeline for deploying the infrastructure in AWS using Ansible.
AD, LDAP configuration and Administration with the Appian and Boardwalk applications.
Professional Experience
PROJECT 6: AML Investigation
Virtusa Consulting Inc
Client: Citi Group Inc. Location: Tampa, FL
Introduced the automated CI/CD pipelines to build and deploy applications on Apache Tomcat applications.
ECS Open shift project creations on underlying containerization analysis and understanding of Python scripts for production environment.
Designed highly available and fault tolerance services in AWS Cloud utilizing Cloud formation templates to automate template usage.
Installed and configured WebSphere Extended Deployment in WebSphere ND8.X on Linux. Expertise in deploying J2EE applications on IBM WebSphere application.
Repositories creation and Configuration in Bitbucket and Jenkins, Plugins installation in Jenkins
Working with developers to help configure virtual hosts, plug-ins, JDBC drivers, data sources, JVM’s and application deployments across multiple instances of WebSphere.
Developed and designed Jenkins pipeline for deploying the infrastructure in AWS using Ansible.
AD, LDAP configuration and Administration with the Appian and Boardwalk applications.
Strong Knowledge on Tomcat and WebSphere and tomcat application servers.
End to End Cyberark Integration with Tomcat and WebSphere applications. also developed a script to integrate the non CyberArk support application like Abinitio to onboard with CyberArk .
Provided extensive support in code deploy, change management, and application
level troubleshooting for the Dev, Test, Pre-Prod and Production environment.
Installed, configured Websphere for all Dev, Test, Pre-Prod environments.
Worked closely with development, SSO, network support teams, as the application
was integrated with other products.
PROJECT 5: P2P
Polaris Consulting & Services Ltd
Client: Citi Group Inc. Location: Tampa, FL
Role: Markview, RPA SME
Solution Architecture and Technical Analyst for Workfusion and Automation Anywhere.
Multiple Business Support running on Workfusion and Automation Anywhere
Assist in the development, design and implementation of Workfusion Applications and Automation Anywhere its Components
Kofax Markview installation and administration and integration with E-business suite.
Web Center Capture installation and configuration.
Workfusion Implementation and integration with Oracle Ebusiness.
Vertex Tax Link and Markview Kofax Markview upgrade from 8.0.0.0 to 8.0.0.8.
Installation of Kofax capture services and administrating.
Cloning of Weblogic server from one node to another node.Sound Knowledge on RAC Administration and Load Balancing.
Trouble shooting user access related issues and long running concurrent program issues.
RAC upgrade from 11.2.0.3 to 11.2.0.4 with minimal outage window.
Performing regular database backups using both RMAN and Local (EXPDP).Creating schedulers using Crontab and Windows Schedulers for performing database ctivities.
Creating cloning databases as same as to the production site for testing environment, UAT environment and other application related activities. And automating the cloning process using shall scripting.
Periodically monitoring the space management in database.
Creating index and monitoring the index if necessary, analyzing the tables and rebuilding the indexes if necessary for database performance.
Database CPU/PSU periodical Patching and Troubleshooting.
Gathering the database performance information using AWR reports and explain plan, and check the performance of the database using OEM.
PROJECT 4: EBS Applications Support
Wipro Technologies
Client: Williams Energy Inc. Location: Tulsa, Oklahoma
Role: Onsite Lead DBA
POC on 12.1.3 to 12.2.4 upgrade .
Applying patches with ADOP Online edition redefinition technology.
Vertex Tax Link and Markview integration with E-business suite
Kofax Markview upgrade from 8.0.0.0 to 8.0.0.8.
Installation of Kofax capture services and administrating.
Periodic health check of the database & Applications for better performance (alert logs, OS logs, trace files, AWR reports)
Cloning of Weblogic server from one node to another node.
Sound Knowledge on RAC Administration and Load Balancing.
Trouble shooting user access related issues and long running concurrent program issues.
RAC upgrade from 11.2.0.3 to 11.2.0.4 with minimal outage window.
Performing regular database backups using both RMAN and Local (EXPDP).Creating schedulers using Crontab and Windows Schedulers for performing database activities.
Creating cloning databases as same as to the production site for testing environment, UAT environment and other application related activities. And automating the cloning process using shall scripting.
Periodically monitoring the space management in database.
Creating index and monitoring the index if necessary, analyzing the tables and rebuilding the indexes if necessary for database performance.
Database CPU/PSU periodical Patching and Troubleshooting.
Gathering the database performance information using AWR reports and explain plan, and also check the performance of the database using OEM.
Performance Tuning of SGA and memory components.
Sound Knowledge on RAC Administration and Load Balancing
PROJECT 3: R12 upgrade
Wipro Technologies
Client: Williams Energy Inc. Location: Hyderabad, India
Role: Lead DBA
Description: Williams is an energy company based in Tulsa, Oklahoma. Its core business is natural gas processing and transportation, with additional petroleum and electricity generation assets; Wipro is providing oracle financials consulting support to William’s upstream business.
Responsibilities:
R12 EBS Application upgrade and Database upgrade to 11g.
3rd party applications Markview 8.0 and Vertex Tax Links upgrade.
Optimize the performance of the Upgrade patch, RDBMS upgrade and Oracle Bug fix patches to reduce the overall downtime of the upgrade.
Configuring Oracle Applications load balancing and PCP configuration.
Build the connectivity to boundary interface system using SSH, SFTP and SCP. Enable PGP encryption and decryption.
Roll-out the upgrade to the production system, provide post upgrade support and provide transition to the Support team to take over the system. Performed all aspects of database administration including Installation, Configuration, Patches
Expert in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring, cloning, upgrading and migration of oracle software and tools.
Upgrading E-Business suite application instances from 11.5.10.2 to 12.1.3
Cloning of Oracle Application through Rapid Clone and manual cloning.
PCP Configuration and Administration, JDK, JRE upgrade Shared Techstack implementation
Integrating and administering discoverer and Workflow administration.
Mark view Integration and web logic administration.
Applied RDBMS patches, maintenance packs, mini packs.
RAC node Addition and deletion Solid experience on Upgrading Oracle databases for Oracle 11g RAC/10g RAC
Backups and Recovery Using RMAN and Data pump
PROJECT 2: Oracle Applications Upgrade and implementation
Wipro Technologies
Client: British Petroleum – UK Location: Hemel hempstead, UK
Responsibilities as Onsite Coordinator:
Actively involved in planning and preparation of the go live project. Played a Key role in go –live and made a successful deployment.
Involved in customer meetings and responsible for taking decisions required for the project.
Transitioned offshore team on the upgrade activities and helped them to understand the internal and external dependencies.
Conducted weekly meetings with both internal and external clients and provided the status updates
Played a key role in post go live support and worked as a single point of contact for client and third party vendors for resolving the post go live issues.
Responsibilities as Offshore Team Member:
Installing and Administrating E-Business Suite 11i and R12.1.3
Upgrading E-Business suite application instances from 11.0.3 to 11.5.10.2
Upgraded E-Business suite application instances from 11.5.10.2 to R12
Upgrading Database from 8i to 11gR2.
Applied RDBMS patches, maintenance packs, mini packs.
Hands on experience in Cloning of Oracle Application through Rapid Clone and manual cloning.
Oracle Applications table spaces are migrated from old architecture to OATM
JDK upgrade from 1.4 to 1.6
Starting and stopping of weblogic admin and managed servers.
Administering weblogic managed servers.
Have worked on OID integration with 11g databases
Implemented SSO Integration with R12.1.3
Upgraded JRE from J-initiator.
Changing and adding database parameters according to upgrade requirement.
Configured secured socket layer (SSL) in oracle applications 11i.
Applying CPU patches to fix the security issues.
Managing Redo log and Archive log files.
Oracle Database space management.
User security management & administration.
Implementing custom tops as for customer business perspective.
Troubleshooting issues during the upgradation.
Managing Imports & Exports using EXPDP and IMPDP
Performing backups using manual methods (both hot & cold) and RMAN for database close and DR testing.
Gathering Statistics for tables & schemas using DBMS_STATS and manually.
Involved in applications performance tuning and database performance tuning.
Using of AWR report, ADDM, ASH, memory adviser, undo adviser and sqltrpt to
Find the performance issues and get recommended solution to improve the
Performance.
PROJECT 1: On Demand Multi Customer Support
ASM Technologies
Client: Oracle India Pvt Ltd.
Role: Apps Database Administration
Description: Worked as Administrator for multi customer production support which involves big pool of clients including both ESD and standard type, responsible for support and maintenance of multiple oracle databases and applications in high availability (24*7) heterogeneous environment.
Responsibilities
Administrating E-Business Suite 11i and R12,
Experience in Application Patching using ad patch and strong analytical and problem solving skills in Patch Management.
Applied RDBMS patches, maintenance packs, mini packs.
Proficient in using auto config for Oracle application system maintenance.
Knowledge on AD Utilities like ad admin, adrelink, adctrl etc
Knowledge on Cloning of Oracle Application through Rapid Clone.
Managing the tablespaces and reorganized the Fragmented Tables.
Added redolog files and maintained redolog groups.
Purging unwanted request output and log files using purge concurrent programs.
Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers.
User management: creating users, disabling users, responsibility management.
Sysadmin tasks like creating user, assigning responsibilities, registering forms, Concurrent programs, creating responsibilities and menus.
Managing Redo log and Archive log files. Conversion of Database in Archive Log / No Archive Log Modes.
Interact with end users to understand their technical queries related to database
And provide assistance in resolving them.
Performing health checks periodically and maintaining consistency.
Starting and stopping the web logic services
Troubleshooting startup issue of concurrent manager server and other servers.