DB2 and AS400 Admin

2 weeks ago

Boca Raton, United States Omni Inclusive Full time
Job Description:
  • Database Administrator on the iSeries/As400
  • Setup and configure Data Mirror High Availability on the iSeries. Performance tuning and day to day maintenance of the iSeries DB2 database. Configuring alerts for Tivoli monitoring for DB2.
  • Analysis, Design and Programming on the iSeries (AS400)
  • Systems. Enhancing Scan out systems and designing and implementing automated ftp processes with enhanced auto recovery.
  • Designing programming and performance testing a Distributed database across an AS400 Network. Analyzing AS/400 performance, providing technical assistance with capacity planning.
  • Assignments included developing in-house Multi-Language Enablement tools. Provided technical expertise at client sites and managed Infomag Consultants.
    Designed and programmed AS400 Synon Order entry system and other support systems for order entry.
  • Setting up SQL Triggers, managing security, setting up and supporting Data Mirror Transformation Server and Data Mirror High Availability. Journal maintenance, backup and recovery, SQL table design. Provided technical support for database related issues.
  • Data replication configuration and maintenance using Mimix. LPAR monitoring and management. Deployed IBM i System upgrades to 6.1 and 7.1 of IBM i OS together with third party product upgrades. Developed system dashboard for IBM i monitoring and load testing.
  • Implemented column level Encryption on the IBM I DB2 database. Deployed Net IQ and Bsafe Security solutions
  • IBM I Database and Performance monitoring using IBM iDoctor Job watcher and Performance Navigator. Developer SQL analysis and review.
  • SQL Deployments and Journal Management. Developed automatic Journal management system using an audit journal scraper to automatically journal tables.
  • Automated SQL plan Cache Reporting. Developed automated alter table and multi-threaded copy process to speed table alters for SQL.
  • Developing fully automated table reorganization process to run Reorg while active. Involved in Power 9 with Vios and LPM and SRR upgrade project.
  • Monitoring and managing SQL Server databases within the Data management department. Installed and configured SQL 2000 and 2005.
  • Carried out performance tuning and trouble shooting, Carried out backup and recovery.
  • Configured and maintained Data Mirror Transformation Services. Installed and configured DB2 on AIX and Windows and developed the implementation strategy for DB2. Worked to configure Tivoli storage manager to work with DB2 on AIX and windows.
  • Experience using DMS and SMS databases. Configured and installed Tivoli monitoring for Databases on SQL Server and DB2.
  • Project and Technical lead for the deployment of new Power 6 hardware and the V5R4 IBM i to V6R1 IBM i OS upgrade. Project and Technical lead for the migration of WEA's data warehouse from the development partition to a stand alone production partition. Implemented Single Signon solution on the IBM i. Implemented IBM InfoPrint, automated PDF emailing and SharePoint distribution services from the IBM i.
  • IBM DB2 UDB V8.1 Family Fundamentals
  • 070-229 SQL Server 2000 Database Design and Implementation
  • 070-228 Installing, Configuring and Administering Microsoft SQL Server 2000