SQL DBA

Job Description

Role & responsibilities Experience with Database Administration for MSSQL Server. Actively and consistently supports all efforts to simplify and enhance the customer experience. Designs and maintains access and security administration. Designs, implements and maintains backup and recovery strategies on Database Management Systems. Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data. Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models. Experience with SQL in a virtualized environment (ESX and Azure). Knowledge of Always-On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Experience in implementing operational automation using scripts. Identify areas of the SQL environment that are suited for automation and then implement a solution using a variety of tools from applications such as HPSA or through scripting (PowerShell, TSQL). Knowledge of indexes, index management, and statistics. Experience working with Windows server, including Active Directory and proper disk configurations. Performs capacity planning of SQL server environment and provides recommendations to management to sustain business growth. Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation. Gathers business requirements and designs, implements multiple projects along with the production support. Creates standard operational procedures and templates. Acts as mentor for Database Administrators and Associate Database Administrators. Performs research and provides plans to remediate complex business problems. Job Description: Redshift Expert in Redshift administration and AWS services like EC2,IAM ,CLoudwatch ,VPC.Manage and support 24x7 production as well as development databases to ensure maximum availability for various applications. Perform DBA related tasks in key areas of Cluster resizing ,Snapshot ,backup,restore object from snapshot ,ESSO SAML setup, Cloudwatch Monitoring , Performance ManagementWork in key areas of User Management,Access rights management , Security Management . Knowledge of day to day database operations,deployments and developmentsGood in designing ,implementing WLM/AUTO WLM by analyzing customer needs