SUMMARY:

• Total 10+ years IT experience that includes AWS Solution Architect, Oracle DBA, RAC & Golden gate
• 3 years of experience on Amazon Web Services
• Supporting AWS services IAM,EC2,S3,VPC,RDS,DynamoDB& Redshift services
• Supporting different AWS services like ELB, Lamda Function, SNS, SQS, SWF, Autoscaling, Cloudwatch & Cloudfront,
• Create Security using IAM, Security Groups and NACL
• Worked on Hybrid Clouds Platforms
• Experience on EC2 instance creation and connecting to EC2 instances
• Experience on configure Java based web application
• Experience on RDS service to launch Various DB instances (Aurora,MySQL,Postgres,Oracle & SQL server) and assign security groups for public cloud connections
• Troubleshoot database performance tuning by using AWS Enhanced monitoring and scale the database based on recommendations
• Automation using Chef in AWS for CI an CD
• Automating AWS infrastructure using OPS works
• Experience on Devops tools Chef,Ansible,Puppet & Jenkins
• Experience in Implementing NAGIOS and SPLUNK
• Experience on AWS cloud watch and create alarm for critical metrics
• Experience on database migrations from on premise to cloud by using DMS & SCT tool
• Experience on Schema Conversion Tool (SCT) for heterogeneous migrations
• Experience on launch Redshift cluster and scale upto 3 node cluster
• Experience on JSON & Yaml to script build using Cloud formation & Terraform
• Experience on Unix Shell scripting & Python scripting
• Experience on implementing and managing oracle real application cluster (RAC), Data guard, Backup and Recovery Process & Performance Tuning
• Experience in Golden Gate technologies for production and development environment
• Experience on various operating systems ( Linux,Unix and Windows)
• Experience in installation, upgradation, migration, cloning, database refresh using RMAN/Data Pump/Exp - Imp/Brtools, patch implementation, planning & managing Backups and Recovery, database tuning and monitoring of oracle servers
• Experience with Oracle 12c RAC/11g RAC/10g in Installation, Administration, Monitoring, Database Backup and Recovery.
• Disaster Recovery solutions using Oracle Data guard (Physical, Snap shot standby, Active Data Guard etc.)
• Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate
• Experience on different Database replication strategies by using golden gate
• Experience on oracle database upgrades from 10g to 11g, 11.2.0.3 to 11.2.0.4 and 11g to 12c.
• Experience in analyzing AWR, ADDM, ASH & Explain plan etc
• Evaluation, upgrade and testing of database software patches and new versions
• Experience on Oracle ASM and convert non- ASM f/s to ASM f/s
• Experience on convert standalone database to RAC database
• Experience on OEM 12c/13c(cloud control) Implementation and Automation
• Experience on Oracle TDE implementation to encrypt crucial data
• Experience on database capacity planning and archive capacity planning
• Handle tickets based on ITIL process and respond back within SLA.

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

AWS Solution Architect

Environment: AWS IAM, EC2,VPC,S3,RDS, Dynamo DB, Redshift & ORACLE

Responsibilities:

• Create proof of concepts (POC) and perform R&D in development environment before going to production
• Implement POC’s in pilot projects to show the results to customer
• Create IAM users, IAM roles and IAM policies to restrict the access on AWS services
• Launch AWS EC2 instance and configure different type of applications
• Configure security groups to restrict access on AWS EC2 instances
• Configure EBS volumes and configure encryption keys on top of EBS volumes
• Leverage AWS CLI utility to automate backups, EBS volumes snapshots
• Configure cloud watch alarm for EC2 and RDS instances metrics
• Enable encryption on EC2 volumes and S3 buckets by using AWS KMS
• Configure load balancer and auto scaling for high availability of application
• Configure Java based web application by using EC2 or Elastic Beanstalk
• Configure server less web application by using Route 53,S3,cloud front, & ACM
• Configure Lamda function based on customer request
• Leverage Lamda function to configure server less application by using S3,Dynamo DB& Rest API’s
• Leverage python & Unix scripting for various application deployment
• Launch various DB instances (Aurora,MySQL,Postgres,Oracle & SQL server) and work with application team for any DB issues
• Design Oracle database architecture in AWS environment and upload all supporting documents into confluence page
• Automate AWS infrastructure by using Cloud Formation template and terra form
• Configure Oracle Secure Backup cloud module in AWS environment
• Schedule RMAN backups by Using Oracle Secure Backup cloud module
• Create AWS S3 bucket objects and assign IAM role to store the objects
• Configure S3 life cycle policy to transit objects/backups from one storage level to other storage level
• Configure S3 bucket policies to restrict the access
• Ensure Oracle Logical & RMAN backups are saved into AWS S3 bucket
• Create a deletion policy, Enable versioning & MFA for critical AWS S3 objects
• Replicate critical backups / objects from one AWS region to other AWS region as per client requirement
• Leverage Ansible script to deploy database provisioning in AWS environment
• Deploy OS packages, Database patches & Database provisioning by using Ansible script
• Migrate oracle databases from on-premises to AWS cloud by using DMS and SCT tools
• Ensure EBS & RDS IOPS are in control during peak business hours
• Monitor AWS cloud watch alarm & Oracle Cloud Control for critical and high alerts
• Monitor EC2 and RDS dashboard and take necessary action if we see any discrepancies
• Coordinate with application and support team to resolve the issues within SLA
• Configure ADFS for single sign for Active directory users in AWS
• Configure Jenkins to manage build and release
• Work with BitBucket,Git, Jenkins, Docker & Ansible for CI / CD
• Knowledge in Docker containers
• Offload Oracle RMAN backup from Primary to standby database in dataguard environment
• Replicate databases by using GoldenGate Bi-directional replication method
• Enable GoldenGate DML and DDL replication as per business standards
• Deploy OEM agent in various databases for alerts and monitoring purpose
• Generate AWR,ADDM & ASH reports and provide analysis during DB performance issues
• Plan for table reorg / index rebuild based on high water mark report
• Consolidating AWS billing and setting up alerts for cost optimization
• Maintain and improve current knowledge on the latest technologies relevant to the role regarding algorithms, language, design methodology, third-party development tools, application platforms, hardware compatibility and operating systems

Confidential, Mason, OH

AWS Solution Architect

Environment: AWS IAM, EC2,VPC,S3,RDS, Dynamo DB, Redshift & Oracle

Responsibilities:

• Consolidating AWS billing and Setting up alerts for Cost optimization
• Extending AWS VPC to Segregate Production, Testing and Development
• Implementing AWS Security Groups and NACL (Access control list) for Additional Layer of Security
• Launch EC2 instances for Production, Testing and Development environment and give proper security groups for user connectivity
• Configure Java based web application by using EC2 or Elastic Beanstalk
• Launch AWS RDS instances(Aurora,MySQL,Postgres,Oracle & SQL server) in multi AZ environment and create read replicas for high availability & failover
• Create encryption for RDS instances & EC2 Volumes by using AWS KMS
• Maintain Security groups for RDS & EC2 instances
• Work with application team for RDS connection issues
• Connect to RDS instances by using sqlplus connectivity tools (MySQL workbench, SQL developer, Dbeaver, Oracle client etc…) and perform daily DB tasks
• Create test databases by using AWS snapshots for critical application testing
• Launch Redshift Cluster and work with application team for DB assistance
• Migrate on premises databases to AWS Cloud by using DMS & SCT tool
• Configure & Monitor cloud watch alarm and take necessary actions if need
• Work with application team to configure Lamda function, SQS & SNS services
• Monitor AWS RDS & EC2 dashboard and take necessary action if we see any discrepancies
• Monitor Cloud watch alarm and take necessary actions if need
• Configure Dynamo DB for NoSQL tasks
• Trouble shoot RDS & EC2 performance issues during on / off business hours
• Create S3 bucket objects and move the data to glacier by using life cycle policy
• Perform database pointing time recovery as per requirement
• Configuring AWS Elastic Load balancer and Pre-warming Elastic Load Balancer as required
• Troubleshooting AWS Auto scaling and EC2 instances related issues
• Connect to EC2 instance by using Putty, GIT, etc
• Setting up AWS Cloudwatch and Custom Metrics for AWS services
• Implementing AWS IAM security best practices
• Implementing AWS Route53
• Maintain SVN,GIT hub to maintain VCS repository
• Used Jenkins to manage Build and release
• Used configuration management tools like Chef, Puppet & Ansible for CI and CD
• Built and Modified Chef recipes to automate using OPSwork
• Built various Ansible playbooks to deploy the tasks from source machine to node machines
• Configure Jenkins, Maven software’s as per customer requests
• Implementing AWS Cloud Formation
• Configure Python script based on requirement
• Knowledge in Docker Containers
• Configure S3 storage objects and enable versioning to store the objects
• Implementing backup Solutions with Amazon Glacier knowledge in Amazon Kinesis, AWS Lambda, Amazon Simple Queue Service (Amazon SQS), Amazon Simple Notification Service (Amazon SNS), and Amazon Simple Workflow Service (Amazon SWF)
• Configured ADFS for Single sign for Active directory users on AWS
• Perform POC’s by using AWS services and implement the pilot projects as per the client request
• Follow SDLC process for major changes to ensure 100% compliance

Confidential, Raritan, New Jersey

Team Lead, AWS &Oracle DBA

Environment: HP-UX,AIX,LINUX, Windows, ORACLE 10,11g & 12c

Responsibilities:

• Maintain Supply chain systems global wise and take necessary action is there any bottlenecks on availability
• Designed, configured and implemented AWS network across Multiple regions
• Customize VPC based on organization structure
• Configure IAM roles in AWS for user level access security
• Launch AWS EC2 instances based on requirement and connect instances by using Git and Putty
• Configure EC2 load balancer to maintain the load in between the web servers
• Configure Cloud watch for Performance Counters on Mission Critical EC2 instances
• Configuring and Implementing Life Cycle Management for S3-IA and S3 Glacier
• Utilize S3 buckets service to store objects into cloud
• Launch DB instances in multi AZ by using AWS RDS service and assign security groups for connectivity
• Setting up Database infrastructure ( RDS, Redshift and Dynamo DB)
• Monitor AWS RDS dashboard and take necessary action if we see any discrepancies
• Migrate on premise databases to AWS cloud by using DMS & SCT tools
• Configured RDS Backups and Deployed Instances from backups
• Configured ADFS for Single sign for Active directory users on AWS
• Configure Jenkins to manage Build and release
• System Analysis & Design, Database Design, Database Architect, Physical disk storage, Data security, Backup and recovery & Change Management
• Define Database objects by using DCL,DML & DDL commands
• Oracle database installation (10g, 11g &12c) based on business requirement
• Administration of Oracle 10g, 11g & 12c database servers using ASM / Non-ASM
• Maintain IDMS databases as per database security and compliance
• Add/Modify existing IDMS entries into OID Server as per requirement
• Ensure all external DB connections pass through OID server to maintain database security
• Implement Oracle TDE encryption in tables to secure customer personal data
• Add additional objects/ columns into TDE based on sensitive data information
• Take care of wallet open / close task during system downtime
• Configure oracle wallet SSO to avoid manual intervention during database startup
• Experience on various SAP modules ECC,CRM,SCM,EP & BW which are running on Oracle Databases
• Maintain SAP ERP systems with high availability and ensure there is no interruption to business
• Maintain SAP backup dashboard and take necessary action if any backups are failed
• Apply SAP databases security configuration to maintain SOX standards
• Monitoring Oracle Datagaurd using automation script and take necessary actions if we see any archive gaps.
• Disaster Recovery solutions using Oracle Data guard (Physical, Snap shot standby, Active Data Guard etc.)
• Apply database Patches by using Opatch & Mopatch utilities.
• Database upgrade from 11.2.0.3 to 11.2.0.4 and 11g to 12c
• Troubleshoot and resolving daily database issues. Creates and maintains all databases required for development, testing and production usage
• Planning and managing the databases infrastructure
• Troubleshoot backup failures such as Bcv/ Online/ Archive backups.
• Refresh databases by using various methods (RMAN, Data Pump,Brtools etc.).
• Backup and recovery strategy by using RMAN
• Implementation of Oracle Flashback in all Databases
• Use the flashback scenario to undo the database to minimize the downtime window
• Manage RAC databases by using SRVCTL and CRSCTL utilities
• Convert logical volume database files to ASM file system
• Covert standalone database to RAC database for high availability
• Add / delete nodes in cluster environment
• Use Goldengate replication methods to migrate the critical production databases to different hardware for zero downtime commitment
• Enable Supplemental logging and install GoldenGate binaries for replication purpose
• Configure Uni & Bi directional Golden Gate replication based on customer request
• Add / delete additional tables in GoldenGate replication
• Configure multi master & Active-Active Golden Gate replication for critical production databases
• Configure DML / DDL replication based on customer requirement
• Monitor GoldenGate process via script and take necessary action if we find any lag, Oracle errors etc.. in replication
• Replicate the tables / schemas from source to target systems on daily basis
• OEM 12c implementation(promotion) and monitoring
• OEM 13c agent upgrade from 12c agent
• Automation using OEM & Scheduling Tools
• Create PLSQL stored procedures to reduce the network traffic and faster execution
• Create PLSQL Triggers to maintain the referential integrity for DML operations
• Create PLSQL packages,functions based on requirement and maintain data integrity
• Analyze AWR, ADDM,ASH reports based on database performance issues
• Execute SQL tuning to optimize the SQL query performance
• Experience in analyze slow running SQL in critical production systems and take necessary action/recommendations to improve the performance
• Enable user session trace & enable Auto trace to identify the performance bottle necks
• Experience on analyze sql profile, execution plan, create optimized indexes & Collect CBO stats etc
• Plan for Table reorg / Index rebuild based on high water mark for database optimization
• Implement memory and DB parameter changes to improve over all DB performance based on Oracle recommendations
• Monitor database performance & Top activity though OEM 12c/13c console
• Interact with OS & storage admin teams to optimize the OS jobs, resource optimization & Scaling
• Engage Oracle Support, HP and all other vendors in sev-1 situation to get response quickly to resolve the issue
• Configure database vault based on customer requirement
• Tablespace monitoring using automation
• Perform Database and archive capacity planning to create and maintain the databases
• Creating new users and manage Roles and Privileges
• Troubleshoot connection issues in JDBC/ODBC & DB LINK connections
• Write Unix scripts to automate repeated and complex tasks
• Connect to SQL server databases and take the reports based on customer request
• Knowledge on Oracle Cloud Control technologies
• Knowledge on Database configuration on multi tenancy architecture
• Implement SOX controls in various critical production systems to maintain compliance stuff
• Experience on Tidal & Veritas netbackup tools for regular backups
• Follow SDLC process for major changes to ensure 100% compliance
• Close all problem tickets/ incidents / tasks/ CRQ’s on time to avoid SLA breaches