MSSQL Database Admin

Job Description

• Provide MSSQL database administration service

• 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.

• Pre-installation Tasks

• Installing Oracle Server and Patch Mgmt

• Installing & Maintaining DB Tools

• Uninstallation

• Database Upgrade

• Database Migration

• Database Patch Installation

• Physical Database Design and Implementation

• Database Setup

• Database Clean up / Removal

• DB Cloning

• Start up and shutdown of Database instances

• Maintaining Database replication / standby / clusters

• Job scheduling

• Verify all Instances are running

• Look for any new alert log entries

• Verify that SNMP is running

• Look for Trace files

• Session Monitoring

• Query or Transaction monitoring

• Lock and Latch monitoring

• Activity / Redo Log monitoring

• Job monitoring and Purging Job history

• Replication / Stand by monitoring

• Object Monitoring

• Verify free space in table spaces

• Verify rollback segments

• Reorganization of DB to remove fragmentation

• Rebuild of indexes

• Analyze of objects

• Purging of DB logs and trace files

SSIS and SSRS:

• 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 table space
• 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
• Check for unusable indexes
• User / Schema Creation
• User Management
• Roles and Privileges Management
• Look for security policy violations
• Privileges & Access controls on Database
• Verify that the database archiving to tape was successful.
• Verify that the database backup was successful
• Backup execution and monitoring
• Conduct Backup , restoration drills for backup verification
• Database Connectivity issues
• Slow response
• Operations timed out
• Database incident and error resolution
• Database incident and error resolution
• Vendor Management
• System Performance Monitoring
• Maintaining Environment details
• Shell Scripting for DB related work
• Adherence to Change Management Process
• Presales knowledge / experience are added advantage.
• Implement ITIL processes & Create Transition Management
• Root Cause Analysis for DB problems/ Recurring problems and initiate Request for Change

Skills

• · Thorough Knowledge of Windows Operating System
• . 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 (file groups, 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
• · Excellent communication Skills
• · Prior experience in a 24x7 environment desired
• · Strong analytical and troubleshooting skills.
• · Provide on-call support as and when required
• · Team player who has a customer focus and brings expertise to the team

Additional Skills

• MCSE MSSQL Certification is mandatory
• Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on
• In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014, 2017, 2019, 2022 Versions.
• Cloud, Azure, AWS

Personal atributes

• Accepts Responsibility
• Openness
• Positive attitude
• Integrity
• Commitment
• Judgement
• Organized
• Proactive