The Information Technology (IT) department manages the technology and computer infrastructure that drives Tangerine’s business systems. The IT department supports the organization in these critical areas: End-User Technical Support, Desktop Management, Network Management, Voice and Data Communications, Business and Web Applications and Strategic Technical Planning.
The Senior SQL-Server Database Administrators role is to design, install, monitor, maintain and performance tune databases while ensuring high levels of data availability. This individual is also be responsible for developing, implementing and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. The Senior Database Administrator will report directly to the Director of Infrastructure Project and Database Systems.
Strategy and Planning
- Assess and develop long-term strategic goals for databases in conjunction with data owners and department managers.
- Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
Acquisition and Deployment
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Create models for new database development and/or changes to existing ones.
- Install and configure relevant network components to ensure database access as well as database consistency and integrity.
- Respond to and resolve database access and performance issues.
- Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
- Monitor, optimize and allocate physical data storage for database systems.
- Plan and coordinate data migrations between systems.
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Create, or support creation of, required reports in response to business needs.
- Establish appropriate end-user database access control levels.
- Develop routines for end users to facilitate best practices database use.
- Manage and/or provide guidance to members of the team.
- Implement corporate policy and audits; develop, publish, enforce and maintain standards and procedures.
- Manage development, test and production environments; perform administrative functions; maintain documentation.
- Promote changes via established IT change control procedures.
- Create and manage to service level agreements.
- Create and maintain data models and metadata.
- Design, create and maintain database structures; review application design and SQL code.
- Design, test and implement backup/recovery strategies and contingency plans.
- Monitor, analyze and report on availability, performance and resource consumption.
- Assess capacity and make recommendations on disk and server sizing based on projected growth.
- Plan, test and implement software upgrades; monitor alerts; administer licenses; interface with vendors.
- Remain current with industry and product direction; evaluate new technologies and product features; make recommendations as to how Tangerine can benefit.
- Troubleshoot problems; provide database problem resolution assistance to IT staff.
- Provide day-to-day consultancy and support to IT staff; act as backup for other Database Systems staff.
- Monitor daily operations; log issues and ensure resolution.
- Other duties as assigned.
- University or College Degree or equivalent experience
- 5+ years of experience as a DBA
- 3+ years of SQL coding experience
- 5+ years of application development experience with at least 2 in a senior capacity
- Experience working in a team-oriented, collaborative environment
- Technical Skills
- Superior working knowledge of SQL Server database products and the SQL language
- Strong understanding of database structures, theories, principles and practices
- Working technical experience with designing, building, installing, configuring and supporting database servers
- Experience with requirements gathering and database design
- Familiarity with client/server, operating system, storage and networking fundamentals
- Basic working knowledge of Windows (SQL Server)
- Strong technical documentation skills
- Proven analytical and problem-solving abilities
- Demonstrated ability in performance tuning and capacity management
- Ability to conduct research into database issues, standards and products as required
- Ability to present ideas in user-friendly language
- Ability to effectively prioritize and execute tasks in a high-pressure environment
- Availability to carry a 24x7 production support pager on a scheduled basis
- Good oral and written communication skills
- Good interpersonal skills
- Highly self-motivated and directed
- Keen attention to detail
The Senior SQL-Server Database Administrator will be working in a traditional office environment and may be subject to special working conditions as needed by the business. Special working conditions may cover a range of circumstances from regular evening and weekend work, overtime, shift work, working outdoors and/or working with challenging clients.
Tangerine will make reasonable accommodations for the known physical or mental disabilities of an otherwise qualified employee or applicant for employment, unless undue hardship to Tangerine would result. Any applicant or employee who requires accommodation in order to perform the essential functions of a job should contact Human Resources or his or her supervisor.
All members of the Tangerine Team are responsible for managing risk and compliance within their departments. As such, employees should maintain and demonstrate the highest standards of integrity and ethical conduct in accordance with Tangerine policies, guidelines and directions.
Tangerine is an Equal Opportunity Employer.
Ceridian. Makes Work Life Better™ This is our promise. Not only for our customers, but our employees as well. Ceridian is a cloud company powered by our people. As an innovative fast-growing...
Posted: 10/11/2018 1:19:54 PM The Information Management (IM) Program within Sunnybrook Health Sciences Centre is seeking a regular full-time Full Stack Developer located at the Bayview...
Category:Database Administration City: Toronto, Ontario, Canada Employment Type: Full Time Position Description: Join our Global Technology Operations Team! We have an immediate opening for a DBA...
Senior Consultant CA-ON-Toronto Apply View All Jobs Share This Job Addthis About Tibco Headquartered in Palo Alto, CA, TIBCO Software enables businesses to reach new heights on their path to...
Senior Programmer and Layout Specialist The Senior Programmer and Layout Specialist is a member of a team of technology professionals and is responsible for the requirements, design, construction,...
Principal Systems Architect - Eloqua Cloud R&D-18001594 Preferred Qualifications System Architect Preferred Qualifications Oracle Marketing Cloud - Eloqua is looking for a passionate and talented...
Ceridian. Makes Work Life Better™ This is our promise. Not only for our customers, but our...
Posted: 10/11/2018 1:19:54 PM The Information Management (IM) Program within Sunnybrook Health...
Category:Database Administration City: Toronto, Ontario, Canada Employment Type: Full...
Senior Consultant CA-ON-Toronto Apply View All Jobs Share This Job Addthis About...
Senior Programmer and Layout Specialist The Senior Programmer and Layout Specialist is a member...
Principal Systems Architect - Eloqua Cloud R&D-18001594 Preferred Qualifications System...