Experience

• 

  Kinetic communication ltd. chinchwad,pune

  Jul 2004 - May 2007

  Oracle dba

  As Oracle Database Administrator was responsible for:• Installing Oracle 8i, 9i on Linux/Unix. • Upgrading databases from Oracle 8i to 9i. • Planning of backup and recovery. • Creating and managing Standby database servers. Physical and logical database storage, user and database security management.• Space monitoring & management of tablespaces and schema objects• Applying oracle patches.• Writing UNIX scripts for cleaning Database alerts, Messages and trace files.• Day end, Month end processing jobs monitoring & troubleshooting• Installing SCO-Unix 5.0, SCO-UnixWare 7, Red Hat Linux 8.Functional, PL/SQL experience:As a Programmer responsible for Analyses data, participates in the design and implementation of databases, develops front end using user interface objects for database interaction using tools SQL Forms30, ReportWriter 1.1 on Unix. Experience in constructing modules like Vehicle Dispatch System, Budget Control & Purchase Order System, Loan Material Accounting System, and Despatch store system.As a Programmer participated in. Develop front end user interface object for database interaction. Participates in the design and implementation of data bases. Participates in the customization and implementation of system. Participate in creating various database packages, procedures, functions, triggers, PL/SQL scripts, Database views.. Writing simple and complex queries. Testing of user interface, generate test dataDomain Skills: Vehicle Manufacturing, Engineering. Show less

• 

  S1 corporation

  May 2007 - Feb 2012

  As a DB2 Database Administrator responsible for:• Planning and estimation of the DBA work and managing the DBA resource • Providing database server storage configuration details and storage requirements• Writing database scripts, migration scripts as per business requirements. Review of the other team members code.• Monitoring database server for system resource usage & storage usage and databases for errors/warnings & performance• Creating and maintaining development and QA databases using DB2 backup, restore, database recoveries, export, import and db2look. • Creating and maintaining the Physical structure of the databases and data dictionary. • Creating and managing users and privileges. • Catalog, uncatalog Nodes, databases using db2ca and command prompt on server as well as client side. • Setting the Cron jobs for daily database operations and for application reports• Perform database performance tuning of ACI applications at Kbank, SCB and MayBank• Working with the architects who are designing our applications for database design• DB Scripts review and tuning. Maintaining the DB scripts.• Support software developers for application development• Continuously monitoring the databases for performance problems and resolving the issuesAs Data Migration Lead responsible for:• Planning and estimation of the DBA work• Providing database server storage configuration details and storage requirements for Data migration• Technical design of the data migration• Data migration Scripting• Performance tuning of the data migration and reconcilation reports• Working with the architects for table and column mapping• Maintaining the Data migration scripts.• Packaging, delivering and execution of the data migration scripts on different environments including Production• Troubleshooting data migration and reconcilation issues Show less As a DB2 Database Administrator responsible for:• Installing DB2 8, 9.5, applying fix packs on AIX, Windows.• Upgradation of DB2 databases between different versions. • Creating and maintaining instances and changing different configuration parameters. • Creating and maintaining development and QA databases using DB2 backup, restore, export, import and db2look. • Designing, creating and maintaining the databases and changing different configuration parameters for performance tuning. • Creating and maintaining the Physical structure of the databases and data dictionary. • Creating and managing users and privileges. • Catalog, uncatalog Nodes, databases using db2ca and command prompt on server as well as client side. • Maintaining databases as a performance point of view by creating and running RUNSTATS/REORG on tables and indexes. Domain Skills: Insurance, Banking. Show less

  • Sr. Database Administrator and Data Migration Technical Lead

    Feb 2009 - Feb 2012

  • DB2 DBA

    May 2007 - Feb 2009
• 

  Aci worldwide

  Feb 2012 - now

  As a DB2 Database Engineer responsible for:• Planning and estimation of the DBA work and managing the DBA resource • Writing database scripts, migration scripts as per business requirements. Review of the other team members code.• Providing database server storage configuration details and storage requirements• Monitoring database server for system resource usage & storage usage and databases for errors/warnings & performance• Creating and maintaining development and QA databases using DB2 backup, restore, database recoveries, export, import and db2look. • Creating and maintaining the Physical structure of the databases and data dictionary. • Creating and managing users and privileges. • Catalog, uncatalog Nodes, databases using db2ca and command prompt on server as well as client side. • Setting the Cron jobs for daily database operations and for application reports• Perform database performance tuning of ACI applications at Kbank, SCB and MayBank• Working with the architects who are designing our applications for database design• DB Scripts review and tuning. Maintaining the DB scripts.• Support software developers for application development• Continuously monitoring the databases for performance problems and resolving the issuesAs Data Migration Lead responsible for:• Planning and estimation of the DBA work and managing the DBA resource for Data migration• Providing database server storage configuration details and storage requirements for Data migration• Technical design of the data migration• Data migration Scripting• Performance tuning of the data migration and reconcilation reports• Working with the architects for table and column mapping• Maintaining the Data migration scripts.• Packaging, delivering and execution of the data migration scripts on different environments including Production• Troubleshooting data migration and reconcilation issues Show less

  • Database Architecture and Engineering

    Apr 2017 - now

  • Sr Database Engineer and Migration lead

    Aug 2014 - now

  • Sr. Database Engineer and Data Migration Lead

    Feb 2012 - Jul 2014
• 

  Dragonfly financial technologies

  Jan 2024 - now

  • Senior Database Specialist

    Sept 2022 - now

  • Principal Database Engineer

    Jan 2024 - Jan 2025
• 

  Fis

  Jan 2025 - now

  Principal database engineer