Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
RI
Rose International
Senior SQL Server Database Administrator (SQL Server 2022, AWS, High Availability & Disaster Recover
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
71
out of 100
Average of individual scores
Job Description
- Only qualified Senior SQL DBA candidates located in the Little Rock, AR area will be considered due to the position requiring an on-site presence
Required Skills:
SENIOR SQL
Database Administrator Skills and Experience (4 Years)- SQL Database administration (see sub-bullets in JD) SQL Server 2016 or later (4 Years)
- Windows Server Administration experience (see sub-bullets in JD) (3 Years)
- Certifications
- 24hr Support SQL Server 2022 (or later versions) database administration:
- Installing and upgrading SQL Servers, including applying service packs, cumulative updates
- Performing routine database maintenance
- Knowledge of SQL Server Agent and jobs
- Monitoring error logs and event logs for database errors and warnings
- SQL Server native tools and services
- SQL Server Profiler
- Index Tuning Advisor
- SQL Server Configuration Manager
- Extended Events
- Performance Monitor
- Dynamic Management View
- SQL Server Broker Service
- Linked Servers
- MSDTC
- SQL Server System Databases knowledge
- SQL Server Health Checks and Policies
- Managing SQL Server security and auditing
- User security
- Authentication methods
- SQL Server and database auditing
- Encryption at rest, transit, and backup
- Capacity Planning for storage and database objects
- Maintaining and managing SQL Server disk storage and experience with AWS storage systems to ensure storage is properly utilized
- Managing disk storage for Windows Failover Cluster Service (WFCS)
- Database backup and recovery
- Establishing standards and schedules for database backups
- Developing recovery procedures to meet RPO and RTO
- 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
- Experience with VLDB
- Experience monitoring, supporting, troubleshooting high intense systems with both online transactions and batch transactions
- Always On and AWS HA ZonesWindows 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 ComponentsPreferred Skills:
- GenTax Software Application architecture and application maintenance
- 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
Job Responsibilities:
- Oversees the design, development, and maintenance of ASP.NET Web Forms applications
- Maintain and enhance existing code
- Perform and participate in design and code review
- Identify risks and make recommendations for best practices
- Meets with and manages expectations of key stakeholders