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, Mesquite , SQL Server Database Administrator, IT / Software / Systems , Dallas, Texas
Didn't find what you're looking for? Search again!
Loading more jobs...