Job Description
The SENIOR SQL Database Administrator will be responsible for providing reliable, cost-effective, & secure enterprise-wide support for business-critical production & non-production databases for the client .
ON-SITE INTERVIWS ONLY
ON-SITE WORK ONLY
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.
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
- 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 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:
- 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
Numbers & Facts
| Location | Little Rock, AR |
| Industry | Staffing/Employment Agencies |
| Company Size | 50 to 99 employees |
| Year Founded | 2017 |
| Website | http://www.prismagicinc.com |
About Company
Prismagic started with an idea of connecting people with 'people', connecting the 'need' to 'accomplishments' and connecting the 'jobs' to 'lifestyle'. At Prismagic, we would like to partner with talent, we call consultants to understand their expertise and how we can best fit that in the growth engine of any corporate, we call client to create a win-win ecosystem for everyone.
With over 30 years of combined expeirence of the key stakeholders in Staffing, Services and Information Technology, Prismagic is a platform built to complement the need of its clients with the potential of its consultants.
We bring an energized team, a fresh perspective and the zeal to exceed the expectations of our partners every time we are entrusted to perform. Our rewards and recognitions today is only the delight that we can bring for our stakeholders through a committed workforce and an honest, transparent, value driven system.
PRISMAGIC (Not just a name, but a philosophy)
We always believed that businesses need to create magic for its stakeholders – the magic of solutions, the magic of trust and the magic of value – and whatever problem we could think of, the final solution is always People. Every problem always starts at design but invariably ends at People and each solution brought us to the fact, “People Relations IS MAGIC” – Process Reinforcement IS MAGIC – “PR-IS-MAGIC” - and We got our name. It is not just a name but a philosophy that every employee believes, trusts and run on.
For more details, please visit http://www.prismagicinc.com/
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder