Loading...
Share this Job
Apply now »

 

 

SQL Server Database Developer

Req id:  10891

Waterloo, ON, CA

 

OPENTEXT - THE INFORMATION COMPANY

As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. 

 

 

The Opportunity: 

OpenText is hiring a SQL Server Database Developer. The successful candidate will have strong experience with developing enterprise level SQL Server databases and gaining understanding of the data elements required for transactional development. In addition, the ideal candidate will have extensive experience developing/analyzing database schemas, designing, coding T-SQL objects, and creating database optimizations where applicable. The ability to quickly translate business requirements into effective database solutions will be critical to the candidate’s success. The successful candidate will participate in the implementation of solutions that employ leading-edge technologies. A high energy level, the ability to set and achieve goals, and great interpersonal and communication skills are essential.

 

 

What You Are Great At:

  • Strong data analytic skills;  Ability to troubleshoot data questions/discrepancies
  • Designing/analysing database schemas and optimize database design
  • Strong T-SQL script creation, used in ad-hoc analysis and object creation
  • Design, develop, and test database objects(tables, views, stored procedures, indexes, functions, constraints)
  • Ability to understand complex business processes and applications which read/write to various databases
  • Estimate development schedules and determine project scope
  • Create code that meets design specifications, follows standards, easy to maintain
  • Capable of identifying and proposing areas of improvement throughout the software development process
  • Uses source control for the appropriate data objects.
  • Work with other developers/business owners to achieve defined goals
     

What it takes to excel:

  • 3+ years’ experience designing and implementing database objects using best practices within Microsoft SQL Server
  • Experience in eCommerce transactional SQL Server development
  • Knowledge of proper database normalization, indexing, transaction protection, and locking is essential
  • Develop tables, views, stored procedures, indexes, functions, and constraints
  • Strong knowledge and experience using Transact-SQL including writing complex queries for ad-hoc requests and data analysis
  • Effective documentation skills (functional/technical design documents, entity relationship diagrams etc.)
  • Experience with high transaction volumes and scalable database models
  • Proficient knowledge of data modeling concepts and formalized database design including creating tables, indexes, and enforcing data integrity
  • Experience working on a commercial Enterprise-level product with a database back-end is a strong plus
  • Exposure to NoSQL databases e.g. DynamoDB, HBase, Cassandra, Mongo would be great but are not essential

 

 

At OpenText we understand and value diversity in our employees and are proud to be an Equal Opportunity Employer. We hire the best talent regardless of race, creed, color, national origin, ancestry, disability, marital status, sex, age, veteran status or sexual orientation. If you require accommodation at any time during the recruitment process please email accommodationrequests@opentext.com. Applicants have rights under Federal Employment Laws including but not limited to: Family and Medical Leave Act (FLMA)Equal Employment Opportunity  and Employee Polygraph Protection Act


OPENTEXT - THE INFORMATION COMPANY

Our growing team is mapping the future of Information Management, and we continue to make new discoveries that expand its boundaries. Join us and be part of a winning team, where the opportunities for your career are limitless. 

From its innovative start as a research project by University of Waterloo professors in 1991, OpenText has grown into a global company with offices in more than 35 countries. Our high- performance culture has forged our growth and is an excellent fit for people looking to push themselves to learn and do more.

It’s our time to lead, and as part of our team, it will be your time too. Our continued growth will provide you the opportunity to explore, learn and chart an exciting career path while enjoying a good work-life balance. 

Perks 
If you thrive in a dynamic work environment, there is always a new horizon to explore. We are proud to offer excellent benefits, challenging work and competitive financial rewards. 

Benefits 
Our employee programs prioritize employees’ well-being and that of their families. We offer a comprehensive benefit plan, education assistance, a wellness/fitness reimbursement and time off to volunteer. 

Social events 
With offices around the world and flexible work arrangements, OpenText strives to make sure all our employees feel connected. Teamwork extends to our social lives too from local social events to company-wide activities, we want our employees to take time to relax and have fun.  

Corporate Citizenship  
Corporate Citizenship is more than a program for us, it is engrained in our purpose, impact, and approach to doing business. Through numerous volunteer initiatives, we support education and innovation for global change.

Explore your career and your potential. Become an OpenText Voyager.

Apply now »