SQL Server DBA

ONE STOP COLLECTIBLE CORP
Atlanta, United States
4 days ago
Apply on startup.jobs
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Azure Information Systems Databases Data Warehousing Relational Databases Disaster Recovery Failover Clustering Microsoft SQL Server Performance Tuning Query Optimization SQL Server Reporting Services SQL Server Integration Services
+4 more
SQL Server Analysis Services Enterprise Software Applications System Availability Information Technology

Job description

The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our enterprise applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. He or she will be responsible to help move our current database systems to Azure., * Installation, Administration and Maintenance of SQL Server Instances

  • Owns the strategic direction for the database topography
  • Create Users and assign permissions based on the level of database access the user would need
  • Design database backup and restore strategy
  • Setup High-Availability as part of Disaster Recovery Strategy for the Databases
  • Troubleshoot various problems that arise in the day-to-day operations and fix the issues
  • Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizations
  • Failover clustering, SAN replication, and other high availability technologies
  • Database growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)
  • Manage Maintenance Plans
  • Monitor backups to ensure they are being performed regularly
  • From time to time recover the databases to a specific point of time, as per the requests

Requirements

  • Microsoft SQL Server DBA experience.
  • Microsoft Azure experience
  • SSIS / SSAS / SSRS experience
  • Data Warehousing experience, * Minimum of 10 years of experience
  • Bachelor’s degree in Computer Science, Information Systems, or related technical field; or equivalent work experience.
  • MCTS, MCITP, and/or MVP certifications a plus

D ISCLAIMER

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on startup.jobs
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:22 min

Embracing polyglot persistence versus strictly relational databases

Stefan Priebsch ¡ World Congress 2021

1:06 min

Outline of free tools for Microsoft Azure

Radu Vunvulea Radu Vunvulea ¡ World Congress 2022

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg ¡ LIVE

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer ¡ LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri ¡ LIVE

3:06 min

Automating image resizing and data streaming tasks

Menaka Baskerpillai ¡ LIVE

Videos

See all

Related articles

See all