Senior SQL Server Database Developer - Alpharetta, United States - OpenText
Description
** Senior SQL Server Database Developer**
Req id: 23903 Alpharetta, GA, US
**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.
**Life At Opentext:**
At OpenText and in IT, we believe in every employee having meaningful, purposeful work. By joining our team, you will join a community of supportive and collaborative peers focused on innovation, teamwork, and driving successful outcomes. Youll be expected to bring with you an ideation and Yes, if mindset. And, as you build your network and demonstrate your professional excellence, you will have the opportunity to forge your own career path and professional growth.
**The Opportunity:** **#LI-Remote**
OpenText is hiring a Lead 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 candidates 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
Design/analyze 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) 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.
Provide guidance and mentoring in database marketing development best practices
Lead and participate in team planning, design, and review sessions
Mentor junior, mid, and senior level developers
**What it takes to excel:**
7+ 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
**Desirable Skills:**
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
exposure to NoSQL databases e.g. DynamoDB, HBase, Cassandra, Mongo would be great but are not essential
For Colorado residents, this job is expected to pay in the range of $130,000/annum to $150,000/annum in addition to a comprehensive and competitive group benefit and healthcare plan. Individual compensation will be determined based on skills and experience comparable to the job requirements.
OpenText is an equal opportunity employer that hires and attracts talent regardless of race, religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, marital status, sex, age, veteran status, or sexual orientation. At OpenText we acknowledge, value and respect diversity. We draw on diversity of thought and experience to reflect the rich array of cultures representing our broad global customer base.
While OpenText is an Equal Opportunity Employer, our 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. Should you require accommodations during the selection process, please contact
Subject to applicable laws and regulations, OpenTexts global vaccination policy requires all employees to be fully vaccinated against COVID-19 to enter an OpenText office to maintain a safe workplace for our employees.
**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.
Its 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 potential. Become an OpenText Navigator.**