Senior Database Administrator & ETL Engineer

SABITHA

Senior Database Administrator

********.****@*****.*** 469-***-****

PROFESSIONAL SUMMARY

Over 9+ years of experience as a database professional with advanced administration of relational databases including Oracle, PostgreSQL, and SQL Server across Production, Development, and Test environments, supporting Fortune 500 and large enterprise organizations. Proven expertise in database design, normalization, and performance tuning, high-availability production support, and building automated, reusable data ingestion and ETL pipelines.

•Strong hands-on experience in database design, normalization, and performance tuning — index strategy, query optimization, and reading/interpreting execution plans across Oracle, PostgreSQL, and SQL Server.

•Extensive backup, recovery, and disaster-recovery planning — HA/DR, replication, and failover clustering using Data Guard, RMAN, RAC, PostgreSQL streaming replication, and SQL Server Always On.

•Security management across platforms — user roles and privileges, encryption, auditing, and regulatory compliance (SOX, PCI, HIPAA-aligned controls).

•Managed large-scale, high-availability production environments (multi-terabyte databases, RAC, multi-AZ) with 24x7 on-call support and SLA-driven incident resolution.

•Strong hands-on experience importing and processing structured and semi-structured data files, including CSV, TSV, Excel (XLS/XLSX), JSON, XML, banking/healthcare EDI formats (BAI, 835, 837), and flat/log files.

•Built robust, reusable data ingestion frameworks using SSIS, Azure Data Factory, and scripted pipelines, with data validation, cleansing, deduplication, and transformation built in.

•Proficient with bulk-load utilities — **SQL\*Loader, BULK INSERT, COPY, and bcp — and with scripting file parsing/transformation to automate database imports and exports**, including error handling and logging in ingestion workflows.

•Implemented CI/CD for database deployments using GitHub, source-controlled schema changes, and automated release pipelines.

•Delivered operational excellence through automation of routine tasks with Shell, PL/SQL, and Python scripting and scheduler jobs, creating maintainable, supportable, and testable solutions.

•Experienced working within Agile teams, contributing to communities of practice, sharing technical expertise, and coaching and training junior team members.

•Strong problem-solving and communication skills with a collaborative approach across application, infrastructure, and business teams in large enterprise projects.

TECHNICAL SKILLS

Databases (RDBMS)

Oracle 19c/12c/11g (RAC, Data Guard, Multitenant PDB/CDB), PostgreSQL (on-prem & AWS RDS/Aurora), Microsoft SQL Server, MySQL

Data Ingestion / ETL

SSIS (SQL Server Integration Services), Azure Data Factory, custom ingestion frameworks; data validation, cleansing, deduplication & transformation

File Formats

CSV, TSV, Excel (XLS/XLSX), JSON, XML, BAI, 835, 837, flat files, log files

Bulk Load / Data Movement

**SQL\*Loader, BULK INSERT, COPY, bcp**, Data Pump (expdp/impdp), Oracle GoldenGate

HA / DR & Replication

Oracle Data Guard / Active Data Guard, RAC, SQL Server Always On, PostgreSQL streaming replication, failover clustering, GoldenGate replication

Backup & Recovery

RMAN, Rubrik, Veritas NetBackup, Commvault, Avamar, pg_dump/pg_basebackup, RDS snapshots

Performance Tuning

Execution plans, index optimization, AWR, ADDM, ASH, TKPROF, SQL Trace, EXPLAIN PLAN, STATSPACK, PostgreSQL EXPLAIN/ANALYZE

Security & Compliance

User roles & privileges, encryption (TDE), auditing, TCPS/SSL, data masking, SOX / PCI / HIPAA-aligned controls

Scripting & Automation

Shell (UNIX/Linux), PL/SQL, T-SQL, Python, cron, Oracle Scheduler, Autosys

CI/CD & Version Control

GitHub, Git, CI/CD pipelines for database deployments, source-controlled schema changes

Cloud

AWS (RDS, Aurora, VPC, Multi-AZ, CloudWatch, Performance Insights), Azure (Data Factory)

Tools

Oracle Enterprise Manager (OEM 12c/13c), TOAD, SQL Developer, Erwin, ServiceNow, Remedy, ITSM

Operating Systems

Red Hat / Oracle Linux, IBM AIX, HP-UX, Oracle Exadata, Windows Server

Methodology

Agile / Scrum, communities of practice, ITIL-based incident/change management

PROFESSIONAL EXPERIENCE

State of Texas Jan 2025 – Present

Role: Senior Database Administrator

Environment: Oracle RAC 12.2c/19c, PostgreSQL, Exadata, AIX 7.1/Linux, GoldenGate, OEM 13c, RMAN, Active Data Guard, ASM, SSIS, GitHub, Python/Shell, ServiceNow

•Administer large-scale, high-availability Oracle 19c RAC Multitenant (PDB/CDB) and PostgreSQL production environments, supporting mission-critical state applications.

•Designed and normalized schemas and drove performance tuning through index redesign, query optimization, and execution-plan analysis, reducing batch runtimes significantly.

•Built reusable data ingestion frameworks to load and process CSV, Excel, JSON, XML, and flat/log files into staging and production, with automated validation, cleansing, deduplication, and transformation.

•Developed Python and Shell scripts to parse and transform inbound files and automate database imports/exports, with structured error handling and logging in the ingestion workflows.

•Implemented CI/CD for database deployments using GitHub, version-controlling schema changes and automating release promotion across environments.

•Implemented Oracle 19c Active Data Guard for disaster recovery and maintained primary/standby databases; managed replication and failover for HA.

•Applied patches, PSUs, and quarterly RUs; migrated on-premise databases to Exadata; deployed Rubrik backup technology across the Oracle estate.

•Provided 24x7 on-call production support, leading P1/P2 incident resolution within SLA and performing root-cause analysis.

•Provided coaching and training to junior DBAs and contributed to team standards and best practices within an Agile delivery model.

Vanguard, NC Sep 2023 – Jan 2025

Role: Senior Database Administrator

Environment: Oracle RAC 12c/19c, PostgreSQL (AWS RDS/Aurora), AWS, Linux, Data Guard, OEM 13c, RMAN, Data Pump, ASM, Azure Data Factory, GitHub, ServiceNow

•Supported multiple critical applications across AWS PostgreSQL (RDS/Aurora) and on-premise Oracle databases in a high-availability environment.

•Built and scheduled ETL / data ingestion pipelines using Azure Data Factory and scripted loaders to process CSV, Excel, JSON, and XML feeds, applying data cleansing, deduplication, and transformation.

•Used COPY and bulk-load utilities to ingest large data files into PostgreSQL, and automated import/export jobs with logging and error handling.

•Performed performance tuning of slow-running queries using execution plans, SQLT, SQL profiles, and SQL plan baselines; tuned PostgreSQL with EXPLAIN/ANALYZE.

•Provisioned and supported databases on AWS RDS with Multi-AZ for automatic failover and high availability; configured VPC and DB subnet groups for isolation.

•Implemented Active Data Guard and RAC on 12c/19c; performed backup, recovery, and cloning using RMAN and RDS snapshots.

•Performed security and change-management activities during maintenance windows; provided root-cause analysis and implemented security initiatives for compliance.

•Collaborated within an Agile team, sharing technical expertise and contributing to continuous-improvement practices.

Huntington National Bank, OH Aug 2020 – Feb 2022

Role: Senior Database Administrator

Environment: Oracle RAC 12.2c/19c, SQL Server, Exadata, AIX 7.1, GoldenGate, OEM 13c, RMAN, Active Data Guard, ASM, SSIS, bcp, ServiceNow

•Administered Oracle 19c RAC and SQL Server databases supporting core banking, consumer, and commercial banking applications in a regulated, high-availability environment.

•Processed and ingested banking data files including BAI, 835/837, CSV, and flat files, building automated pipelines with validation, cleansing, and transformation for downstream reporting.

•Used SSIS, bcp, and BULK INSERT to load structured and semi-structured files, with error handling and logging across ingestion workflows.

•Implemented security management — roles, encryption, auditing — to meet banking compliance and regulatory requirements, maintaining controls and documentation.

•Configured GoldenGate bi-directional and uni-directional replication for ETL and HA; implemented Active Data Guard for disaster recovery.

•Performed performance tuning using AWR, ADDM, ASH, TKPROF, SQL Trace, and execution plans; implemented Oracle Resource Manager to control CPU load.

•Automated routine maintenance via Shell scripts and scheduler jobs; handled P1/P2 incidents with SLA-driven resolution and 24x7 on-call support.

•Mentored less-experienced team members and reinforced database standards and best practices.

Continental Tires Feb 2018 – Jul 2020

Role: Senior Database Administrator

Environment: Oracle RAC 11gR2/12c/19c, IBM-AIX, HP-UX, GoldenGate, OEM 12c, RMAN, Active Data Guard, ASM, SQL*Loader, ServiceNow

•Installed and maintained Oracle 11gR2/12c/19c RAC on IBM-AIX and Linux; upgraded databases from 11g to 19c.

•Used **SQL\*Loader and Data Pump to import and process large structured data files, and wrote scripts to parse, transform, and automate** data loads.

•Made performance improvements through database design choices — partitioned tables, index-organized tables, materialized views, and bitmap indexes — plus SQL and execution-plan tuning.

•Managed security — user management, privileges, roles, auditing, profiling, and authentication.

•Implemented Oracle 12c Active Data Guard for disaster recovery; created database maintenance plans including statistics, re-indexing, and capacity planning.

•Automated daily routine activities and maintenance jobs with Shell scripts and Oracle scheduler; provided 24x7 on-call production support.

New York Life (State of NY) Mar 2016 – Jan 2018

Role: Oracle Database Administrator

Environment: Oracle RAC 12.2/19c, Oracle GI 11.2/19c, AIX 7.1, Data Guard, GoldenGate 12c, OEM 13c, RMAN, Data Pump, ASM, Exadata, ServiceNow

•Installed and configured 12.2 and 19c Grid Infrastructure standalone and RAC databases for a large insurance enterprise.

•Processed insurance and healthcare claim files (835/837) and other structured feeds, troubleshooting inbound/outbound file failures and load errors.

•Configured and troubleshot GoldenGate replication (Extract, Pump, Replicat); performed half-yearly switchover activities for DR compliance.

•Applied quarterly RU patches to multiple 19c databases; migrated databases across AIX Power7 to Power9 systems using RMAN backup/restore.

•Managed all aspects of the physical database — schemas, DDL, users, and security — across development, UAT, and production; resolved performance issues via SQL tuning.

British Telecom (BT Group PLC) Mar 2015 – Feb 2016

Role: Oracle Database Administrator

Environment: Oracle RAC 11.2/12c/19c, Windows, Data Guard, GoldenGate 12c, OEM 13c, RMAN, Data Pump, ASM, TOAD, HP Service Manager

•Served as offshore DBA lead and technical SPOC to the client, driving P1/P2 incident resolution and root-cause analysis within SLA.

•Performed migration and housekeeping across all Oracle versions; supported application releases and troubleshooting.

•Proactively monitored and tuned CPU, I/O, and memory performance; tuned SQL and managed index usage and segment space.

•Handled inbound/outbound file transfer failures to/from external vendors, maintaining scripting standards and monitoring logs and data flow.

•Managed refreshes of production data to UAT with data masking for audit compliance; automated jobs using SQL and OEM.

HGS (India) Feb 2014 – Jan 2015

Role: Oracle Database Administrator

Environment: Oracle 11g/11gR2 RAC, RedHat Linux, HP-UX Itanium, OEM, RMAN, Data Guard, ASM, AWR, TOAD, Erwin, SQL Developer, HP Data Protector

•Supported Oracle 11gR2 RAC databases and both Data Warehousing and OLTP systems up to 10 TB on RAC.

•Re-engineered production schemas using Erwin, TOAD, and SQL Developer data modelers, applying normalization and design best practices.

•Refreshed schemas across environments with tablespace re-mapping; configured RMAN hot/cold backups with HP Data Protector.

•Implemented security user management, privileges, roles, profiling, and auditing; performed performance planning and tuning with baselines and wait-event analysis.

•Participated in team management and mentoring, supporting knowledge sharing across the DBA team.

EDUCATION

M.S. in Computer Science and Information Systems — Southern Arkansas University, Dec 2023

CERTIFICATIONS

•AWS Certified Solutions Architect

•Oracle Certified Professional (OCP)

Contact this candidate