This is a fully remote position, allowing you to work from the comfort of your won home from anywhere in the US.
As a Senior SQL Server Database Administrator, you will support a large SQL Server environment with infrastructure both in on-prem data centers and AWS. This role is proficient at SQL Server Database Administration, T-SQL, DevOps concepts, Scripting and automated deployment, monitoring, and support. Be a hands-on engineer to drive detailed and evolutionary designs while working across the organization interfacing with the Application Development and Reporting Teams. Will execute day to day tasks related to operational or project work and contribute to 24x7x365 days of on-call staff coverage.
Responsibilities:
Configure and manage Always On Availability Groups and Failover Clustering.
Accurately complete change ticket requests for database deployments on a timely basis.
Provide SQL Server/T-SQL performance tuning including but not limited to configuration settings, storage optimization (on AWS), query tuning and indexing.
Ensure successful database backups in a way to meet the business RPO's and RTO's
Define improvements to increase system reliability, security, and performance.
Recommend and implement emerging database technologies.
Identify and automate repeating database tasks.
Ensures proper instrumentation of Infrastructure to align with Production Assurance processes (Event, Incident, Change, Release and Problem management).
Assist with database upgrades including planning, preparation & execution of upgrades.
Diagnose and troubleshoot database related issues and errors.
Incident, Change, Release and Problem management).
Contribute to 24x7x365 days of on-call staff coverage.
Required skills:
3+ years minimum experience as a SQL Server Database Administrator
Strong verbal and written communication skills.
PowerShell scripting experience
Knowledge of AWS including RDS, EC2, EBS, Cloud Watch, and S3
Demonstrated problem solving techniques.
Familiarity with SSAS, SSIS, SSRS
Experience with SQL Server Profiler and Extended Events
Critical thinker.
Experience in health care, insurance, or related field.
This position will analyze problems and administer more than one infrastructure area. Will understand and develop non-functional requirements for a system. This role is proficient at DevOps concepts, Scripting and automated deployment, monitoring and support. Will execute day to day tasks related to operational or project work. Contribute to 24x7x365 days of on-call staff coverage.
Performs daily database and database application support which includes the following tasks: Contributing to 24x7x365 staff coverage, Oracle, SQL Server, MongoDB and MariaDB, MySQL, Hadoop, Redshift, AWS EMR database and application server administration.
Assists with all duties related to on-going operational database infrastructure on premise and in the cloud.
Creates and maintains database objects.
Monitors, troubleshoots and resolves failed tasks or database issues.
Creates databases, database clusters, assign permissions and resolve connectivity issues.
Assists IT management in prioritizing database administration team projects.
Monitors database storage allocation and usage daily as well as other resource usage.
Assists with backup standards and schedules, and recovery procedures.
Develops security plans, testing and maintenance. Intent of this security plan is to establish a means of providing complete accountability for any and all use of the databases.
Develops and maintains the portions of the disaster recovery plan that pertain to the database servers and provide documentation of the steps necessary to perform the disaster recovery process. This documentation must provide detailed instructions on how to perform the disaster recovery plan at a level of explanation that any member of IT would be able to perform the steps.
Advises developers/end users on issues such as database design and application architecture.
Provides performance turning related to database technology and database/server configuration.
Provides Technical guidance to teammates.
Exports/Imports data and data replication.
Schedules Jobs and Events.
Manages special projects as assigned.
Other Job Requirements
Responsibilities
3+ years minimum experience deploying and/or administrating infrastructure solutions or database administration. Strong working knowledge of automated deployment and Cloud platforms.AWS Sysops certification or certifications in VMware, Microsoft, Cisco, Avaya, Oracle, SQL Server.Critical thinker.Demonstrated problem solving techniques.Strong verbal and written communication skills.Willing and able to quickly learn new technology.
General Job Information
Title
Senior SQL Server Database Administrator - Remote
Grade
27
Work Experience - Required
IT
Work Experience - Preferred
Education - Required
Education - Preferred
Bachelors - Computer and Information Science
License and Certifications - Required
License and Certifications - Preferred
Magellan Health, Inc. is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled.Every employee must understand, comply with and attest to the security responsibilities and security controls unique to their position; and comply with all applicable legal, regulatory, and contractual requirements and internal policies and procedures.
Magellan is the employer of choice for hard working people interested in making a difference in the health care industry and in the communities where we work and live. Our strong culture of caring is the common thread in both our business strategy and our work environment. We value professional growth and development, total health and wellness, rewards and recognition as well as employee unity. Magellan is a place where you can thrive.
Magellan is committed to providing equal employment opportunities to employees and applicants for employment without regard to race, color, creed, religion, sex, gender identity and expression, sexual orientation, marital status, age, national origin, ancestry, citizenship, physical or mental disability, disabled veteran or veteran of the Vietnam Era status, or any other factors protected by law.
Magellan is committed to meeting applicable Federal labor and employment law posting requirements by providing necessary posters in a format which is easily accessible and conspicuous to all applicants. Copies of applicable posters are accessible by clicking here (https://www.magellanhealth.com/media/760295/mg-federal-contractors-applicant-english.pdf) .
Warning: Employment Scam
It has come to our attention that a false representative is contacting potential candidates and offering them work at home positions with Magellan Health. -Interviews- are conducted completely through email and the false job offer includes the promise of a check to be issued to the candidate for the purposes of setting up a home office.
Please know that Magellan Health does not interview any candidate through email, nor do we issue checks to candidates to set up home offices. All of our available positions are posted on legitimate job boards and our recruitment team directly contacts candidates should there be a fit.
If you suspect you are being contacted by a false representative of Magellan Health, please call 410-953-2911
