Database Administrator (DBA)

Database Administrator (DBA)

EDUCATION,EXPERIENCE REQUIRED:

BE/MCA/ B.TECH / BCA

Exp -  Min 4 yrs  

CTC – Upto 12 LPA

Job Description:

1. Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2005/2008/2008R2/2012/2014/2016
2. Database administration activities like Installation, Configuration, Backup & Recovery, and Database Security.
3. Providing availability solutions like Mirroring, Log Shipping, Replication and Always on.
4. Database Up gradation and Migration
5. Ensure performance monitoring, backup, restore, and security recovery solutions.
6. Troubleshooting expertise in SQL server issues under production environment.
7. Handling the entire production servers with skills and understanding client's requirement Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
8. Automating process by creating jobs, and error reporting using Alerts by SQL Server Agent.
9. Backup and Recovery strategy, Database Refreshes.
10. Creation and maintenance of Databases, creating Roles and managing user permissions.
11. Setting up, trouble shooting and maintenance of production server databases.
12. Providing Production support for Database and Applications.
13. SQL Server store procedure, functions, View, Index and trigger development.

 

Job requirement:

1. Deep understanding of OS and its management including kernel space management
2. Experience with Linux servers in virtualized environments
3. Experience installing, configuring, and maintaining services such as Bind, Apache, MySQL, Nginx, etc.
4. Experience in Monitoring tools like Nagios.
5. Familiarity with load balancing, firewalls, etc.
6. Proficient with network tools such as iptables, Linux IPVS, HA Proxy, etc.
7. Experience with virtualization technologies, such as Xen KVM and VMware.
8. Ability to build and monitor services on production servers