SUMMARY

• Reliable DevOps engineering, building Highly Available and Cost Saving AWS environments; durable systems that operate continuously with unlikely failure.
• Managed AWS infrastructure provisioning using CloudFormation.
• Design and deploy scalable, highly available, fault tolerant and reliable applications in AWS.
• Hands - on experience with AWS CLI including deploying CFTs, managing S3, EC2, IAM on CLI.
• Monitor infrastructure and applications using CloudWatch, VPC Flow Logs, CloudTrail.
• Implement cost optimization strategies in the AWS infrastructure.
• Build highly available content distribution sites by using CI/CD tools like Ansible, Jenkins, Jira Git and Github.
• Experience with Amazon RDS and Aurora PostgreSQL and MySQL database engines with Multi-AZ for Automatic Failover and Read Replicas.
• Design EC2 and related architecture to meet HA while incorporating security best practices.
• Implement security best practices in AWS including MFA, access key rotation, encryption using KMS, Security Groups and NACLs, S3 bucket policies and ACLs, mitigating DDOS attacks etc.
• Manage Puppet, Chef, Ansible, Jenkins, Github and SSM for configuration management.
• Use AWS System Manager and Run Command to automate operational tasks across AWS resources.
• Use Jira to plan, track, support and close requests, tickets and incidents
• Delegate access across AWS accounts using IAM cross account roles.
• Knowledge of Docker, Docker Hub and related tools.
• Installation and Administration of PostgreSQL databases
• Configuration and deployment of Oracle RDS and Aurora PostgreSQL database engines
• Understanding of PostgreSQL architecture and internals
• Experience with migration projects using tools like Ora2pg and AWS SCT and DMS
• Considerable experience in converting Oracle PLSQL to PostgreSQL PL/pgSQL
• Strong knowledge of Oracle and PostgreSQL data types
• Considerable understanding of tuning memory parameters in PostgreSQL
• Some Linux administration and troubleshooting skills
• Ability to identify alternatives for several Oracle features in PostgreSQL
• Experience and Maintained standby databases, Switch Over/ Failover
• Expertise in configuration and administration of Oracle databases; standalone and RAC
• Experience in UNIX shell scripting, Oracle schedular, CRON jobs, AutoSys scheduler
• Good understanding of System Development Life Cycle (SDLC) Methodology
• Proficient in system Monitoring and Database Performance Tuning
• Expertise in implementing High Availability Solutions; PostgreSQL, Oracle Data Guard, Golden Gate and RAC
• Experienced in using RMAN tools; Backup and Recovery, PITR, Cloning, Refreshes…etc.
• Extensively worked on Import/Export and Data Pump export/import tools
• Experienced using TDE and Data Masking & Redaction for Data in motion
• Good knowledge and understanding of EXADATA Database Technology

TECHNICAL SKILLS

RDBMS: Oracle 10g, 11g,12c, SQL Server, PostgreSQL,MySQL

Tools: and Utilities: 10g/11g OEM, 12c GUI Cloud Control, TOAD, SQL Developer, ORAchk, OPatch, AWR,ADDM,TKPROF, Explain Plan, SQL*Loader, Putty, VNC,, RMAN, Data pump, Pg Hero, Pg Bouncer,Pg Admin,Badger

Operating Systems: HP-UX 10.x, 11.x, 12c, Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

High Availability Technologies: Data Guard, Golden Gate, RAC, Streaming Replication

PROFESSIONAL EXPERIENCE

Confidential - ATLANTA, GA

Cloud Database Administrator

Responsibilities:

• Responsible for providing 24x7 on-call support ; Monitoring and Notification
• Configuration of Continuous Integration (CI) and Continuous Delivery (CD) using Code Pipeline and Code Deployments for automation.
• Good experience in creating and editing shell, bash and python scripts for automation.
• Working with configuration management tools like Puppet, Chef, Ansible, Source Code Management tool GitHub and Jenkins for Continuous Build Management.
• Use Jira to plan, track, support and close requests, tickets and incidents.
• Experience in Shell, Bash, Yaml, and Json scripting languages, for day to day automation operations.
• Design and architect self-healing, secured, highly available and fault tolerant infrastructure in AWS.
• Implemented maintenance and configuration of user account for Dev, QA and production servers and created roles for EC2, RDS, S3, Cloud Watch resources to communicate with each other using IAM.
• Experience in migrating and implementing of multiple applications from on premise to cloud using AWS services, SMS, DBMS, Cloud Formation, S3, Route 53, Glacier, EC2, RDS, SNS, Lambda, VPC, Cloud Trail, API gateway.
• Build and configure a virtual data center in the AWS Cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups (SG), Route Tables, Elastic Load Balancers ELB), Route 53.
• Build servers using AWS, importing volumes, launching EC2, RDS, creating SG, auto-scaling, ELBs in the defined VPC.
• Designed AWS Cloud Formation Templates to create multi region web applications and databases.
• Using CloudWatch, VPC Flow Logs to monitor and retain account activity related to actions across AWS infrastructure.
• Leverage AWS System Manager to automate communication between S3 and other AWS services.
• Solution VPCs for various environments including NAT Gateway, VPC Peering and Transit Gateways.
• Documented and assisted in data migration from Oracle RDS to Aurora PostgreSQL.
• Installed/configured PostgreSQL (9.5, 9.6. and recently worked with PostgreSQL VERSIONS 10).
• Tuned autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Managed and monitored these databases using PgAdmin, psql tools.
• Used Pg Hero for Performance TUNING mostly, SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY.
• Created roles, granting privileges, creating tables, use of indexes, and primary & foreign key constraints as required.
• Performed maintenance activities like vacuum, vacuum full, analyze; Checking the auto vacuum jobs, customized vacuum on certain tables and columns.
• Used Pg Bouncer for connection pooling, Pg Badger for generating statistic reports.
• Experienced in tuning PostgreSQL database settings & Troubleshooting performance issues, Managing Users and Tablespace on PostgreSQL Servers.
• Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recovery.
• Experienced in backups (pg basebackup, pg backrest, pg dump,) and restore, compressed (gzip) backups, database or schema refreshes.
• Configured and monitored replication types between Master and Slave Servers for Disaster Recovery.
• Upgrading database version using pg dump/pg restore and pg upgrade tools and updating the latest security patches to database, which are provided by PostgreSQL open source community.
• Operational DBA work includes Working on tickets, resolve backup failures, attend to incident/problem management calls, Team and new Project meetings.
• Capacity planning of databases for datacenter consolidation project
• Performance tuning, SQL Tuning and SQL Plan management.
• Provided instance and Server level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage using tools like AWR, ADDM, OEM, EXPLAIN PLAN, SQL TUNING ADVISORS, SQL TRACE & TKPROF
• RAC- administration/Troubleshooting of 2/3 Node Cluster on Oracle 10g/11gR2. Configuring Grid Infrastructure, SCAN Listeners on 11gR2. Migrate OCR files to ASM
• Perform Disaster Recovery and Role Transition drills for Production environments as per Audit and compliance.
• Performed full and incremental backup (cumulative and differential) using RMAN and implemented recovery strategies
• Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility
• Upgradation, Cloning and Patching 10g, 11g and 12c RAC and Standalone databases.
• Used TDE to secure Data at rest and Data Masking & Redaction for Data in motion
• Using TCP/IP Protocol configured SQL*Net files on server /client machines and resolved client connectivity issues

Confidential - HOUSTON, TX

Oracle Database Administrator

Responsibilities:

• Involved in 24x7 on-call support for databases
• Created Databases both manually and automatically using DBCA
• Created and managed users granting them necessary privileges, roles, profiles… etc
• Monitoring and administration of both primary and standby databases including production; performing daily database administration tasks.
• Monitoring and optimizing the performance of the database/application
• Troubleshooting of various database Performances Issues by proper analysis at all levels like SQL, PL/SQ database tables, indexes, Instance, memory, OS using AWR, ADDM, ASH, V$SESSION, Explain plan.
• Member of Team that configured MAA; Data Guard, Golden Gate and RAC (ASM)
• Perform DG- Disaster Recovery and Role Transition drills for Production environments as per Audit and compliance.
• Backup and Recovery using Hot, Cold and RMAN backups and UNIX scripts.
• Logical Backup (Data pump export/Import)
• RMAN Tablespace Point in time recovery and Instance recovery done on 11g
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Performed some PostgreSQL secondment tasks of monitoring .