Architect - 470

Altera, a new member of the N. Harris Computer Corporation family, delivers health IT solutions that support caregivers around the world. These include the Sunrise, Paragon®, Altera TouchWorks®, Altera Opal, STAR, HealthQuest and dbMotion solutions. At the intersection of technology and the human experience, Altera Digital Health is driving a new era of healthcare, in which innovation and expertise can elevate care delivery and inspire healthier communities across the globe. A new age in healthcare technology has just begun.

***

**Experience**

Minimum of 10 Year over all experience with minimum of 3-5 year in a DB Architect role

**Technical Skills**
- Good knowledge of SQL engine architecture, RDBMS concepts and data modeling
- Should have handled large databases, say 1TB or more, on highly concurrent environment
- Good knowledge & experience in Transact-SQL i.e. writing Stored Procedures, UDF and Triggers
- Troubleshoot and resolve SQL related issues
- Good experience on Always ON, CDC and extended events
- Working Knowledge on SQL Azure and Migration
- Working experience in SSRS, SSIS and Power BI
- Experience working with SQL 2014 or higher version is a must
- Hands on experience in performance tuning of database objects
- Conduct code/schema reviews for developers and mentor/coach them on areas of improvement
- Working knowledge in Database Administration SQL Server
- Knowledge of In-memory OLTP, Azure SQL Audit, UML, XML and JSON will be an added advantage

**Soft Skills**
- A Team Player with good interpersonal skills & communication skills
- Ability to work independently and with a team.
- Excellent analytical and problem-solving skills.
- Willing to work during weekends/off hours based on business need
- Familiar with SAFe agile methodology or Scrum(Nice to Have)
- Knowledge on Healthcare Domain (Nice to Have)

Altera is an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state or local law.