Experience: 6 - 8 YEARS

Location: MUMBAI

CTC TO BE OFFERED : Mention Your Current & Expected CTC

Notice Period: IMMEDIATE

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 workplace

- 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

📌 MS SQL DBA CONSULTANT (India)
🏢 Swathi Business Solutions
📍 India