Anwar Carter Email and Phone Number

Supported Legacy Mainframe Databases and New Database installations.Provided support to tax system databases that contained both federal and state tax information.Served as primary database support for DB2 on Z series Mainframe in production environment.Performed Table Reorgs, Indexing, Table Partitioning, Performance Tuning, Automation and Scheduling of tasks in Zeke with extensive use of JCL, Easytrieve and Rexx.Data Analysis and database management Maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning (Logical) Administration of application objects within database; maintenance of business requirements for database, database schema, data maps, ERDs, application objects, performance of database application tuning; provision of business and data requirements and data for capacity planning.

Creating, developing and reviewing the physical model created from the logical model, ensuring the detailed physical design of data structures complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, maintenance, and efficiency [DB2 on z/OS]Reviewing overall physical database structures for data integrity, performance quality, recoverability, maintenance and space requirement considerationsClosely monitoring RDBMS performance, identifying problems and implementing solutionsVerifying implementation of correct backup strategyExecute recovery procedures, including recovery from loss of dataUsing tools to reorganize or defragment database table spaces, tables and indexesProviding efficient database environment to maximize productivity and improve performanceMonitoring file system space, database allocation, etc.Communicating complex technical information in a concise and articulate mannerConducting application transaction volume and traffic analysis and interpreting impact on database and network performanceInteracting with analysts and developers, understanding system requirements from conceptual models, analyzing transactions and data volumes, and designing the logical/physical databaseWork closely with various Infrastructure and Support teams to resolve problems and answer questionsBusiness Continuity planning and testingParticipate in 24 x 7 on-call rotationWork within production change control guidelines and processes

Develop and executive (DDL) to support projectsData refresh using Pre and Post trial image copiesBackup and Recovery of DB2 ObjectsRunning online and standalone utilitiesCompare and migration of structures of different environmentsRemoving the restriction of pending status against DB2 objects Reorganization of Tablespace and collecting statistics using RunstatsPackaging approval and creation Unloading, loading the database and collecting statistics for the sameDatabase performance tuning using DB2 Explain utilitiesAuthorization and privileges for DB2 accessUsage of DB Catalogs