ApTask ยท 4 weeks ago
Database Administrator (DMS-14)
New York, NY
Full-time
Hybrid
Senior Level, Lead/Staff
$100/hr - $110/hr
9+ years expApTask is a leading global provider of workforce solutions and talent acquisition services. They are seeking a SQL Database Administrator responsible for managing SQL Server databases, performing routine maintenance, troubleshooting issues, and ensuring optimal performance and reliability.
Human ResourcesInformation TechnologySmall and Medium BusinessesStaffing Agency
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
Qualification
Required
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
Benefits
Subsidized insurance coverage to our employees.
Non-benefitted (other than those mandated under state or federal law). Please note that this position does not include paid time off benefits.
Company
ApTask
ApTask is a staffing and recruiting company offering staffing, project, and workforce solutions.
201-500 employees
H1B Sponsorship
ApTask has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Taj Haslani
Founder
Recent News
Company data provided by crunchbase