Ms Sql Db Admin Senior Usa

MS SQL Database Admin

Experience - 6-8 years

Location - New york, NY

Roles and Responsibilities-

•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. Pre-installation Tasks

•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, 6+ years 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 2000, 2005, 2008, 2012, 2014, 2016, 2017 Versions.

•Mongodb, Mysql, Postgress, cloud, Azure

Personal Attributes :

•Accepts Responsibility

•Openness

•Positive attitude

•Integrity

•Commitment

•Judgement

•Organized

•Proactive