Database Administrator
Processware Systems Pvt Ltd.
Description
Experience: - 1.5 years- 2 years
Qualification: UG – BCA/MCA/B E /BTech
Functional Area: IT Software (Banking)
Employment Type : Full Time
Location: Bangalore
Mode of interview: Face to face
Technology: SSRS, SSIS, SSAS.
Responsibilities
Installation, configuration, and upgrades: Handling the installation, configuration, and upgrades of SQL databases and related components
Technical support: Providing technical support for Unix administrators and application developers
Operational and development support: Providing operational and development support for package modifications and ETL failures
High availability technologies: Configuring and maintaining high availability technologies such as SQL replication, failover clusters, and Always-On Availability Groups
Performance monitoring: Monitoring SQL Server for utilization, capacity, and performance
Maintenance plans: Managing backups, agent jobs, and maintenance plans
Disaster recovery plans: Designing, documenting, implementing, and maintaining disaster recovery plans, including regular testing
SQL server health monitoring: Checking SQL logs and backups, and monitoring the health of the SQL server and databases
Migration and upgradation: Good knowledge of migration and upgradation.
Mode of work: Work from office
Working days: 6 days(1st and 3rd –Full day 2nd and 4th Saturday half day)
Bond: 10th and 12th original submission for 2 years
Notice period : Immediate or less than 15 days.
Work location:
Processware Systems Pvt Ltd.#33,P T Street Basavanagudi,Bangalore-560004
Land Mark: Next to Pai Vista Convention Hall.
Requirements
Job Description
· Minimum of 2-3 years technical experience on SQL databases in a large scale environment
· Experience in implementation of SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analytical Services SSAS
· Creating / Validating SQL scripts / Stored procedures/ functions/ triggers
· Install & Configure and Manage Microsoft SQL Server 2008/2012/2014/2016/2017.
· Check Database backups and SQL logs.
· Monitor the health of the SQL server and databases.
· Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues
· Fluency in T-SQL and batch scripting
· Good knowledge on migration and upgradation.
· Experience implementing and managing SQL Server high-availability technologies (replication, mirroring, failover clusters, etc.)
· Participate in disaster recovery tests.