Oracle & AWS Database Infrastructure Manager

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

•AWS Certified Solutions Architect 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 Datacenter 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 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)

•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.

WORK EXPERIENCE

Employer/Client

Trillion Technology Solutions / Federal Aviation Administration (FAA)

Duration

Nov 2025- Till Date

Role

Oracle AWS RDS Database Administrator

Environment

RHEL 7/8, Windows 2012 / 2016 / 2019

Tools/Utilities/ RDBMS

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

Responsibilities:

•Production ON-CALL Support

•Administer Amazon RDS for Oracle databases across development, testing, and production environments.

•Managed database provisioning, parameter groups, option groups, snapshots, and automated backups.

•Performed database migrations from on-premises Oracle databases to Amazon RDS using Oracle Data Pump and AWS migration tools.

•Monitored database performance using CloudWatch, Performance Insights, and Oracle performance reports.

•Implemented database security using IAM integration, encryption, and Oracle user privilege management.

•Performed database patching and maintenance during scheduled maintenance windows.

•Collaborated with development and infrastructure teams to resolve production issues.

•Migrated multiple Oracle databases from on-premises infrastructure to Amazon RDS.

•Applied patches and upgrades supported by RDS

•Managed users, roles, and security

•Reduced infrastructure management overhead by leveraging managed AWS services.

•Configured automated backups, monitoring, and disaster recovery.

•Identified inefficient SQL statements using AWR and ASH reports.

Employer/Client

Spatial Front Inc (SFI) / Department of Transportation (DOT)

Duration

Dec 2022- Nov 2025

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, MSExcel, 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, propose 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)

•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.

Client

State Highway Administration (SHA), MD, USA

Employer

SRICHAKRA Inc, 5066 Bending Sky Way, Ellicott City, MD 21043

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 flavors 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 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 databases, data files, and allocating space for future requirements.

•Consistent maintenance of the Database Health check and taking 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 refresh and do 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.

•Following 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.

Client

The Ford Motor Company, MI, USA

Employer

THE EPITEC INC, 24800 Denso Drive, Southfield, MI 48033

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, MSOutlook, 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, 48411 Northwestern Highway, Suite 640, MI, USA

Duration

July 2003 - November 2003

Role

Programmer Analyst

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)

Company

Systech Inc, 30600 Telegraph Road, Bingham Farms, MI, USA

Duration

March 2002 - June 2003

Role

System Analyst

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