ANUSHA BANDE

• Oracle Database Administrator • 425-***-**** • adbsp6@r.postjobfree.com

PROFESSIONAL CERTIFICATIONS

• Oracle Certified Associate

• AWS Certified Solutions Architect – Associate

SKILLS

Databases: ORACLE 9i/10g/11g & 12c and AWS RDS

Operating Systems: AIX, Solaris, Linux/Unix, Microsoft Windows Programming Languages: Python, SQL and Shell scripting

• Oracle Database Architecture and the Internals

• Installation, Upgradation(Manual&DBUA), Patching(Oracle Home/Grid Home)

• Backup and Recovery (RMAN and Traditional Export/Import & Data pump)

• Troubleshooting and Resolution of database issues

• Performance Tuning

• High Availability solutions (Dataguard, ASM and RAC)

• AWS Cloud Technologies - EC2, VPC, S3, IAM, Security Groups, NACL etc.

• Unix/Linux Administration

• Networking - OSI Model, TCP/IP protocol suite (IP, ARP, ICMP, TCP, UDP, SMTP, FTP etc.), IP addressing, subnetting and routing

KEY RESPONSIBILITIES

• Proficient in all DBA responsibilities such as backup and recovery, cloning, memory tuning, DR testing, user management (privileges, roles, quotas, table partitioning, index, sequence), space management (tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity)

• Database monitoring that includes handling key alerts round-the-clock and perform health checks and validations post the changes from application/database end

• Customer engagement as a LEAD/SPOC for projects of multiple enterprise clients

• Support developers in database-related activities

• Perform database migrations and upgrades

• Implementation of database backup/recovery

• Database performance tuning

• Root cause analysis and resolution of production-related database issues

• Deployment of Oracle 11gR2/12cR2 Grid Infrastructure, RDBMS, Client & Gateway software

• Maintain databases on cloud infrastructure

• Perform administrative functions on Linux/Unix operating system

• Database security and privilege management

• Database and Grid infrastructure PSU quarterly security patching during the maintenance period

• Database failover between different networks

• Provide 24x7 on-call database support

PROFESSIONAL EXPERIENCE

DXC Technology, Seattle WA Mar 2019 to Till Date

• Involved in migration of on-premise Oracle databases to AWS RDS

• Build servers in AWS - launching EC2 instances, RDS, creating security groups, auto-scaling groups, load balancers (ELBs) in the defined VPCs

• Provide operational support to maintain databases on cloud infrastructure

• Configuring the Data guard with FSFO

• Migrating databases from Non ASM file systems to ASM and Non-ASM Single Instance to ASM RAC Instance

• Monitor and tune database performance using Explain Plan, AWR, ADDM, TKPROF

• Monitor and resolve daily alerts that include filesystem and RMAN backup job failures etc.

• Database refreshes using expdp, impdp, RMAN Duplicate and cloning

• Application of PSU, maintenance and interim (opatch) patches on all the databases Computer Sciences Corporation (CSC), India Aug 2015 to Sep 2018

• Administration of 500+ Oracle databases (RAC/Standalone) across 11g and 12c

• SQL queries tuning by applying Hints, Baseline, SQL profile

• Performance tuning the databases on regular basis

• Performed DR Testing in all databases annually

• Monitored database using Oracle 11g Grid Control

• Supported critical projects as a SPOC in production environments

• Assisted developers on database-related queries and operations

• Design and implement backup and recovery procedure for new databases

• Implemented shell scripts for regular database monitoring and reporting jobs

• Performed Data guard (Physical standby) configuration and management

• Worked on Switch over the primary database to physical standby database

• Monitored database growth and space administration

• Performed RMAN backup and recovery on various scenarios (RMAN Duplicate using tape backups/filesystem backups/Cold/Hot Backups, RMAN Active Clone)

• Performed 11gR2/10R2 OCR/Voting Disk replacement for Storage migration

• Defragmentation of tables and indexes for improved performance and effective space management.

• Maintained database security by auditing

• Enabled Transparent Data Encryption (TDE) to encrypt sensitive PII data at rest Tata Consultancy Services, India June 2014 to Aug 2015

• Provided Tier2 & Tier3 support to critical prod/non-prod environment with various phases such as a new server build, installation, upgrades, patching, migration, recoveries etc.

• Worked with several team members such as application, platform, middleware team to sort out the critical issues

• Experience in installation, configuration of 12c/11gR2/10gR2 RAC, ASM, RMAN and handling multi- terabyte databases on PROD, QA, DEV environments

• Implemented Oracle Enterprise Manager (OEM) and configured all the databases to it

• Managed a project to address the challenges faced by developers in database access

• Monitored performance using AWR reports and ADDM reports

• Performed Character set conversion

• Executed domain change on RAC/Dataguard/Standalone systems

• Configured and monitored database backup (Cold, Hot and RMAN - Using 3rd party backup tools) and performed backup validations

• Installation and configuration of Grid Control – EM12c and 11g agents

• Handled database upgrades from 11.2.0.1/11.2.0.2 to 11.2.0.3,11.2.0.4 or 12.1.0.X Genpact, India July 2011 to June 2014

• Administration of Oracle databases 24x7 across 9i,10g and 11g

• Regularly monitor the database performance using AWR, ADDM, adding/modifying indexes etc.

• Worked with Oracle Support to resolve critical issues

• Recovery of database - Recover from Media Failure, Recover tables dropped accidentally, Recover data files, Recover from Block Corruption

• Performed Reorg of tables/rebuild of indexes using brtools

• Handled datafile adding and resizing operations using brtools

• Executed database restore and recovery using cold backup of physical files, RMAN duplicate and RMAN active clone

• Performed Database refreshes using Exp/Imp and data pump utilities

• Gained experience in SAP databases oracle 11g installation, upgradation and SBP patching

• Gained troubleshooting experience in Perl Job failures

• Developed an automation script to monitor the status of database objects EDUCATION

Bachelor of Engineering (B.E) in Information Technology, 2011 Jawaharlal Nehru Technological University, Andhra Pradesh, India

Contact this candidate