KeySkills:

DATABASE, DBA ADMINISTRATION, DATABASE AUTOMATION, DATABASE ARCHITECTURE, DATABASE MIGRATION, DATABASE SECURITY, PERFORMANCE TUNING, HIGH AVAILABILITY, BACKUP & RECOVERY, MONITORING, REPORTING, CLOUD, OPERATING SYSTEM, NETWORKING, ETL, REPORTING, ITSM

Job Description:

• Provide database administration service along with Team Lead.

• Coordination with Global customers.

• Following standard team processes and defines new ones with corrections.

• The individuals will be expected to be fully-functional DBA’s who can perform traditional DBA

• activities independently and guide team members too.

• Able to provide escalation support whenever required.

• From an operational perspective, responsibilities include troubleshooting problems, working

• maintenance windows and providing 24x7 on-call supports on a rotational basis.

• Database automation for MSSQL using Ansible

• Pre-installation Tasks

• Installing SQL Server and Patch Mgmt

• Installing & Maintaining DB Tools

• Uninstallation

• Database Upgrade

• Database Migration

• Database Patch Installation

• Physical Database Design and Implementation

• Database Setup in 32 and 64 architecture

• Database Clean up / Removal

• DB Cloning

• Design Database, RAID configuration & Capacity Planning for Large Databases

• Setup and implement Cluster Setup in multiple nodes environment

• Implement High Availability configuration like replication and log shipping

• Start up and shutdown of Database instances

• Maintaining Database replication / standby / clusters

• Job scheduling

• Verify all Instances and dependent services are running

• Look for any new error log entries

• Session / Process Monitoring

• Query or Transaction monitoring

• Lock and Deadlock monitoring

• Activity / Transaction Log monitoring

• Job monitoring and Purging Job history

• Replication / Log shipping monitoring

• Monitor Space usage /growth of Database objects

• Verify free space in filegroups / databases

• Monitor transaction log growth and truncate schedule

• Reorganization of DB to remove fragmentation

• Update Stats for hot objects

• Purging of DB logs and trace files

• Schedule maintenance plans for maintenance like DBCC REINDEX / INDEX DEFRAG

• Creation and schedule maintenance plans and jobs for update stats , defragmentation, checking database integrity

• Verify that Server has enough resources for acceptable performance

• Periodic Report Generation on Database Health

• Identify bad growth projections

• Identify space-bound objects

• Review contention for CPU, memory, network, and disk resources

• Generating statistics

• Look for objects that break rules.

• Ensure that all indexes use an index tablespace

• Ensure that all tables have unique primary keys.

• Look for harmful growth rates

• Examine tuning opportunities.

• Look for I/O Contention

• Review fragmentation by investigating row chaining and other areas of fragmentation

• Database Objects Creation / Review

• Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc

• Capture Performance Statistics using performance monitors

• User / Schema Creation

• User Management

• Roles and Privileges Management

• Look for security policy violations

• Privileges & Access controls on Database
• Verify that the database backup was successful

• Backup execution and monitoring

• Define Backup policy and retention policy for complete/differential/transaction backup

• Conduct Backup, restoration drills for backup verification in different scenarios

• Database Connectivity issues

• Slow response

• Operations timed out

• Dead locks

• Database Hangs

• Database incident and error resolution

• Transaction Log Backup Stuck for Space

• Database incident and error resolution

• Vendor Management

• System Performance Monitoring

• Maintaining Environment details and change management

• Windows Scripting for automations of DB related work

• SSIS and SSRS

• Implement ITIL processes & Maintain Transition Management Docket

• Adherence to Change Management Process

• Presales knowledge / experience is added advantage.

• Implement ITIL processes & Create Transition Management Dockets

• Presales knowledge / experience is added advantage.

QUALIFICATION:

• As per the Project Requirement

EXPECTED SKILLS / EXPERIENCE (L1 / L2 / L3) : L3

• At least SQL DBA experience of 6+ years is required

• Thorough Knowledge of Windows Operating System, Networks and Active Directory

• Knowledge of creating and maintaining standby / replication setup

• Strong in SQL fundamentals

• Knowledge of using Enterprise Manager and Query Analyzed for basic administration

• Knowledge of configuring and setting up maintenance activities for DB

• Knowledge of SQL statements tuning and DB Tuning

• Knowledge on DB structures (filegroups, Indexes - clustered /non clustered/fillfactor)

• Knowledge on Memory structures (configurable parameters)

• Knowledge of complete /differential / transactional backups and their recovery scenarios

• Knowledge on High Availability configuration like replication and log shipping , cluster setup

• Knowledge of DTS and bcp and other data load tools across same and different RDBMS

• Knowledge on database design and storage recommendation and NTFS file systems & capacity planning

• Knowledge in making scripts for automations , writing procedures and functions

• Knowledge of ITIL processes & Transition Management

• Excellent communication Skills

• Prior experience in a 24x7 environment desired

• Strong analytical and troubleshooting skills.

• Provide on-call support as and when required

• Ability to handle pressure

ADDITIONAL QUALIFICATION / SKILLS:

• Team Leader

• MCSE MSSQL Certification is mandatory

• Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on

• In depth Knowledge on SQL server 2008, 2012, 2014, 2016, 2017, 2019, 2022 Versions.

• Cloud, Azure, AWS

• Database automation for MSSQL using Ansible

PERSONAL ATTRIBUTES :

• Accepts Responsibility

• Openness

• Positive attitude

• Integrity

• Commitment

• Judgement

• Organized

• Proactive

Note:

(i) Our client is looking for immediate & early joiners.

(ii) Having LinkedIn Profile is a must.

(iii) Being an immediate & high priority requirement interested candidates can share their Resumes with Photograph in word doc. format and the details are enc`losed as below: