This job has expired, please see additional jobs below
Database Admin Team lead
INTL FCStone
Chicago, IL, United States
Job Details - this job has expired, please see similar jobs below
Position Purpose:
A highly motivated individual with a deep demonstrated knowledge of MS SQL administrative tasks and the ability to consult on design, development, and automation improvements. Having a passion for maintaining MS SQL databases that meet or exceed internal and client contracted production SLA's for availability and performance. The right candidate will ideally have past hands-on experience administering MS SQL databases running in a public cloud environment such as AWS or MS Azure
Primary Accountabilities/Responsibilities:
• Document complex installation, configuration, and optimization procedures so they can be automated.
• Provide support 24/7/365 for any troubleshooting or corrective actions related to incidents impacting application availability within the production environments.
• Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs (backups, DBCCs, apply indexes/re-indexing, etc.), to meet or exceed baseline stability and performance SLA's on large databases (1 TB+) and large volumes of databases (100+).
• Create, implement, and maintain SQL DB Health Checks, and have a demonstrated ability to automate SQL health reporting/event notification, and corrective actions.
• Configure SQL Server monitoring utilities to minimize false alarms, and have a demonstrated ability to monitor/trend SQL environments to determine and implement enhanced monitoring thresholds to prevent incidents and reduce mean time to recovery (MTTR).
• When performance issues arise, determine the most effective way to increase performance including scaling up or out, server configuration changes, index/query changes, etc.
• Identify code defects and enhancements and develop a detailed root cause analysis that can be leveraged by the product management and development teams to improve application availability and decrease the total cost of ownership.
• Ensure databases are being backed up and can be recovered in a manner that meets all BCDR objectives for RPO and RTO.
• Perform all database management responsibilities in Microsoft Azure for production and non-production workloads.
• Regularly meet with the business and management about architecture, implementation and support complex and highly available database environments
Job Requirements:
• 6+ years working in Information Technology
• 3+ years of experience administering, analyzing, and/or developing relational databases.
• Experience creating data models of databases, and monitoring/tuning database performance
• Experience working in a 24/7/365 operation.
• Bachelor’s degree in Computer Science or Information Systems.
• Familiar with basic Azure IaaS capabilities, and some experience designing and building MS SQL databases within Azure or AWS is a plus.
• Experience operating in an ISO certified and/or highly regulated (SSAE, PCI, HIPPA, etc.) hosting operation.
• Familiar with Dev/Ops concepts, and ideally experience working with a Dev/Ops team focused on implementing and enhancing continuous delivery capabilities.
• Experience automating SQL Server deployment and configuration through PowerShell, Chef, Puppet, etc.
Physical requirements/Working conditions:
• Climate controlled office environment
• Minimal physical requirements other than occasional light lifting of boxed materials
• Dynamic, time-sensitive environment
We encourage applicants of all ages and experience, as we do not discriminate on the basis of the applicant's age.