Database Administrator Business Analyst
Resume:
Antony Amalraj
DATABASE ADMINISTRATOR
********@*****.***
LinkedIn: https://www.linkedin.com/in/antony-amalraj-03909329/
Technical Skills:
Software: Oracle 7/8/8i/9i/10g/11g/12c/19c, IBM UDB/LUW DB2 EEE//ESE/ASE 6.x/7.x/8.x/9.x/10.x,11.x
Oracle Data Guard, RAC11g, 12c/19c, RMAN, MySQL, MS SQL Server 2005/2008/2012, IBM WebSphere
Scripting: Python, Shell & Perl Scripting
Languages: SQL, PL/SQL, VB 6.0, XML, HTML, PHP, JSP, Java/Java scripts, C#, JDBC, ODBC,
Operating Systems: MS DOS, Windows NT/2000/2012/2019, VM Ware, RedHat Linux, HP-Unix, Sun Solaris 10,AIX 6/7/8
Hardware: IBM PC, Macintosh, Unix Hardware, Local Area Network (LAN), WAN, TSAM, DDBoost, Avamar,
Tools: TOAD 10.5, Oracle Enterprise Manager,2.0/12, Erwin 7.0, Control Center, Command Center, CLP (Command Line Processor), Quest Central for UDB, Cognos 8.x, DataStage 8.x, Symantec i3, DSM
DBArtisan, Aqua data Studio, IBM Data Studio, NetCool, Apache, Tomcat, Terraform, Azure, Puppet
Professional Experience:
DTE(Detroit Energy), Detroit, MI. July’2023 to Aug’2025
Database Administrator
Database Installation & Configuration: Installed, configured, and upgraded database software IBM DB2 LUW/UDB 10.5/11.1/11.5 on Linux/Unix/Windows on Dev, QA and PROD env.
Backup & Recovery: Established and maintained database backup (online, offline and incremental) and recovery (Regular & Redirect restore) procedures, ensuring data integrity and availability in case of system failures or disasters situation. Conduct regular DR recovery tests.
Security Management: Implemented and enforced database security policies and standards to comply with relevant regulations (SOX/PUAR) and best practices including user access control, encryption, and auditing, to protect sensitive data from unauthorized access.
Troubleshooting and Support: Diagnose and resolve complex database issues, including connectivity problems, data corruption, and performance degradation. worked as Hands on DBA. Managed team of 4 members as well. Escalated the priority issues by creating Service Now Tickets and joining the command center call.
Maintenance and Monitoring: Performed routine database maintenance tasks such as DB Health Checks, patching, upgrade, space management, and integrity checks. Setup and managed database monitoring tools and alerts.
Replication and High Availability: Implemented and managed database replication (HADR), Q Rep, CDC, Clustering, to minimize downtime and ensure continuous operation.
Performance Tuning & Optimization: Monitored database performance, identify bottlenecks, and implement tuning strategies like optimization, indexing, schema design adjustments, to ensure optimal tunning and efficiency.
Capacity Planning: Monitored database growth and usage, performing capacity planning to ensure sufficient resources available for future requirements.
Analyzed database performance metrics and provided recommendations for improvements.
Documentation: Created and maintained comprehensive documentation for database configurations, changes, procedures, and troubleshooting guides. Created DB health Check, lock/log check scripts and automated the same.
Collaboration: Work closely with developers, system administrators, and other IT professionals to support application development, deployments, and infrastructure projects.
Ran the data maintenance utilities Reorg and Runstats for better performance on daily and weekly scheduler. Used and managed the db2pd, db2top, db2diag and snapshot monitors to determine the database problems.
Migrated/upgraded (In-place) database from 9.7 to 10.5, 10.5 to 11.5 and 11.1 to 11.5 on Test, Dev and PROD Env. Utilized data definition language using db2look and db2move/export while setting up new DB2 LUW/UDB database Env.
Created IBM PMR priority ticket, provided db2support and db2diag.log files for their Analysis and findings and followed up with IBM SME and Duty Manager for an update and remedy. Implemented the mitigation steps. Done the RCA.
Worked with SAP(ERP) – BASIS system team and Application team on deployment and DB server failover. Performed the DB Refresh using Redirect restore from production to QA and DEV and TEST environment.
Worked on Database and Query tuning. Created and enabled the custom DB/application snapshot monitoring script. Worked on monitoring, maintenance, Incident. Service and change management tickets. Performed Root cause/problem Analysis.
.
Global Foundries(GF), East Fishkill, NY Jan’2021 to June’2023
Database Administrator
Installed and configured DB2 LUW 9.7/10.1/10.5/11.1/11.5 on both Windows and Linux/Unix/AIX env.
DB2 installations, configurations, patching and upgrades on Prod, QA, Test and Dev env on LUW
Performed Database and Query Tuning for Optimization. Done Backup and Recovery.
Enforced database security policies, including user access control, encryption, and auditing etc
Worked closely with developers and system administrators, to support application both development and deployments
Design logical and physical databases and database objects for DB2 UDB on Dev, Test and PRD
Monitor database performance and provided recommendations to improve operational efficiency
Create the new DB’s and maintain DB objects like table spaces, buffer pools, stored proc, tables etc.,
Manage load jobs with DB2 Movement Utilities like Export, Import Load and db2move.
Run the data maintenance utilities Reorg and Runstats for better performance on daily and weekly basis
Perform the Backup & Recovery of DB2 Databases (Regular & Redirect restore), online database backup,
Perform the DB Refresh using Redirect restore from production to QA and DEV and TEST environment
Migrate/upgrades database from 9.7 to 10.5, 10.5 to 11.5 and 11.1 to 11.5 on Test, Dev and PROD Env
Utilize data definition language using db2look while setting up new DB2 LUW/UDB database environments
Used and managed the db2pd, db2top, db2diag and snapshot monitors to determine the database problems
Managed and monitored DB2 HADR (High Availability) and DB2 DPF env. Provided ensure 24 x7 system availability
Supported IBM db2 MF on Z/os. Worked on maintenance DB. Worked on Qrep and CDC (Change Data Capture).
Created PMR priority one ticket. Implemented the mitigation steps. Done the RCA. Done Database and SQL tuning.
Worked on Database and Query tuning. Created and enabled the custom application snapshot monitoring script.
Worked on Postgres SQL Database Administration. DB monitoring, Performance tunning both SQL and DB.
Worked with SAP(ERP) – BASIS system team and Application team on deployment and DB server failover on AWS cloud env
Worked on monitoring, maintenance, release management, issue/problem management.
Installed and configured Oracle Databases 11g/12/19c/21c on Linux/Unix/AIX/Windows env.
Installed and configured and maintained PostgreSql databases 12.x/13.x/14.x/15.x
Installed and configured IBM OPM(Optim Performance Manager) tool for database performance and Apps response analyzis
Managed team of 10 members, including 6 offshore and 4 onshore Escalated the priority issues and worked as DBA as well.
Catepillar(CAT), Peoria, IL Jan’2020 to Jan’2021
LUW/UDB DB2 Database Administrator
Installed and configured DB2 LUW 9.7/10.1/10.5/11.1 on both Windows and Linux/Unix/AIX env.
Installed and configured HADR setup. Worked on both Single Partition and DPF databases env, with IBM and resolved.
Created DB2 Databases with TBS: (SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges
Managed and monitored DB2 HADR (High Availability). Provided ensure 24 x7 system availability
Created PMR priority one ticket. Implemented the mitigation steps. Done the RCA. Done Database and SQL tuning.
Perform database patch/version upgrade. Worked. Involved in Backup Recovery process
Supported IBM db2 MF on Z/os. Worked on maintenance DB. Worked on Qrep and CDC(Change Data Capture
Worked on db2connect Gate way server, resolved user connectivity issue for IBM MF(Z/os)users connecting from diff Apps
Worked on QA and DEV DB Backup data refresh using DB2 Redirect Restore Method, re-mapped tablespaces, data &Temp
Worked on Database and Query tuning. Created and enabled the custom application snapshot monitoring script
Ran db2 utilities like runstats, load, reorg for tables to improve query performances. Done Database performance Tuning,
Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management.
Worked with SAP(ERP) – BASIS system team and Application team on deployment and DB server failover on AWS cloud env
Managed 7 DBAs supporting multiple clients. work assignments, technical direction, status reporting
Freddiemac, Washington, DC Aug’2019 to Dec’2019
LUW/UDB DB2 Database Administrator
Installed and configured DB2 LUW 9.7/10.1/10.5/11.1 on both Windows and Linux/Unix/AIX env.
Installed and configured HADR setup. Worked on both Single Partition and DPF databases env, with IBM and resolved.
Created DB2 Databases with TBS: (SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges
Managed and monitored DB2 HADR (High Availability) infrastructure and TSA. Provided ensure 24 x7 system availability
Created PMR priority one ticket. Implemented the mitigation steps. Done the RCA. Done Database and SQL tuning.
Perform database patch/version upgrade. Worked on db2haicu, RSCT and TSA. Involved in Backup Recovery process
Worked on QA and DEV DB Backup data refresh using DB2 Redirect Restore Method, re-mapped tablespaces, data &Temp
Worked on Database and Query tuning. Created and enabled the custom application snapshot monitoring script
Worked on Qrep and CDC(Change Data Capture. Done Database performance Tuning,
Ran db2 utilities like runstats, load, reorg for tables to improve query performances.
Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management.
Managed 4 team members and have assigned them work, technical direction, status reporting
Staples Corp, Boston, MA Nov’2018 to July’2019
LUW/UDB DB2 Database Administrator, Supports NO SQL CouchBase,
Installed and configured DB2 LUW 9.7/10.1/10.5/11.1 on both Windows and Linux/Unix/AIX env.
Worked on db2 backup and recovery strategies. Analyzed db2diag log file for critical errors and addressed appropriately
Installed and configured HADR/HACMP – setup for All the five Production Applications like (ECH, SAC,RTMS,HUB,SAD)
Worked on both DPF and Non-DPF databases env, Created PMR priority one ticket with IBM and resolved. Done the RCA
Installed and Configured IBM data studio/DSM to connect/monitor different databases env (Dev, QA, PERF and PROD)
Managed and monitored DB2 HADR (High Availability) infrastructure and TSA to ensure 24 x7 system availability
Worked on QA and DEV DB data refresh using DB2 Redirect Restore Method, for re-mapping the tablespaces, data &Temp
Enabled the custom application snapshot script on both PROD DB(ECH) to capture Federated long running Query for tuning
Created DB2 Databases with TBS: (SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges,
Ran db2 utilities like runstats, load, reorg for tables to improve query performances. Done Database performance Tuning,
Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management,
Worked with UDB DB tools like db2pd, db2diag, db2inspect, db2dart, db2top,db2mtrk, dbptnmem, dbcfg, dbmcfg etc.
Working on Azure Cloud Platform on migrating DB2 to CouchBase Database Data Center. Worked on DPF Databases
Installing and Configuring Database instances, created databases, Monitoring the databases and responding to alerts
Experience in DB2 SQL performance tuning using tools such as db2advis, db2expln, db2exfmt and DSM
Experience installing DB2 and applying DB2 Fixpack upgrades. Worked on db2haicu, RSCT and TSAMP
Worked on DB maintenance. Worked on Qrep and CDC(Change Data Capture)., Exposure to db2 OPTIM
Monitored DB Disk/Memory/CPU utilization for both db2 and CouchBase databases
Followed the support proto call, communicated and addressed the issues appropriately on time with in the given SLA
Created SNOW (Service Now) SRF, CR, Ticket, Analyzed and identify the Root Cause/mitigation for “critical” issues
Attended daily scrum meeting, Supporting CouchBase and Mongo DB. Exposure to AWS. Generated monitoring reports
Created NO SQL - Couchbase databases(buckets), clusters, created user accounts and granted access,
Worked on Couch base version upgrade. backups and restore. Have used the puppet to push the code for node upgrade
Working as both hands-on DBA and doing 24/7 support, also, leading 7 - DBA team. Escalated the priority issues
Attended and conducted weekly/Daily DB2 team meeting and discussed about un-resolved, impacting and outstanding issues
Followed up with our team to create the SOP for re-occurring issues like DB Refresh for both DB2 and Couchbase etc.,
Windstream, Charlotte, NC
LUW/UDB DB2 Database Administrator Feb’2016 to Oct’2018
Installed and Configured UDB/LUW DB2 EEE/ESE/ASE /9.x/10.x/11.x on Linux and Windows O/S
Created DB2 Databases (with TBS: SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges,
Ran db2 utilities like runstats, load, reorg for tables to improve query performances. Done export/import
Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management,
Installing and Configuring Database instances, Monitoring the databases and responding to alerts
Worked on db2 backup and recovery strategies. Analyzed db2diag log file for critical errors.
Installed and configured HADR– setup for 3 Production Applications (PM, FM and CM). Worked on db2haicu, RSCT and TSAMP
Installed and Configured IBM data studio to connect with different databases (PM, FM and CM)
Attended daily scrum meeting, Worked on DBA - KT handover process. Generated monitoring reports
Worked independently, with guidance in only the most complex situations, Exposure to MS SQL databases
Created simple shell scripts for DB Backups, DB monitoring, Snapshot Monitoring, Alert “log” Monitoring etc.,
Restoring Dev/Test env from PROD as per Application group requirements, Attended SCRUM meetings,
Involved in database and query tuning, ran explain plan (db2exfmt, db2advis) for long running queries and analyzed the results
Restored db2 primary backup image at DR datacenter location, to recover the corrupted Stand by database
Created Federation DB setup, by creating catalog/un-catalog and wrapper for the databases to generate reports
Created simple scripts to monitor the locks using system procs like monreport.lockwaits, monreport.dbsummary etc
Have done the Production Support for Oracle databases 11g, 12C on different O/S (Windows/Unix/Linux)
Exposure to Mongo DB, My SQL, MS SQL – Installation, Configuration, monitoring and maintenance,
Exposure to change data capture, CDC,Q-Replication. DB Monitoring with Data Studio, DSM/DB2TOP, DB2PD
Worked on DB2 LUW Version in-place upgrade from 10.1/10.5 to 10.5/11.1 Worked on DB2 memory tuning etc.,
Created users, groups, roles, Schema, tables, stored proc, triggers and other DB objects. Worked on both DPF and Non-DPF
Provided production support for critical applications running on 24/7 On-call basis. Managed and escalate problems as appropriate etc. Created PMR for “critical” – DB issues and followed up with IBM support to resolve the same on time.
Managed and escalate problems as appropriate etc. Created PMR for “critical” – DB issues and followed up with IBM support to resolve the same on time.
Morgan Stanley. 111, Wall Street, NY Aug’2015 to Jan’2016
LUW/UDB DB2 Database Administrator
Responsibilities:
Working as Database Administrator for MDM (Master Data management) Project
Installed and Configured UDB/LUWDB2 EE/ESE/AESE /9.x/10.x on Linux and Windows O/S
Used Power Designer for Physical & Logical data modeling and Reverse Engineering
Created UDB Databases (SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges,
Installed and configured IBM DB2 9.7/10.x and the IBM Data Studio tool. Worked on HARD
Resolved Data base connectivity issue for Linux/Unix client and Kerberos Connectivity
Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management,
Worked on db2 backup and recovery strategies. Have an exposure to db2diag log file.
Provided production support for critical applications running on 24/7 On-call basis. Installed and Config Postgres
Created users, groups, roles, Schema, tables, views, stored proc, triggers and other DB objects.
Generated different types of reports like user query, data analysis, performance, replication etc.,
Created Buffer Pools, Indexes, MQT, Temporary Tables, Alias, Grants (select, insert, update, delete)
Ran db2 utilities like runstats, reorg for tables to query improve performances. Done export/import
I have done import/export, data refresh, Monitored transaction log, table space using db2top & db2pd tools
Have done the Production Support for Oracle databases 11g, 12C on different O/S (Windows/Unix/Linux)
Involved in database and query tuning, ran explain plan(db2exfmt, db2advis) for long running queries and analyzed the results
Used snap shot monitor for locks, load, session etc, Have used db2pd and db2top tools for trouble shooting
Used in house database tool “db2ts” for schema compare, import/export, to grant/revoke permission and T/O
Have ran monitoring report to get the threshold table spaces, data files, log file etc, Exposure to DB2 DPF databases
I have worked with infrastructure team to install and configure, DB server with instance, databases, deployed code into QA, UAT. Escalated critical issues with Infrastructure and Prod support team to resolve within SLA
Worked on different level of support., Created ITSM tickets for issue/problem management Provided database support like monitoring different Autosys jobs, database scheduled jobs, etc.,
State Street Bank Corp. 1290, Americas Ave, NY, NY Aug’ 2005 – July’2015
Database Administrator Lead (UDB DB2 and Oracle)
Working as DBA for State Street Bank Corp, for the past 10 years, involved as a DBA in a multi-tier Strategic development projects. This System includes various projects like SLE2 & SLD, WebLend, ECM, SLD, SLPR, ALD, SFBIR., etc.
Security Lending Enterprise (SLE) and Security Lending Data Warehouse (SLD)
Responsibilities:
Installed and Configured UDB/LUW DB2 EEE/ESE/AESE 6.x/7.x/8.x/9.x/10.x on Sun Solaris, Linux and Windows O/S
Used Power Designer and Erwin for Physical & Logical data modeling and Reverse Engineering
Created UDB Databases (SMS & DMS) for Dev, UAT & PROD, Created user accounts. Roles, privileges,
Created and maintain database security (created & maintained users, group, roles, and grant privileges).
Perform database tuning and performance monitoring. Performed Data Migration from UDB DB2 8.x to Oracle 9i DB.
Extensive experience in DB2 client set-up. Created database triggers (Before & After Insert, Update, Delete) and stored Proc’s
Created UDB Databases (SMS & DMS) for Dev, UAT & PROD, Created Backup and Recovery procedure. wrote Purge Shell Scripts– to Export/Archive/Delete records from set of tables for particular time slot. Worked on Capacity/Storage planning
Performed Export/Import across different databases, wrote a conversion script to upload/download data between different Data bases (UDB/Oracle). Installed and Configured SQL Server databases SQL Server 2012.
Used Control Center, Script center, Quest Central tools for DB Administration, and SQL Visual Explain, Health Monitor, DB2TOP & DB2PD for Performance. Handled on experience in monitoring the DB manager, databases, locks, applications, table spaces, active logs, and archive log using SNAPSHOT, and EVENT Monitors.
Have used Database maintenance utilities using REORG, RUNSTATS, LOAD, UNLOAD, IMPORT, EXPORT, DB2LOOK, DB2MOVE, QUIESE etc. Exposure to DB2 HADR (High Availability Disaster Recovery). Wrote various SQL queries, scripts, triggers, stored procedures. Performed UDB Backups and recovery. Involved in database Migration / Upgrade of 11g, 10g, 9i,
Wrote scripts to automate & schedule the maintenance jobs (REORG, RUNSTATS)
Installation and Configuration of Oracle databases 11g, 10g, 9i, 8i on different O/S (Windows/Unix/Linux)
Created and maintain database security (create and maintain users and roles, assign privileges).
Created DB Links and Materialized Views. Automated jobs using UNIX Shell scripts
Worked with RMAN backup and recovery procedures and its operations. Used Data Pump utility for the high-speed data move
Worked with development team in writing/assisting the PL/SQL tuning using Query Plan for dynamic queries procedures and functions. Worked on Database Sizing information for UAT, Production and Dev databases.
Used Power Designer and Erwin for Physical & Logical data modeling and Reverse Engineering
Created user accounts, roles, and privileges. Created other database objects, rbs, tables, table spaces, and synonyms.
Worked on Export/Import, Load data utilities and Cloning to move data between environments
Worked on generate reports like SQLTRACE, TKPROOF, AWR/ADDM, STATSPACK for trouble shooting
Support and work with Real Application Cluster RAC11g and ASM environment
Developed Stored Proc/function/triggers/packages. Created Shell Scripts. Developed Purge/Archive Process
Used SQL*Loader for Data conversion. Used Flashback recovery procedures for recover tables.
Worked on Oracle Enterprise Manager (OEM), SQL analyzer and TOAD tools for monitoring
Designed, developed, Implemented, the automated Purge/Archive process
Self-motivated, goal-oriented team player with excellent communication skills
Provided technical expertise to development and deployment teams on integration/configuration of supporting infrastructure. Supported Unit, Integration, User Acceptance, Load, Performance and System testing efforts
Created DB objects like tables, indexes, views, sequences, synonyms, table spaces, data files, user accounts, roles,
Assisted different Build release management (INT, UAT, UXT, PROD) by running baseline comparison report using IBM clear case, extracted, deployed SQL scripts. Installed and configured MySQL Server and SQL server for a small Application.
Involved in Production Support, trouble shooting, maintain data base integrity, data base performance tuning.
Provided production support for critical applications running on 24/7 On-call basis.
Exposure to Datastage (ETL tools) and Cognos 8.x (BI) while work on SLD WH
Used Third party tools like Symantec i3, DBArtisan, Toad, Aqua data Studio and BMC
Exposure to Online Analytical Processing (OLAP), DWH, DSS and OLTP environments.
Experience in identifying Facts and Conformed Dimensions used in Data Mart.
Environment: Oracle 7/8/8i/9i/10g IBM UDB/LUW DB2 ESE/EEE 6.x/7.x/8.x/9.x, Shell, Perl
Time Warner Inc., Tampa, FL May’2000 – Jul'2005
Database administrator
Worked as a DBA, supporting “Publishing Distribution System” for Time Warner Group. This application was developed to maintain the information about different publications, customer data and subscription details. This system also maintains membership details, renewal information and payment details. This system exchanges data with many other systems like Accounting and generates various reports. Responsibilities included database creation and maintenance, security, backups and recovery procedures for the Oracle databases. Creating table spaces, creating users, creating roles, Import & Export of databases, creating Stored Procedures, Stored functions, database triggers, Extracted data using stored Procedures to feed other systems. Import data from flat files to database tables using SQL*Loader
Installed and Configured UDB DB2 EEE 7.x/8.x on Sun Solaris and Windows O/S
Performed Oracle Database backups. (Hot and Cold). Recovered databases using archived log files, Performed Data Migration from UDB DB2 7.x to Oracle 9i DB.
Created and maintain database Security (create and maintain users and roles, assign privileges). Have strong analytical and troubleshooting skills. Created UDB Databases (with TBS: SMS & DMS) for Dev, UAT & PROD,
Created Backup and Recovery procedure. Performed UDB Backups. wrote Purge Shell Scripts– to Export/Archive/Delete records from set of tables for particular time slot
Successfully restored the database on Sun Solaris machine using Backup seed using Database build re-direct Mechanism
Have used Database maintenance utilities using REORG, RUNSTATS, LOAD, UNLOAD, IMPORT, EXPORT, DB2LOOK, DB2MOVE, QUIESE etc. Wrote various SQL queries, scripts, triggers, stored procedures
Created 250 database triggers (Before & After Insert, Update, Delete) and stored procedures.
Performed Export/Import across different databases, wrote a conversion script to upload/download data between different Data bases (UDB/Oracle).Used Control Center, Script center, Quest Central tools for DB Administration, and SQL Visual Explain, Health Monitor for Performance Monitoring.
Certifications & Training programs:
IBM Certified Solutions Expert in DB2 UDB/LUW V8.x/9.x/10.x Database Administration
Lean Certified Leadership Training Program
Education:
M.S Computer Science at Pace University, White Plains, NY GPA – 3.85
Master of Science (M Sc) Electronics in St. Joseph’s College – Tamil Nadu, India GPA 3.75
Work Authorization Status: Permeant Resident - Green Card Holde
LinkedIn: https://www.linkedin.com/in/antony-amalraj-03909329/
Contact this candidate