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

S͏kills

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

P͏ersonal atributes

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

͏