Database professional with extensive experience in database management and optimization. Proven ability to enhance system performance and ensure data security. Known for strong collaborative skills and adaptability to evolving project needs, leveraging deep knowledge of SQL, database tuning, and data backup processes.
Designed,developed,configured and managed DB systems .
Create database object,files systems and data storage.
Designed,developed,configured and managed DB systems .
Implemented enhancements that resulted to improve data system availability. Performing regular maintenance tasks such as vacuum,analyze,backup,restore,indexing strategies.
To make sure implementation methods are inline with company policies and any external regulation that may apply.
Regular database and OS patching for data protection regulation and internal policies.
Enabling the encryption to enforce security measures so that sensitive data can be protected which also is in compliance with company policies.
Extensive experience in problem analysis and troubleshooting database related issues.
Setting up monitoring alerts , database health and maintenance jobs in CRON. Knowledge of SQL and NO SQL database.
Database monitoring
Database management
Database administration
Backup and recovery
Relational databases
Running backups
Performance tuning
Database design
Database development
Database troubleshooting
Query optimization
Disaster recovery
Data migration
Linux operating system
Replication management
Patch management
NoSQL databases
Relational database management
Schema management
Data audits
Database backup
Databases:
IDMS, DB2 (AIX,LINUX), POSTGRES, SOLIDDB and SQL server. Cloud Platform: Microsoft Azure.
· 18+ years of DBA experience in IT industry and working in MasterCard Pune on POSTGRES, DB2 LUW & SOLIDDB DBs.
· Experience in database migration from AIX to Linux, on soil migration .
· Experience in modernization project from mainframe to DB2/POSTGRES.