Oracle Database Admin Resume
SUMMARY
- Software professional with 11+ years of total experience, with couple of years as a Oracle DBA and 8+ years with ability to accomplish all aspects of the software configuration management (SCM) process, systems deployment engineering (SDE), AWS and DevOpsin CI/CD pipeline, Build/Release management and Cloud Security Engineering.
- Extensive experience working with AWS provided Resources like EC2, VPC, IAM, S3, EBS, AMI, SNS, RDS, EBS, Lambda, Cloud Watch, Cloud Trail, Kinesis, Cloud Formation AWS Config, Auto scaling, Cloud Front, and Route53, AWS CLI.
- Experience in System Administration, System Builds, Server builds, Installs, Upgrades, Patches, Migration, Troubleshooting, Security, Backup, Disaster Recovery, Performance Monitoringand Fine - tuning on UNIX Red Hat Linux Systems.
- Experienced in provisioning IaaS and PaaS and end to end automation of Web and Application servers onAWScloud using Chef, Ansible and Cloud Formation templates
- Extensive Programming experience in Python, PowerShell and Bash scripting. Wrote bash and Shell scripts for auto launch and web server configurations.
- Strong experience in configuration and automation management tools such as Ansible, Chef and Puppet.
- Extensive experience in Application Deployments and Environment configuration using Chef, Puppet, Ansible and Terraform.
- Hands on experience with Terraform,a tool for building, changing, and versioning infrastructure safely and efficiently.
- Working experience in ansible and writing paybooks to deploy the servers on K8's.
- Experience with containerization and orchestration technologies like Kubernetes, Docker.
- Deployed application which is containerized using Dockeronto a Kubernete scluster which is managed by Amazon Elastic Container Service for Kubernetes (EKS).
- Configured AWS ECSfor deploying and orchestrating containers by defining tasks and services.
- Used Kubernetes to deploy scale, load balance, scale and manage Docker containers with multiple namespace versions.
- Deploy, maintain and improve performance over containerized applications in EKS.
- Hands-on experience in version control using SVN, GIT and GITHUB and continuous integration management using Jenkins.
- Worked on creating SonarQube quality gates for applications based on requirements and run Sonar Analysis on Project and Publish report to Sonar Dashboard.
- Expertise in setting up Baselines, Branching, Patches, Merging and Automation processes using Shell/Bash and Batch Scripts.
- Helped the team in monitoring the system, changing the app configurations, tuning OS parameters, and AMI build practices and backup Procedures.
- Worked with various scripting languages like Bash, Shell, ruby and Python and Worked with various application servers like Tomcat, Jboss.
- Created build pipeline for various applications using Jenkins as CI tool.
- Have Experience on jfrog artifactory.
- Worked with different Bug and Log Tracking Tools like Splunk, Jira.
- Extensive knowledge on database administration for Oracle 10g, 11g, & 12c with experience within very large-scale database environment and mission critical large OLTP systems.
- Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
- Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g & 12C RAC environment
- Proven hands-on experience on EBS product including installation, configuration & upgrade, Concurrent Manager, Web Server, 10g Application Server, OID and Single Sign on, shared Appl Top, setup and maintenance of oracle Workflow.
- Ability to adapt to new environment quickly,strong team player, good communication, good analytical and computation skills, enthusiastic learner, confident, sincere and committed.
- Outstanding communicator with extensive experience in customer service as well as ability to identify, develop and enhance client relationships.
TECHNICAL SKILLS
Configuration Management: Ansible, Ansible tower, chef, Puppet
Virtualization Tools: Docker, Kubernetes, VM Virtual Box, VMware
Version Control: GitHub, GitLab, Bitbucket, Tortoise SVN
Cloud Environment: Amazon Web Services (AWS)
CI Tools: Bamboo, Jenkins
Build Tools: ANT, MAVEN, Gradle
Web servers: Web logic, Web Sphere, Apache Tomcat, JBOSS
Scripting: Perl Scripting, Shell Scripting, Python, Ruby
Web Technologies: Servlet, JSP, HTML, JavaScript, XML
Bug Tracking Tools: JIRA, HP Quality Center, IBM Clear Quest, Mingle
Databases: Oracle, MYSQL, DB2, Cassandra
Operating Systems: RedHat Linux, Ubuntu, Centos, Windows, And Mac.
PROFESSIONAL EXPERIENCE
Confidential
Sr AWS/DevOps Engineer
Responsibilities:
- Use agile methodology throughout the project. Involved in weekly and daily bases release management.
- Working with a strong team of architectures, backend developers to gather function and non-functional requirements.
- Monitoring IoT (Internet of Things) specified infrastructure design and implementation process.
- Involved in source control management with GitHub and GitLab Enterprise level repositories. Regular activities include configure user’s access levels, monitor logs, identifying merge conflicts and managing master repository.
- Deploy and monitor scalable infrastructure on Amazon web services (AWS) & configuration management.
- Involved in performing application deployment toAWSElasticBeanStack environment.
- Configured & deployed Java applications on Amazon Web Services (AWS) for a multitude of applications utilizing theAWSstack, cloud formation.
- Created environment on AWS platform, AWS Hadoop EMR cluster, Kafka Cluster, Cassandra Clusters and implemented system alerts onDataDog.
- Used the command line interface to manage apps, services in PivotalCloudFoundryas well as Apps manager.
- Create, bind the user defined and built-in services in PivotalCloudFoundry(PCF).
- Build, Test and deploy applications by using pivotalcloudfoundry
- Built & Deployed Java/J2EE to web application server in agile continuous integration environment and automated Labelling activities in TFS once deployment is done.
- Working knowledge of several types of configuration management tools like Puppet, Chef, Ansible, Salt and Vagrant.
- Involved in phases of testing for example Integration testing, Smoke testing Performance testing and Load testing. We are also using inbuilt test cases in Jenkins and running those tests on master branch.
- Developed build & deployment scripts using MAVEN. Automated the process using plugins available Jenkins and move from one environment to other throughout the build pipeline.
- We are driving towards continuous integration and continuous delivery using Jenkins and Ansible for docker image building and deployment.
- Configuring ‘nginx’ for proxy RESTful API calls to micro-services in Docker containers.
- Produced scripts for viable combination ofJIRAapplications with different tools.
- Customized bothJIRAand Confluence to integrate into the pre-existing systems with an eye towards making the programs extensions of their systems, and not hindrances to their systems.
- Created Custom workflows, custom screens and custom fields onJIRA.
- MigratedJIRAacross environments and worked onJIRAdatabase dumps.
- Configured and maintained Jenkins to implement the CI process and integrated the tool with Ant and Maven to schedule the builds.
- Worked with Release Management tool likePlutora& their report development.
- Experience in usingSQL,PL/SQLstored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
- Creating and Managing Virtual Machines using Xen, KVM or RHEV to run specific services.
- Perform promotion onClearCasefrom one server to another server.
- Designing & deploying data center architecture on Linux Platform. Building, patching and managing existing data center rack servers on Red Hat Enterprise Linux
- Setup up and maintenance of automated environment using Chef recipes& cookbooks within Azure environment.
- Deployment and management of many servers via script and chef, utilizing cloud providers as a direct substrate for implementation.
- Deploying and managing many servers utilizing both traditional and cloud-oriented providers (Azure) with the Chef platform configuration system.
- Used ANT and Python scripts to automate the Build and deployment process. Used maven for few modules.
- Create, manage, and delete users and groups as per the request using Amazon Identity and Access Management.
- Monitoring each service deployment, and validating the services across all environments.
- Active participant in scrum meetings, reporting the progress and maintain effective communication with each team member and manager.
Environment: Git, Jenkins, Maven, nginx, Ansible, AWS, VPC, Microsoft Azure, Shell scripting, Apache Tomcat, chef, ClearCase, VM, REST and python.
Confidential
Sr Devops Engineer
Responsibilities:
- Creating fully automated CI build and deployment infrastructure and processes for multiple projects.
- Developing scripts for build, deployment, maintenance and related tasks using Jenkins, Docker, Maven, Python and Bash
- Experience of writing & managing Chef Scripts& using Linux automated deployments using Chef.
- Built and managed a large deployment of Ubuntu Linux instances systems with Chef Automation. Wrote recipes, tools, shell scripts and monitoring checks.
- Used Chef to manage Web Applications, Config Files, Database, Commands, Users, Mount Points, and Packages.
- Implemented a Continuous Delivery pipeline with Docker, Jenkins and GitHub and AWS AMI’s
- Have experience of working with Docker- docker hub, pulling images from docker hub, running containers based on an image, creating Dockerfile to manage customized containers, exposing a container with port redirect, container volume management, docker inspect, docker commit to capture the file changes/settings into a new image and pushing the image to docker hub
- Automated AWS components like EC2 instances, Security groups, ELB, RDS, IAM through AWS Cloud information templates.
- Used Ruby Rspec framework and wrote test cases for regression and to resolve refactoring problems.
- POC on Implementing AWS Kinesis based consumers in Lambda and pipeline data to a data lake while allowing real time analytics using DynamoDB and ordering based on the location of mobile users and ordering trends
- Installing and Configuring Monit, AppD & Grafana and Logstash and FileBeat for monitoring and transferring logs to Elastic search
- Experience in designing and deploying AWS Solutions using EC2, S3, and EBS, Elastic Load balancer (ELB), auto-scaling groups and OpsWorks.
- UsedMicro servicesarchitecture with Spring Boot based service through REST
- Experience in creating alarms and notifications for EC2 instances using Cloud Watch.
- Creating Lambda function to automate snapshot back up on AWS and set up the scheduled backup.
- Utilize Camel to integrate microservices with other microservices and RabbitMQ messaging exchanges.
- Worked on creating the Docker containers and Docker consoles for managing the application life cycle.
- Experience with ElasticSearch, Logstash&Kibana stacks.
- Experience with Nagios/Observium/NewRelic monitoring and alerting services for servers, switches, applications and services.
- Worked closely with developers and managers to resolve the issues that were risen during the deployments in different environments.
Environment: AWS EC2, S3, Cloud Formation, Dynamo DB, Kinesis, VPC, IAM, Tomcat Apache, Micro-Services, Cloud Watch, New Relic, Git, Linux, ELK Stack, Jenkins, Maven, Ansible, JVM etc.
Confidential
Build And Release Engineer
Responsibilities:
- Developed build using ANT and MAVEN as build tools and used CI tools to kick off the builds move from one environment to other environments.
- Participated in the release cycle of the product which involves environments like developments QA and production.
- Involved in setting up builds using CHEF as a configuration management tool.
- Used CHEF to configure and mange infrastructure.
- Established Chef Best practices approaches to system deployment with tools with vagrant and managing Chef Cookbook as a unit of software deployment and independently version controlled.
- Involved in developing and build shell scripts.
- Hands on compiling builds using pom.xml and build.xml.
- Worked asXLDeploy tool administrator for the CM team.
- Used the continuous Integration tools such as JENKINS & HUDSON for automating the build processes.
- Resolved 30+ customer complaints everyday related to Jenkins, Git, Gerrit,Clearcase, Nexus, Sonar, Java.
- Developed build and deployment scripts using ANT and MAVEN as build tools in JENKINS to move from one environment to other environments.
- Involved in developing the ruby scripts for puppet and great ideas to automate system deployment to scale infrastructure.
- Administering the UNIX, SVN Repository. Migrated the code from other Version Control to Subversion.
- Used the version control system GIT to access the repositories and used in coordinating with CI tools.
- Integrated maven with GIT to manage and deploy project related tags.
- Performed necessary day to day Subversion/GIT support for different projects.
- Used ANTtool has been used for the build and deploy procedure scripts in UNIX.
- Managed all the bugs and changes into a production environment using the JIRA tracking tool.
- Assisted end-to-end release process from the planning of release content through to actual release deployment to production.
- Wrote variousSQLandPL/SQLscripts and stored procedures to support applications.
- Deployed Java/J2EE applications on to the Apache Tomcat server and configured it to host the websites.
- Deployed application packages on to the Apache Tomcat server. Coordinated with software development teams and QA teams.
- Managed all the bugs and changes into a production environment using the ServiceNow tracking tool.
- Executed the planning of product software releases.
- Performed clean builds according to scheduled releases.
- Verified whether the methods used to create and recreate software builds are reliable and repeatable.
- Identified the Data Source and defining them to build the Data Source Views.
- Deployed the build artifacts into environments like QA, UAT according to the build life cycle.
Environment: SVN, Maven, Ant, Xl Deploy, Jenkins, Hudson, Chef, Apache Tomcat, shell, Perl scripting, Subversion, Puppet, JIRA, ServiceNow, Cloud Foundry, ClearCase, Windows, Python, Linux, Unix, Git.
Confidential
Oracle Database Admin
Responsibilities:
- Created work breakdown structure before starting the implementation
- Implemented ITIL framework to streamline the processes.
- Installed Oracle Applications in 2-node setup on Linux platform.
- Upgraded Oracle application 11.5.10.2 to 12.1.3 & 12.2 with database version 11g
- Configured EBS 12.2 WebLogic Server 11g (WLS) domain and deploy EBS applications into it.
- Developing Online Patching tool ADOP for EBS 12.2 release.
- Providing technical support by troubleshooting and resolving database system and related operating system, and application problems.
- Monitoring database system and application performance including its integration with operating system usage. Correcting and tuning abnormalities.
- Maintaining a current knowledge of database systems, related networking technologies, operating systems, and applications
- Designing, developing, documenting, and validating database backup and recovery plans in accordance with the business requirements
- Designing and assisting with capacity planning, sizing, and space management
- Providing user-level system services such as setting up accounts, assigning passwords, and setting privileges
- DB migration from 32-bit Linux platform to 64-bit platform.
- Installed and configured Discoverer.
- Configured Disaster Recovery (DR), SSO & SSL.
- Implemented Daily hot backups and automated cold backups.
- Configured send mail at O/S level.
- System Administration tasks like creation and maintenance of Users, Responsibilities and Menus etc.
- Configured Workflow mailer notification.
- Patching oracle application.