View All Jobs at Esr healthcare
Refer a Friend
Why join Esr healthcare
esrhealthcare.com.mysmartjobboard.com
Job Description
SQL DBA L3 Appleton, WI (Onsite from day 1)
>
> Job Description:
> Experience - Min 10+ years required.
>
> This position is 6+ months in delivering and supporting a technical
> solution for MS SQL Server Database technologies and requires a person
> who has expertise in setting up, configuring, deploying and supporting
> MS SQL Server 2019, 2016, 2014, 2012, 2008 databases throughout the
> enterprise. This position will have current subject matter experience
> not only in strategic vision, design and development but also in
> current deployment practices. He/she will have contacts within the
> industry that will allow for continuous updating of industry practice
> information. This position requires 7+ years of experience.
> The successful candidate will be able to quickly understand and
> resolve issues, mitigate risks and dependencies and the ability to
> drive projects to completion.
>
> Details:
>
> · Identifies database requirements by interviewing customers;
> analyzing department applications, programming, and operations;
> evaluating existing systems and designing proposed systems.
> · Recommends solutions by defining database physical structure
> and functional capabilities, database security, data back-up, and
> recovery specifications.
> · Installs revised or new systems by proposing specifications
> and flowcharts; recommending optimum access techniques; coordinating
> installation requirements.
> · Maintains database performance by calculating optimum values
> for database parameters; implementing new releases; completing
> maintenance requirements; evaluating computer operating systems and
> hardware products.
> · Prepares users by conducting training; providing information;
> resolving problems.
> · Provides information by answering questions and requests.
> · Supports database functions by designing and coding
> utilities.
> · Maintains quality service by establishing and enforcing
> organization standards.
> · Maintains professional and technical knowledge by attending
> educational workshops; reviewing professional publications;
> establishing personal networks; benchmarking state-of-the-art
> practices; participating in professional societies.
> · Contributes to team effort by accomplishing related results
> as needed
>
> Essential Skills and Competencies:
>
> · Install, configure and fine tune MS SQL 2019, 2016, 2014,
> 2012 and 2008 R2
> · Proficient in High availability (Always on / Replication /
> Mirroring / Clustering etc.)
> · Proficient in SSIS package development and deployment.
> · Experience in Upgrade / Database Migrations between different
> SQL versions or Different data centers.
> · Experience working with storage mount points for SQL Server
> and establish disk I/O baselines.
> · Experience working with VLDB's over 1TB in size.
> · Experience working with table partitioning and indexes.
> · Experience working with using Actifio for SQL database
> backups.
> · Need to be very good at Database Performance Tuning.
> · Implementing Database Security using SOX/Internal audit
> guidelines.
> · Experience using JIRA as a work management tool.
> · Implementing archiving policies for Data life Cycle
> Management and retention policies.
> · Experience with different Operating Systems (Windows / Linux)
> · Promoting Process Improvement / Problem Solving / Presenting
> Technical Information
> · Attention to Detail and Focus on Quality
> · Excellent interpersonal, verbal and written communications,
> analytical and presentation skills.
>
> Thanks & Regards,
>
> Shivangi
Skills