Job Description

Location: Mumbai (Airoli) Exp: 5-8 Yrs SPOC: Arpita Pawar Key Skills: Primary Skills : MS SQL DBA Secondary Skills : PostgreSQL DBA : \'Minimum 4 yrs of experience of handling MS SQL & PostgreSQL DB Manage MS SQL Server databases Manage PostgreSQL database Configure and maintain database servers and processes Monitor system\'s health and performance Ensure high levels of performance, availability, sustainability and security Analyze, solve, and correct issues in real time Provide suggestions for solutions Refine and automate regular processes, track issues, and document changes Assist developers with query tuning and schema refinement Provide 24x7 support for critical production systems Perform scheduled maintenance and support release deployment activities after hours Responsible for physical database architecture and design, development, performance tuning, implementation, and support of the applications from a database perspective Define and implement database, SQL standards and best practices Execute all changes of db schema and maintain controlled development database environment Work closely with application developers to test, configure, and optimize servers based on application demands work with large volume, heavy load databases PowerSHell scripting for automating the tasks. Create database scripts for all objects and integrate them with source control Handle database object deployment to Integration, QA, UAT, and Production Good in reading and writing complex stored procedures, views, and triggers Experience in writing technical documentation Has credible experience in supporting production databases Backup / Recovery, Data Replication, Distributed databases, Data Migration- worked on replication , cluster , mirroring and log shipping Experience in resolving blocking and deadlock issues Tune the databases- Write Windows Scripts, Planning, Job scheduling, and Monitoring Monitoring & Troubleshooting Blocking and Deadlock Execution of DBCC Commands (OPENTRAN (DBName) , SQLPERF (LOGSPACE) , checkdb , shrinkfile , shrinkdatabase , indexdefrag , dbreindex, etc) Create and update maintenance plan for database maintenance- Monitor and understand the error log and event log Monitor the disk space on the server and take action accordingly (Including Data files, Transaction log files, tempdb database) Understand how connectivity is established between servers (Remote Access) Connecting remote server using QA, EM, and TS) - Managing DB backups. Restoring database from Full/ Differential/ T- log backup Provide day to day support of high OLTP HA of SQL Server (2000, 2005, 2008) databases- Identify root causes of production problems and work with developers to circumvent and resolve such problems Provide technical services to monitor and maintain environments, (the SQL Server production, development, and test databases) running on firm\'s strategic platforms including periodic software upgrades and migration of the SQL Server products Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization- Create and maintain Windows and SQL scripts to automate tasks such as setting up and refreshing DEV, QA, and Production database environments Log, schedule and track all changes using change management system tools Responsible for all corrections to the database infrastructure and for repairs to the system or database\'

foundit