Jitender Kumar Singh Email and Phone Number

• Configure and support MS-SQL database Mirroring, Replication, Log Shipping and AlwaysON• Monitor and optimize MS-SQL database performance and capacity planning.• Troubleshoot database issues, maintain database systems availability and scalability. • Develop and optimize database design for new applications.• Installation & Configuration of MSSQL Database engine.• Configuring multiple instances of MSSQL instances on single Host.• Configuring data directory, backup… Show more • Configure and support MS-SQL database Mirroring, Replication, Log Shipping and AlwaysON• Monitor and optimize MS-SQL database performance and capacity planning.• Troubleshoot database issues, maintain database systems availability and scalability. • Develop and optimize database design for new applications.• Installation & Configuration of MSSQL Database engine.• Configuring multiple instances of MSSQL instances on single Host.• Configuring data directory, backup directory, log directory for MSSQL database engine.• Manage User account and privileges.• Install, Configure and support MSSQL high availability environment. • Monitor and optimize MSSQL database performance.Kick started MySQL for E-Business Suite and developed best practices on Amazon cloud.Developed patching, cloning and backup strategy for MySQL 5.6 on Amazon EC2 Cloud.Developed strategy for cloud/virtualization migration and implementation best practices.Helped to develop backup and recovery strategy for applications and database on virtualization platform.Set up the test servers on Amazon for MySQL/MSSQL databases using AMIs. Show less

--Server startup/shutdown--Mastering the mysqladmin administrative client--Using the mysql interactive client--User account maintenance--Replication (Master to Master & Master to Slave)--Log file maintenance--Database backup/copying--Multiple server setups--Software updates and upgrades--File system security--Server security--Repair and maintenance--Crash recovery--Preventive maintenance--Understanding the mysqld server… Show more --Server startup/shutdown--Mastering the mysqladmin administrative client--Using the mysql interactive client--User account maintenance--Replication (Master to Master & Master to Slave)--Log file maintenance--Database backup/copying--Multiple server setups--Software updates and upgrades--File system security--Server security--Repair and maintenance--Crash recovery--Preventive maintenance--Understanding the mysqld server daemon--Performance analysis--Table Pertitioning--Installing Perl DBI support--Installing PHP--Installing Apache--Installing MongoDB--Manage database on MongoDB Show less

Key responsibilities.... as DBA--Obtaining and Installing MySQL--Starting Up and Shutting Down the MySQL Server--Securing a new MySQL installation--Managing MySQL User Accounts--Maintaining MySQL Log Files,Backing Up, Copying, and Recovering MySQL Databases--Tuning the MySQL Server--Running Multiple MySQL Servers--Updating MySQL,MySQL Security--MySQL Database Maintenance and Repair.

Creating web application using JSP, SERVLET, EJB. Running application, troubleshooting, Maintenance. Also Looking databases server and their performance.