09/06/2022 updated
MG
100 % available
AWS Redshift Administrator
Bangalore, India
India
MSAcceptance TestingIBM AIXAmazon Web ServicesAmazon Elastic Compute CloudAmazon S3Analysis Of Variance (ANOVA)ArchitectureBackup DevicesBig DataCloud ComputingCloud Computing SecurityDatabasesData CentersData WarehousingDatabase Design
HBase, Redshift, Oracle, MSSQL, MySQL, Database designing, Configuration, Administration, Monitoring, Performance Tuning, Database, various cloud technologies AWS, RDS, EC2, AWS WAR, cloud security, IAM, Cloud trail, AWS KMS, testing, ANOVA, ANCOVA, Cloud Technologies, AWS, Bigdata, HBase (EMR), Datawarehouse, Python, R, shell script, AWS cloud trail, exploratory Data, Machine Learning, linear regression, KNN, SVM, logistic regression, K-means, Database Architecture, Red Hat Linux, IBM AIX, Solaris, S3, Cloud, data warehouse, Netezza/Oracle, Netezza, data center, EMR, Oracle Database, NLP, Lambda, Shell Scripting, RMAN, Dynamo DB, MS SQL, Oracle RAC Databases, Amazon EC2, backups, EC2 servers, AWS Lambda, data science, Sybase, Hadoop, RAC, DG broker, TimesTen, DB, DR, UAT DB, UAT, Apex 3.2 to 4.2, Oracle GoldenGate 11g, 12c, backup, OEM, ITIL v3
Experience
Professional experience10+ years
Languages
EnglishFluent
Project history
T ECHNOLOGIES:
Oracle Database, AWS, NLP, Python, Lambda, Shell Scripting, Data Guard, RMAN, AWS, Redshift, RDS,
EC2, S3 buckets, Dynamo DB and MySQL
R ESPONSIBILTIES:
* Played a major role during transition of three Business units from vendors to In-house -
technical and operations.
* Cross functional support for 5 Business units(25 members) - Oracle, MS SQL, Redshift and MySQL.
* Migration of Oracle RAC Databases to Amazon EC2 instances.
* Migration of Oracle Databases from one data center to another.
* Lead Oracle Database upgrades /patches.
* Managing Database wallets.
* Restoration of RMAN backups from S3 buckets to EC2 servers.
* Redshift cluster build & manage Redshift Database.
* Managing RDS MySQL & Oracle Database.
* Working on AWS Lambda services for catalog project.
* Member of data science project - Built an accounting model for General Ledger posting for work
automation, TIME Inc.
Oracle Database, AWS, NLP, Python, Lambda, Shell Scripting, Data Guard, RMAN, AWS, Redshift, RDS,
EC2, S3 buckets, Dynamo DB and MySQL
R ESPONSIBILTIES:
* Played a major role during transition of three Business units from vendors to In-house -
technical and operations.
* Cross functional support for 5 Business units(25 members) - Oracle, MS SQL, Redshift and MySQL.
* Migration of Oracle RAC Databases to Amazon EC2 instances.
* Migration of Oracle Databases from one data center to another.
* Lead Oracle Database upgrades /patches.
* Managing Database wallets.
* Restoration of RMAN backups from S3 buckets to EC2 servers.
* Redshift cluster build & manage Redshift Database.
* Managing RDS MySQL & Oracle Database.
* Working on AWS Lambda services for catalog project.
* Member of data science project - Built an accounting model for General Ledger posting for work
automation, TIME Inc.
T ECHNOLOGIES:
OracleDatabase, GoldenGate, Apex, Sybase, MSSQL, Hadoop, RAC, DG broker, RMAN, Veridata, Exadata and
TimesTen
A PPLICATIONS:
SMSV, GTRAC, Treasury, Board Finance
R ESPONSIBILTIES:
* Monitor and maintain ORACLE Productions DB of both RAC and Standalone setup, DR and UAT DB,
ensuring minimum downtime for the same. Providing optimum utilization of resource available.
* Create new Production, UAT Database with/without ASM configuration and Clusterware setups as per
client requirement.
* Install and Administer Apex 3.2 to 4.2.
* Manage Exadata Database.
* Install, Administer and upgrade Oracle GoldenGate 11g to 12c.
* DR switchover and failover. Participated in four DR (Disaster recovery) switchover
activities.
* RMAN backup configuration, restorations, RMAN duplication and standby creations.
* DG broker configuration and Database switchover using DG broker.
* Configure Database and other components in OEM & managing the same through OEM.
* Handle user incident, Service Request, Change, Problem Requests with customer's due satisfaction.
* Install, configure & management of Oracle 12c Cluster ware and Oracle 12c Database.
OracleDatabase, GoldenGate, Apex, Sybase, MSSQL, Hadoop, RAC, DG broker, RMAN, Veridata, Exadata and
TimesTen
A PPLICATIONS:
SMSV, GTRAC, Treasury, Board Finance
R ESPONSIBILTIES:
* Monitor and maintain ORACLE Productions DB of both RAC and Standalone setup, DR and UAT DB,
ensuring minimum downtime for the same. Providing optimum utilization of resource available.
* Create new Production, UAT Database with/without ASM configuration and Clusterware setups as per
client requirement.
* Install and Administer Apex 3.2 to 4.2.
* Manage Exadata Database.
* Install, Administer and upgrade Oracle GoldenGate 11g to 12c.
* DR switchover and failover. Participated in four DR (Disaster recovery) switchover
activities.
* RMAN backup configuration, restorations, RMAN duplication and standby creations.
* DG broker configuration and Database switchover using DG broker.
* Configure Database and other components in OEM & managing the same through OEM.
* Handle user incident, Service Request, Change, Problem Requests with customer's due satisfaction.
* Install, configure & management of Oracle 12c Cluster ware and Oracle 12c Database.
P ROJECTS:
* Nearly 30 customers which includes Yes Bank Limited, Chola, Sanmar, Lakshmi Vilas Bank and so on.
R ESPONSIBILITIES:
* Provide remote support to multiple customers in Request, Incident, Change, and Problem Management
aligned to ITIL v3.
* Prepare POA (Plan Of Action) and SOP (Standing Operating Procedure).
* Automate mundane tasks.
* Identify risks in current setup, recording in standard format of Risk register & recommend
solutions to overcome those risks.
* Capacity Planning.
* Fine tune Servers to meet the industry standards and the best practices.
* Suggest and Implement SIPs (Service Improvement Plan).
* Nearly 30 customers which includes Yes Bank Limited, Chola, Sanmar, Lakshmi Vilas Bank and so on.
R ESPONSIBILITIES:
* Provide remote support to multiple customers in Request, Incident, Change, and Problem Management
aligned to ITIL v3.
* Prepare POA (Plan Of Action) and SOP (Standing Operating Procedure).
* Automate mundane tasks.
* Identify risks in current setup, recording in standard format of Risk register & recommend
solutions to overcome those risks.
* Capacity Planning.
* Fine tune Servers to meet the industry standards and the best practices.
* Suggest and Implement SIPs (Service Improvement Plan).