Antony Amalraj

DATABASE ADMINISTRATOR

ac180d@r.postjobfree.com

914-***-****

Technical Skills:

Software: Oracle 7/8/8i/9i/10g/11g, IBM UDB/LUW DB2 EEE//ESE/AESE 6.x/7.x/8.x/9.x/10.x, Sybase 12.0,

Oracle Grid, Data Guard, RAC11Rg, RMAN, MS SQL Server 2005, MS SQL Server 2008.

Scripting: Shell & Perl Scripting

Languages: SQL, PL/SQL, VB 6.0, XML, HTML, PHP, JSP, Java/Java scripts, C#

Operating Systems: MS DOS, Windows NT/2000/XP, Linux, VM Ware, RedHat Linux, HP-Unix, Sun Solaris 10

Hardware: IBM PC, Macintosh, Unix Hardware, Local Area Network (LAN), WAN

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,

DBArtisan, Aqua data Studio, IBM Data Studio, NetCool.

Professional Experience:

Wind Stream, Charlotte, NC

LUW/UDB DB2 Database Administrator Feb’2016 to Present

Installed and Configured UDB/LUWDB2 EE/ESE/AESE /9.x/10.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, reorg for tables to query improve performances. Done export/import

Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management,

Worked on db2 backup and recovery strategies. Analyzed db2diag log file for critical errors.

Installed and configured HADR – setup for All the 3 Application Products (PE, FM and CM)

Installed and Configured IBM data studio to connect with different databases (PE, FM and CM)

Attended daily scrum meeting, Worked on DBA KT handover process. Generated monitoring reports.

Created users, groups, roles, Schema, tables, views, stored proc, triggers and other DB objects.

Provided production support for critical applications running on 24/7 On-call basis

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.

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

Have done the Production Support for Oracle databases 11g, 10g on different O/S (Windows/Unix/Linux)

I have done import/export, data refresh, Monitored transaction log, table space using db2top & db2pd tools

Involved in database and query tuning, ran explain plan 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

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

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 Database Sizing information for UAT, Production and Dev databases.

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

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

Involved in database Migration / Upgrade of 11g, 10g, 9i, and 8i.

Handle Data Pump utility for the high speed infrastructure data and metadata move

Created DB Links and Materialized Views. Automated jobs using UNIX Shell scripts

Worked with RMAN backup and recovery procedures and its operations

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.

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.

Analyzed, designed, developed, Data Warehouse and Data Marts projects

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/11g, 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 (which is from another machine) 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 Database Administration

Lean Certified Leadership Training Program

Oracle 11g OCP certification is in progress

Education:

M.S Computer Science in Pace University, White Plains, NY GPA – 3.85

Master of Science (M Sc) Electronics in St. Joseph’s College – Tamil Nadu, India

Work Authorization Status: Green Card Holder

Contact this candidate