SQL Server Database Administrator

Company: Disability Solutions
Location: Dallas
Posted on: October 3, 2024

Job Description:

Job Title:SQL Server Database AdministratorLocation:TX - Dallas/IrvingWhat you'll do:We are seeking a skilled and experienced SQL Server Database Administrator (DBA) to join our IT team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server databases, ensuring the availability and consistent performance of corporate applications. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication abilities.What we are looking for: Key Responsibilities:

• Database Administration:
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply database upgrades, patches, and security configurations.
  • Backup and Recovery:
    • Ensure data integrity and availability by implementing robust backup and recovery strategies.
    • Perform regular database backups, restores, and participate in disaster recovery planning.
    • Performance Tuning:
      • Monitor performance, identify issues, and optimize queries to improve overall system performance.
      • Perform index maintenance, query optimization, and performance tuning.
      • Security Management:
        • Implement database security controls, including authentication, authorization, encryption, and access management.
        • Conduct audits and ensure compliance with security policies (e.g., SOX, GDPR).
        • Capacity Planning and Monitoring:
          • Proactively monitor server performance, resources, and database storage capacity.
          • Plan for future capacity requirements and identify database growth trends.
          • Automation and Scripting:
            • Develop automation scripts for database administration tasks.
            • Use tools such as PowerShell and SQL Server Agent to automate processes like backups, index rebuilds, and routine maintenance.
            • Collaboration and Support:
              • Work closely with development teams to provide guidance on database design, SQL query best practices, and troubleshooting.
              • Provide 24/7 on-call support for production database environments, as needed.
              • Documentation and Reporting:
                • Maintain comprehensive documentation of database configurations, processes, and changes.
                • Generate reports for system performance, uptime, and other key metrics.Qualifications:
                  • Bachelor's degree in Computer Science, Information Technology, or a related field.
                  • 5+ years of experience as a SQL Server DBA, including hands-on experience with SQL Server 2012/2016/2019.
                  • Strong knowledge of database performance tuning, high availability (HA), and disaster recovery (DR) options for SQL Server.
                  • Expertise in SQL Server tools (Profiler, DTA, SSMS, PerfMon, DMVs).
                  • Experience with Always On Availability Groups, Replication, Mirroring, and Clustering.
                  • Proficiency with T-SQL and writing efficient queries.
                  • Experience with cloud platforms (Azure, AWS) and database migration strategies.
                  • Familiarity with PowerShell scripting and automation.
                  • Knowledge of compliance standards such as SOX, HIPAA, and GDPR.
                  • Strong analytical and problem-solving skills.Preferred Skills:
                    • Certification in Microsoft SQL Server (e.g., MCSA, MCSE).
                    • Experience with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
                    • Experience with NoSQL databases or other RDBMS platforms (MySQL, Oracle, etc.).Benefits you'll love:We offer all the important things you'd want - like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!About the company:Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company.Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email HR@westernalliancebank.com or call 602-386-2488. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.-- Western Alliance Bancorporation

Keywords: Disability Solutions, Wylie , SQL Server Database Administrator, IT / Software / Systems , Dallas, Texas