We provide IT Staff Augmentation Services!

Team Manager Resume

SUMMARY

  • Around 19 Years of Experience in Information Technology
  • 16 Years of Experience as DBA, 12 years working on DB2 UDB Administration on Unix (AIX/Solaris/Linux) and Windows, 4 years working on Netezza/Greenplum and 3 years in Oracle/SQL Server, 1 year experience in Paraccel
  • Expertise in DB2 UDB, Big Data Netezza(Twinfin/Striper), Greenplum and Paraccel/Matrix (Columnar)
  • Strong Expertise in Unix/Perl Scripting
  • Migration Project experience from Oracle/SQL Server to DB2 UDB
  • Concrete Knowledge and Experience in Business/Data Modeling, Documentation, Re - engineering, Development, Testing and Implementation
  • Expertise in Data Database Design, Data Modeling and Data Warehousing
  • Good Communication, Team and Interpersonal Skills
  • Project Management/Team Management experience
  • Can independently handle critical work requiring extreme planning, coordination and execution
  • Have presented OPTIM tool at the IBM IOD Conference

TECHNICAL SKILLS

HARDWARE: HP 3000, RS/6000, SOLARIS, IBM ES/9000, Z/OS, UNISYS 2200, IBM PC AND COMPATIBLES

OS: MVS S/370, S390, OS/2, UNIX - SOLARIS, LINUX, AIX, HP, WIN 98/NT

LANGUAGES: PERL, HIVE, ASP,L, JAVA, PL/SQL, DELPHI, COBOL, JCL, SQL, T-SQL,

DATABASES: DB2 UDB, NETEZZA, ORACLE, SQL SERVER, GREENPLUM, PARACCEL

TOOLS: ERWIN, TOAD, AGINITY, OPTIM PERFORMANCE MANAGER, SPUFI, WEBSPHERE INFORMATION INTEGRATOR, PVCS, VIASOFT, APACHE, CGI, SED, AWK, SED, MS EXCEL, MS WORD, MS ACCESS, MS VISIO, MQSERIES, HADOOP CLUSTERS, HDFS, MAPREDUCE

SECURITY: SSH, SSL, PGP

ADMIN TOOLS: SMIT, VMSTAT, IOSTAT, TOP, SAR, SMART DBA, DB2 PERFORMANCE EXPERT, SNAPVIEW, GREENPLUM PERFORMANCE MONITOR

NETWORKING: FTP, IFCONFIG, NETSTAT, HTTP, ETHTOOL

PROFESSIONAL EXPERIENCE

Confidential

TEAM MANAGER

Responsibilities:

  • Served as a Business Continuity Manager for Global Markets and Risk Technology domain
  • Established Baselines and standards for DB2, Netezza and Paraccel
  • Have worked with business data users to define the use of data within the risk application areas such as Arctic, Zinc, Market Risk, Liquidity Risk, Enterprise Credit Risk systems.
  • Involved in identifying and recommending remediation of control gaps and implement effective risk controls of our data processes and systems.
  • Involved in the design and architecture plan and hardware recommendation based on the Business Requirements
  • Led user acceptance testing of data control, quality, cleansing and archival processes by working with several groups.
  • Proactive monitoring of incoming data feeds and recommending optimal and efficient methods of storing data based on their data classifications.
  • Involved in the backup/restore from DB2 UDB utilizing TSM, Nebackup for SAN/NAS
  • Involved in the Design, Creation and Maintenance of DB2 Objects
  • Involved in the Configuration and administration of HADR, SQL and Q Replication
  • Involved in writing stored procedures and triggers for various requirements
  • Expert in System level Performance Tuning and helped Application Developers with SQL query optimization
  • Involved in establishing the database audit process across the bank
  • Involved in the database upgrades from 9.1 to 9.7 and 9.7 to 10.1
  • Have performed proof of concept for DB2 10.5 (BLU )
  • Involved in the Data Modeling utilizing ERWIN
  • Utilized Export, Import, Load, Reorg, Runstats
  • Utilized OPTIM for performance tuning in addition to script level repository
  • Utilized DB2 WLM for optimizing resources in the system
  • Involved in the Netezza Upgrades for OS, HPF, FDT and NPS upgrades from 4.6 to 6.0, 6.5, 7.0 and 7.1
  • Involved in Netezza administration, backup/restore, nz genstats, groom, vacuum etc.
  • Utilized NZLOAD, WLM, nzevent, nzresponders, schedqueues, performance tuning of SQL, database, skew and designing CBT’s, and various other tools.
  • Recommended best practices, tuned for star schema and dimensional modeling for Netezza
  • Recommended registry variables that can lead to performance improvements
  • Exploited Netezza WLM to throttle for resources in Netezza appliances depending on the day/night for ETL and user reporting
  • Involved in testing Netezza Replication
  • Involved in the Oracle database administration, performance tuning, Data Guard, RAC, backup and recovery, log, writing advanced PL/SQL, administration and management.

Confidential

SENIOR DATABASE ADMINISTRATOR

Responsibilities:

  • Involved in the DB2 UDB database administration and served as Onshore Coordinator for 40 plus applications, participated in SDI refresh of various applications. Documented and Established procedures for support and maintenance, backup and recovery, federation, MQT’s, replication etc. Also involved in creating PMR’s to work with vendors on issues and upgrades.
  • Involved in the backup/restore from DB2 UDB utilizing TSM on SAN
  • Involved in the Design, Creation and Maintenance of DB2 Objects
  • Involved in writing stored procedures and triggers for various requirements
  • Supported Application Developers with SQL query optimization
  • Involved in the Data Modeling utilizing ERWIN
  • Utilized Export, Import, Load, Reorg, Runstats

Confidential

SENIOR DATABASE ADMINISTRATOR

Responsibilities:

  • Involved in the backup/restore from DB2 UDB utilizing TSM on SAN
  • Involved in the Design, Creation and Maintenance of DB2 Objects
  • Involved in the Configuration and Monitoring of SQL Replication
  • Involved in writing stored procedures and triggers for various requirements
  • Supported Application Developers with SQL query optimization
  • Involved in the Data Modeling utilizing ERWIN
  • Utilized Export, Import, Load, Reorg, Runstats

Hire Now