AWS Cloud Administrator/Database Administrator
PROFESSIONAL SUMMARY:
6.9 years of Oracle/MS SQL server DBA/AWS Administrator experience in administrating
Database, IT AWS Infrastructure and Hosting based 24X7 support environment. Seeking
an opportunity to utilize my talents in a professional capacity, employing comprehensive
knowledge and vast professional experience.
WORK EXPERIENCE
AWS Cloud Administrator/Cloud DBA Team Lead
Wipro Technologies -
Account: Shell Cloud Operations
Shell is a global group of energy and petrochemical companies. Shell
headquarters are in The Hague, the Netherlands. Shell Aims is to Using Amazon Cloud,
Shell could provision a private, Public and hybrid isolated section of the Amazon Web
Services (AWS) cloud where it could launch resources in a virtual network.
Job Responsibilities
Working as Administrator strategy in various environments of Windows/Linux along
with adopting cloud strategies based on Amazon Web Services.
Experience in configuring, deployment and support of cloud services including
Amazon Web Services (AWS)
Strong knowledge and experience on Amazon Web Services (AWS) Cloud services
like EC2, S3, EBS, RDS, VPC, and IAM.
Designed and managing public/private cloud infrastructures using Amazon Web
Services (AWS) which include EC2, S3, Cloud Front, RDS, VPC, Route53,
CloudWatch, Cloud Trail, Cloud Formation, and IAM which allowed automated
operations.
Setting up databases in AWS using RDS, storage using S3 buckets and configuring
instance backup to S3 bucket.
Improved infrastructure design and approaches of different projects in the cloud
platform Amazon Web Services (AWS) by configuring the Security Groups, Elastic
IP's and storage on S3 Buckets.
Customized Amazon Machine Images (AMIs) & deployed these customized images
based on requirements.
Performing the Oracle and MS SQL Server Database Migrations from On-Premise
DB’s to AWS Cloud EC2/RDS instances.
With the help of IAM created roles, users and groups and attached policies to provide
minimum access to the resources.
Created topics in SNS to send notifications to subscribers as per the requirement.
Configuring S3 bucket permissions, versioning, and logging.
Strong Experience automated build platforms/continuous integration using DevOps
architecture.
Troubleshoot and resolve EC2 instance connectivity and availability issues.
Created monitors, alarms and notifications for EC2/RDS using CloudWatch.
AWS data backup (snapshot, AMI creation) techniques, along with data-at-rest
security within AWS.
Evaluating system-based configuration and security vulnerability to ensure
compliance with the organization's standards
Working on call 24/7 for Production support
___________________________________________________________________
Cloud Services Infra Oracle/SQL server DBA
Account: Shell Cloud Operations Team
My role was Database administrator for supporting AWS Cloud RDS DB instances
and EC2 DB instances in Development/Testing/Production environments on AWS VPC.
Handling administration and troubleshooting of Database operational tasks.
Job Responsibilities
Launched and managed the AWS RDS instances as per customer requirements.
Installations and Administration of SQL server and Oracle Databases on AWS EC2
instances.
Performed the Database migrations from On-premise to AWS Cloud EC2 or RDS
instances
Hands on experience on Backup and restore activities for AWS EC2 and RDS
instances by using Snapshots
Performed the tasks using Amazon Command line interfaces (CLI’s).
Configured the SQL server DB mirroring as per the project requirement
Providing support and taking ownership on escalated cases and perform root cause
analysis (RCA) & complete documentation of problems and solutions.
Involved in Support and Enhancements project.
Project activities included support production ticket and Enhancement of multiple
Applications in .NET framework and SQL SERVER/Oracle Database.
SQL Job and SSRS, SSIS Package monitoring. Also involved in SSRS Report
development.
Developed SSRS report for Customer requirement.
Technical contribution to design - providing inputs to design solutions and
documents.
Mentor new team member and provide knowledge transfer on the application and
tasks
Oracle Database Administrator
Account: Expresso Telecom Group Ltd
Expresso is an African telecommunications services company. Expresso
telecommunications services provided coverage in five African markets through both our
fixed and mobile network infrastructure, servicing our individual and business
customers. My role here was as a Database administrator for supporting oracle
databases in Development/Testing/Production environments on Solaris and Linux
platforms. Handling administration and troubleshooting of the Oracle server versions
10g/11g.
Job Responsibilities
Installed and administrating of Oracle database server 10g/11g on Linux.
Supported for Oracle 10g RAC database and involved in troubleshooting of DB issues
Created several databases manually and by using DBCA tool for supporting
production and test and development environments
Created users & privileges with appropriate roles and levels of security and
Controlling and monitoring the user access to the database
Performing logical backups using export utility and recovering specific object or
schema using import utility
Configured and monitoring the whether the automatic RMAN scripts or successfully
running or not
Performed day-to-day operations like troubleshooting client connectivity, monitoring
database growth, listener and monitoring scheduled jobs
Monitoring alert log and trace files for errors
___________________________________________________________________
Performed extensive tuning / troubleshooting of databases for optimal performance
and tuning the application SQL's, lock contention and index usage etc
Performed several database upgrades and applied patches for Oracle databases both
on production and development databases
Managed partitions for large tables and troubleshooting of network and configuration
problems using listener tracing/SQLNET client tracing
Resolving user issues and performance issues and complex backup and recovery
issues
Monitoring the CPU usage, I/O statistics and CPU time to identify any OS level
Performance killers
Preparing automated scripts for RMAN backup and alerts
Oracle Database Administrator
Account: HDFC Securities, Mumbai
My role here was as a Database administrator for creating oracle databases in
Development/Testing environment on Linux platforms. Handling administration and
troubleshooting of the Oracle server versions 10g/11g during application testing phase.
Job Responsibilities
Installed and maintained the Oracle database server 10g/11g on Linux.
Created several databases manually and by using DBCA tool for supporting Test and
Development environments
Created users & privileges with appropriate roles and levels of security and
Controlling and monitoring the user access to the database
Performing logical backups using export utility and recovering specific object or
schema using import utility
Configured and monitoring the whether the automatic RMAN scripts or successfully
running or not
Performed day-to-day operations like troubleshooting client connectivity, monitoring
database growth, listener and monitoring scheduled jobs
Monitoring alert log and trace files for errors
SKILLS:
AWS (4.8 years), DATABASE (6.8 years), MSSQL (4.8 years), Oracle (6.8 years)
CERTIFICATIONS
AWS Solution Architect – Associate
TECHNICAL SKILLS:
AWS: EC2, RDS, S3, IAM, VPC, SNS, CloudWatch, KMS,
Operating System: Windows, Linux
Database: ORACLE, MS SQL SERVER and DynamoDB
Database Language: SQL, T-SQL
Tools: SQL Management Studio, Toad, SQL Developer, RMAN,AWS CLI, Putty, OEM
Monitoring: AWS CloudWatch
Troubleshooting: top, ping, telnet, netstat, traceroute
___________________________________________________________________
