| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email EMAIL AVAILABLEPHONE NUMBER AVAILABLECertified OralceStreet Address G, DB2 UDB V9, PostgreSQL9.6 DBA & AIX System Admin.SUMMARY:More than 27 years of experience in Software Analysis, design, development, testing and implementation.Specializing in developing Application Software using IBM Mainframes, RDBMS and Client /Server environment.For more than 19 years, I am being involved in managing the database administration including Oracle7/8/8i/9i/10g/11g, DB2 UDB 6/7./8.X/9,10.5/11.x & DB2 on RDBMSs on HP UNIX, Sun Solaris, and AIX & Z/OS.Experienced in Infrastructure Deployment Installation, Configuration and Administration of ERP Applications such as PeopleSoft 8.3 HRMS 8.8, FIN8.1x/8.44, and PeopleSoft 8.1 x Supply Chain Management, EPM, Portal, Student Admin 8.21, and CRM 8.8/9.0/9.2 with Oracle 9i/10g/11g/12C DB2 UDB /DB2 V6/7/8 on OS/390 as backend in multi-platform environments.Around two year experience on Amazon Web Services (AWS), have experience with PostgreSQL Admin .Migration from onPrem to cloud AWS, AzureBuild DB2 LUW on AWS EC2 instance and RDSSKILLS:HardwareRS/6000 SP & Pseries, E Series, Power 5 Servers, SUNW sparc,ESS-800, DS4800,DS6800,DS8000,Ultra-Enterprise,HP Tru64, EMC CLARiion CX series. Dell 1650,6650, Dell PowerEdge 1950,2900, Blade Servers HS20-21Operating SystemsWindows NT/2000 to 2012,MVS, Z/OS,AS/400, HP/UX 10.0, Sun Solaris 8/9/10, AIX 4.3/5.3,6.x/7.x, Linux 4 to 7RDBMSOracle 7/8/8i/9i/10g/11g/12c,18c,19c, DB2 UDB V6.1/7.x/8.x/9/10/11 & DB2 V4,5,6,7,8,9,10 OS/390/Z/OS, DB2 i Series,SQLServer2000/2005/2008/2012, Informix, SYBASEOSRDBMSPostgreSQLRDSOracle,MYSQL,PostgreSQL,SQL ServerCloud SolutionAmazon Web Services (AWS ), Microsoft Azure, Google & IBM SoftLayerBig DataMongoDB, HadoopERPPeopleSoft 8.14 (Supply Chain Management), PeopleSoft8.3, HRMS 8.8/8.9,Student Admin 8.42,9.0, EMP,Portal 8.4,9.0, 9.1 CRM PeopleSoft design tools, PSADMIN, Data mover, query, upgrade Assistant, Seibel V7.x,SAP V 3/4.6, DBACockpit,SAP DB2Admin, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS Utilities, Lawson HCMClustering ToolsIBM HACMP 5.1, TSA, Xkoto GridScaleServer, EMC, Veritas Clustering,Flash Copy, Peer to Peer remote Copy(PPRC), Oracle RAC ( Real Application Cluster),DataGaurd,ASM, Quest SharePlex for Oracle, DataGuardDisaster RecoveryVMWare Tools, IBM Tivoli Storage Management(TSM), Flash Copy, Peer to Peer Remote Copy(PPRC)/, EMC SnapView,MirrorView, Sun's StorageTek Virtual Storage Manager (VSM). VERITASWebServesIBM Web Sphere, BEA WebLogic,IIS, iPlanet, Oracle 10G application ServerConnectivity ToolIBM DB2 Connect, Relational Connect, Oracle GatewayReplication ToolData Propagator,DB2 Replication Center (SQL Replications, Q Replications), WebSphere ( information integrator), Oracle Streams,IBM InfoSphere Replication, GoldenGate, IBM CDCDBA Tools for OraclePlatinum DBvision, Tsreog, BMC Patrol, SQL Backtrac, Oracle, Enterprise Manager, RMAN, Import, Export, Oracle Data Guard, Flash Back, Automate Storage Management(ASM), Grid Control, DBCA,DBUA,SQL*Loader, SQL*DBA, Replication Manager, Quest Database Admin Tools, Oracle Ware House BuilderDB2 OS/390 toolsPlatinum Database Analyzer, Plan Analyzer, Subsystem Analyzer,SQL Easy, RC/Migrator, RC/Security, Log Analyzer, CA Unicenter, CA7DB2 UDB toolsBMC Patrol for DB2 UDB, IBM Relational Connect, DB2 Connect, Data Propagator, Quest Central for DB2 UDB/, BMC Web DBA,DGI SQL Guy, Wise Guy, MQ Series,IBM Data Studio .Data WarehousingOracle Discoverer, Oracle Express, IBM InfoSphere,Informatica Power Center & Cloud, MicroStrategy, Cognos, SnowflakeDesignDesigner 2000, Erwin, ER - StudioFront EndDeveloper 2000 - Forms 4.5, Reports 2.5, Graphics 2.5, Power builder 5.0LanguagesCOBOL, C, Pro*C, JCL, Perl, PythonCERTIFICATION:Oralce10G, DB2 UDB V9, PostgreSQL DBA & AIX System Admin.INDEPTH EXPERIENCE AND EXPERT KNOWLEDGERDBMS DBA supportSr. DB2 LUW DBA /ArchitectSr. DB2 Z/OS DBASr. DB2 DBA AS/400Sr. Oracle DBA/ArchitectSr. SQLServer DBASr. PostgreSQL DBA on AWS, Azure / for migrationERP solutionPeopleSoft Admin/Architect ( Install, upgrade & Migration )SAP Basis SupportWORK EXPERIENCEDB2 LUW DBA CITI from 2020 Jan to July24Install, fix pack apply for DB2 LUW from version 10.5 to 11.5 on AIX and Linux.Build and automate HADR using DB2 cluster Manager (db2cm), that also called as pacemaker .Build scripts to monitor DB health check, memory and CPU usage, locks, long running application, expensive SQL schedule as cron job on AIX, also using ContrlM scheduleling utilitiesBuild and schedule cron jobDatabase maintenance monitoring and alert automation including fragmented tables and indexes send notificationDB2 LUW, Z/OS and Oracle DBA for Health interactive Cloud for multiple states May18 to 2019 DecDeploy Health Interactive Cloud on IBM cloud ( SoftLayer) Linux 7.2 DB2 V10.5,V11, including DB2 Docker container, DB2 warehouse.Build environment automation using Jenkins automation, this including install binaries, instance creation, DB cloning from source backup using db2relocatedb and redirect restoreDeploy Backup as per SLA Retention policies, DB health check, alert automation( Instance, DB status, resource usage, memory,long running SQL, db2dia.log critical, severe, error message )Deploy Data Encryption at transits ( TLS 1.2) Data at rest using DB2 native encryption for standalone and HADR environments.Automate DB maintenance ( RUNSTATS, REORG, rebind, object validation ) using shell scripting and store proceduresPerformance tuning, troubleshooting & user supporting .Database Architect in Health care industry DB2 LUW V10.5/11 on Linux IBM cloud .Which includes getting the requirements from the client, estimate required resource, build plan, work with infrastructure team, build the environment, automation of deployment, as perHealth care SLA design backup & recovery plan.Setup 99.99 to 99.999 availability, 3 hours RPO and 15 RTO DR plan.Build health care solution deployment for 10 states, which including OH, WY,VA,KY,MI,MT statesBuilding SQL standard for development teamAnalyze SQL and program units procedures and function and triggers, make sure SQL written optimized wayOptimizing and tuning old procedures like replace UNION and UNINION ALL with case statements, avoid not condition, reduce outter join as much as possible.Conduction knowledge sharing session with development to build code with best optimized way, avoid cartesian join and full table scans.Environment :DB2 LUW V10.5/11.1/11.5 Fix pack 10, DB2 Z/OS V11, Oracle 11g and 12c on IBM cloud SoftLayer and RHEL V7.2.DB2 LUW DBA & Oracle DBA for Different Clients June16 to April18Global Foundries, Tyco, FLBCBSDB2 LUW DBA On AIX & LinuxGathering Hosting Data center details.Build scripts extract following details at hosting data centerServer ConfigurationBased on extracted details, estimate required resource hardware, memory, disk spaceBuild scripts build environment from extracted details from hosting data center.Re-catalog instance node from hosting hostname to client hostnameMigration of 2000 DB2 instance - some of them as lift and shift, change hostname, change network change from hosting to client network. Re-catalog node with new hostname .build servers, software, create instance, build database from hosting database backup, catalog instance & DB with new hostname .Migration from DB2 V9.7/10.5 on AIX 7.1 to Linux V7.1Configure HADR & HACMP for different application as per nature of the application.Support and maintenance DB2 LUW environment from V9.5 to 10.5 on AIX V6/7 and on Linux .Setup DPF environment 4 Physical 6 logical nodesCreate maintaining MDC, Partition tables in DPF environment.Setup Q and SQL Replications single & bi directional for different source and target on AIX and Linux environment.Upgrade DB2 from V9.7 to 10.5 /11 on AIX V7.1Design, setup Backup and Recovery using TSM.DR site with flash copy and using snapshot backup.Build Scripts to automate environment monitoring & maintenance using db2pd, db2batch, db2advisor, db2diag and admin view ( SYSIBMADM)Maintaining including RUNSTATS, REORGDesign Backup incremental, Delta and full back up as per SLA, design DB archive, purging.Building SQL standards for devilment team to write code best optimized wayTuning programing units procedures, function, triggers SQL statements by running explain, run index advisor ( db2advis), use global temporary tables instead in sight views, avoid sorting as much as possible, reduce I/O, keep most frequently used lookup tables in buffer .Did Multiple migration DB2 Z/OS environment to DB2 LUW on RHELEnvironment :Oracle10gR2 on Aix 5.3, Oracle12c on Red Hat Enterprise Linux,Baan ERP V5SiView, DB2 Z/OS 10, DB2 LUW V9.5 to 10.5 on AIX V6 & V7, HARD, HACMP, TSMIBM xSeries & pSeries Serves DS6400 storage, Cisco Unicenter with EMX Vmax storage.Beacon Spyglass, Indianapolis, IN Feb14- Jan16 (support Multiple Clients)DB2 DBAPerformance tuning by analyzing snapshot of DBM, DB, BP, TBS, Table, Application and locks and expensive SQL statements.Based on record length, activity of the table moves tables into bigger page size, its own tablespacesBuild scripts to automate database maintenance like RUNSTATS, REORG, bind packages, validate & recompile programing units (Procedures, Functions, Triggers)Create 12 logical node database with 4 BP and 4 tablespaces with 20 tables, load data into tables up to 20M records into tablesImplemented incremental & delta backupMerger all delta backup instead of taking full backupInstall & configure DB2 high performance unload design test case & testedUnload large table from tablespaces, extract data from DB backup, recover drop table from DB backupMigrate whole database from one server to another.Design and implementation of backup recovery strategySetup HADRSetup and build DPF environment, install, configure & testing merge backup, high performance unload and recovery expert.Build, Supporting & maintaining Pure Scale clustering environmentsSetup 2 node Purescale environment on AIX with TSA and DS series storageWork with System & storage team to design & build GPFS volume groupsConfigure & setupReliable Scalable Cluster Technology (RSCT)Resource monitoring and control (RMC) subsystemRSCT core resource managersRSCT cluster security servicesTopology Services subsystemGroup Services subsystemConfigure & work with Cluster Cache Facility (CF)Environment :DB2 V10.5 on Linux, DB2 V10.5 DPF, Fix Pack 5 on AIX, Tomcat, Websphere, SAPIBM xSeries & pSeries Serves DS6400 storage, Merge Backup, High Performance Unload,PurescaleOracle 10gR2, 11gR2 on Linux with RAC 3 nodes.University of Texas, Arlington, TX Jan12 to Oct14PeopleSoft Oracle DBA/ System adminPeopleSoft modules HCM, CRM, Financial, EPM PeopleSoft tool upgrade to 8.51.15Applying PeopleSoft Bundles, patches, TAX update to update using change assistant .Web logic upgrade to 10.3.5Oracle upgrade from 11.2.0.2 to 11.2.0.5, apply critical patchesAs part of consolidation all campus of the environment and upgrade building all new environments for all PeopleSoft modules.Setup Integration Broker Gateway server and agents and single sign on for all environments.Environment re-fresh environment to environment, production to test and development as per user requirements using RMAN duplication and file system levelAutomated Environment monitoring for PeopleSoft and Oracle database, disk spaces and resource usage, alerts .Building scripts startup and shutdown the environments including database, application, batch and web server.Database backup and recovery strategy and implementing physical and logical backup using RMAN and data pump.Managing Oracle RAC with 2 nodes for all production database on Linux Dell PowerEdge R7 and Qlogic storage .Maintaining and supporting non- production environment.Performance tuning at database, application side and SQL tuning using Oracle GRID control, AWR, ADDM, tuning packages .Implemented horizontal slicing of an Oracle Exalogic machine quarter rack for Oracle Solaris and Oracle Linux physical environments.Environment :-PeopleSoft FSCM, HCM, CRM, EMP 9.1 and Campus Solution 9.0/9.1, tools 8.51.05/8.51.15 on Oracle 11gR2 Linux and AIX People, IBM P575 Servers and VMware ESX4.1 and Qlogic storage, TSM for tape managements, Quest STAT for change management, Exalogic 3.2, CA WA ESPAgrex Inc, Overland Park, KS March11 Dec11.PeopleSoft SysAdmin/Architect.Environment :PsoftSoft FCM 9.1, tools 9.51 on DB2 V9.7 on Windows 2008 R2, WebLogic 10.3IBM x series Serves DS3400 storage, VMware ESX4.1DST System Oracle Consulting Jan11 to Feb11Senior Consultant Oracle USA, Inc.(Advanced Technology Services).Environment :-PeopleSoft FSCM 8.9/9.1 People tools 8.49/8.50 on DB2 LUW V9.5 bits on AIX 5.3 P570, spark servers (880,480).College of Lake County,Chicago, IL Feb09 to Dec10Sr. PeopleSoft DB2 DBADB2 upgrade from V7.2 to V9.5 and PeopleSoft upgrade from 8.8 to 9.0Environment :PeopleSoft HRSM 8.8, EPM 8.46, People Tools 8.46DB2 V7.2/9.5 on AIX 5.3 on IBM DS4700 storage with SVC, P5 and P6 serversUniversity of North Dakota, Grand Forks, ND Jan 2008 to Jan09System Architect/Sr PeopleSoft Oracle DBAEnvironment :Oracle10g/11g,SQL Server 2005 on windows 2003 for PeopleSoft Student Admin 8.21/9.0, People Tool 8.43/8.49, Tuxedo V8/9, Change Assistant,Data Mover, PS Query, PeopleSoft Application designer, WebLogic V8/9,VMware ESX,DS6400 storage, with IBM TSMUniversity of Florida, Gainesville,FL June 2007 to Dec 07System Architect/Sr. PeopleSoft DB2/Oracle DBAEnvironment :PeopleSoft Financial, HRMS, EPM 8.8/9.0 people tool 8.46/8.48,WebLogic version 8/9,Oracle 10g Application Server, Informatica, Cognos,tuxedo 8.1, DB2 UDB version 8.2/9.1,Oracle10g release 2.03, Oracle Gateways, SQL Server 2000/2005 on Win 2003, SuSE Linux version 10,IBM BladeServer HS20-21,DS4800,DS8000,EMC CLARiiON CX300/700 3-40, SnapView,SnapMirror, SnapCLone, SnapCopy, IBM P650,P630 servers,Scholastic Book Fairs, Lake Mary, FL Jan 2007 to May07PeopleSoft Oracle/DB2 /SQL Server DBAEnvironment :PeopleSoft CRM version 8.8/9.0 people tool 8.46/8.48,Web Sphere version 5.x/6, Oracle 10g Application Server, tuxedo 8.1, DB2 UDB version 8.2,, Oracle10g release 2.3, SQL Server 2005, DB2 V5.1 on AS/400,AS/400,Windows 2003, SuSE Linux V10,Dell 1650,6650, PowerEdge 1950,2900Florida A&M University, Tallahassee,FL Jan 2004 to 2006 NovSr. PeopleSoft Oracle /DB2 UDB DBA / System ArchitectEnvironment :RS 6000 ESS 800,DS8000,pSeries 690, 650,630s, AIX 5.2/5.3,DB2 on OS/390,WIN Tivoli storage Manager, HACMP, IBM Flash Copy, Peer-to-Peer Remote Copy,DB2 UDB V7/8.2.x, Oracle 9i/10g,SQLServer2000/05 PeopleSoft Student Admin V8.21, Financial 8.43, HRMS 8.9,Portal 8.44, EPM, CRM, Seibel V7.X, App designer, Data Mover, upgrade assistant, WebLogic V5/6/7/8.YUM Brand, Louisville,KY Sept 2003 to Dec03Verizon, Irving,TX Jun 2003 to Sept03Sun Solaris V8, WebLogic 6 & 7, IPlanet Admin, Oracle 8i/9i & DB2 UDB V8 DBAWorld Savings, San Antonia, TX Oct 2002 to May 03DB2 UDB DBA & Data Warehouse ArchitectBelk Inc., Charlotte, NC June 2002 to Sept02Environment:DB2 7.1 on OS/390, PeopleSoft HRMS 8.3, People Tools 8.118, AIX 4.3 on RS/6000, DB2 Connect Enterprise Edition 7.2 PK 7, DB2 Connect personal edition 7.2, Web Server IIS, Bea WebLogic, Win2k Load Balancing Cluster, TUXEDOSprint North Supply, Garner, KS, USA Jan 2001 to March 2002DB2 UDB EE DBA on PeopleSoft8 Primary,DB2 UDB DBA EE for CRM Seibel & WebLogic as secondaryDB2 UBD EEE for Data warehouse ProjectEDUCATIONB.Sc. 1989 from Venkateshwara University, Tirupati AP, IndiaPGDCA 1991 from Nagarjuna University, Nagarjuna Nagar AP, India |
