VARITE INC · 8 hours ago
Senior SQL Server Database Administrator
VARITE INC is seeking a skilled SQL Database Administrator with expertise in installation, configuration, and maintenance of SQL database servers. The ideal candidate will be responsible for monitoring system performance, implementing backup strategies, and collaborating with development teams to enhance database solutions.
Information Technology & Services
Responsibilities
Install, configure, and maintain SQL database servers (RDS and on-prem/Cloud SQL server installations)
Monitor and tune database performance to ensure high levels of performance, availability, and security
Implement and maintain database backup and recovery strategies to minimize data loss and downtime
Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning
Develop processes for optimizing database security, protect sensitive data, and manage database access efficiently
Complete necessary patching and updates on servers and instances
Recommend and implement emerging database technologies
Create and manage database reports, visualizations, and dashboards
Refine and automate regular/repeating processes, track issues, and document changes
Be available for on-call support as needed
Work with developers, DevOps and engineering team to support application development and implement solutions/enhancements for recurring problems
Design and complete migration of databases to AWS
Troubleshoot and resolve database-related problems/escalations in a timely manner
Qualification
Required
5 to 8 years of experience in SQL server database administration, AWS RDS, and Redshift
Strong command of SQL, SQL server tools and NoSQL databases like MongoDB
Experience with High Availability (HA), database security, backup and Disaster Recovery (DR)
Experience in design, planning and migration of databases to AWS
Experience in PowerShell/Unix Shell scripting & operational automation
Experience with Performance Tuning and Optimization, using native monitoring and troubleshooting tools as well as 3rd party tools
Understanding of relational and dimensional data modeling
Familiarity with SSAS, SSIS, SSRS
Experience working with Windows server, including Active Directory
Self-motivated, directed and with keen attention to detail
Excellent interpersonal, verbal and written communication skills as well as strong logical, analytical and problem solving skills
Experience working in team-oriented, collaborative environment and with teams spread across multiple locations across multiple time zones
Experience with Linux and Windows Server environments
Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
Experience with AWS cloud services (RDS, Redshift, S3, Glue) required
Bachelor's degree in computer science or a related field
Preferred
MCSE/MCSA certifications preferred
Experience with MongoDB is preferred