I am currently working Lead DBA. Objective of the job is to ensure that DB operations are properly in lined and working properly as per organization's Service Level Agreement and to make sure that Databases are available 24/7.

• Performing pre-requisites for database migration
• Finalizing the road-map for migration
• Strong knowledge of various migration tools and options for MySQL DB migration.
• Experience managing Linux systems with configuration management tools such as Puppet chef, ansible etc.
• All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
• Responsible for database administration support for production, development, and test environments to include day-to-day monitoring and maintenance
• Implemeting HA solutions for MariaDB/MySQL
• Extensive experience with database backup, restoration, and migrations.
• Technical Trainings and presentation to different teams
• Automation of recurring Tasks
• Implementation of MySQL Cluster
• Experience working with Cloud Base solutions (Amazon, Azure etc).
• Experience in using Percona utilities
• Installation ,configuration and management of hadoop file-system
• Exploring NoSQL databases (Redis , Cassandra , Hive , Mongo etc)
• Collaborating with development, QA, DevOps and product teams to define requirements, conduct effective planning, and architect the design of optimal database solutions
• Manage database security, disaster recovery, and capacity planning.
• Monitor and ensure 24x7x365 databases availability and stable operation
• Ability to work with developers to troubleshoot and remediate challenging database problems.
• Managing and assigning tasks among the team and delegation of responsibilities

I am currently working in Ibex Global(TRG) as senior software Engineer-DB. Objective of the job is to ensure that DB operations are properly in lined and working properly as per organization's Service Level Agreement. To make sure that Databases are available 24/7. In case of any disaster/abnormality follow company's procedure to avoid any decline at database level.


➢ Working on MySQL,MSSQL, Amazon,MongoDB etc.
➢ Migrations from MySQL to MSSSQL and from MSSSQL to MySQL
➢ Managing and administration of multiple platforms(MySQL,MSSQL,RDS,MongoDB,MariaDB,PerconaDB etc)
➢ Experience in Working MySQL 5.5,5.6 and 5.7
➢ Experience in building different topological model for High Availability in multiple platforms(MSSSQL,MySQL,Informix etc)
➢ Experience of working on different OS (UNIX*,Windows)
➢ Experience of working with Bash/Batch/Perl etc
➢ Automation of different database administration related tasks
➢ Planning ,Preparing,installing and managing MSSQL (2005,2008,2012) & MySQL 5.5,5.6 and 5.7
➢ SQL Server Database Engine Management Tasks
➢ Administering the SQL Server Agent
➢ Developing Packages
➢ Creating a Project
➢ Enhancing Packages
➢ Deploying and Running Integration Services Packages
➢ Transferring Data with Integration Services
➢ Index Design and Strategy
➢ Backing Up and Recovering the Database Engine
➢ Point-In Time Recovery
➢ Introduction to Policy Based Management
➢ Concepts of Fail-Over Clustering
➢ Database Mirroring and Other High-Availability Alternatives
➢ Performance Tuning
➢ Database Troubleshooting and Optimization
➢ Using the SQL Server Profiler
➢ Using the Database Engine Tuning Advisor
➢ Experience in a 24X7 production environment

Senior Software Engineer-DBA

To ensure that DB operations are properly in lined and working properly as per organization's Service Level Agreement. To make sure that Databases are available 24/7. In case of any disaster/abnormality follow company's procedure to avoid any decline at database level.

I carry following skills

Informix

➢Evaluate the Database Server Hardware
➢Installation of informix on solaris,Linux platforms
➢configuration, upgrade, and migration on solaris,Linux platforms
➢ Database design and implementation
➢Memory Management
➢Managing OLTP and OLAP based systems
➢Physical logging, checkpoints, and fast recovery
➢Strategies for high availability and scalability
➢Point in time recovery
➢Manage disk space
➢Performance monitoring and tuning
➢Fail over and switch over strategies
➢Monitoring utilities

Mysql

➢Setting up different mysql installations on same machine
➢configuration, upgrade, and migration on solaris,Linux platforms
➢Strategies for high availability and scalability
➢Cluster management and configurations and administration
➢Backing Up, Copying, and Recovering MySQL Databases
➢Tuning the MySQL Server
➢Internal security: data and directory access
➢MySQL Database Maintenance and Repair
➢Mysql Enterprise backup utility
➢Level-0,Level-1 and Level-2 Backups
➢Mysql Monitoring agent


Oracle
➢Install the Oracle Database Software
➢Plan and open the Database
➢Back Up the Database
➢Plans and implements backup and recovery of the Oracle database
➢High Availability solutions
➢RMAN and data pump
➢Offline and online backup
➢Oracle Data Guard
➢Tune Database Performance
➢Managing Database Resources
➢Knowledge of physical database design
➢Oracle Enterprise Manager


Vecorwise/Ingres

➢Create and Open the Database
➢Back Up the Database
➢Plans and implements backup and recovery of the Vectorwise databases
➢Version up-gradation and migration
➢Performance Monitoring and tuning
➢Database check-pointing
➢Migration from different platforms to vectorwise

➢ Installation and troubleshooting of MySql
➢ Database Performance Tuning
➢ Maintenance of Data verification at CDB (Central Database)
➢ Defining standard procedures for migration activities
➢ Backup and restoration of different servers
➢ Application configuration and customizing according to the organization need
➢ Defining scope of an application
➢ Embedding new change objects within the already existing domain
➢ Conducting professional and user end trainings
➢ Strong understanding of application Work Flow
➢ Managing OS related issues within the domain of an application
➢ Operational skills at organizational level
➢ Strong understanding of Banking/Financial Systems
➢ Roll out of different objects
➢ User end related issues
➢ Communicating the application bugs to the concerned quarters and timely corrections.
➢ Migrating from one application to another application
➢ Handling of different routine
➢ Installation and configuration of different server services including DNS, NFS, DHCP, squid, samba
➢ Helping end user for developing better understanding of the system