SQL Database Engineer DBA, New Jersey

Job Description :
Job Title: Sr. MS SQL Database Engineer (DBA)

Location : Alpharetta GA, Terrell Mill GA (Onsite from Day 1)

Job Summary: The Senior MSSQL Server Database Engineer/Administrator is responsible for the configuration, maintenance, and troubleshooting of Microsoft SQL Server environments. This role supports data integrity, performance optimization, automation, and secure data transfer processes within SQL and Windows Server platforms. The ideal candidate will have a proactive approach to database administration with expertise in Always On Availability Groups, experience in building Azure databases, and familiarity with migration from on-premises environments to Azure or AWS.

Required Skillset and Qualifications:

Bachelor's Degree in Computer Science, Information Technology, or a related field, or equivalent experience.

8+ years of experience as a SQL Server Database Administrator with a strong focus on installation, configuration, and administration of Microsoft SQL Server databases. Experience ensuring optimal performance, scalability, high availability, performance tuning, automation, and data security.

Proficiency in SQL Query Language and experience with PowerShell and Python scripting for automation.

Strong knowledge of Windows Server and basic network connectivity troubleshooting.

Experience with monitoring tools like Splunk and Dynatrace is preferred.

Experience with Always On Availability Groups, configuring and maintaining high availability environments.

Experience in building Azure databases, including Azure SQL Database and Managed Instances.

Familiarity with migration processes from on-premises SQL Server to Azure or AWS, including best practices and tools for smooth transitions.

Key Responsibilities:

SQL Server Management : Install, configure, and administer Microsoft SQL Server databases, ensuring optimal performance, scalability, and high availability.

Query Optimization and Tuning : Write and optimize SQL queries to improve database performance, focusing on efficient data retrieval and transaction processing.

Database Backup and Recovery : Manage backup, restore, and recovery plans to ensure data protection and disaster recovery.

Security Management : Implement and maintain database security protocols, access controls, and encryption, following best practices and compliance standards.

Automation and Scripting : Develop PowerShell and Python scripts for automating routine database tasks, file processing, and report generation to enhance productivity.

Performance Monitoring : Use monitoring tools like Splunk, Dynatrace, and SQL Server Profiler to track database health, detect performance issues, and conduct root cause analysis.

Technical Product Implementations : Support and perform SQL DBA and Windows Server administration for technical product deployments, ensuring smooth integration with existing systems.

Cross-Platform Database Support : Provide support for IBM Db2 and other database platforms as needed, ensuring a cohesive data infrastructure.

Collaboration with Cross-Functional Teams : Work closely with infrastructure, development, and business teams to align database solutions with organizational goals and support stability.

Additional Information:

This position may require participation in an on-call rotation for database support and maintenance.