Description

American Specialty Health Incorporated is seeking a Sr. Database Engineer I to join Information Technology Operations 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 communicating as accurate a timeline as possible. 

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).  

Responsibilities

• Modeling database objects and independently providing solutions to your customer without the need for guidance.
• Shredding and understanding older code without the need to know everything about a business process.
• Maintaining and enhancing the performance of existing database programs.
• Assisting database development teams in designing new database programs that meet the organization's performance needs.
• Monitoring databases and related systems to ensure optimized performance.
• Writing new support programs and scripts in support of development teams.
• Performing debugging procedures on database scripts and programs, as well as resolving conflicts.
• Adhering to best practices in securely storing, backing up, and archiving data.
• Documenting processes related to database design, configuration, and performance.
• Keeping abreast of developments and best practices in database engineering.
• Design, troubleshoot and optimize SSIS packages to meet business needs.
• 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.
• 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.
• Defining requirements for automating routine database service delivery processes and collaborating with peers to develop and enhance existing database service delivery automation solutions.
• 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.
• Mentoring Application Developers on the best way to accomplish a goal.
• Assist developers with complex query tuning and schema refinement.

Qualifications

• Bachelor’s degree in an IT related field or equivalent experience. If equivalent experience, high school diploma required.
• 3 – 5 years of prior experience with T-SQL coding at a Master level. Familiar with SQL Server 2012 all the way through SQL Server 2019.
• Evidence of continuous learning and being part of the SQL community (certifications, training, group associations) is preferred.
• Knowledge of the Agile methodology.
• Database modeling with a focus on OLTP environments. Experience working with a modeling tool like ER/Studio is preferred.
• Experience working within 2-week sprints as part of an agile scrum team including being able to determine effort, commit to requirements, and deliver product.
• Experience creating, supporting, and troubleshooting existing stored procedures, functions, views, and all other database objects.
• Experience creating, supporting, and troubleshooting existing SQL Agent Jobs that span multiple databases and perform ETL processing.
• Experience performance tuning complex TSQL statements across multiple databases.
• 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.
• Experience developing and troubleshooting SSIS packages from SQL 2012 forward, including the SSIS Catalog is preferred.
• A firm understanding of SQL Server best practices and conforming to database design standards.
• Knowledge and/or experience working with Azure Data Factory is a plus.
• Knowledge and/or experience working with Azure SQL Database is a plus.

Core Competencies

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

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

Office and/or Work-from-home (WFH) environment.

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. $112,500.00 to $143,00.00 Full Time Annual Salary Range.

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