SUMMARY:

• Working as Certified Database Administrator, AWS solution architect and Cloud Foundry Developer with 9 years of experience in diversified and very large production and non - production environments in various domains with database implementations in various UNIX, Windows Cloud platforms.
• Worked extensively in setting up database and application infrastructure environments in Private, public and Hybrid clouds
• Highly motivated and committed AWS solution architect, sysops administrator, Cloud foundry Developer experienced in Automating,
• Configuring and deploying instances on AWS, Azure, PCF, cloud environments and Data centers.
• Managing users and groups using the amazon identity and access management (IAM) in AWS using CLI and Console
• Worked on Infrastructure Development and Operations involving AWS Cloud platforms, EC2, EBS, S3, VPC, RDS, ELB, Auto scaling, Cloud Front, Cloud Formation, Elastic Cache, Cloud Watch, SNS, SES, SQS, SWF, Lambda functions, Athena, Data pipeline, Route 53 and other and other services in the AWS cloud infrastructure such as IAAS, PAAS and SAAS.
• Designed Cloud Security framework by creating complex IAM polices, implementing federated access to cloud and designed application architecture to mitigate DDOS attacks.
• Ensure data integrity and data security on AWS technology by implementing AWS best practices.
• Experienced in cloud automation using AWS Cloud Formation Templates.
• Application Deployment on PCF using Build pack and Docker.
• Experience in using PCF Ops Manager/BOSH to deploy and manage cloud foundry .
• Extensively worked on Jenkins for continuous integration and Concourse for continuous Deployment for End-to-End automation for all build and deployments.
• Worked on administering Oracle, MySQL, Postgress SQL Prod, Non-Prod, test, development environments on AWS EC2 instances and RDS instances.
• Worked on managing database security groups on AWS.
• Good knowledge on Pivotal Cloud Foundry (PCF), Google products and Docker container services.
• Extensively worked on migrating Oracle on premise databases to Oracle 12C RDS instances.
• Experienced in Branching, Merging, Tagging and maintaining the version across the environments using SCM tools like GIT on Linux platforms.
• Good experience on DevOps tools such as Chef, Ansible, Puppet, Jenkins, GIT, and Docker.
• Worked on installing, configuring, administering and managing oracle databases & implementing solutions like High availability (HA), Disaster & Recovery, Cloning, and Database security.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Upgraded the Databases from Oracle 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.
• Implemented Heterogeneous replication and Bi-Directional Replication using Golden Gate (Oracle to oracle, db2, SQL Server) and troubleshoot issues using Log miner.
• Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard).
• Proficient in implementing/configuring and using OEM 11g, 12c and13c cloud control.
• Worked on Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Worked on DATAPUMP, AWR, ASM, ADDM, Grid Monitoring & Oracle Enterprise Manager (OEM).
• Expertise in PL/SQL, SQL and UNIX Shell Scripting, Pearl scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities)
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS:

Technologies: Oracle, MySQL, Maria, SQL - Server, AWS, Azure, PCF, Informatica, Datastage

Tools: OEM, RMAN, Data pump, GIT, Splunk, Nagios, Dynatrace, Jenkins, Chef, Puppet, Ansible

Operating Systems: Linux, IBM-AIX, HP-UX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr.Oracle DBA/AWS Solution architect/PCF Cloud Foundry Developer

Responsibilities:

• Worked extensively in setting up database and application infrastructure environments in Private, public and Hybrid clouds
• Highly motivated and committed AWS solution architect, sysops administrator, Cloud foundry Developer experienced in
• Automating, Configuring and deploying instances on AWS, Azure, PCF, cloud environments and Data centers.
• Managing users and groups using the amazon identity and access management (IAM) in AWS using CLI and Console
• Worked on Infrastructure Development and Operations involving AWS Cloud platforms, EC2, EBS, S3, VPC, RDS, ELB, Auto scaling, Cloud Front, Cloud Formation, Elastic Cache, Cloud Watch, SNS, SES, SQS, SWF, Lambda functions, Athena, Data pipeline and other and other services in the AWS cloud infrastructure such as IAAS, PAAS and SAAS.
• Designed Cloud Security framework by creating complex IAM polices, implementing federated access to cloud and designed application architecture to mitigate DDOS attacks.
• Ensure data integrity and data security on AWS technology by implementing AWS best practices.
• Experienced in cloud automation using AWS Cloud Formation Templates.
• Experience in using PCF Ops Manager/BOSH to deploy and manage cloud foundry .
• Integrated Active Directory Federation service (ADFS) with PCF for SSO.
• Extensively worked on Jenkins for continuous integration and Concourse for continuous Deployment for End-to-End automation for all build and deployments.
• Experience in administering Oracle, MySQL, PostgreSQL Prod, Non-Prod, test, development environments on AWS EC2 instances and RDS instances.
• Worked on Pivotal Cloud Foundry (PCF), Google products and Docker container services.
• Extensively worked on migrating Oracle on premise databases to Oracle 12C RDS instances and to EC2 instances.
• Experienced in Branching, Merging, Tagging and maintaining the version across the environments using SCM tools like GIT on Linux platforms.
• Worked on DevOps tools such as Chef, Ansible, Puppet, Jenkins, GIT, and Docker.
• Worked on all database activities such as User management, space management, and database security management on 11g and 12c databases on LINUX servers.
• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Worked extensively with stored procedures, triggers, functions, packages, UNIX Shell scripting, Partitioning, and Indexes and excellent experience in installations, configurations, administration, and tuning of Oracle 10g, 11g, 12c and ASM for high available databases.
• Installed and configured and maintained Maria 10.2.8 version on non-prod and production environments.
• Installed 2 node 12.1.0.2 RAC databases on NFS file systems and Worked on Multiple RAC clustered environments ranging from 2 nodes per cluster.
• Developed and maintained data models using tools such as CA ERwin Data Modeler and TOAD Data Modeler.
• Worked on 11g Grid control and 12C/13C Cloud control and intensively used for Diagnostic & tuning activities.
• Migrated 2 TB 2 node RAC database and physical standby databases from 11.2.0.4 to 12.1.0.2 on NFS storage.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Upgraded databases from 11.2.0.4 to 12.1.0.2 on LINUX environments.
• Installed, configured and tested oracle advance security options and oracle Data vault, Data masking .
• Familiar with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, Export/Import, Data Pump, TTS, and Hot and Cold back-ups and experience with other oracle features like Flash-Back Recovery, ASM, ASH, AWR, ADDM, ASSM, AMM, ASMM, Automatic Undo management .
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches like PSU and CPU on RAC/Non RAC after testing on DEV, QA and UAT.
• Involved in 24x7 production database maintenance and on-call support.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Managing users and groups using the amazon identity and access management (IAM) in AWS using CLI and Console
• Very Good knowledge on EC2, S3, EBS, ELB, Elastic IP, RDS, SNS, SQS, Glacier, IAM, VPC, Cloud Formation, Route53, Cloud Watch and other and other services in the AWS cloud infrastructure such as IAAS, PAAS and SAAS.
• Worked on all database activities such as User management, space management, and database security management on 10g, 11g databases on LINUX and WINDOWS servers.
• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Installed, Configured Oracle 11g RAC Cluster for a 3 node multi instances hybrid cluster.
• Performed Oracle RAC Cluster ware Installation of 12C (12.1.0.2)/ 11g (11.2.0.4) Cluster Ready Services on 3 nodes Configuration, RAC Database Creation, and Node Administration.
• Installed and Configured Golden Gate for replication of production databases to Reporting Databases and troubleshooted Golden Gate issues.
• Installed, configured and supported uni-directional and bi-directional replicated environments utilizing Golden Gate 11.x software and created manager, extract, replicate trail files. Tested data is flowing from heterogeneous source systems to oracle database.
• Develop custom utilities to automate manually intensive tasks including mass schema changes, recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Implemented ETL process, MV Replication, Database Security using security compliance auditing, and bulk loading of data from flat files using SQL loader.
• Created Materialized views on big tables and enabled the AUDITING on few tables in production.
• Worked on implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also using RMAN.
• Developing, testing & implementing strong backup and recovery strategy. Also responsible for monitoring backups.
• Extensively worked in various areas of Dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Worked Extensively on DR (Disaster Recovery) process by testing failover and failback of production resources from Primary to standby and vice versa.
• Involved in checking and writing scripts for managing table space growth, monitoring the data file growth and extents too and Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Experienced in BCP (Business continuity process), in identifying Issues and finding out root cause/Analysis/Fix and documenting the procedures for the business units.
• Worked with Data Warehouse team on problem resolution and implemented change requests. - Performance tuning on DataWarehouse such as Data extraction from production to Data warehouse. Worked with Developers for High frequency data transfer.
• Managed and Administrated the SQL Server 2008 production and Non-production servers.
• Worked on Business Objects, INFORMATICA for Creating and managing Users, Universes, Reports, and Dashboards.
• Provided 24*7 supports with an on call pager.

Confidential, Austin, TX

Sr. Oracle DBA

Responsibilities:

• Worked on all database activities such as space management, User management, database security management, rollback segments & creation of DB links.
• Installed 10g (10.2.0.1) cluster ready services and 10.2.0.1 database in OCFS and ASM file systems.
• Responsible for Upgrading the Database from 10.2.0.1 to 10.2.0.4 and Upgrading) CRS from 10.2.01 to 10.2.0.4.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Involved in administering and maintaining Oracle Application Server 10gR2 (10.1.2).
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN and Data Guard.
• Tested many backup and crash recovery scenarios on test environment, using RMAN tool.
• Responsible for automation of startup and shutdown on all production and development databases.
• Increased availability of non production instances by reducing cloning time by implementing clone automation using Grid.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Wrote scripts (Linux Shell) for database maintenance activities such as monitoring the growth rate of tablespaces and extents. Also wrote UNIX scripts to process batch jobs.
• Install Oracle administrative tools like OS Watcher and CHM to assist in administration of the Oracle database and its environment.

Confidential , Houston, TX

Jr .Oracle DBA

Responsibilities:

• Responsible for Installation, administration and upgrade of Oracle RAC 10g production and development databases.
• Performed cloning using RMAN to set up development and test databases from Production database.
• Upgraded the single instance database from 9.2.0.8 to 10.2.0.2.
• Responsible for installation and configuration of Oracle 10g Grid Control and agents and Managed databases using Oracle 10g Grid Control.
• Responsible for installing, configuring and maintaining the Physical standby database.
• Worked on implementing Data Guard and Stand-by databases for fail-over and recovery.
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those.
• Performed daily health check of the databases by implementing above backup and recovery procedures. Also implemented logical, cold and hot backups.
• Worked extensively in Performance Tuning Confidential various levels including instance tuning, Query tuning, Database performance tuning by using tools like

Confidential

Database Developer/DBA

Responsibilities:

• Performing database design, analysis and development of the system.
• Developing PL/SQL Packages to monitor revenue earnings and expenses and to maintain the general ledger of the organization.
• Developing stored procedures and functions using PL/SQL for complex updates and audit trails.
• Testing PL/SQL procedures against the test cases. Involved in creating use cases and test cases
• Implement Hot, Cold and Logical backup plans. Designed backup and recovery procedures for OLTP system