Job Description & Scope
Job description Job Purpose As a SQL Database Administrator, you will be part of the Global Data Services team with accountability for designing, testing, implementing, and maintaining the organizations databases across multiple platforms, technologies (e.g., relational, non-relational and warehousing) and computing environments (e.g., host based, distributed systems, client server). The successful candidate will be responsible for all aspects of data and database administration. Responsibilities SQL DBA with 24/7 support for financial applications. Good experience in different MS SQL Server versions 2012,2014, 2016, 2017 & 2019. MS SQL Server installations/Patching on Standalone/Cluster environment. Should support database upgrades and patches, capacity planning and other activities as may be necessary. Database backup and recovery. Creating, configuring, monitoring, scheduling & troubleshooting jobs. Configuring and troubleshooting Log shipping, Mirroring, High Availability. Configuring, Reinitializing, and troubleshooting Replication. Troubleshooting clustering issues. SQL Server Database Performance Tuning. Detecting and troubleshooting Security and remote connectivity issues. RCA Provision and Problem management. Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions). Understanding of Mount points. Good knowledge on PowerShell scripting would be added advantage. Knowledge and Experience Bachelors Degree in Computer Science, Information Technology or related field 5+ years of experience with production database management, preferably with Microsoft SQL Server & Oracle Experience with Microsoft Replication design, implementation, and support Experience with Microsoft SQL Server Always On availability groups - design, implementation, and support Technical architecture and documentation skills, preferably with Visio Ability to independently complete projects with minimal guidance Ability to work an on-call schedule, after hours and weekends as needed. Ability to learn new technology with a willingness to teach. If you are interested for the above role, please share your resume with the following details at surabhi.jain@ice.com : Total Exp Current CTC (fixed) - Expected CTC NP Current Location Current Company Ready to work 5 days from Office. Role: Database Administrator Industry Type: IT Services & Consulting Department: Engineering - Software & QA Employment Type: Full Time, Permanent Role Category: DBA / Data warehousing Education UG: Any Graduate PG: Any Postgraduate Key Skills Skills highlighted with ‘‘ are preferred keyskills MS SQL Server ClusterPerformance TuningMonitoring
