Database Administrator

Job Description

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 organization’s 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 Bachelor’s Degree in Computer Science, Information Technology or related field 4+ 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.