Database Administrator III in Irving, TX at Cottonwood Financial

Date Posted: 4/12/2021

Job Snapshot

Job Description

Reporting to our Head of IT Infrstructure, the Senior Database Administrator (a.k.a. Database Administrator III) will work closely with System Administrators and Developers and will be responsible for implementation, configuration, maintenance, backup/recovery, and performance of critical SQL Server RDBMS systems on-premises and in Azure. This position will also play a pivotal role in Cottonwood’s cloud data strategy. Designing and implementing cloud technologies to improve the availability and security posture of data companywide leveraging Azure IaaS and PaaS solutions like Data Factory, Synapses, Managed Instances, and virtual machines running SQL Server. The successful candidate will be responsible for the development and sustainability of SQL Server Databases, ensuring its operational readiness (health, security, and performance), executing data loads, and performing data optimization in support of multiple development teams (Application Development and Data Engineering teams). They will ensure the availability and consistent performance of the entire data estate and must be capable of working independently and collaboratively. This position is based at our Administrative Office (HQ) in Irving (Las Colinas), Texas.

Key Responsibilities

  • Installation and administration of SQL Server databases in on-prem and cloud environments
  • Work closely with and provide data expertise to Developerment, Data Engineering, and Data Analytics teams
  • Design and implement creative cloud solutions to improve data performance, security, and reliability including technologies like Azure SQL Data Warehouse, Data Lakes, Databricks, and other PaaS SQL solutions
  • Optimize the performance and reliability of Microsoft SQL systems
  • Perform reviews of schemas, stored procedures, and other changes to database DDL
  • Develop, manage, and test database backup & recovery strategies, verifying data integrity
  • Establish and maintain standards, policies, configuration guidelines, procedures, and best practices
  • Initiate corrective action to ensure all database servers meet processing requirements for performance and reliability
  • Performance tuning and query optimization
  • Management of databases, schemas, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints
  • Manage and oversee database security
  • Create, edit and maintain SSIS packages
  • Create, test and document custom stored procedures
  • Proactively monitor production environments and identify performance bottlenecks
  • Participate in on-call rotation for production operations and other environments, as needed

Requirements

  • Bachelor’s Degree or equivalent Military/other experience 
  • At least 7 years’ experience as a DBA supporting a production environment
  • 5+ years’ experience in a Microsoft SQL Server environment
  • Advanced knowledge of database clustering, always-on, mirroring, and replication
  • Strong programming SQL programming skill including T-SQL
  • Experience with Azure cloud database design and implementation
  • Expertise in table and index design
  • Strong experience with writing, configuring, and troubleshooting SSIS packages
  • Experience with database monitoring solutions
  • Automation skills with restores and data refreshes
  • Resourcefulness with good problem-solving and critical thinking skills
  • Ability to work in a team environment
  • Local (Dallas/Fort Worth area) candidates only - no relocation
  • Must be currently authorized to work in the United States without sponsorship and not require sponsorship in the future

Preferred Qualifications

  • SQL Server certification
  • Experience with SolarWinds APM
  • Experience with other database vendors (Mongo, MySQL, etc)
  • Experience with Powershell scripting, C# or .NET
  • Familiarity with Agile development methodology such as KANBAN

Compensation

  • Annual salary up to $103,000

Benefits

  • Medical, dental, and vision
  • Voluntary life/ AD&D
  • Short-term & long-term disability
  • 401K with company match
  • Paid vacation, holidays, and sick time
  • Paid maternity, paternity, extended medical leave, and jury duty
  • Corporate discount program on personal cell phone accounts with select providers
  • Business casual work environment

About Cottonwood

Founded in 1996, Cottonwood Financial is one of the largest privately held retail consumer finance companies in the United States. We have zero debt, have been profitable every year since inception, and our growth is funded entirely through internally generated capital. Headquartered in Irving (Las Colinas), Texas, we have company-owned locations, under our Cash Store brand, across the country. Through this national brick-and-mortar footprint, we provide best-in-class customer service and offer an innovative mix of financial products and services to our customers.


We have been named several times to the Inc. 5000 list of America’s fastest-growing private companies, as well as to the Dallas 100 list of the fastest-growing private companies in North Texas.