Oracle Database Production Support

Vathsala BalaseeniAyyalu

Email : ********@*****.***

Mobile: 313-***-****

SUMMARY:

Database Infrastructure management professional with history of achieving cost savings and enhancing system functionality. Track record of tackling and solving tough business and technical problems. Strong leader with demonstrated ability to work effectively with individuals at all levels and in all functional areas. Experience in managing full project lifestyle from requirements gathering to final implementation and 24x7x365 production support management. Strong experience in the IT industry, working in multinational, local, state and Federal government organizations and multi-vendor, hybrid environments. Experience in design, installation, upgrade, administration and support of Oracle, SQL Server and Postgres with real world demonstrable skills in Oracle Database Administration, Real Application Cluster, Performance Tuning, Disaster Recovery, High Availability, Data Warehousing, and AWS Administration.

Areas of Expertise:

Databases

Oracle 19c/11g/10g/9i/8x/7x, MS SQL-Server, MS-Access, PostgreSQL, MongoDB

Cloud

AWS, Azure

Operating Systems

Sun Solaris 10.x/9/8/7, IBM-AIX, HP Unix, SuSE Linux, RHEL and Windows 2000 /2003 /2005/2012

Tools

OEM, DATAGUARD, RMAN, ASM, RAT, Exp/Imp, DATAPUMP, SQL-Loader, STATSPACK, TKPROF, AWR, ADDM, SQL Tuning Adviser, SQL Access Adviser, SQL-Developer, Svrmgrl, SSIS, SSRS, SSMS, Putty, Toad, SQL-Developer, PgAdmin, DBeaver, Hummingbird, Tivoli, Commvault, Avamar, Qlik, TALEND, BMC REMEDY, Jira, ServiceNow

Specialties

DB Hosting Solutions, Performance Tuning, DB Server Consolidation, DB High Availability, Capacity Management, DB Backup & Recovery, IT Operations Management, Troubleshooting & Problem Solving, Develop and implement Database Security & Controls, DR solutions Design, Testing & Implementation. AWS Administration, Super Cluster T5-8, Exadata, ASM, Oracle DBA Production Support, Oracle DATAGUARD, Shell Scripting, Data Encryption, Oracle Audit and TDE, Oracle Weblogic, SQL, PL/SQL, OEM Grid Control, EXADATA, SAN, NFS, Oracle License Management.

EDUCATION/CERTIFICATIONS

Bachelor of Science in Mathematics, Madurai Kamaraj University, 11/1990

Post Graduate Diploma in Computer Application, Bharath Computer Centre 06/1992

Bachelor of Education in English and Mathematics, Madurai Kamaraj University 04/1993

Oracle Database 9i Administrator Certified Associate (OCA-DBA 9i)

Oracle Database 9i Administrator Certified Professional (OCP-DBA 9i)

Oracle Database 10g Administrator Certified Professional (OCP-DBA 10g)

Microsoft certified Azure Database Administrator Associate

Professional Synopsis:

Leading multiple key database infrastructure projects, including Resilient Infrastructure DB Build and Global Capacity Management for Oracle DB solutions.

Providing enterprise database engineering solutions for applications hosted in Enterprise Datacentre and distributed locations globally.

Worked with team of 10-12 Senior Oracle Infrastructure DBAs and coordinated with 20-25 mid-level DBAs in global support Center in India.

Strong experience on AWS, Postgres Aurora RDS database administration.

Comprehensive experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, migrations, patch apply, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, Oracle service request support, Unix shell scripting and documentation.

MS SQL Server Database Installation, Administration, upgrade, tuning, backup, maintenance, and performance tuning.

Expertise in Oracle products licensing. Provided techniques to reduce the licensing cost without compromising database scalability and performance. Managed Oracle product licenses. Involved in auditing of Oracle products with Oracle’s License Management Services (LMS).

Strong experience of the Oracle 19C, 12c, 11g, 10g, OEM, ASM, and Grid Control

Hands on experience on Backup and Recovery using RMAN, DATAPUMP, Disaster Recovery.

Planned and implemented DR & high availability solutions using Oracle 19C/12c/11g/10g Data Guard, Configured, and maintained Standby Database in OLTP environment to automatically synchronize with production database.

Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.

Experienced managing multiple Production and Development Oracle Applications environments of different releases.

Experienced Linux and Windows patch apply and database patches with opatch utility.

Strong experience on OMS, OEM 13c/12c (Oracle Enterprise Manager), TOAD.

Participated in Disaster Recovery Drills, documented database, and application validation steps.

Performed all daily Maintenance tasks, interacting with Oracle Customer service as and when required.

Database start-up and shutdown, alter database parameters, tablespace management, space monitoring and analyses, alter and move data files, table reorganization, index rebuild, export and import, manage database statistics, manage flashback databases.

Very strong experience on Real Application Testing (RAT)

Mongo DB Database Administration

Good understanding of ITIL framework mainly Change, Problem, Release, Incident, Security Management.

Received best performer awards for my prompt response and the way I handled various responsibilities.

Certifications:-

Oracle Database 9i Administrator Certified Associate (OCA-DBA 9i)

Oracle Database 9i Administrator Certified Professional (OCP-DBA 9i)

Oracle Database 10g Administrator Certified Professional (OCP-DBA 10g)

AWS Certified Solutions Architect – Associate

Microsoft Certified : Azure Database Administrator Associate

WORK EXPERIENCE

==

Company

Department of Transportation (DOT), Washington DC, USA

Duration

Dec 2022- Till Date

Role

Senior Database Administrator

Environment

RHEL 7/8, Windows 2012 / 2016 / 2019

Tools/Utilities/

RDBMS

Oracle 19c, MS-SQL Server, PostgreSQL Aurora RDS, DBeaver, RAC, DATAPUMP, TOAD, SQL-Developer, Avamar Backup Tool, Putty, VPN, MS-Outlook, MS-Word, MS-Excel, MS-Power Point, WINSCP, Microsoft Teams, ASM, DATAGUARD, Oracle Enterprise Manager Grid Control 13c/12c, RMAN, DATAGUARD, PGADMIN

Responsibilities:

Provided expert technical solutions and guidance to Project Managers and team DBA’s on adopting best Oracle practices and standards to enable the IT objectives and initiatives to be attained in the most efficient manner.

Production ON-CALL Support

Serve as technical expert, responsible for design and implementation of database infrastructure and set database administration standards for the enterprise. Research DB technology, determine business requirements, proposes changes, develop migration and implementation plans.

Primarily responsible for Oracle RAC setup/configurations, installations, implementations, and RAC database creations.

Performed patching, data migrations, security Role Implementations, as well as troubleshooting, performance, and health monitoring.

Monitor AWS logs / Email using CloudWatch tool and fixing issues.

Upgraded AWS certificate on Non-Prod / Prod environments.

Upgraded Postgres RDS aurora from 12.x to 16.x on all Prod and Non-Prod environments.

Upgraded Replication engines (DMS)

Worked with DB Engineering and OST, upgraded RHEL servers from 7.x to 8.x.

Involved with Application team, migrated data from Oracle to Postgres RDS Aurora Database.

PgAudit setup and attached to CloudWatch tool.

Working with the team, Schema setup, creating users, role setup and assigning privileges.

Working with Security team to fix Vulnerability issues.

Decommissioning un-used roles, schemas and users, database, software, and DB servers

Experience in Postgres includes installation, backup, maintenance, and support of the systems.

Company

State Highway Administration (SHA), MD, USA

Duration

Dec 2019- Dec 2022

Role

Consultant – Sr Database Administrator

Environment

RHEL 7, Oracle Linux 8, Windows 2012 / 2016 / 2019

Language

SQL, PL/SQL, JAVA

Tools/Utilities/

RDBMS

Oracle 19c, MS-SQL Server, PostgreSQL, MongoDB, TALEND, SQL*Plus, SQL*Loader, DATAPUMP, TOAD, SQL-Developer, Erwin Data Modeler, Commvault, BMC Patrol, Hummingbird Exceed, Putty, VPN, MS-Outlook, MS-Word, MS-Excel, MS-Power Point, WINSCP, Microsoft Teams, Remote Desktop, ASM, DATAGUARD, Oracle Enterprise Manager Grid Control 13c/12c, RMAN, Flashback

Responsibilities:

On-call support for critical production issues

Installing, planning and documenting PSU for Oracle RDBMS and GRID

Installed Postgres software, DB Migration, DB refreshes.

Working with application users for performance tuning using OEM AWR, ADDR tools.

Created ASM Disk & Disk groups and maintained Oracle ASM instance.

Configure, monitor, troubleshot Oracle and SQL Server and file system backups using Commvault. Restore database and files whenever needed.

Creation of database in versions 19C/12c on all flavours of Linux and Windows servers.

Upgraded Oracle Grid Infrastructure / databases from 12c to 19c

Worked on upgrading Oracle Enterprise Manager 12c to 13c.

Installed and configured of Oracle Key Vault for advanced security.

Installed and configured Oracle Connection Manager (CMAN)

Prepared project document for various project plans

Implemented DATAGUARD setup and database switchover / failover using dgmgrl.

Developed and implemented Backup and Recovery Plan using RMAN and DATAPUMP.

Schema refreshes across databases (from production to staging/development)

Service request assisting in planning and implementing Oracle database and application changes

Developing and reviewing adherence to these standards and procedures

Monitoring the growth of database, data files, allocating space for future requirements.

Consistent maintenance of the Database Health check and take remedial measures proactively.

Implementation of database deployment in production, test and development databases.

Creating and working with Oracle to troubleshoot Oracle issues.

Working with Network and Backup team to tune and troubleshoot OS and Backup issues.

Setup and managed flashback database.

Setup PostgreSQL databases, Databases refreshes and doing daily tasks by customer’s request.

Support MS-SQL server database and working with the application team to develop, tune and troubleshoot database issues.

Implemented custom Error handling in Talend jobs and worked on different methods of logging.

Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs to execute the Jobs

Created ETL/Talend jobs both design and code to process data to target databases.

Created Talend jobs to load data into various Oracle tables.

Utilized Oracle stored procedures and wrote few Java codes to capture global map variables and use them in the job

Involved in the development of Talend Jobs and preparation of design documents, technical specification documents.

Created Talend jobs to load data into various Oracle tables.

Utilized Oracle stored procedures and wrote few Java codes to capture global map variables and use them in the job

Setup, designed and implemented scalable MongoDB.

Involved in MongoDB deployments.

Company

The Ford Motor Company, MI, USA

Duration

Dec 2003 - March 2018

Role

Database Administrator

Environment

HP-UX 11.0, SuSE Linux SLES 11.0/ 10.0/9.0/8.0, Sun Solaris 9.0, IBM-AIX 5.3/5.1, Supercluster, Windows 2003

Language

SQL, PL/SQL, JAVA, Pro *C, Visual C++

Tools/Utilities/

RDBMS

Oracle 11i(11.5.10.2), Oracle 19c,12c/11g/10g/9i/8i/8.x/7.x, Oracle 9iAS, Peoplesoft (ERP), EXADATA, DB2, SQL*Plus, Server Manager, Net8, SQL*Loader, Exp/Imp, SQL-Trace/ TKPROF, STATSPACK, TOAD, SQL-Developer, Erwin Data Modeler, Request Center, Remedy 5.01.02, Tivoli Net Backup, BMC Patrol, Hummingbird Exceed, Putty, VPN, MS-Outlook, MS-Word, MS-Excel, MS-Power Point, WINSCP, TMUX, MS-Communicator 2005, FTP, Telnet, Remote Desktop, Super Cluster, Sun Solaris, IBM-AIX, SuSE Linux 12/11/10/9, Windows, EXADATA, ASM, DATAGUARD, OEM, RMAN, DATAPUMP, Flashback, MS-SQL Server.

Responsibilities:

24x7 On-call support for critical production issues.

Provided support and mentorship to DBA team in different time zones.

Gained in-depth knowledge and experience in Oracle Infrastructure, application behaviours in Enterprise Data Center (EDC) and playing SME role for EDC’s Oracle Infrastructure.

Supporting for high/critical tasks on super cluster/zone cluster environments.

Creating and managing the ASM database

Created ASM Disk & Disk groups and maintained Oracle ASM instance.

Installed Oracle Software 12c/11g/10g/9i on Linux & Sun Solaris platforms.

Monitor database space requirements and adjust for future needs.

Creation of database in versions 12c/11g/10g/9i/8x on all flavours of UNIX (SuSE Linux, Solaris, AIX, Hp-Unix) and Windows (2000 /2003/2005)

Planned and Implemented DATAGUARD and Oracle Databases. DATAGUARD management using DGMGRL. Standby Database Build, switchover and failover. Physical Standby rebuild using incremental backups.

Maintenance of Oracle Software Products which includes CPU patching, One-Off patching, Patch set upgrades.

Database upgrade from 7.x/8.x to 9i, 9i to 10g, 10gR2 to 11GR2, 11GR2 to 12cR1 and 12cR1 to 12cR2.

Developed and implemented Backup and Recovery Plan using RMAN and DATAPUMP.

Installation and upgrade OEM agents on all database servers and configuring database/node to OEM Grid control.

Complete Database refreshes (from production to staging/development) using RMAN and User Managed backups.

Cloned or duplicate the databases using RMAN Backup

Schema refreshes across databases (from production to staging/development) using Export/Import and DATAPUMP.

Proficient in all DBA responsibilities such as backup and recovery of Oracle databases, cloning, user management (synonyms/privileges, roles, profiles, quotas, index), space management (Tablespaces, rollback segments), monitoring (alert log, memory, disk I/O and CPU).

Assisting in planning and implementing Oracle database and application changes

Working with developers to define and maintain an Oracle environment for application development and testing

Troubleshooting and tuning performance using OEM tool

Creating and setting up Physical Standby Database.

Helping application teams understand and use Oracle features.

Maintaining and contributing to internal team-knowledge documents

Evaluating new Oracle database products and features

Developing and reviewing adherence to these standards and procedures

Monitoring the growth of database, data files, allocating space for future requirements.

Consistent maintenance of the Database Health check and take remedial measures proactively.

Implementation of database deployment in production, test and development databases.

Maintaining and moving data across the environment on request thru Export, Import utilities.

Setting up new instances and configuring with RMAN Catalog for RMAN Backup and recoveries.

Handling general tuning escalations on production databases time to time.

Working on Oracle Support processes for technical requests with Metalink.

Working with Sysadmins and Configuring of kernel-parameters of the environments according to the end-requirements.

Setup and managed flashback database.

Creating and maintaining the database users and controlling the usage of resources by using profiles. Maintain the security and access to the database by granting and revoking roles to and from users.

Setup and monitored STATSPACK and fixed issues on daily basis.

Implemented database auditing, data security and remediate high-risk violation in production environment.

Implemented various backup policies and daily maintenance tasks in the project.

Company

Technosoft Corporation, MI, USA

Duration

July 2003 - November 2003

Role

Database Administrator

Environment

Sun Solaris 5.6, Windows 2000

Language

SQL, PL/SQL, JAVA, Pro *C, Visual C++

Tools/Utilities

Oracle 8i, Oracle 9i, 8.1.5, 7.3.4.0, 7.1.2.0, SQL*Plus, PL/SQL, Server Manager, Net8, SQL*Loader, EXPORT/IMPORT, OEM and RMAN

Responsibilities:

24x7 On-call support

Data upgrade from Oracle 7.1.3 and 8.1.7 to Oracle 9i (9.0.2)

Migrated the data from Excel, text, MS-Access, SQL-Server to Oracle 9i Database.

Application Tuning (Explain Plan and SQLTrace), Design (Physical and logical Database using Erwin Data Modeler)

Stored procedure (Oracle PL/SQL/ Procedure / Function / Packages and Database Trigger) and involved in Reports 9i and Discoverer (EUL)

System Analyst, Systech, USA 03/2002-06/2003

Responsibilities:

Oracle Maintenance (on call support)

SQL Tuning and Troubleshooting

Documentation (System Requirement Specification and System Detail Specification)

Development (TOAD and SQL Navigator),

Testing (Unit, Integrated and Block-box testing using WinRunner

Operating Systems

HP 9.0, RHES AS 2.1, Windows NT/2000

Tools/Utilities/ RDBMS

Oracle 8i, Oracle 9i, 8.1.5, 7.3.4.0, 7.1.2.0, SQL*Plus, PL/SQL, Server Manager, Net8, SQL*Loader, EXPORT/IMPORT, OEM and RMAN

Contact this candidate