Nov 2021 – Jan 2024 · 2 yrs 2 mos

• Creating terraform code to provision AWS resources like EC2, EFS, Load Balancer, Target group, Code Artifact, RDS instance, secrets manager, S3 bucket etc.
• Implementing S3 lifecycle management policies to optimize the AWS cost.
• Creating custom AMI using packer for Jenkins worker
• Performing log scraping of application resources in Grafana using Loki
• Jenkins and Bitbucket server upgrade depending on recent LTS version.
• Defining Branch enforcement rules and commit checks using git hooks.
• Provisioning of Jenkins and Sonarqube using Terraform on AWS.
• Integrating Jenkins with Sonarqube and Snyk for Quality gate in the pipeline.
• Performing PR reviews for IAC code and granting access on the repositories based on requirement from stakeholders.
• Troubleshooting Jenkins Build issues using AWS Cloudwatch, Datadog and CloudTrail.
• Integrating Datadog with Jenkins for observability purpose.
• Implementing Jenkins global library for multibranch pipeline jobs.
• Working on standard / best practices for CICD workflow.
• Integrating Jenkins with AWS secrets manager.
• Creating Informatica jobs for cross migration of data i.e. from Snowflake to SQL Server
• Creating Sigma dashboards for analyzing the data from Snowflake warehouse.
• Automating Informatica jobs by running API through service user.

Sep 2017 – Oct 2021 · 4 yrs 1 mo · Bengaluru, Karnataka, India

• Managing the deployment of SIT, UAT , STAGE and PROD on daily basis through CICD process
• Merging of GIT weekly release branches with master and creating tag in both prior to the removal of previous.
• Administration of Jenkins tool like upgradation, installation of plugins, provisioning and decommissioning of slave nodes, account creation, job creation, etc.
• Migrating the entire Jenkins Freestyle job to pipeline using Groovy scripting.
• Bringing enhancements in the prevailing patch process as a part of continuous improvement.
• Making code enhancements, fixing bug via JIRA stories, and providing the updates on daily standup call.
• Administration of Oracle APEX 050100 like installation of Oracle restful data services, user management, page troubleshooting, etc.
• Installation of tools for improving the code standards like Sonarqube, Fortify SSC and UTPLSQL.
• Utilizing the version control system SVN and GIT for maintaining the code repository and defining their branches.
• Training and guiding developers to get accustomed with dynamic changes in Database patching process.
• Exploring the database refactoring tools like Liquibase, Redgate for deployment to higher environment
• Integration of build output with SLACK channel to furnish and analyze the execution history.
• Integrating JIRA and Oracle service cloud (OSvC ticketing tool) with Jenkins using REST API for validating and updating task/bug/ticket post patch deployment.
• Adding unit tests, code coverage and sonarqube scans in the deployment jobs (CICD).
• Upgrading sonarqube quality gate tool and migrating the SQ database from MySQL to Oracle.
• Dockerizing selenium web automation for applying APEX translated pages
• Containerization of Java (weblogic) and OJET build+deployment mechanism using docker in dev environments.
• Dockerizing Oracle 19c database with proper configuration and backup strategy for tracking CICD related stuffs.
• Migrating on premise Jenkins job to Oracle Cloud Jenkins

Jul 2016 – Sep 2017 · 1 yr 2 mos · Bengaluru, Karnataka, India

• Working on P1/P2/P3 Incidents (critical issues) and ensure to meet SLA norms
• Fixing and providing the RCA pertaining to database performance issues (SQL queries running slow, ORA-0600, ORA-07445, etc.) and patching up with other infrastructure team if required.
• Actively involved in database outage bridge calls where we provide the solution to the customers (Application team) to ensure minimal impact in business.
• Executing change and emergency change (Database refresh, switchover, parameter change, etc.) in the required window.
• Creating Oracle service request and following up with the vendor for major issues.
• Major planned weekend activities like DR drill and dataguard switchover via Databroker
• Rebuilding new standby database after failover and then failback the primary database to primary site.
• Retrieving the old backup pieces from TSM tape and also from Virtual tape library (VTL) for database refresh.
• Troubleshooting OEM monitoring issues and fixing the unavailable targets.

Feb 2014 – Jul 2016 · 2 yrs 5 mos · Greater Kolkata Area

• Database automations with BASH for productivity improvement and optimization
• Preparing design document for automations to have better client's visibility
• Incident reduction for mundane task with proper follow up and investigation
• RMAN backup improvement for databases persisting with configuration issues
• Active database duplication via RMAN to refresh development instances.
• Oracle database upgradation depending on requirement
• Applying latest PSU patch on oracle binaries (10.2.0.5/11.2.0.2/11.2.0.3/11.2.0.4)
• Conventional export/import and datapump to refresh database schemas in non prod instances.
• Installation and cloning of oracle binaries (10.2.0.5/11.2.0.2/11.2.0.3/11.2.0.4).
• Troubleshooting of RMAN backup failures and providing the RCA to stakeholders.
• Provisioning and decommissioning of databases using DBCA utility.
• Schema creation and granting the necessary privilege depending on requirement and feasibility.
• Fixing the ORA errors pertaining to database prior to proper investigation.

Dec 2009 – Jan 2014 · 4 yrs 1 mo

• Role: Oracle database administrator
• Installation of Oracle 11gR2 two node RAC on RHEL 6.1,AIX 6.1
• Implementation of RMAN L0 and L1 incremental backup and retention policies
• Implementation of security policies like Database audit, managing profiles and password policies
• Responsible for RMAN cross platform migration from RHEL 6.1 to AIX 6.1
• Schema refresh on development instance using datapump on adhoc basis.
• Responsible for complete database migration (Linux to Linux) using RMAN
• Index management by creating, analyzing, monitoring and rebuilding indexes.
• Troubleshooting database through alert logs and AWR reports
• Development of shell script to monitor database health check in HTML format
• Diskgroup management using ASMCA
• Monitoring of tablespace and altering the size as per defined policy.
• Configuration of Oracle Enterprise Manager.
• Daily monitoring of database health and troubleshooting incase of failure.
• RMAN migration from production to development database
• Handling tickets for session kill, password expiry and tablespace size
• Performance tuning of long running queries through AWR reports and explain plan.
• L0 and L1 incremental backup tuning (allocating multiple channels and enabling BCT)
• Contact to Oracle using Metallink to escalate issues and open Service Request.
• Role: MySQL database administrator
• Installation of MySQL 5.0, 5.1 and 5.5 tar files on SLES 11
• Upgradation of MySQL 5.0.89 version database to MySQL 5.5.19 on SLES 11
• User creation, granting and revoking privileges depending on their role
• Backup – Full and incremental
• Maintenance- mysqlcheck, myisamcheck, Repair, Optimize, Analyze, check.
• Engines – InnoDB and MyISAM
• Recovery – Full and point in time recovery
• Replication setup of full database as well as table based
• Troubleshooting of database using error logs, monitoring slow logs and deadlocks
• Index rebuilding for optimizing performance