The Role
Administer and support SQL Server environments, including installation, upgrades, maintenance, security, auditing, performance tuning, backups, recovery, disaster recovery, capacity planning, and high availability. Manage Windows Server infrastructure, EC2 instances, failover clusters, endpoint protection, and server roles. Develop T-SQL and support ETL processes, troubleshoot high-intensity transactional systems, maintain application infrastructure, and provide 24-hour operational support.
Summary Generated by Built In
Expert Level SQL Database Administrator
Position is available for extensions.
NOTE: This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration.
• Experience with FAST GenTax/DS-VS architecture and application maintenance
• Familiarity with industry security standards (PUB1075, FIPS, and PII)
• Cloud computing knowledge
• Cloud storage, backup, and restore mechanisms
• Firewall administration and maintenance
• Active Directory knowledge (GPO, FQDN, DNS Server, SPN)
• Email, SMTP, and Proxy Server troubleshooting
• Web Services development and support
• Availability to provide 24 hour support
• Strong communication skills, both oral and written
Requirements
Position is available for extensions.
NOTE: This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration.
MINIMUM: 4 Years Experience SQL Server 2022 (or later versions) database administration:
• Installing and upgrading SQL Servers, including applying service packs, cumulative updates
• Performing routine database maintenance
o Knowledge of SQL Server Agent and jobs
o Monitoring error logs and event logs for database errors and warnings
• SQL Server native tools and services
o SQL Server Profiler
o Index Tuning Advisor
o SQL Server Configuration Manager
o Extended Events
o Performance Monitor
o Dynamic Management View
o SQL Server Broker Service
o Linked Servers
o MSDTC
o SQL Server System Databases knowledge
o SQL Server Health Checks and Policies
• Managing SQL Server security and auditing
o User security
o Authentication methods
o SQL Server and database auditing
o Encryption at rest, transit, and backup
• Capacity Planning for storage and database objects
o Maintaining and managing SQL Server disk storage and experience with AWS storage systems to ensure storage is properly utilized
o Managing disk storage for Windows Failover Cluster Service (WFCS)
• Database backup and recovery
o Establishing standards and schedules for database backups
o Developing recovery procedures to meet RPO and RTO
o Restoring databases with point in time recovery
• Creating and testing Disaster Recovery plans
• Proficient in TSQL coding, tuning, and ETL methodologies
• SQL Server High Availability Methods
o Experience with VLDB
o Experience monitoring, supporting, troubleshooting high intense systems with both online transactions and batch transactions
o Always On and AWS HA Zones
Required: 3 Years Windows Server Administration experience:
• Building and maintaining Windows Servers and EC2 Instances
• Installing and managing end point protection
• Application Server, Web Server, File Server, and FTP Server configuration and maintenance
• Utilizing PowerShell for administration tasks
• Windows Failover Cluster configuration and maintenance
• Windows Server Roles and Features
• .NET Framework Components
Preferred Knowledge and Skills:• Installing and upgrading SQL Servers, including applying service packs, cumulative updates
• Performing routine database maintenance
o Knowledge of SQL Server Agent and jobs
o Monitoring error logs and event logs for database errors and warnings
• SQL Server native tools and services
o SQL Server Profiler
o Index Tuning Advisor
o SQL Server Configuration Manager
o Extended Events
o Performance Monitor
o Dynamic Management View
o SQL Server Broker Service
o Linked Servers
o MSDTC
o SQL Server System Databases knowledge
o SQL Server Health Checks and Policies
• Managing SQL Server security and auditing
o User security
o Authentication methods
o SQL Server and database auditing
o Encryption at rest, transit, and backup
• Capacity Planning for storage and database objects
o Maintaining and managing SQL Server disk storage and experience with AWS storage systems to ensure storage is properly utilized
o Managing disk storage for Windows Failover Cluster Service (WFCS)
• Database backup and recovery
o Establishing standards and schedules for database backups
o Developing recovery procedures to meet RPO and RTO
o Restoring databases with point in time recovery
• Creating and testing Disaster Recovery plans
• Proficient in TSQL coding, tuning, and ETL methodologies
• SQL Server High Availability Methods
o Experience with VLDB
o Experience monitoring, supporting, troubleshooting high intense systems with both online transactions and batch transactions
o Always On and AWS HA Zones
Required: 3 Years Windows Server Administration experience:
• Building and maintaining Windows Servers and EC2 Instances
• Installing and managing end point protection
• Application Server, Web Server, File Server, and FTP Server configuration and maintenance
• Utilizing PowerShell for administration tasks
• Windows Failover Cluster configuration and maintenance
• Windows Server Roles and Features
• .NET Framework Components
• Experience with FAST GenTax/DS-VS architecture and application maintenance
• Familiarity with industry security standards (PUB1075, FIPS, and PII)
• Cloud computing knowledge
• Cloud storage, backup, and restore mechanisms
• Firewall administration and maintenance
• Active Directory knowledge (GPO, FQDN, DNS Server, SPN)
• Email, SMTP, and Proxy Server troubleshooting
• Web Services development and support
• Availability to provide 24 hour support
• Strong communication skills, both oral and written
Requirements
Skill
Required / Desired
Amount
of Experience
SENIOR SQL Database Administrator Skills and Experience
Required
4
Years
Required
4
Years
SQL Database administration (see sub-bullets in JD) SQL Server 2016 or later
Required
4
Years
Required
4
Years
Windows Server Administration experience (see sub-bullets in JD)
Required
3
Years
Required
3
Years
Certifications
Required
Required
24hr Support
Required
Required
GenTax Software Application architecture and application maintenance
Desired
Desired
Skills Required
- At least 4 years of SQL Server 2022 or later database administration experience
- Hands-on experience installing, upgrading, patching, maintaining, monitoring, securing, and auditing SQL Server environments
- Experience with SQL Server Agent, jobs, error logs, event logs, native SQL Server tools, Extended Events, DMVs, Linked Servers, MSDTC, and system databases
- Experience with SQL Server storage management and AWS storage systems
- Experience managing Windows Failover Cluster Service disk storage
- Experience establishing database backup schedules and recovery procedures meeting RPO and RTO objectives
- Experience with point-in-time database recovery and disaster recovery planning and testing
- Proficiency in T-SQL coding, performance tuning, and ETL methodologies
- Experience with SQL Server high availability methods, VLDBs, Always On, and AWS HA Zones
- Experience supporting high-intensity systems with online and batch transactions
- At least 3 years of Windows Server administration experience
- Experience building and maintaining Windows Servers and EC2 instances
- Experience installing and managing endpoint protection
- Experience configuring and maintaining application, web, file, and FTP servers
- PowerShell administration experience
- Windows Failover Cluster configuration and maintenance experience
- Knowledge of Windows Server roles and features and .NET Framework components
- Availability to provide 24-hour support
- FAST GenTax and DS-VS architecture and application maintenance experience
- Knowledge of PUB1075, FIPS, and PII security standards
- Cloud computing, storage, backup, and restore knowledge
- Firewall administration and maintenance experience
- Active Directory, GPO, FQDN, DNS, and SPN knowledge
- Email, SMTP, and proxy server troubleshooting experience
- Web services development and support experience
- Strong oral and written communication skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Novalink Solutions LLC is a global consulting, engineering, and AI product development company specializing in information technology and telecommunications. They provide AI-powered products, automation platforms, intelligent workflow systems, IT consulting, managed engineering, and staff augmentation services.
