Central Point Partners

SQL Database Administrator

3 days onsite

Fulltime

Location: Trenton, NJ (Local Preferred)

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.

Key Responsibilities:

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

Qualifications:

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

"TGIT01"

Job Type: Full-time

Pay: $130,000.00 - $140,000.00 per year

Work Location: In person