Aashutosh Kumar

Software Engineer

Technicolor•  May 2019 - Present

Developing tools and applications using Django Web Development & Python. Developing Infrastructure tool for Servers, Databases, Networks monitoring & Incident Management. Developing REST API applications. Deploying Continuous Integration & Deployment using Git, GitHub-Actions, Jenkins etc. Jira Development & Administration. Advance automations using Webhooks, Python Scripts, REST APIs. Bash Shell & Powershell scripting. Infrastructure Automation. Inhouse Finance Application Development. Database Administration - Oracle, SQL Server, MySQL, PostgreSQL, Sybase Database Administration. Linux Administration and automated house keeping using bash scripts. Working on Jenkins to build jobs and automate many script based tasks using Jenkins UI. Infrastructure configuration using Ansible, Rundeck. Container deployment using dockers. Deploying resources on Cloud, like AWS EC2 instances, Lambda Functions, S3, GCP & Azure Functions etc. Deploying Cloud Managed Databases lie . Deploying apps on Cloud Server less functions Deploying & Configuring nginx for load balancing & Reverse proxy. Experience on deploying multi node application architecture like Jira & Confluence on premise and cloud. Wrapping application services to be auto restarted on system boot. Database Development & Administration Writing SQL & PL-SQL scripts, nested queries, loops, conditional blocks in SQL Database Administration of Oracle, SQL Server, MySQL, Postgres Database Backups & Restores, writing automated scripts for backup and restores on Linux & Windows. Mainitaining Database High Avalilability and replication. Setting up Disaster Recovery, Stand by databases. Table maintenance and indexing strategy. Automated tablespace & storage management of Databases using Automated scripts for Database Refresh & Cloning.

Associate IT Technology Consultant

SAP•  February 2018 - May 2019

Database Development & Administration Writing SQL & PL-SQL scripts, nested queries, loops, conditional blocks in SQL Database Administration of Oracle, SQL Server, MySQL, Postgres Database Backups & Restores, writing automated scripts for backup and restores on Linux & Windows. Mainitaining Database High Avalilability and replication. Setting up Disaster Recovery, Stand by databases. Table maintenance and indexing strategy. Automated tablespace & storage management of Databases using Automated scripts for Database Refresh & Cloning.

Associate Consultant

capgemini•  June 2016 - February 2018

System & Database Administration: • Database administration, installation, patching & upgrades on Oracle, PostgreSQL, MySQL & SQL Server on Windows & Unix/Linux systems. • Experience in cloud managed SQL & No-SQL database services like AWS RDS, Aurora, Heroku, No-SQL databases. • Writing SQL & PL-SQL scripts, nested queries, loops, conditional blocks in SQL. • Performing ad hoc & automated Database backups, Disaster Recovery, Replication, Dataguard & High availability. • Automated application & database cloning/refresh using Python, Bash scripts & Jenkins. • Automation of database tasks like Tablespace management, Table partitioning, User audit & account management, email alerts. • Developed GUI Query execution, User creation & Password reset tools using Jenkins with bash or PowerShell scripts. • Troubleshooting Database performance bottlenecks & optimizing SQL queries. • Awesome Unix commands expertise on awk, grep, find, sed, crontabs etc. • Installing & running services with auto restart daemon in Unix systems.