We provide IT Staff Augmentation Services!

Site Reliability / Aws Cloud Engineer Resume

2.00/5 (Submit Your Rating)

Plano, TX

SUMMARY:

  • 12+ years of IT experience spanning across Cloud Management / Devops / Backups / Storage / Database / Virtualization / Data center operations and IT Infrastructure supporting multiple platforms and applications.
  • Technology professional with knowledge of full infrastructure stack implementation, automation, design and management
  • Experience in Building Infrastructure on AWS Cloud using Cloud Formation templates, EC2, Virtual Private Cloud (VPC), Elastic Load Balancing, Auto Scaling, Route 53 DNS, RDS, S3, SNS, SQS, Cloud Trail, Cloud front, Aurora, Dynamo DB, Redshift, Migration, Glacier, Security Groups, Kinesis and other Services.
  • Building full Enterprise infrastructure application stack for high volume data and real time processing.
  • Good knowledge and worked on several Confidential Blue mix, Azure, Google Cloud Platform and OpenStack, of IaaS, PaaS and SaaS tools.
  • Expertise in developing cloud strategies, roadmaps, architecting new cloud solutions or migrating enterprise applications to the cloud.
  • Experience in redesigning infrastructure to Dockers & Containers and leverage Kubernetes.
  • Automation of infrastructure management and deployments using tools like chef, Ansible and Puppet
  • Performed storage allocation using Auto Provisioning Technology of VMAX for heterogeneous open systems environment
  • Experience in managing and setting up Continuous Integration using tools like Jenkins, Build Forge, Build Bot, Docker, Bamboo and Electric Commander, Sonar, Subversion(SVN), Selenium, Cucumber, Team foundation server, Accrue and Nexus & artifactory
  • Complete and In - depth understanding, Architecture of various Backup solutions & Technical Expertise in supporting multiple platforms and applications. For Backup and Recovery using Symantec NetBackup, Legato Networker, Commvault, TSM And EMC Avamar
  • Experience in Docker, Docker swarm, Kubernetes & Ansible in build automation pipeline and production deployment
  • Used Packer to Build prod images in AWS and TEST/QA instances in Customer data center premises.
  • Skilled in installations, up-gradations and maintenance of Oracle8i/9i/10g, MS SQL server 2000/2005/2008 and DB2 databases on different platforms like Windows/Sun Solaris/AIX/Linux.
  • Experience with performance tuning in changing kernel Parameters, Configurations, Upgrades, and Network Tuning, Database Tuning etc.
  • Manage virtual and physical cloud resources as required with an overall objective of improving the Scalability, reliability, performance, and availability of the cloud infrastructure
  • Configured Tivoli Data Protection for Oracle, DB2, MS SQL Server, Lotus dominos and MS-Exchange.
  • Experience in installation, configuration and administration of VMware based virtual servers using ESX/ESXi servers, vSphere and Virtual Center
  • Supported as system admin on different platforms like AIX, Sun Solaris, Windows and Mainframes as Mainframe operation support.
  • Involved in the functional usage and deployment of applications in Web Logic, Web Sphere and Apache Tomcat Server.
  • Highly Expertise in configuring Confidential Data protectier, HP Store one, EMC Data Domain using DDBOOST, VTL, CIFS/NFS with EMC Networker, NetBackup, EMC Avamar, TSM Backup tools for Virtual Backup & Storage Environments.
  • Experience in Administration of Storage to Multiprotocol Environments like CIFS and NFS in NetApp SAN/NAS environment.
  • Expertise in Storage backup and recovery utilizing Confidential Tivoli Storage Manager 5.x/6.x/7.x and Experience in Installations and up-gradations of Backup Infrastructure on Windows/Aix/Solaris/Linux.
  • Highly experienced in Migration of Data centers and designing backup solutions
  • Experience in installing Integrated Solution Console and Admin Center on AIX.
  • Experience with issues, constraints and problems typically found in a support or development team
  • Understand and experienced in issues such as IT productivity, performance management, service level management, quality and rework metrics, SDLC, Application, help desk.
  • Ability to effectively lead or participate in cross-functional projects, challenge the status-quo to champion improvements, maintain a "client first" perspective

TECHNICAL SKILLS:

Hardware: Compaq, Gateway, Confidential (P 550, e-series, x-series, ESS, P690) and Dell PCs, Dell, Sun, Confidential and Compaq Servers

Applications / Software: Tivoli Storage Manager 5.x /6.X/7.X(TSM), Tivoli Data Protection (TDP) for Oracle, SQL,Informix and Exchange, Ghost; ACSLS, Server Graph, Veritas Net backup, ADMS, FTP, telnet, Tarantella, Citrix Metaframe, Emc Datadomain,Vantive, Remedy, Microsoft Office, JCL, novel Netware, Confidential Data protectier (VTL),EMC 4406, commvault

PC and Server Operating Systems: Windows 2000/2003/XP, WIN7/8, Sun Solaris 8/9, AIX 5.x, Red hat Linux Enterprise edition 3/4, ZLinux

Languages and Scripting: C, C++, JAVA, UNIX Shell Scripting and PL/SQL Scripting

Databases: Oracle 8i/9i/10g, MS SQL Server 2000/2005/2008, DB2 UDB 7/8, SAP Hana, Sybase, Amazon RDBMS, Mongo DB

TSM Servers: Confidential Tivoli Storage Manager 5.x/6.x/7.x

Cloud Services: Confidential Bluemix, Azure,OpenStack and Amazon Web Services(AWS), EC2, RDS, S3, ROUTE53, IAM (Identity and Access management), SNS, SQS, Cloud front, API Gateway, Lambda, Elasticsearch, CloudFormation, EBS, ELB, Cloud watch, Elastic beanstalk and Cloud trail 

PROFESSIONAL EXPERIENCE:

Confidential, PLANO, TX

Site Reliability / AWS Cloud Engineer

Responsibilities:

  • Responsible for Infrastructure Automation, Developing tools for Backup/storage/Database Infrastructure Automation and Monitoring with Continuous Integration and Continuous Deployment/Delivery pipeline.
  • Design AWS Cloud Formation templates using resources like EC2, ELB, Security Groups etc.., in a custom sized VPC
  • Worked on Amazon Virtual private cloud(VPC) in creating public subnets, Private subnets and NAT instances and dealt with security and access
  • Worked on core AWS services further setting up new server EC2 instances, configuring security groups and setting up elastic IP, auto scaling configuration.
  • Migrated the current Linux environment to AWS/RHEL Linux environment with auto scaling feature
  • Maintained Services IAM, RDS, Route 53, VPC, RDB, SES, SQS and SNS in AWS cloud.
  • Experience in using AWS command line EBS (elastic bean stalk).
  • Extensively worked on Cloud Formation templates in creating cloud infrastructure using JSON and YAML.
  • Setting up Puppet Infrastructure in Database Environment for Monitoring and Automation
  • Developed Puppet Modules and Manifests for Confidential DB2 Database Infrastructure Automation and Monitoring. And streamlined Infrastructure Automation / Monitoring as Continuous Deployment
  • Wrote puppet manifests for deploying, configuring, and managing collected for metric collection and monitoring.
  • Worked on integrating AWS Dynamo DB using AWS Lambda to store the values the items and backup the DynamoDB streams.
  • Built Puppet manifests and bootstrap scripts to allow us to bootstrap instances to various roles without having to maintain AMIs.
  • Implemented Devops pipeline Automated Builds, Continuous Integration and Continuous Deployment with tools Jenkins and Continuous Delivery with Confidential Urban Code Deploy
  • Worked on Cloud Formation to create cloud watch metric filters and alarms for monitoring and notifying the occurrence of cloud trail events
  • Automation of application deployment framework using chef, puppet and Ansible in build automation
  • Worked on Aws Elasticsearch, Cloud Watch in EC2 instance monitoring, IAM (Identity and Access management), ELB group (ALB & CLB) with multiple EC2 instances in it and used both S3 bucket EBS backed instances for volume.
  • Created Docker Images by packaging required components of an Application and worked on Docker Container Orchestration with Kubernetes.
  • As a Site Reliability Engineer worked on all Layers in Open Stack from Network Layer to Application Layer.
  • Worked as a system administrator for the build and deployments process on the enterprise server using Jenkins
  • Responsible for the Plugin Management, User Management and END-END build and deploy setup using Jenkins.
  • Designing and implementing fully automated server build management, monitoring and deployment by Using Technologies like Splunk, Shell scripts, GIT, Maven, Bitbucket, Jenkins, Selenium, Sonarqube, Nexus, Bamboo, Chef & Ansible.
  • Designed and implemented Continuous Integration process using tools like Jenkins with approval from development and other affected teams. Defined processes to build and deliver software baselines for internal as well as external customers.
  • Experience in Docker, Kubernetes & Ansible in build automation pipeline and production deployment.
  • Created Docker Images by packaging required components of an Application
  • Automated builds, deployments and Scaling of a micro service architecture application using Openshift. And worked on Docker Container Orchestration with Kubernetes.
  • Focused on containerization and immutable infrastructure. Docker has been core to this experience, along with Kubernetes
  • Managed local deployments in Kubernetes, creating local cluster and deploying application containers
  • Provisioning and managing virtual infrastructure using Docker.
  • Created monitors, alarms and notifications for EC2 hosts using Cloud Watch as well as IAM & Security Management via Cloud Trial.
  • Developed complex administration, monitoring and management utilities using Perl, Python and UNIX shells.
  • Created various scripts in Python and Ruby for automation of various build processes.
  • Experience in installation, configuration and administration of VMware based virtual servers using ESX/ ESXi servers, vSphere and Virtual Center
  • Migrated and automated cloud deployments using API’s, chef, python (boto & fabric) and AWS Cloud Formation Templates.
  • Implemented rapid-provisioning and life-cycle management for Ubuntu Linux using Amazon EC2, Chef, and custom Ruby and shell/Bash scripts. .
  • Hands on experience on Configuring Emc Data domain and enabling replication between primary & dr sites
  • Hands on experience on installation and configuration of backup environment using CommVault backup software
  • Provided 3rd Level Storage Management Services, Support and Product Support for Net backup
  • Worked on Confidential Data protectier TS7650G Appliance which combines the feature of VTL with inline deduplication.
  • Involved with DRM exercise
  • Capacity planning, to estimating the storage capacity for the next annual year, plan to getting resources (tapes, drives, etc)
  • Preparing automated scripts for regular activities (reporting, config files backups, etc), using Perl and korn shell placing them in crontab and also modifying the old scripts
  • Working with the drive and path problems and validating SAN connectivity

Environment: Jenkins, Cloud Formation, Agile, RHEL, Kubernetes, Cloud watch, ELK Stack, Open stack, Red Hat, Elastic Beanstalk, Chef, Docker, RDS, JIRA, DDB, Apache Tomcat, Selenium, VMware, Maven, Nexus, EC2, Dynamo DB, Git, IAM (Identity and Access management), Subversion(SVN), Aws Lambda, Elastic search, Ruby, Cloud Trial, Ansible, shell/Perl, API Gateway, Amazon VPC, Json, Python, Terraform, Linux,TSM 5.3/5.5, AIX, Sun Solaris, Red hat Linux, Windows 2000/2003/XP, Oracle 9i/10g, MS SQL server 2000/2005, db2

Confidential, Carrolton, TX

Site Reliability / AWS Cloud Engineer

Responsibilities:

  • Implemented AWS solutions using EC2, S3, Aws Lambda, RDS, IAM (Identity and Access management), Route 53, Elasticsearch, Cloud front, EBS, Elastic Load Balancer, Auto scaling groups, Optimized volumes and EC2 instances using API Gateway.
  • Worked on Cloud Formation to create cloud watch metric filters and alarms for monitoring and notifying the occurrence of cloud trail events.
  • Used Git & Subversion(SVN)as source code repositories, managed for branching, merging, and tagging the files.
  • Implemented rapid-provisioning and life-cycle management for Ubuntu Linux using Amazon EC2, Chef, and custom Ruby and shell/Bash scripts.
  • Deployed and scaled java web applications on to Apache servers using Elastic Beanstalk.
  • Involved in setting up and operating Aws Relational database service (RDS) & Nosql Database Dynamo DB(DDB) services..
  • Defined AWS resources, Parameters and mappings in JSON and YAML using Cloud Formation.
  • Experience with Virtualization technologies like Installing, Configuring, troubleshooting, and administering VMware ESX/ESXi and created and managed VMs (virtual server) and also involved in the maintenance of the virtual server.
  • Expertise and worked on of Docker and Kubernetes in container-centric development.
  • Developed Perl, PowerShell and shell/Bash scripts for automation of the build and release process, developed Custom Scripts to monitor repositories, Server storage.
  • Worked on Aws Elasticsearch, Cloud Watch in EC2 instance monitoring, IAM (Identity and Access management), ELB group (ALB & CLB) with multiple EC2 instances in it and used both S3 bucket EBS backed instances for volume.
  • Worked on Kubernetes in scheduling and running containers on virtual machines.
  • Experience in installing and configuring Splunk in cluster environment and fixing patches.
  • Expertise in terraform for multi cloud deployment using single configuration..
  • Worked on Aws lambda for deploying application with zero downtime in Aws Elastic Beanstalk for pipeline.
  • Experience in log management by using log entries and ELK stack Elasticsearch, Logstash and Kibana for over 150 servers.
  • Integrated Cloud front with S3 storage for content delivery (CDN).
  • Implemented rapid-provisioning and life-cycle management for Ubuntu Linux using Amazon EC2, Chef, and custom Ruby/Bash scripts.
  • Worked on launching containers with Docker to automate deployment of applications inside container for efficient usage of underlying systems.
  • Extensively worked on Cloud Formation templates in creating cloud infrastructure using JSON and YAML.
  • Automated the contiguous process writing code using shell, Bash, python scripting languages.
  • Worked on Amazon Virtual private cloud(VPC) in creating public subnets, Private subnets and NAT instances and dealt with security and access.
  • Used confluence in documentation of processes.
  • Providing Infrastructure consulting to the customer and managing terabytes of incremental backups on a day basis.
  • Performance tuning of TSM servers and co-ordinate with different group for resolving performance issues with TSM environment.
  • Hands on experience on Configuring Emc Data domain/ HP Store one and enabling replication between primary & dr sites
  • Hands on experience on installation and configuration of backup environment using CommVault backup software
  • Installation of New Net backup Master/Media servers to Balance the Work Load
  • Provided 3rd Level Storage Management Services, Support and Product Support for Net backup
  • Work with DBA’s and Lotus Admins for online backups configuration and restore using API, TDP for Oracle, Vmware,SQL, Lotus notes
  • Worked on Confidential Data protectier TS7650G Appliance which combines the feature of VTL with inline deduplication.
  • Worked on ACSLS and Confidential Library Manger for tape handling Defining Tivoli storage Manager Server storage pools - Primary disk storage pool - Sequential storage pool - tape and copy storage pool - tape for onsite and offsite data
  • Implemented Avamar 7.0 and configured Avamar Replications for Disaster Recovery.
  • Involve and assist in various audit procedures for TSM environment and provide required restores/retrieves for various litigation issues
  • Involved with Installation and configuration of Confidential Tape Library TS3310, TS3400 and 3584 directly connected with Tivoli storage manager server.
  • Create backup reports and analysis using tools like Bocada and TSM manager.
  • Quarterly backup sets for Data Preservation Project (DPP)
  • Capacity planning, to estimating the storage capacity for the next annual year, plan to getting resources (tapes, drives, etc)
  • Working with the Vendors of Confidential, EMC and STK to raise the ticket for the software and hardware related issues
  • Maintain the SAS 70 Security Compliance and manage the audit reports as well as TSMCOPS

Environment: Jenkins, Cloud Formation, Agile, RHEL, Kubernetes, Cloud watch, ELK Stack, Open stack, Red Hat, Elastic Beanstalk, Chef, Docker, RDS, JIRA, DDB, Apache Tomcat, Selenium, VMware, Maven, Nexus, EC2, Dynamo DB, Git, IAM (Identity and Access management), Subversion(SVN), Aws Lambda, Elastic search, Ruby, Cloud Trial, Ansible, shell/Perl, API Gateway, Amazon VPC, Json, Python, Terraform, Linux,TSM 5.3/5.5, AIX, Sun Solaris, Red hat Linux, Windows 2000/2003/XP, Oracle 9i/10g, MS SQL server 2000/2005, db2

Confidential, DALLAS, TX

Site Reliability / Cloud Engineer

Responsibilities:

  • Responsible for Automation of integrating various components in Backup/Storage/Database/VMware/Network Infrastructure to Support wide range of offerings like IAAS, PAAS, SAAS,DRAAS (Disaster Recovery as a service) to Customers Provided by Confidential .
  • Providing Infrastructure consulting to the customers and managing terabytes of 1000 plus Customers Data on a day to day basis across 19 Regions supported by 60 Plus datacenters across the Globe.
  • Automation and Monitoring with Continuous Integration and Continuous Deployment/Delivery pipeline.
  • Automation of infrastructure management and deployments using tools like chef
  • Automation of application deployment framework using chef, puppet and Ansible in build automation
  • Created Docker Images by packaging required components of an Application and worked on Docker Container Orchestration with Kubernetes.
  • Troubleshoot customer issues and gave root cause analysis for issues pertaining to their Infrastructure in Confidential
  • As a Site Reliability Engineer worked on all Layers in Open Stack from Network Layer to Application Layer.
  • Automation of Backups for the Virtual Environment and Supported various kinds of backup services provisioned for vmware environment to customer via Portal.
  • Worked as a system administrator for the build and deployments process on the enterprise server using Jenkins
  • Responsible for the Plugin Management, User Management and END-END build and deploy setup using Jenkins.
  • Designing and implementing fully automated server build management, monitoring and deployment by Using Technologies like Splunk, Shell scripts, GIT, Maven, Bitbucket, Jenkins, Selenium, Sonarqube, Nexus, Bamboo, Chef & Ansible.
  • Designed and implemented Continuous Integration process using tools like Jenkins with approval from development and other affected teams. Defined processes to build and deliver software baselines for internal as well as external customers.
  • Experience in Docker, Docker swarm, Kubernetes & Ansible in build automation pipeline and production deployment.
  • Worked on Troubleshooting various Kinds of issues related Automation Deployment Service requests from customers related to 170 plus services offered in Confidential via portal.
  • Debugging issues related to Various Layers in open stack and its associated service offerings.
  • Worked on Migration and Managing the Public, Private, Hybrid Cloud Environment using Chef.
  • Supported Disaster recover as a service and safe guarded Customer Data with wide range of service offerings in Confidential like DRVAULT(backup Tapes to offsite) as well as replication of Data to the nearest availability Zones with in the region.
  • Performance tuning of various components in open stack for fine run of customer applications in Cloud. .
  • Automation of Backup Installations and configurations on MS Windows, Red hat Linux, sun Solaris and Confidential AIX platforms.
  • Responsible for Infrastructure Automation, Developing tools for Backup/storage/ vmware/Database Infrastructure Automation and Monitoring with Continuous Integration and Continuous Deployment/Delivery pipeline
  • Automation of Installation and Configuration of TDP (Tivoli Data Protection) for MS-SQL server, Vmware, Oracle, Vmware. Sap Hana, Exchange, Lotus notes Etc.
  • Worked with configuring NAS backups using NDMP protocol and also supported virtual Tape Libraries in Confidential .
  • Work with DBA’s and for Automated online backups configuration and restore using API, TDP for Oracle, VMware, SQL
  • Worked on Confidential Data Protectier Appliance which combines the feature of VTL with inline deduplication.
  • Automation of Admin Schedules as well as Client Schedules on Backup Server.
  • Involve and assist in various audit procedures for Confidential and provide required solutions for various litigation issues.

Environment: Bluemix, Soft layer, TSM 6.x/7.x,AIX,SunSolaris,RedhatLinux, Windows, vmware,Oracle10G/11I,MS SQL server 2005/2008, SAP Hana, Sybase, Dockers, Kubernetes, Chef, Puppet, Ansible.

Confidential, DALLAS, TEXAS

TSM/ Commvault Administrator

Responsibilities:

  • Installation of Tivoli Storage Manager Server 6.3 on Windows 2003 Server.
  • Installing and configuring the ISC and Admin Center on the AIX box.
  • Customization of pre and post event scripts, Monitoring cluster health by checking logs files, Project planning & data collection, and writing shell scripts to generate TSM reports.
  • Provided 24/7 on-call support for the TSM Servers/ clients, on shift basis.
  • Trouble shooting of LTO Libraries under TSM environment, Checkup, error log checkup, Administrative schedules, Client backup schedules.
  • Check all the scheduled jobs, includes the daily backups and other daily activities like Migration, Reclamation, Collocation.
  • Registration of new TSM clients, creating their respective policies for the backups.
  • Worked with the Confidential Tape library 3584, keep track of the storage volumes (LTO), labeling, check-in, check-out and house keeping tapes.
  • Trouble shooting of TSM client problems, working on Problem and Change ticket management.
  • Hands on experience on installation and configuration of backup environment using CommVault backup software
  • Involved in creating CommCell & media agents
  • Work with DBA’s and Lotus Admins for online backups configuration and restore using API, TDP for Oracle, Vmware,SQL, Lotus notes
  • Worked on Confidential Data protectier TS7650G Appliance which combines the feature of VTL with inline deduplication.
  • Involved with DRM exercise
  • Knowledge and Experience of NDMP to backup and restore of NAS file server through Tivoli Storage manager for Windows and AIX
  • Worked with Confidential 3584 and STK L700, 8500,Quantum i6000 libraries
  • Installation of Tivoli storage manager B/A, Web Client and configuration on AIX 5.3.
  • Developed shell scripts for automation of TSM 3584, Tape Library management & report generation.
  • Providing operational and management reporting on the backup/recovery environment.
  • Managing tape inventory and maintaining tape drives and enterprise level tape libraries.
  • Monitoring backups, perform system restores and setting up TSM policies for backups and restores.
  • Defining policies to keep the number of versions of the databases and client Files.
  • Defining administrative schedules, backup storage pools, run expire inventory process.
  • Participated in meeting as point of contact (POC) for the TSM Servers.
  • Writing scripts for the TSM backup schedules, shell scripting when necessary.

Environment: TSM 5.3/5.4, Confidential AIX, Windows 2003, Remedy

Confidential, AUSTIN, TX

TSM Administrator

Responsibilities:

  • Monitor components of TSM, including databases, logs, tape libraries, messages and backups. Daily maintenance of TSM servers like Health check.
  • Define and manage storage pools in line with standards.
  • LAN-Free backups, Offsite, Disaster Recovery to hundreds of client nodes having different applications including Oracle, SQL Server, Lotus Domino, Exchange.
  • Define and manage retention policies, management classes and copy groups.
  • Provide support for backup server Tape drives and library problems, including halting and/or restarting the backup server software applications.
  • Installed, Configured and managed the Tivoli Storage Manager for backups and restores.
  • Provided Oracle and DB2 UDB database support.
  • Installing configuring and Trouble shooting of LTO Libraries under TSM environment.
  • Installation and testing of the DRM for TSM server Restoration.
  • Configuration of Database and Recovery log.
  • Worked on the reporting tool, for the backup reports and monitoring.
  • Define and setup the Storage pools, Configure the hierarchy between storage pools.
  • Configuring TSM operations like expiration, migration, reclamation, collocation etc.
  • Define and configure the client schedules and administrative schedules, for automatic backup of Oracle databases and logs at Exchange, File servers data predefined intervals.
  • 24 / 7 support for the Production and Disaster recovery site.
  • Backup & Restoration of databases from local site & recovery site.
  • Managing different types of OS and database backups and restores using TSM.
  • Designing complete backup and restore Strategy.
  • Define and setup the Storage pools, Configure the hierarchy between storage pools.
  • Define and configure the client schedules and administrative schedules.
  • Tuning the SQL queries, providing parallel, index hints for the queries to improve performance.

Environnent: TSM 5.x, Oracle 9i/10g, AIX, Sun Solaris

Confidential, DALLAS, TX

TSM administrator/ Oracle DBA

Responsibilities:

  • Regular TSM health Checks - DB, Log, Storage pool, Scratch count, etc.
  • Checking the missed/ failed backups and trying to resolve them.
  • Monitoring all the scheduled jobs includes the daily backups and other daily activities like Migration, Reclamation, and Collocation.
  • Registration of new TSM clients, creating their respective policies for the backups.
  • Cleaning up the decommissioned clients
  • Involved in day-to-day basis DBA activities like monitoring, performance tuning and maintenance of databases.
  • Developed the databases, Tables, Views, materialized views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
  • Created tables, indexes by analyzing and rebuilding Indexes for better performance.
  • Created temporary tables, reports for the development team.
  • Worked on the automation of various batch jobs, monitoring CPU, memory at regular intervals.
  • Estimated Storage requirements design the physical database layout and create the databases for production, testing and development.
  • Export/Import data from production to Development/ Reporting database for testing.
  • Loading the data from flat files using the SQL*Loader.
  • Installation and upgrade of TSM 5.2 to 5.3.
  • Define and setup the Storage pools and configure the hierarchy between storage pools.
  • General database health checks, backup checks and monitoring, archiving and user creations, tablespace management, space management, CPU and memory monitoring.
  • Monitoring the backup plan and managed Import/ Export data for Dev and QA team.
  • Provided 24/7 monitoring of network & database operations to ensure efficiency.
  • General System Administration, which include user creation, creating groups, housekeeping, CPU and memory monitoring using commands like SAR, VMSTAT, PRSTAT, TOP, IOSTAT, etc.
  • Installation of Red Hat Linux, allocating IP Address, making system ready for the testing purposes.

Environment: Oracle 9i, SQLserver 7.0/2000, TSM 5.x, Netback up 6.0

Confidential

Oracle/ SQL server DBA/ TSM administrator

Responsibilities:

  • Administration of Oracle8i/9i databases including installation, creation, and monitoring database.
  • Handled database tuning and performance enhancement (SQL tuning) for number of Applications. Creating indexes, explain plan, optimizer hints, and TKPROF.
  • Involved in Troubleshooting and support to client sites in case of problems.
  • Monitoring listener services and listener logs (for access)
  • Monitoring table spaces for space usage and adding required space after it reaches threshold.
  • TSM server performance tuning and monitoring.
  • Creating new objects like synonyms and providing required grants to users.
  • Installing oracle client versions for developers.
  • Troubleshooting several client access issues (like toad client) and helped users to resolve those issues.
  • Installation and Configuration of TDP for Oracle and MS SQL Server.
  • Developed SQL Server Stored procedures and DTS packages to extract data from database.
  • Installation of SQL server 7.0 on Windows environment.
  • Performed several schema/object refreshes
  • Cloning database using cold/hot backup methods
  • Applied RDBMS patches.
  • Creating the required table spaces, users, and roles for the application. Work with application administrators to implement and support Tivoli Data Protection components.
  • Define and setup the Storage pools and configure the Policy domain, Policy Set, Management class, Backup copy group, Archive copy group as per Customers requirement.
  • Configuration and checking status of Database, Recovery log and storage pools.
  • Day-to-Day TSM maintenance, Fixing Library related issues.
  • Backing and restoring the oracle database using RMAN utilities.
  • Provide 24/7 backup recovery and perform daily check to verify the nightly scheduled backups.
  • Manage capacity and performance of the backup infrastructure ensuring the integrity of the infrastructure.
  • Installed Integrated Solution Center and Admin Center for TSM
  • Generating TSM reports by using shell scripts and also scheduling the scripts in the cron job.

Environment: Oracle 8i/9i, SQL server 7.0/2000, AIX 4.x, Sun Solaris, TSM 5.2

We'd love your feedback!