CONSULTANT ORACLE/DB2 DBA at Verizon (2021-01 – 2025-12)
A leading telecommunications company providing wireless, wireline and networking solutions serving consumers, businesses, and government globally.
- Responsible for creating Linux(EC2) servers, carving out storage, creating database users, deploying database binaries, creating and populating databases via export/import and by using AWS Schema Conversion tool (SCT) and Data Migration service (DMS).
- Responsible for DB2 to Aurora Postgres Migrations using AWS Schema Conversion tool (SCT) and Data Migration service (DMS).
- Experience in spinning up Linux(EC2) servers and performing Quarterly Rehydrations.
- Participated in Disaster Recovery exercises for Aurora Postgres and Oracle.
- Applied Oracle PSUs on a regular basis.
- Performing deployments and releases frequently in all environments using Jenkins/CICD pipeline.
- Extensively used Export/Import/Datapump utilities for selective Backup, transferred tables between Oracle Instances.
- Experience in oracle database administration across broad environments like onprem standalone, Rac Cluster, OCI and ATP.
- Worked with Shareplex replication for data sync of tables across multiple applications.
- Oracle Database user management by creating users and granting required roles/privileges after standard approvals.
- Developed shell scripts to monitor databases and to generate alerts for critical situations.
CONSULTANT DATABASE (DB2) at Verizon (2014-03 – 2020-12)
A leading telecommunications company providing wireless, wireline and networking solutions serving consumers, businesses, and government globally.
- Performed database installation, Configurations and administration of DB2 LUW databases on AIX, Linux & Solaris platforms.
- Determined project requirements; planned for database backup & recovery, infrastructure, capacity and maintenance.
- Performed Schema/Database Refreshes as part of Application Requirements.
- Performed database performance tuning and optimization.
- Troubleshooted and resolved DB2 issues within SLA.
- Collaborated with System admins and application teams for the change requests like OS patching, Middleware upgrades, Database upgrades.
- Performed database version upgrades and fix pack installations and patch updates.
- Performed database migrations from AIX/Solaris to Linux.
- Configuring HADR, SQL Replication and DR Setup with Log Shipping and supporting.
- Support databases on Linux VERITAS & REDHAT clustering and Aix HACMP.
- DB2Audit/Splunk setup and configuration to capture database events.
- Configuration of Native encryption & SSL connections Encryption.
- Performing redirect restore/ roll forward from one environment to another.
- Monitoring the database manager, databases, locks, applications, table spaces, active logs etc. by using snapshot, db2pd, db2top and event monitors.
- Perform data Export/Import with data movement utilities such as Load, DB2move, and import/export.
- Perform and support database design, Data analysis, performance tuning, monitoring and application support.
- Participated in Disaster Recovery exercises.
- Automated the DB2 services shutdown / startup, Healthchecks for system maintenance activities.
- Involved in depth analysis for recurring db2 issues and resolved issues timely.
- Responsible for migrating the DB2 databases across the data centers.
- Monitored and tuned databases for performance, provided query analysis, expanded / rebalanced tablespaces. Troubleshoot issues related to database locks, memory/CPU, heap, swap etc.
- Provided extensive on call support for 24*7 production environments as primary DB2 DBA.
- Worked closely on IBM PMR's and Implement a permanent fix to DB2 databases as advised.
Information Specialist at NewtGlobal (2012-04 – 2014-02)
A leading telecommunications company. Client: Verizon
- Provided 24x7 database support for DB2 LUW databases.
- Installed and configured DB2 using system5/RPM installation packages for database product deployments on Linux, AIX, Solaris servers.
- Performed database upgrades, backup and restore/rollforward operations, failover and failback.
- Performed database loads and unloads; Implemented database life-cycle maintenance.
- Setting up new environments for debugging production issues in applications and setting environments for tests.
- Table space management – Adding, dropping, extending, reducing and resizing table space containers, Create and managing SMS, DMS, and Automatic Storage table spaces.
- Analyze the diagnostic log records for any problems and troubleshooting. Solve any issues reported in the db2 diagnosis log.
- Used shell scripts for reporting database health checks and to run maintenance jobs.
