SUMMARY

• 12+ years of experience as an Oracle Database Administrator / AWS Cloud Engineer in the Database Installation, Development and Production System Supporting leading global teams in a wide variety of cutting edge environments
• Expertise in performing logical backups using export and import Utilities, performing Physical (Online and Offline) database backups, Flashback Database, Flashback Query, Flashback Table, administration of Backup and Recovery (Logical and Physical), creating clone and standby databases and configuring / managing Data Guard in Oracle and AWS Environments
• Supported code/design analysis, strategy development and project planning in AWS
• Experience on a multi tenant environment and managed oracle databases in AWS
• Created and managed cloud compute, storage, and services in AWS
• Developed automation for provisioning, decommissioning services, and security patching in RDS
• Understanding and contribute solutions, along with identifying opportunities to reduce existing data center
• Estimate AWS costs and implement mechanisms for cost optimization
• Proactively stay current on new AWS offerings and services
• Understand and provide solutions with a hybrid IT approach
• Good experience in designing and developing AWSLambda functions, AWS Glue jobsscripts usingpythonandPySpark
• Maintain technical documentation for support and disaster recovery needs
• Experience in designingStep functionfor integrating multiple Lambda function in a step - by-step process
• Experience in working on file uploads to SFTP from S3 fromAWS Glueusing python, PySpark
• Strong Experience with AWS services such as EC2, ECS, ECR, or RDS Experience building and maintaining instances within AWS
• Created new databases Oracle/Aurora/Mongo/ in Aws Cloud (EC2 or RDS) and also migrated too using s3 Bucket and AWS Database Migration Service
• Working with thedevelopment and engineering teams to identify and implement the most optimal cloud-based solutions for the company
• Planning, designing and developing cloud-based applications including migration of on-premise applications to cloud platforms
• Managing private and public cloud data environments in accordance with company security guidelines
• Educating teams on the implementation of new cloud-based database initiatives, providing associated training as required
• Employing exceptional problem-solving skills, with the ability to see and solve issues before they snowball into problems
• Lead and develop best practices for larger SQL/Database teams
• Strong experience in Oracle Database Administration, Conversant with Database Creations, Backup & Recovery, Archival, Sizing Oracle Data Dictionary tunable parameters and Performance Tuning.
• Experience in configuring RMAN Backups
• OPatch Installation/Upgradation on recommendation by Oracle.
• Patch Upgradation from 9.2.0.7 to 9.2.0.8, 10.2.0.2 to 10.2.0.5, 11.2.0.2 to 11.2.0.3.
• Migration from 8.1.7.4 & 9.2.0.8 to 10.2.0.3 & 10gR2 to 11gR2.
• ClusterWare/ASM Upgrade from 11.2.0.1 to 11.2.0.2., 11.2.0.3.
• Experience in Oracle Database Administration, Oracle RAC (Real Application Cluster 10g, 11gR1 & 11gR2), Standby database - Oracle 11g Dataguard, Backup and recovery, SQL/PLSQL development, UNIX shell scripting, monitoring of database systems using command utilities as well as Oracle Enterprise Manager on different operating system environment like Windows 2000/NT/Advance Server, Linux and Sun Solaris.
• Experienced in Table space management and user management
• Experience in taking logical backups of data using oracle data pump utilities expdp and impdp, to move Oracle data from a database or schema to another
• Experience in using SQL TRACE, Explain Plan and TKPROF for SQL and database Tuning.
• Planned: logical and physical data modeling, normalization, replication, integrity, security, Capacity Planning: performance analysis of database servers and storages in standalone and clustered environment
• Experienced in undo tablespace management. Implemented multiplexing of control files & redo log files. Good understanding of all type of startup and shutdown process. Monitoring RAC database with SRVCTL
• Good knowledge of managing schema objects
• Experienced in monitoring the users sessions/locks/blocking sessions and taking appropriate steps to increase the performance.
• Good knowledge in developing python scripts and debugging of python code
• Experience in integration of python with AWS services, testing and validation
• Experience in working on Spring Tool Suite (STS) for core Java
• Having exposure in Apache Kafka using python
• Creating and managing the ASM database
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing & configuring Oracle clusterware& Database Software (Troubleshooting using cluvfy& handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Worked with customer for different RAC related issue: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on
• Troubleshoot performance issues for the RAC instances (GC events)
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Upgraded the databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c
• Add or Remove Node from RAC.
• Performed DB cloning using RMAN, Transportable table space with Data pump
• Knowledge of data warehouse on Oracle11g
• Experience in Oracle database 12c Administration and Worked with Oracle12c OEM
• Operating system: Aix/Solaris/HP-UX/LINUX
• Experienced in programming: shell script/sql/plsql/RMAN
• Backup/Recovery: Rman/User Managed Backup /Recovery
• High Availability: RAC/CRS/Grid Infrastructure/Data guard/Replication/ASM
• Tuned operating system/network/database parameters/SQL/plsql
• Worked with OEM / DB verify / Log miner / Tkproof / SQL*Loader / import /export/Data pump/AWR/ADDM
• Knowledge of oracle streams 11g(CDC change data capture), Golden gate data replication, RAC setup and experience in RAC environment & RAC like configuring SAN & NAS servers
• Knowledge on RMAN Utility and Log Miner, Tivoli
• Worked with various O/S like Linux, Solaris, & AIX
• Experienced Database and Data Warehouse
• Skills of Oracle Database, SQL, PL/SQL, SQL Tuning, Replication, ETL, Database Design, Data Modeling, Data Warehousing
• Designed and implemented analytical Data Warehouse. It was complete end-to-end implementation including ETL processes, logical and physical database design.
• Working Experience of Amazon Web Services Rds Oracle Dba
• Experience in Erwin Data Modeling and reverse engineering
• Hands-on experience in Data Profiling, PL/SQL, stored procedures and triggers & functions
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005,Windows NT,XP,V

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g/11g (RAC, Data Guard and Golden Gate) Aws Rds, Aurora, Mongo, Postgres

Languages: SQL, PL/SQL, C, C++, Perl, Korn,python,UNIX Shell Scripting, VB, Advanced VB

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools: AWR, ADDM, ASH

Database Modeling: Erwin 4.0, Rational rose, UML 2.0

Other: EMC, NetApp, Veritas NetBackup

PROFESSIONAL EXPERIENCE

Confidential

Aws Cloud Engineer / Database Adminstrator

Responsibilities:

• Created new databases Oracle/Postgres/Aurora/Mongo databases in AWS Cloud (EC2 or RDS) and also Migrated development/production databases to AWS RDS using S3 bucket and AWS Migration services
• Involved in installation/configuration of Oracle in Aws Ec2-Console
• Setup/Managing Linux servers on Amazon (EC2, Security Groups, RDS and IAM)
• Setup/ Managing databases on Aws Rds and monitoring servers through Amazon Cloud Watch, SNS
• Troubleshoot performance related issues in AWS Oracle data warehouse environment
• Created/Managed AMI/Snapshots /Volumes and Upgrade/downgrade AWS resources (CPU, Memory, EBS)
• Developed python scripts based on the requirement and embedded the code into AWS
• Created AWS Instances for Oracle Databases
• Reviewed cloud resources and cost drivers, compute, storage, network, managed services, database and service licenses, marketplace, and accounts in AWS
• Maintains smooth operations of multi-user computer systems - Monitors and manages system resources, including CPU usage, disk usage, and response times to maintain operating efficiency
• Setting up administrator and user accounts including user names and passwords
• Maintains system and software documentation
• Tuning system performance
• Work with team members to come up with solutions in line with group's standards
• Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installs
• Collaborate with Operations Database group, Systems Administrators and Capacity Planning groups as and when situation demands
• Perform applications database administration( Oracle) functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support
• Actively monitor databases servers and respond to any alerts
• Coordinates installation of hardware/software, and responsible for backups and recovery
• Maintain cloud-based servers patching vulnerabilities, backup/restore operations, provision new servers, configure firewalls, configure monitoring systems.
• Monitor cost allocations, security compliance, budgets and set alerts across accounts, workloads, and users
• Use AWS Config to monitor and track resource configuration
• Set standards for resource configurations, evaluate configuration compliance, and risk, and remediate configuration drift
• Use AWS CloudTrail for compliance audits by recording and storing event logs for actions made within AWS accounts
• Set controls to monitor to assure compliance
• As per the production team request performs the databases refresh (Db refresh) and CPU resize
• Proficient in using Cell CLI/DCLI commands to administer/monitor AWS storage cells
• Installed and configured OEM 12C Grid control and deploy agents to monitor Production, development instances.
• Assisted in performance tuning production pre/post go-live on both database/applications level
• Design on How/When to run different concurrent requests and scheduled jobs accordingly to reduce load on the system and provide better performance
• Alert management, Created and setup alerts to send notification to Users from application wherever necessary.Updated earlier releases of PostgreSQL to version 8.2.5 on 6 servers running Fedora Core 7.
• Insure night cron jobs for backups, reindexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres/Oracle production and development databases.
• Bash shell scripts for scheduled maintenance.
• Review all PostgreSQL logs for problems.
• Create, Backup, Restore & Drop databases per developer’s requirements.
• Respond to database outages caused by equipment failure and coordinate with Network Admin to perform database fail over to standby servers.
• Optimize postgresql.conf for performance improvement.
• Coding of Pl/PgSQL Stored Procedures, Data Types, Triggers, and Constraints.
• Review database schema & structure for design improvements and data normalization.
• Coordinate with Java developers for changes to schema & table structures.
• Install & configure development PostgreSQL 8.1.1 databases on Redhat Linux servers.
• Coding of new tables, views and modifications as well as Pl/PgSQL Stored Procedures, Data Types, Triggers, Constraints and Constraints.
• Perform day to day activities like Snapshot, backup-restore, space management, monitoring database alerts, performance tuning.
• Responsible for regular maintenance work like upgrades and patches
• Responsible for any production issue which might impact application performance
• Working as a production DBA databases for various team
• Have a good experience in administering Oracle Aws RDS components
• Working on tuning, building and administering Amazon Web Services Databases
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace
• Monitored database Performance using AWR, ASH, OEM and tuning parameters for optimization of system performance
• Managed datasets usingPandadata frames and Oracle sql, queried Sql database queries from python.
• Designed and developed components using Python withDjangoframework. Implemented code in python to retrieve and manipulate data.
• Responsible for all regular AWS Database administrative activities
• Going through the day-to-day user requests and troubleshooting the database related problems
• Building test strategies, backup & recovery models for Oracle. Refreshing test databases
• Responsible for Online/Offline database backups and managing Database recovery with Snapshots.
• Worked withAWSSupport during ORA-03135 and ORA-1652 issues in Production database
• Control user access and monitor space consumption
• Worked on database refresh using AWS snapshot process or Exp/Imp Process.
• Providing direct Client Production support in 24x7 environments
• Created the Private, Public and Global database link in all environments.
• To the companies requirement, modifying the AWS database structure, as necessary
• Regular monitored Alert log Files on Day to Day Basis
• Performed Weekly stats gathering activities
• Increased/decreased instance CPU Resize according to business Application requirements.

Environment: Linux x86-64, OS version 5, ERP 12.1.3, TOAD, Data Loader,OEM12C,Discoverer 11g, Oracle WebLogic server 11g, Aws Rds, Korn Shell Scripting, SQL Server.

Confidential

Aws Cloud DBA

Responsibilities:

• Created users, roles, profiles & audited users according to the application requirement.
• Expertise in handling Very Large Database (VLDB) and OLTP environment.
• Implementation of database deployment in production, test and development databases.
• Migrating database from 8.x, 9.x, 10g to 11G.
• Setting up new instances and configuring with RMAN Catalog for RMAN Backup and recoveries.
• Develop the code in python based on the requirement and embed the code into AWS cloud
• Monitor Oracle Database performance and perform Tuning activities accordingly.
• Installing Oracle Server & Clients on Win NT, & Linux.
• Flashback Database, Flashback Query, Flashback Table
• From information given by the application developers
• Created Nonstandard Block Size Table space
• Monitored Table spaces/Tables/Indexes
• Enrolled users and maintained system security.
• Data transfer using export/import
• Creating Shell scripts for automation and scheduling it in crontab.
• Developed and designed an API (RESTfulWeb Service). Used the Python language to develop web-based data retrieval systems.
• Creating and setting up Physical Standby Database
• Creating Partition for large tables and scatters them in different table spaces.
• Clone or Duplicate the databases using RMAN Backup
• Configuring and administering multiple databases under Oracle Grid Control.
• Implemented ARCHIVELOG process to produce local and remote Archive log files with Multiple-Archive log Destinations for high-availability of the Database.
• Performed weekly rebuild partition index
• Managed threads for CDR(core database repositories) database
• Tuned the DOP value according to instance work load
• Managed data flow for the database users
• Created views as per the users requirement
• Monitored CDC with oracle streams
• Managed primary database with standby database during DR exercise
• Refreshed database and data load
• Managed Temp table space/undo table space for various database
• Migrated databases from data center to AWS RDS
• Setup/configure EC2 Instance in AWS and setup RDS database in Aws.
• Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Table spaces and Temp TS
• Managing databases running in production, development and test environment on Linux/Unix.
• Maintaining and moving data across the environment on request thru Export, Import utilities.
• Installing Oracle Server & Clients on Win NT, & Linux.
• Creating Partition for large tables and scatters them in different table spaces.
• Created primary database storage structures (Table spaces) as required, modifying the database structure, as necessary, from information given by the application developers
• Created and maintained database links for data transfer

Environment: Sun Sparc 5.9, IBM - AIX, Linux, RMAN, Shareplex, Toad, Expdp/Impdp, Oracle 10.2.04, 11gR2, Aws Rds Oracle, Korn Shell Scripting, SQL Server.

Confidential

Oracle DBA

Responsibilities:

• Installed 12c cloud and migrated all the databases from 11g to 12c RAC (4 node) using oracle Cluster ware and ASM.
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 12c, 11g, 10g) for the purpose of monitoring multiple databases and application servers.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Manage RAC environment for Day to Day Database administrator, Performance Tuning.
• Creating and managing the ASM database
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Worked with customer for different RAC related issue: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on
• Troubleshoot performance issues for the RAC instances (GC events)
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Add or Remove Node from RAC.
• Fine tuning users and developers SQL queries for better performance.
• Installing patches on recommendation by Oracle.
• Detection and analysis of failures and solving database issues.
• Writing Script using Oracle SQL and PL/SQL on 8i, 9i,10g and 11g.
• Supporting Development team to resolve DB issues.
• Setting up new Database instances for testing purpose.
• Implemented nightly backup routines, which includes Oracle Managed Backups complete and incremental methods to optimize the time-window for backups.
• Worked with three main repositories OMDB(One Merck Database) / CDR(Core Database Repositories / AERECON)
• Managed 25 databases, partition/sub partition/exchange & partition for data warehouse
• Managed RAC instances and data guard standby server
• Reported to business during database audit logs.
• Coordinated with onsite and offshore team members
• Understood the users requirement by meeting schedule
• Managed the many application issue and ora error with users.
• Estimated table space size
• Tuned the pl/sql procedure with developers by doing analysis for execution plan
• Created many shell scripts for database monitoring
• Checked invalid objects for databases and making it valid with scripts
• Monitored chained rows and migrated rows
• Monitored unusable indexes for IT/DEV/PRODUCTION database
• Provided security with creating users and password profile according to policy26
• Monitored and deployed the TNS and LISTENERS For RAC database
• Monitored RMAN
• Transported the Table space from production database and plugged-in it in development database for the usage of developers
• Extensively used Export /Import utilities for selective Backup and defragmentation
• Monitored the Database growth and increase the table space size in production database
• Installed Oracle 11g on Linux
• Created the Private, Public and Global database link
• Flashback Database, Flashback Query, Flashback Table
• Enrolled users and maintaining system security. Controlling and monitoring user
• Involved in data transfer using export/import
• Kept the system highly available i.e. 24hours*7days of a week.
• Created and maintained database links for data transfer
• Export/Import, Standby physical database Data loading using sql loader
• Recovery of database in various cases of media failure.
• Involved in managing and maintenance of space allowed.
• Excellent in analytical, interpersonal and communication skills.
• Enthusiasm in learning new technologies.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, PL/SQL, Data Pump, OEM, RMAN, SQL*Loader, NETBACKUP, VMwareESXi 5.5 Server, Korn Shell Scripting, SQL Server, OLTP, Datacenter, SAN and NAS Migrations.

Confidential

Oracle DBA

Responsibilities:

• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installing 9i, 10g and 11g databases on Solaris and Linux.
• Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Tables paces and Temporary TS etc.
• Implemented nightly backup routines, which includes Oracle Managed Backups complete and incremental methods to optimize the time-window for backups.
• Created users, roles, profiles and Auditing of Users according to the application requirement.
• Implemented ARCHIVELOG process to produce local and remote Archive log files with Multiple-Archive log Destinations for high-availability of the Database.
• Transported the Table space from production database and plugged-in it in development database for the usage of developers
• Extensively used Export /Import utilities for selective Backup and defragmentation
• Monitored the Database growth and increase the table space size in production database
• Migrated Non ASM databases to ASM.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Manage RAC environment for Day to Day Database administrator, Performance Tuning.
• Installed Oracle 10.2.0 on Linux
• Creating and managing the ASM database
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing & configuring Oracle cluster ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of cluster ware)
• Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• Worked with customer for different RAC related issue: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on
• Troubleshoot performance issues for the RAC instances (GC events)
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Add or Remove Node from RAC.
• Created the Private, Public and Global database link
• Flashback Database, Flashback Query, Flashback Table
• Created primary database storage structures (Table spaces)
• To the companies requirement, modifying the database structure, as necessary,
• From information given by the application developers
• Created Nonstandard Block Size Table space
• Regular monitored Alert log Files on Day to Day Basis
• Monitored Table spaces/Tables/Indexes
• Enrolled users and maintained system security.
• Controlled and monitored user
• Accessed the database
• Data transfer using export/import
• Kept the system highly available i.e. 24hours*7days of a week.
• Created and maintained database links for data transfer
• Export/Import, Standby physical database Data loading using sql loader
• Involved in recovery of database in various cases of media failure.
• Involved in managing and maintenance of space allowed.
• Mapping of old data fields to new model data fields for data migration.
• Worked very closely with development team.

Environment: Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, HP UX, Korn Shell Scripting, SQL Server.

Confidential

Oracle DBA

Responsibilities:

• 24x7 Oracle Database Administration of Production, Development, Testing databases.
• Setup and configured Standby Databases for disaster recovery and reports generation in maximum performance mode using Data guard.
• Setup and Configured Physical Standby and Logical Standby Databases for various production systems.
• Involved in Data Modeling, Design, Implementation and Creation of Databases.
• Worked closely with System Administrators, Network Administrators to build the RAC environment.
• Involved in setting up of ORACLE 10g RAC Databases for test prototype environment with three nodes-clusters on Red hat Enterprise Linux 4.
• Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
• Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
• Documented the procedures for adding a node for current DATAGUARD environment.
• Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries etc.
• Installed and configured software/databases as of Oracle’s Optimal Flexible Architecture (OFA).
• Designed various Backups/Recovery strategies for Oracle databases as per SLA requirements.
• Configured users into consumer groups and set the resource utilization based upon business activity using RESOURCE MANAGER.
• Configured and performed automated and various levels of backups using RMAN.
• Very good experience with Oracle Application Server & WEBLOGIC server’s middle tier.
• Installed ORACLE Enterprise Manager GRID CONTROL and configured it server targets for a centralized monitoring system.

Environment: Oracle 8i/9i/10g, Oracle 10g/9iOAS, Solaris 9, Red Hat Enterprise Linux 4, HP-UX 11.2, Grid Control 2, TOAD, and SQL developer.