SQL Database Administrator

Compunnel Inc.
Trenton, NJ, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$130,000.0 - $140,000.0
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Microsoft Azure Databases Database Design Monitoring of Systems Microsoft SQL Server SQL Azure Performance Tuning Windows PowerShell Power BI SQL Databases SQL Server Reporting Services
+5 more
Transact-SQL Backup and Restore Scripting Cloud Platform System Information Technology

Job description

Job Summary: The SQL Database Administrator (DBA) will be responsible for maintaining and ensuring the ongoing availability of SQL Server systems, both on-premises and in the cloud (AWS SQL Server and Azure SQL). The DBA will take ownership of the complete understanding and optimization of multiple database products, ensuring their performance, security, and reliability., * Maintain and ensure the availability of SQL Server systems, including on-premises, AWS, and Azure environments.

  • Monitor system performance and implement necessary security updates and patches.
  • Optimize and manage multiple database products to ensure high performance and efficiency.
  • Quickly learn new product platforms and database technologies. Stay updated with the latest industry trends in database management.
  • Improve standard practices and procedures within the team to enhance efficiency and effectiveness. Develop and implement best practices for database management.
  • Troubleshoot and solve database-related issues effectively. Provide timely and efficient resolution to database problems.
  • Continuously work to acquire deep skills in relevant DBA areas. Participate in training and development programs to enhance technical expertise.
  • Understand the infrastructure environment and independently support an application’s database platform. Ensure the database platform meets the application’s requirements.
  • Maintain solid proficiency in backup and recovery options. Develop and implement backup and recovery strategies.
  • Perform database design tasks, including schema design, indexing, and normalization. Ensure database designs meet performance and scalability requirements.
  • Maintain team’s documentation and make updates and improvements as needed. Ensure documentation is accurate and up to date.
  • Capacity planning of databases and regular performance assessments and implement tuning measures.
  • Write and optimize T-SQL scripts for automating administrative tasks. Ensure scripts are efficient and maintainable.

Requirements

  • Bachelor’s degree in computer science, Math or IT related field.
  • Minimum of 10 years of experience with Microsoft SQL Server.
  • At least 3 years of experience with native Azure SQL Database.
  • Minimum 5 years of experience with Powershell or Python scripting.
  • MongoDB Atlas database management experience a plus.
  • Experience in technical database administration, development, tuning, and database design.
  • Working experience or knowledge SSRS and PowerBI Reports development.
  • DB Certification in Microsoft SQL Server or Azure SQL database preferred.
  • Strong communication and interpersonal skills.
  • Proven self-reliant, self-starter with the ability to educate others.

· Strong analytical and problem-solving skills.

  • Project and task-oriented with a focus on details.
  • Strong collaboration and teamwork skills.

Apply for this position

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

Apply on indeed.com

Good distractions

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

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:04 min

Introduction to Bitcoin script parsing tools

Steve Shadders · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all