Anthony Pinto Email & Phone Number

Bengaluru, Karnataka

Bengaluru Area, India

• Supporting around 500+ databases including Production, Development, Test, Sandbox & MQ with highest database size of 250TB+ which are hosted on Private CLOUD.• Working knowledge of Database architecture• Installation, Creation and Configuration of Databases on Linux.• Monitor database/Server performance to check everything is going.• Raising change request if there are any ongoing changes in respective environments as per client request.• Performing root cause… Show more • Supporting around 500+ databases including Production, Development, Test, Sandbox & MQ with highest database size of 250TB+ which are hosted on Private CLOUD.• Working knowledge of Database architecture• Installation, Creation and Configuration of Databases on Linux.• Monitor database/Server performance to check everything is going.• Raising change request if there are any ongoing changes in respective environments as per client request.• Performing root cause analysis on issues.• Setting up backups and restores, and in performing recovery as per client request.• Performing maintenance activities.• Working with Application team on database issues & performance issues.• DB2 installation and applying fix packs upgrades.• Backup and refresh activities.• Database maintains& troubleshooting activities.• Working with all database object level changes.• Resolving lock, deadlock issues.• Working with Utilities DB2look, Db2advise, db2explain, Db2move,db2inspect,db2dart, Export, Import, & operational utility.• Responsible for creating weekly deck. Show less

Banglore,India

Daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job issues, locking issues and scheduling administration activities.Ensure the successful implementation of the new code across the environments Dev, QA, UAT & Prod.Db2 installation & applying fix. Working in incidents with SLA. Managing SQL replication. Replicating & Extracting Data from Database.Creation and Administration of Tables, Indexes… Show more Daily support activities which include maintaining and testing backups, monitoring logs, monitoring thread activity, resolving job issues, locking issues and scheduling administration activities.Ensure the successful implementation of the new code across the environments Dev, QA, UAT & Prod.Db2 installation & applying fix. Working in incidents with SLA. Managing SQL replication. Replicating & Extracting Data from Database.Creation and Administration of Tables, Indexes, Database objects, Instances, Databases, Bufferpools and non-partitioned environment.Loading & updating the Data to DatabaseGranting access to Database Configuring the DatabasesDealing with user issues with respect to connecting databases & Resolving it(Using ticketing tool).Creating CHANGE REQUESTS for implementing various changes in Production environment.Monitoring loads from various data sources.Dealing issues with production loads.Data Analysis.Exporting,Importing & loading data. Show less

Bengaluru Area, India

Responsibilities:• Perform database maintenance activities such as backup, reorg, runstats.• Install and configure DB2 UDB new releases, upgrades, and patches.• Installation, monitoring, maintaining, troubleshooting, and tuning UDB databases• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.• Proactively monitor performance, diagnose problems and tune queries and… Show more Responsibilities:• Perform database maintenance activities such as backup, reorg, runstats.• Install and configure DB2 UDB new releases, upgrades, and patches.• Installation, monitoring, maintaining, troubleshooting, and tuning UDB databases• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.• Proactively monitor performance, diagnose problems and tune queries and database.• Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes)• Implement data security guidelines while making data available to those authorized to have access• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.• Perform capacity planning and analysis and implement required changes on the database server Show less