Database Engineer Ii (Remote)

American Specialty Health Incorporated is seeking a Database Engineer II to join our Information Technology Software department. This position will provide high quality Design and T-SQL code to your Agile teams. Open lines of communication with the application engineers and your fellow database team members. High quality of work and communicate as accurate a timeline as possible.

Salary Range

American Specialty Health complies with state and federal wage and hour laws and compensation depends upon candidate’s qualifications, education, skill set, years of experience, and internal equity. $89,300.00 to $121,000.00 Full Time Annual Salary Range.

Remote Worker Considerations

Candidates who are selected for this position will be trained remotely and must be able to work from home in a designated work area with company-provided technology equipment. This remote/WFH position requires you have a stable connection to your Internet Service Provider with the ability to participate by video in online meetings over a reliable and consistent network (minimum internet download of 50 Mbps and 10 Mbps upload speed).

Remote Worker Considerations:

Candidates who are selected for this position will be trained remotely and must be able to work from home in a designated work area with company-provided technology equipment.

Responsibilities

• Participate in design and architecture review of the databases and applications. Lead efforts with database topology review and communicate with multiple teams to finalize optimal design for databases and applications.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Serve as escalation point for troubleshooting minor to major problems on an as-needed basis; often requiring time sensitive response and pro-active communication to different groups within the organization Requirements.
• Develop SSIS packages to meet business needs.
• Contribute to the creation of processes, procedures and standards for SQL Server database administration that supports the use of optimal database server resources and performance to minimize potential downtime scenarios.
• Modeling, designing, and developing database solutions
• Modeling OLTP database objects and independently providing solutions to your customer, with minimal guidance.
• Assisting database development teams in designing new database programs that meet the organization's performance needs.
• Performing debugging procedures on database scripts and programs, as well as resolving conflicts.
• Documenting processes related to database design, configuration, and performance.
• Keeping abreast of developments and best practices in database engineering.
• Shredding and understanding older code without the need to know everything about a business process.
• Monitoring databases and related systems to ensure optimized performance.

Qualifications

• Ability to work independently and with minimal guidance from Senior Engineers.
• Knowledge of the Agile methodology.
• Database modeling with a focus on OLTP environments.
• An understanding of SQL Server best practices. Along with conforming to database design standards.
• Evidence of continuous learning and being part of the SQL community (certifications, training, group associations) is preferred.
• Experience creating, supporting, and troubleshooting existing stored procedures, functions, views, and all other database objects.
• Experience working with SSIS is preferred.
• Experience with managing and deploying database changes to different environments in support of the software development lifecycle. A familiarity with SQL Server Database Projects in Visual Studio is preferred.
• Bachelor’s degree in an IT related field or equivalent experience. If equivalent experience, high school diploma required.
• Experience performance tuning TSQL statements within a single database.
• 1 – 3 years of prior experience with T-SQL coding. Familiar with SQL Server 2012 all the way through SQL Server 2019.
• Experience creating, supporting, and troubleshooting existing SQL Agent Jobs that span a single database.

Core Competencies

• Ability to exercise strict confidentiality in all matters.
• Demonstrated ability to analyze information, problems, issues, situations and procedures to develop effective solutions.
• Ability to display excellent customer service to meet the needs and expectations of both internal and external customers.
• Ability to effectively organize, prioritize, multi-task and manage time.
• Excellent listening and interpersonal communication skills to identify critical core competencies based on success factors and organizational environment.
• Demonstrated ability to interact in a positive, respectful manner and establish and maintain cooperative working relationships.
• Demonstrated accuracy and productivity in a changing environment with constant interruptions.

Mobility

Primarily sedentary, able to sit for long periods of time.

Physical Requirements

Ability to speak, see and hear other personnel and/or objects. Ability to communicate both in verbal and written form. Ability to travel within the facility. Capable of using a telephone and computer keyboard. Ability to lift up to 10 lbs.

Environmental Conditions

Work-from-home (WFH) environment.

American Specialty Health is an Equal Opportunity/Affirmative Action Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law.

Please view Equal Employment Opportunity Posters provided by OFCCP here.

If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact our Human Resources Department at (800) 848-3555 x6702.

ASH will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company’s legal duty to furnish information.
#LI-Remote