Database Administrator

About Client:

The Client is a renowned multinational technology company which has grown to become one of the world's most influential and successful companies in the field of software development, computer hardware, and related services.

The Client's primary focus revolves around developing, manufacturing, and licensing a wide range of software products, including the globally recognized operating system, Windows. It has released several versions of Windows, catering to both personal computers and servers, which have become integral to the functioning of millions of devices worldwide.

Apart from Windows, client offers an extensive portfolio of software applications and tools for both individuals and enterprises.

Moreover, client has a substantial presence in the field of artificial intelligence (AI) and research, working on projects like the development of conversational AI agents, natural language processing, and machine learning technologies.

Rate Range: 100-$110/Hr

Job Description:

The SQL Database Administrator will be responsible for independently managing SQL Server databases, including new installations and migrations from existing systems.

The role requires supporting ongoing database activities, troubleshooting and resolving issues as they arise, and performing routine maintenance and administrative tasks.

The candidate will monitor database activity and resource usage to ensure optimal performance and reliability.

Success in this position demands strong technical expertise, solid organizational skills, and the ability to deliver high-quality work within a customer-focused, schedule-driven environment, in line with company and client objectives. Schedule & Work Location:

M-F 9-5 or as needed for escalations

Location: mostly remote; quarterly onsite visits to NYC office may be required Responsibilities:

Independently manage SQL Server database environments, including new setups and migrations from existing databases.

Assist in database support activities and perform ad-hoc SQL Server troubleshooting and remediation.

Conduct standard database maintenance and administration tasks, such as monitoring database activity, resource usage, and optimizing performance.

Plan for and forecast resources needed to support database growth and capacity.

Perform capacity planning to create and maintain databases, collaborating with system administration teams as needed.

Maintain disk and database capacity reports.

Perform routine configuration, installation, and reconfiguration of databases and related products.

Manage database configurations, including installing, upgrading software, and maintaining relevant documentation.

Handle SQL Server patching and assist with Always On Availability Group failovers during Windows Server (OS) patching processes.

Manage SSL certificate deployment and renewal.

Proactively monitor database systems to ensure secure services and minimal downtime, employing MS SQL Server best practices.

Establish and enforce policies and procedures for database security, integrity, compliance, and auditability.

Develop and maintain procedures and documentation for databases.

Contribute to setting and enforcing standards for the definition, security, and integrity of database objects.

Ensure conformance to established database standards and practices. Requirements & Experience:

9+ years of experience as a SQL Server Database Administrator, with strong expertise in new setup and migrations.

7+ years working with On-Premise SQL Server database applications and the Azure platform, including SaaS SQL Database and SQL on VM.

Proven ability to work independently and be a quick-starter, adapting to the pressures of large migration projects.

Experience supporting large, complex database systems both on-premises and in Azure, including SQL Server versions 2014, 2016, 2019, and 2022.

Expertise in index and statistics maintenance for very large database environments.

Experience supporting databases over 10TB, including troubleshooting issues related to maintenance, backup/restores, and database corruption.

In-depth knowledge of SQL Server setup, installation, administration, and management, as well as SSRS (Reporting Services) and SSIS (Integration Services).

Working knowledge of backup and recovery strategies, data masking, encryption, and SQL certificate deployment.

Skilled in SQL Server queries, PowerShell scripting, and automation with PowerShell and Excel.

Prior experience in production support operations, delivering high availability services within team environments.

Hands-on experience with SSIS, SSRS, clustering, Always-On Availability Groups (AOAG), and HA/DR troubleshooting.

Comprehension of AOAG configurations, including read-only routing and monitoring of AOAG systems.

Ability to perform business analysis and write effective documentation and specifications.

Experience writing T-SQL stored procedures, triggers, and functions, as well as knowledge of database table partitioning.

Demonstrated ability to work well under pressure and meet tight deadlines.

Resourcefulness in finding information to address technical issues.

Non-benefitted (other than those mandated under state or federal law).Please note that this position does not include paid time off benefits. ApTask offers subsidized insurance coverage to our employees.

About ApTask:

ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Candidate Data Collection Disclaimer:

At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

If you have any concerns or queries about your personal information, please feel free to contact our compliance team at

Applicant Consent:

By submitting your application, you agree to ApTask's Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at or . Message frequency may vary. Msg & data rates may apply.

About ApTask:

ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.

Candidate Data Collection Disclaimer:

At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

If you have any concerns or queries about your personal information, please feel free to contact our compliance team at .

Applicant Consent:

By submitting your application, you agree to ApTask's Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at or . Message frequency may vary. Msg & data rates may apply.