OPENTEXT
OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation.
Your Impact
OpenText is hiring a Senior 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.
What the role offers
- Strong data analytic skills; Ability to troubleshoot data questions/discrepancies with little to no documentation
- Design/analyze database schemas and optimize database design
- Strong T-SQL script creation, used in ad-hoc analysis and object creation
- Able to work independently
- Backend Development: Strong experience in C#, .Net Core, Oops concepts, SOLID Principles and Design Patterns.
- Microservices Architecture: Skilled in designing and developing microservices, including knowledge of RESTful API design and event-driven architectures.
- Design, develop, and test database objects (tables, views, stored procedures, indexes, functions, constraints) that are highly optimized
- 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
- Provide off-hours/flex support as needed
What you need to succeed
- 3+ years experience designing and implementing database objects using best practices within Microsoft SQL Server
- 3+ years experience in eCommerce transactional SQL Server development working as a SQL developer
- Knowledge of proper database normalization, indexing, transaction protection, and locking
- 3+ years experience developing tables, views, stored procedures, indexes, functions, and constraints
- 3+ years experience using T-SQL including writing complex queries for ad-hoc requests and data analysis
One Last thing
- Experience with high transaction volumes and scalable database models
- Knowledge of XML and JSON
- Extract, Transform, Load development using SQL Server Integration Services (SSIS)
- 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
OpenText's efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws.
If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please contact us athr@opentext.com. Our proactive approach fosters collaboration, innovation, and personal growth, enriching OpenText's vibrant workplace.
