SQL Database Administrator

Job Details


SQL Database Administrator

Memphis, Tennessee        Contract To Hire       September 19, 2022


Apply Now

SQL Database Administrator (SQL DBA)

JOB DESCRIPTION:
Essential Job Functions

  1. Primary responsibilities will be to maintain the various servers, tune performance, and manage day to day processes within various SQL environments, and support key projects with little or no direction from leadership and potentially significant collaboration with peers.
  2. Work with support teams on both internal & external developed applications to insure data and process integrity
  3. Install, monitor, and support SQL server instances including SSIS, SSRS, and SSAS components
  4. Install, monitor, and support various High Availability and Disaster Recovery solutions
  5. Install, monitor, and support various Azure solutions including: Data Factory, Data Lake, SQL Managed Instance, SQL DB, Analysis Services
  6. Create new databases and overwrite test databases with copies of production databases while maintaining proper security
  7. Manage SQL Server authentication using both SQL logins & AD groups; enforce principle of least privilege while providing necessary data access
  8. Backup/recover/rollback production, test, and development databases environments
  9. Work with both virtualized and physical installations of SQL
  10. Troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (Always On) and other issues in production, QC, and development environments. Coordinate/implement production fixes, or advise the application owner/developer, as appropriate.
  11. Monitor & manage data storage capacity of production and pre-production SQL Servers to support database growth and coordinate drive expansions with operation & user teams
  12. Write T-SQL code and stored procedures to monitor, automate and support DBA tasks
  13. Create and manage database reports, visualizations, and dashboards.
  14. Create automation for repeating database tasks.
  15. Completes tests and evaluations regularly to ensure data security, privacy, and integrity.
  16. Build and maintain the performance of database servers.
  17. Develop processes for optimizing database security.

Minimum Qualifications

Bachelor's degree in Computer Science or similar field plus 3 years in database administration, information technology, database architecture, or a related field, totaling education/experience of 7 years.

PREFERRED SKILLS:
5+ years of Microsoft SQL Server database administration experience preferred.

MCSE/MCSA certifications preferred.

Experience with cloud services (AWS, Microsoft Azure) a plus

Experience managing a SaaS environment with a managed services vendor partnership a plus.

SQL Azure experience would be preferred

NOTE:  Some LOCAL travel might be necessary so need reliable transportation and rate must be all inclusive of any travel related costs.  No travel reimbursements.

Knowledge, Skills, and Abilities

  1. Advanced or expert knowledge in these skills: Clustering/mirroring/Always-On experience, index optimization, SQL Server 2012/2016/2017, backups, storage, archiving, performance analytics and SQL DMVs, schema analysis and documentation, query tuning, SQL, and experience tuning SQL Server.
  2. Experience with both virtual and physical servers.
  3. Demonstrated ability to design and develop solutions working with business or IT.
  4. Demonstrated ability to be a self-starter in proactively looking for opportunities to create an environment that is highly stable and performant.
  5. Experience designing advanced SQL queries, SSIS, SSRS, stored procedures, triggers, scripts, cursors
  6. Experience with Windows server, including Active Directory.
  7. Experience upgrade SQL Server databases.
  8. Knowledge of best practices when dealing with relational databases.
  9. Analyze performance issues of databases. Assist developers with performance tuning.
  10. PowerShell and Unix shell scripting skills

#LI-AT

Apply Now

Amy.Tillman


  • This field is for validation purposes and should be left unchanged.