EVERSANA

The Database Administrator will be expected to exhibit strong troubleshooting techniques while striving to maintain a high level of customer satisfaction.. These results are achieved by:Responsibility for all database technology deployed in the enterprise including various versions of Microsoft SQL Server and features including the core database engine, SSRS, SSIS, SSAS, SQL Replication technologies and other modules.. Design, document, implement and maintain disaster recovery plans including regular testingResponsible for the SQL Server security model, including using Active Directory-integrated accounts in a multi-forest environment.. Responsible for advising report writers and their deployment in SSRS or writing reports when needed.. Determine the best way to improve performance, whether through hardware purchases, server configuration changes or index and query changesUnderstanding of software development methodologies, software development lifecycle management, and working in an Agile/SCRUM environment with software development teams, providing consultative advice on database design and query optimization, including indexes.

sr database administrator

Job DescriptionOn a day-to-day basis, this individual will be responsible for administrating and implementing database solutions while providing system operational support, administration, problem resolution, and perform software installations and upgrades on our database systems. The Database Administrator will be expected to exhibit strong troubleshooting techniques while striving to maintain a high level of customer satisfaction. Other duties also include monitoring performance and capacity on our database systems. ESSENTIAL DUTIES AND RESPONSIBILITIES:Our employees are tasked with delivering excellent business results through the efforts of their teams. These results are achieved by:Responsibility for all database technology deployed in the enterprise including various versions of Microsoft SQL Server and features including the core database engine, SSRS, SSIS, SSAS, SQL Replication technologies and other modules. Perform installations of SQL server, including patching.Configuration and maintenance of high availability technologies such as SQL replication, failover clusters, and Always-On Availability Groups.Monitor SQL Server for performance, utilization, and capacity. Work with application teams when appropriate to address issues.Manage maintenance plans, backups, and agent jobs.Design, document, implement and maintain disaster recovery plans including regular testingResponsible for the SQL Server security model, including using Active Directory-integrated accounts in a multi-forest environment.Responsible for T-SQL query writing and optimization.Responsible for database Architecture.Responsible for advising report writers and their deployment in SSRS or writing reports when needed.Responsible for performing SQL traces and SQL Server Profiler to analyze and troubleshoot problems.Determine the best way to improve performance, whether through hardware purchases, server configuration changes or index and query changesUnderstanding of software development methodologies, software development lifecycle management, and working in an Agile/SCRUM environment with software development teams, providing consultative advice on database design and query optimization, including indexes.Familiarity with DevOps tools such as Octopus Deploy for managing releases.Familiarity with code repository tools such as Microsoft Team Foundation Server for managing SQL objects as code with version control.Lead projects which may include additional resources.On-call support for after-hours issues required. Leverage automated alerting to be notified of issues as they happen. Tune alerts to reduce noise.Responds to incoming phone, email or web reported technical issues from internal users related to network, infrastructure, and to assist in troubleshooting database issues as well as application issues which the database may be a contributing factor.Identifies severity and impact and documents details in the Help Desk call tracking system.Performs database monitoring to ensure service level agreements are met and alerts appropriate IT staff and management of any downtime.Works in partnership with all IT teams to find solutions, and/or escalates issues to appropriate IT groups for resolution. Communicates status and updates to end users in a timely and consistent manner.Sets priorities for open issues and escalates issues to the correct department for resolution.Follows through with closure of user issues.Recreates problems in development environments for troubleshooting and resolution when needed.Creates and documents workarounds.Assist in training.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.EXPECTATIONS OF THE JOB:Hours 40 hours per week, 5 days of the weekThe above list reflects the general details necessary to describe the expectations of the position and shall not be construed as the only expectations that may be assigned for the position.An individual in this position must be able to successfully perform the expectations listed above. QualificationsMINIMUM KNOWLEDGE, SKILLS AND ABILITIES:The requirements listed below are representative of the experience, education, knowledge, skill and/or abilities required.10+ years experience in database administration in an enterprise environment, preferably across multiple versions of SQL Server using multiple features including SSRS and SSIS.Administrative knowledge of Active Directory securityScripting and automation experience, including SSIS scriptingDemonstrated excellent verbal and written communication skills Demonstrated strong customer service and analytic skills Demonstrated ability to think through sets of complex problems, create and implement appropriate solutions Proven ability to establish and maintain effective professional working relationships Ability to think and work independently Ability to adapt and learn in a fast paced, changing environmentAdministrative experience with Windows Server OSLinux experience a plus.Practical experience in backup technologies that can be used to back up SQL Servers.Experience in Disaster Recovery technologies.PREFERRED QUALIFICATIONS:15+ Years of experience preferred spanning more than one environmentMongoDB and other non-Microsoft SQL Server database technologies a plusData Warehousing experience a plusCloud-based database technologies a plusPowerShell scripting and automation experience a plusPHYSICAL/MENTAL DEMANDS AND WORKING ENVIRONMENT:The physical and mental requirements along with the work environment characteristics described here are representative of those an individual encounters while performing the essential functions of this position.Office: While performing the essential functions of this job the employee is frequently required to reach, grasp, stand and/or sit for long periods of time (up to 90% of the shift), walk, talk and hear; occasionally required to lift and/or move up to 25 pounds. The noise level in the work environment is usually moderately quiet, with frequent interruptions and multiple demands.Work Perks  Competitive Wages Above market salary structures as part of our total rewards program  Retirement Resources Generous employer matching retirement solutions  Health & Wellness Leading health, dental and vision insurance products  Continuous Education Employer-funded tuition reimbursement  Global Workplace Flexibility Remote and hybrid work across the globe  Paid Time Off Generous paid time off including company holidays  Training & Development Company provided training and development, including LinkedIn Learning  Employee Assistant Programs Offering financial, work-life balance, legal solutions and more to employees at no cost 24-7-365

START NEW SEARCH