Job description

Responsibilities:
- Maintain the various servers, tune performance, and manage day to day processes within various SQL environments

- Work with support teams on both internal & external developed applications to insure data and process integrity

- Install, monitor, and support SQL server instances including SSIS, SSRS, and SSAS components

- Install, monitor, and support various High Availability and Disaster Recovery solutions

- Install, monitor, and support various Azure solutions including: Data Factory, Data Lake, SQL Managed Instance, SQL DB, Analysis Services

- Create new databases and overwrite test databases with copies of production databases while maintaining proper security

- Manage SQL Server authentication using both SQL logins & AD groups; enforce principle of least privilege while providing necessary data access

- Backup/recover/rollback production, test, and development databases environments

- Work with both virtualized and physical installations of SQL

- 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.

- Monitor & manage data storage capacity of production and pre-production SQL Servers to support database growth and coordinate drive expansions with operation & user teams

- Write T-SQL code and stored procedures to monitor, automate and support DBA tasks

- Create and manage database reports, visualizations, and dashboards.

- Create automation for repeating database tasks.

- Completes tests and evaluations regularly to ensure data security, privacy, and integrity.

- Build and maintain the performance of database servers. 17. Develop processes for optimizing database security

The essential functions of this role include:

• skills:working up to 3 hrs of overtime per week

qualifications:Experience level: Experienced
Minimum 3 years of experience
Education: Bachelors

• SQL

Job Type: Contract

Pay: $41.63 - $75.20 per hour

Schedule:

• 8 hour shift
• Monday to Friday

Ability to commute/relocate:

• Memphis, TN 38109: Reliably commute or planning to relocate before starting work (Required)

Experience:

• MySQL: 1 year (Preferred)
• Database administration: 1 year (Preferred)
• Oracle: 1 year (Preferred)

Work Location: In person

abouteureka.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, abouteureka.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, abouteureka.com is the ideal place to find your next job.