This is an intermediate level MS SQL DBA position responsible for a variety of MS SQL database administration activities including physical design and logical design of databases, design HA and COB solutions for MS SQL 2012 and above, perform database build, upgrade, patch, troubleshoot and performance tuning independently. The overall objective of this role is to ensure quality standards are being met within existing and planned frameworks.
Responsibilities: Improve Problem Management and Stability within MS SQL environmentsWillingness to work in a high-volume environmentEffectively collaborate with architecture, application development, requirements group, QA, testing and PMO teamsWork with Audit/Compliance teams to install and maintain MS SQL security updates and patchesManage trouble and request queues ensuring timely resolutionProvide expert support, analysis and research into exceptionally complex problemsAssist with analysis, evaluation and preparation of recommendations for system improvements, optimization, development, and/or maintenance effortsMonitor status of critical system services reporting performance and server healthDevelop mutually beneficial working relationships with customersReview, improve and approve technical work, to guide others, and to teachHelp manager to track global initiatives such as cloud migration, EOVS remediation, VTM patchingQualifications: 2-5 years of relevant experience in an MS SQL DBA roleProduction support experience for critical MS SQL database systemsExcellent troubleshooting skillsStrong knowledge of Operating system platform and scripting/automationMS SQL 2012, 2014, 2016, 2019, 2022 internalsAdvanced knowledge of replication, AlwaysOn, db-mirroring, log-shipping, partitions and security for MS SQL serversExcellent knowledge of T-SQL languageStrong experience with backup and recovery procedures for all MS SQL Server database systems according to industry best practicesExcellent written and verbal communication skills and ability to work with remote teamsKnowledge of Powershell scripting is a big plusExperience working in Financial Services or a large complex and/or global environmentProject Management experienceConsistently demonstrates clear and concise written and verbal communicationComprehensive knowledge of design metrics, analytics tools, benchmarking activities and related reporting to identify best practicesDemonstrated analytic/diagnostic skillsAbility to work in a matrix environment and partner with virtual teamsAbility to work independently, prioritize, and take ownership of various parts of a project or initiativeAbility to work under pressure and manage to tight deadlines or unexpected changes in expectations or requirementsProven track record of operational process change and improvementEducation: Bachelor's degree/University degree or equivalent experience
#J-18808-Ljbffr