Microsoft SQL Database Administrator

Full-time - Mid Level

Carrollton, TX

Credit Intermediation and Related Activities

About the position

The Database Administrator (MS SQL) is responsible for coordinating the creation and changes to system databases and tests and implements the database applying knowledge of database management systems. This role may plan, coordinate, and implement security measures to safeguard computer databases as well as support various corporate department business systems. As a Database Administrator, you will need to have a strong understanding of both technical and business needs, as well as excellent troubleshooting skills and a commitment to ensuring the integrity and confidentiality of data systems and ensure databases run efficiently.

Responsibilities

• Create and organize systems to store and secure data
• Design and build new databases
• Ensure that data is secure and protected from unauthorized access, breaches, and other threats
• Work with other teams to assure that all Databases are setup for Monitoring and Alerting based on Thresholds that are agreed upon, and that the alerts are setup to be delivered to the appropriate Teams for Monitoring
• Ensure that databases operate efficiently and without error, and tuning performance when needed
• Backup and restore data to prevent data loss
• Make sure that data is available to authorized users and that users can easily access the information they need
• Create and test modifications to database structure when needed
• Provide support to users and troubleshooting any data-related issues
• Establish and ensure database standards for security, reliability, availability, and scalability
• Identify opportunities for database infrastructure optimization and cost reduction
• Coordinate the business intelligence (BI) system to transform raw data into meaningful insights
• Collaborate with developers to design and implement new features

Requirements

• Bachelor's Degree in IT related field or equivalent experience
• Database Performance Tuning (MSSQL, MongoDB, MariaDB, PostgreSQL, etc.)
• Database Management (3+ years minimum in Microsoft SQL)
• Requirements Analysis
• Software Development Fundamentals
• Data Maintenance
• Database Security
• Promoting Process Improvement
• System Administration

Nice-to-haves

• Strong knowledge and experience in setting up, securing, and managing public cloud infrastructure (AWS/Azure)
• Experience building and working with public cloud infrastructure
• Strong knowledge and experience in configuring and managing Windows Server/Clients within a Cloud environment
• Demonstrated knowledge of cloud provisioning and administration, cloud interoperability, cloud disaster recovery and business continuity strategies, as well as performance measurement and monitoring in the cloud on a large scale
• Deep knowledge of web protocols, multiple operating systems, hypervisors and distributed systems architecture AWS, and/or Azure platforms and services
• Strong programming skills and fluency with at least one of the following scripting languages: Python, Powershell
• Experience in LinuxNIX system administration
• Experience with Container technologies (Docker, Kubernetes, Open Shift)
• Cloud provider certification (e.g., AWS Certified Developer, AWS Certified Architect, Azure)
• Experience with architecting software solutions Agile development practices and test-driven development

Benefits

• Uncapped Flexible Paid Time Off
• A comprehensive new hire training program designed to help set you up for success
• Access to a robust learning management system, full of e-learning modules and training programs to help boost your professional and personal development
• Professional Development and Mentor Programs plus Ongoing Training Resources
• Multiple coverage levels for Medical, Dental, & Vision
• Group Health & Wellness Program, plus special savings on retail items, travel, entertainment, and more through TMX Perks
• Traditional 401(k) and Roth 401(k) with Company match
• Options for Flexible Spending Accounts and Health Savings Accounts
• Basic and AD&D Life Insurance
• Optional pet insurance
• Voluntary benefits, including short-term and long-term disability insurance, accident, critical illness, and hospital confinement insurance