resume

Harish Chander, Network/Server Administrator

9958463225 – harish.chander@hotmail.com - Gurgaon

Objective
Results-driven IT professional seeking a technical specialist position in the area of
OS/Networking/Storage” and To pursue a challenging career in an organization that gives me tremendous scope for professional improvement and an opportunity to contribute back to the organization and the professional to the best of my knowledge and abilities.

Technical Skills

Server - File/Application, SVN, PBX, FTP, Virtual Server, AD, PBX, Asterisk, VPN, DMZ, Radius, Mql Replication, Chat Server, Lync, IIS, LAMP, MAMP, Virtualizations, Hyper V, Mail server - Postfix, Mdaemon, Server Migration – Recovery, NagiOS, Cacti, LDAP.

Firewall - Squid, Cyberome, Clear OS, Net gear, Sonic wall, ACL, Load Balancing, Cisco ASDM Firewall, Scripting Shell/Perl

Security - Data Protector-Tape Drive, Licensing, Recovery, End Point Security, Viruses, Parental Control, Access Policy, Cisco ASDM, DMZ, VPN, AAA, Radius, RAID, SAMBHA, L3 Switch Router.

Cpanel - Domain Buying, Reselling, Sub hosting, WHM, Webhosting, Records, Rackspace, web intellects, Blue Host Go daddy, Dedicated Server, Google App hosting, AWS,

OS - Red Hat Linux / Centos / Ubuntu / Window Server 2003/2008/2012

Database Storage - MySQL, Mongo DB, Storage server - SAN, Raid.

Device - Device - IBM x340(7379), IBM x3650 M5Rack, HP

Krukshetra University - JIET, Jind Haryana - 2011

Bachelors of Technology in Computers

Certifications

·         MCSE (Microsoft) | Jul 2012 | Microsoft Certified Professional ID: E738-3580

●        Cisco Certified Network Associate [CCNA] (Cisco Systems, Inc.) | Oct 2011 | Cisco ID: CSCO12000202

●        A+ Grade Ducat | May 2011 | ID : 15149

●        C# ( NIIT ) | October 2010 | Certified Professional ID: 11CNZZZZZ0487

●        Ethical Hacking | Kyrion Digital Securities | June 2010

●        A + | C Language | May 2009 | Certificate No : 010908005860

●        RHCSA, RHEL & RHCA training has been completed successfully.

AdGlobal360 India Pvt Ltd                                                      Jan 2012  - June 2014 

Onsite & Remote Support – As Linux System Administrator.  Hand- on Working Experience on ISM and Escalation Matrix.

·         Firewall hardware/Software – Squid, Cyberome, Clear OS, Sonic wall.

·         Installation and configuration Linux for new build environment.

·         Configuration Installations of servers.

·         Virtual Machine administration on hypervisor OVM.

·         Database Administration on Various platforms like Linux and Windows server.

·         Adding Disks and creating Slices and File system Administration.

·         Disk replacement (Root disk / Data disk).

·         Configuring and monitoring Disk mirroring, striping using LVM.

·         NFS configuration & administration.

·         Managing upgrade of Linux and Windows Servers.

·         User Management & Administration.

·         LDAP / Linux Administration.

·         Ticket assessment on daily basis.

·         Swap space management.

·         Job Scheduling and Automating process using CRON & AT.

·         RAID configuration.

·         Installation of patches and packages.

·         Configuring and managing network interfaces.

·         Amazon AWS Virtual Server Management.

·         Security implementation by using ACL's & special file permissions.

·         Creating File system and configure to available network through NFS.

·         Monitoring system logs and root's email for important messages such as errors and
warnings or hardware failure errors.

·         Managing Disk File Systems, Server Performance, Users Creation and Granting file
access Permissions.

·         Creation of groups, adding User ID to a group as a primary or secondary group,
removing User ID from a group.

·         Mirroring of root disk in AIX and Linux.

·         Trouble shooting User's login & home directory related issues.

·         Managing (adding/removing) disks and partitions (LVM).

·         Samba Server configuration with Samba Clients.

Triple Dash InfoTech Pvt. Ltd                                            8 June 2011 to Dec 2012

·         Implementation of systems & scheduling automated and manual backups/restored to
take production data and archive log files backup.

·         Managing (adding/removing) disks partitions.

·         Performing system administration activities including installation, system monitoring,
configuration, troubleshooting.

·         Performing User ID creation, modification, deletion and maintain server security.

·         Monitoring system logs and the root's email for important messages such as errors and
warnings or hardware fail errors.

·         Monitoring/Installation/Troubleshooting/Backup of SAN Server.

·         Design / Installations all Kind of Software & IT Equipment’s.

·         Effectively resolving any networking related issues, Network Printers, Application related
issues

·         Troubleshooting of CISCO VPN client related issues.

·         Handling Domain related Issues.

·         Active Directory user ID creation, modification and deletion.

·         Installation of Antivirus and Troubleshooting with virus related issues.

·         CISCO router installation and configurations.

·         Installation & troubleshooting of IP Camera.

·         Installation of Active Directory Users and computers

·         Installation of Antivirus and Troubleshooting with Virus issues.

·         Troubleshooting with Software and Hardware.

Achievements

·         Microsoft Audit.

·         SQL Replication.

·         Radius Server.

·         Mail Server Migration.

·         AD/Network Design & Implement.

Extracurricular Achievements

Ø  Was active member of coordinating committee in various activities during college.

Ø  Have participated and won lot of prizes in Boxing.

Ø  Captain of college basketball team.

Ø  Third in coding test on C organized by IT HORIZONE.

Ø  Participated in various extracurricular activities in SOLO DANCING/SKIT.

Ø  First In Basketball Interdepartmental held by collage GOLD.

Ø  District Karate GOLD medalist.

Ø  11 open National Marshal Art GOLD  

Ø  CBSE School Federation Basketball Silver

Strength

• Know my work how to do perfectly and quickly
• Clear Communications & Reporting
• Have confidence to complete the assigned task within the
  scheduled time. Quick learner and Positive attitude.
• I have been consistent in my career objectives. My experience of Work has given me
  the confidence to adapt myself to the rapidly changing technology and to complete
  the assignments on time.
• I believe that you will provide me the opportunities to further develop the necessary
  skills needed for tomorrow's environment in the industry.

Personal Details

Father’s Name                                                Mr. Surander Singh                

Date of Birth                                                   08 JUL 1988

Marital Status                                                 Single

Sex                                                                    Male   

Nationality                                                       Indian

Language Known                                            English, Hindi

                                   

Certification

I, hereby certify that to the best of my knowledge and belief that these curriculum vitae Correctly describe my Qualification, experience and myself.

Date :

Place :                                                                                                          Harish

How To Set Up MySQL Master-Master Replication

MySQL replication is the process by which a single data set, stored in a MySQL database, will be live-copied to a second server. This configuration, called "master-slave" replication, is a typical setup. Our setup will be better than that, because master-master replication allows data to be copied from either server to the other one. This subtle but important difference allows us to perform mysql read or writes from either server. 

The examples Server A and Server B.

Server A: 10.0.0.1

Server B: 172.16.31.1

Step 1 - Install and Configure MySQL on Server A

The first thing we need to do is to install the mysql-server and mysql-client packages on our server. We can do that by typing the following:

sudo apt-get install mysql-server mysql-client

We need to edit /etc/mysql/my.cnf on Server A. There are four lines that we need to change, which are currently set to the following:

#server-id              = 1
#log_bin                = /var/log/mysql/mysql-bin.log
#binlog_do_db           = include_database_name
bind-address            = 127.0.0.1

We need to uncomment that line, by removing the "#" before it. The second line indicates the file in which changes to any mysql database or table will be logged.

server-id = 1

log_bin                 = /var/log/mysql/mysql-bin.log
binlog_do_db            = example
# bind-address          = 127.0.0.1

Now we need to restart mysql:

sudo service mysql restart

We can get to our root mysql user by typing the following:

mysql -u root -p 

mysql> 

Once we are logged in, we need to run a few commands.

create user 'harish'@'%' identified by 'password';

Next, we need to give this user permissions to replicate our mysql data:

grant replication slave on *.* to 'harish'@'%'; 

We will need to make note of:

show master status; 

The output will looking similiar to the following, and will have two pieces of critical information:

+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |      107 | example      |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

We need to make a note of the file and position which will be used in the next step.

Step 2 - Install and Configure MySQL on Server B

We need to repeat the same steps that we followed on Server A. First we need to install it, which we can do with the following command:

sudo apt-get install mysql-server mysql-client

We will start by editing the /etc/mysql/my.cnf file.

sudo nano /etc/mysql/my.cnf 

We need to change the same four lines in the configuration file as we changed earlier.

The defaults are listed below, followed by the changes we need to make.

#server-id              = 1
#log_bin                = /var/log/mysql/mysql-bin.log
#binlog_do_db           = include_database_name
bind-address            = 127.0.0.1

We need to change these four lines to match the lines below. Please note, that unlike Server A, the server-id for Server B cannot be set to 1.

server-id              = 2
log_bin                = /var/log/mysql/mysql-bin.log
binlog_do_db           = example
# bind-address         = 127.0.0.1

After you save and quit that file, you need to restart mysql:

sudo service mysql restart

It is time to go into the mysql shell and set some more configuration options.

mysql -u root -p 

Replace "password" with the password you wish to use.

create user 'harish'@'%' identified by 'password'; 

Next, we need to create the database that we are going to replicate.

create database example; 

And we need to give our newly created 'replication' user permissions to replicate it.

grant replication slave on *.* to 'harish'@'%'; 

The next step involves taking the information that we took a note of earlier and applying it to our mysql instance.

slave stop; 
CHANGE MASTER TO MASTER_HOST = '10.0.0.1', MASTER_USER = 'harish', MASTER_PASSWORD = 'password', MASTER_LOG_FILE = 'mysql-bin.000001', MASTER_LOG_POS = 107; 
slave start; 

You need to replace 'password' with the password that you have chosen for replication. Your values for MASTER_LOG_FILE and MASTER_LOG_POS may differ than those above. You should copy the values that "SHOW MASTER STATUS" returns on Server A.

The last thing we have to do before we complete the mysql master-master replication is to make note of the master log file and position to use to replicate in the other direction (from Server A to Server B).

We can do that by typing the following:

SHOW MASTER STATUS; 

The output will look similiar to the following:

+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000004 |      107 | example      |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

Take note of the file and position, as we will have to enter those on server C, to complete the two-way replication.

The next step will explain how to do that.

Step 3 - Completing Replication on Server A

Back on Server A, we need to finish configuring replication on the command line. Running this command will replicate all data from Server B.

 
slave stop; 
CHANGE MASTER TO MASTER_HOST = '172.16.31.1', MASTER_USER = 'harish', MASTER_PASSWORD = 'password', MASTER_LOG_FILE = 'mysql-bin.000004', MASTER_LOG_POS = 107; 
slave start; 

Keep in mind that your values may differ from those above. Please also replace the value of MASTER_PASSWORD with the password you created when setting up the replication user.

The output will look similiar to the following:

Query OK, 0 rows affected (0.01 sec)

The last thing to do is to test that replication is working on both VPS. The last step will explain an easy way to test this configuration.

Step 4 - Testing Master-Master Replication

We are going to test it now. To do this, we are going to Create/Delete a table in our example database on Server A and check on Server B to see if it shows up.

We now need to create the database that will be replicated between the servers. We can do that by typing the following at the mysql shell:

create database example; 

Once that's done, let's create a dummy table on Server C:

create table example.dummy (`id` varchar(10)); 

We now are going to check Server D to see if our table exists.

 
show tables in example; 

We should see output similiar to the following:

+-------------------+
| Tables_in_example |
+-------------------+
| micra             |
+-------------------+
1 row in set (0.00 sec)

The last test to do is to delete our dummy table from Server B. It should also be deleted from Server A.

We can do this by entering the following on Server B:

DROP TABLE mica; 

To confirm this, running the "show tables" command on Server C will show no tables:

Empty set (0.00 sec)

Note - Any Query please post happy to help.

How to Create Self Signed Certificate in Apache in CentOS

Intro - 

A SSL certificate is a way to encrypt a site's information and create a more secure connection. Additionally, the certificate can show the virtual private server's identification information to site visitors. Certificate Authorities can issue SSL certificates that verify the virtual server's details while a self-signed certificate has no 3rd party corroboration.

Step One—Install Mod SSL

In order to set up the self signed certificate, we first have to be sure that Apache and Mod SSL are installed on our VPS. You can install both with one command:

yum install mod_ssl

Step Two—Create a New Directory

Next, we need to create a new directory where we will store the server key and certificate

mkdir /etc/httpd/ssl 

Step Three—Create a Self Signed Certificate

When we request a new certificate, we can specify how long the certificate should remain valid by changing the 365 to the number of days we prefer. As it stands this certificate will expire after one year.

openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/httpd/ssl/apache.key -out /etc/httpd/ssl/apache.crt

With this command, we will be both creating the self-signed SSL certificate and the server key that protects it, and placing both of them into the new directory.

This command will prompt terminal to display a lists of fields that need to be filled in.

The most important line is "Common Name". Enter your official domain name here or, if you don't have one yet, your site's IP address.

You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:US
State or Province Name (full name) [Some-State]:New York
Locality Name (eg, city) []:NYC
Organization Name (eg, company) [Internet Widgits Pty Ltd]:Awesome Inc
Organizational Unit Name (eg, section) []:Dept of Merriment
Common Name (e.g. server FQDN or YOUR name) []:example.com                  
Email Address []:webmaster@awesomeinc.com

Step Four—Set Up the Certificate

Now we have all of the required components of the finished certificate.The next thing to do is to set up the virtual hosts to display the new certificate.

Open up the SSL config file:

 vi /etc/httpd/conf.d/ssl.conf

Find the section that begins with <VirtualHost _default_:443> and make some quick changes.

Uncomment the DocumentRoot and ServerName line and replace example.com with your DNS approved domain name or server IP address (it should be the same as the common name on the certificate):

 ServerName example.com:443

Find the following three lines, and make sure that they match the extensions below:

SSLEngine on
SSLCertificateFile /etc/httpd/ssl/apache.crt
SSLCertificateKeyFile /etc/httpd/ssl/apache.key 

Your virtual host is now all set up! Save and Exit out of the file.

Step Five—Restart Apache

You are done. Restarting the Apache server will reload it with all of your changes in place.

 /etc/init.d/httpd restart

In your browser, type https://youraddress to view the new certificate.