SQL DBA

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