Sr. Database Reliability Engineer II

Job Summary: 
Under general supervision, the Sr. Database Reliability Engineer II will be responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of data systems in the company. The role includes the development and design of database strategies, system monitoring and improving performance and capacity, and planning for future expansion requirements. Leads root cause analysis for performance issues, researches and participates in implementation of related new technologies. The Sr. Database Reliability Engineer II will mentor/coach team members including Database Administrators.  They may also plan, co-ordinate and implement security measures to safeguard the database.
 
Job Expectations:

• Installing and upgrading the database server and application tools

• Allocating system storage and planning future storage requirements for the database system

• Developing database queries for applications and programs as needed

• Diagnosing database problems and coming up with resolutions

• Ensuring compliance with database vendor license agreement

• Monitoring and optimizing the performance of the database

• Planning for backup and recovery of database information

• Contacting vendors for technical support

• Serves as the subject matter expert on DRE issues, improvements and implementations

• Mentors and coaches new and/or less experienced DRE’s on the team

• Participate in on-call rotation and incident escalations as necessary 

The duties and responsibilities described above may provide only a partial description of this position. This is not an exhaustive list of all aspects of the job.  Other duties and responsibilities not outlined in this document may be added as necessary or desirable, with or without notice.
Knowledge, Skills and Abilities:
   Required:

• Strong knowledge of relational and nosql databases 

• Strong knowledge of T-SQL and experience with Microsoft SQL Server

• Full understanding of database transactions and how they work.

• Experience in optimizing query plans

• Experience in database security

• Experience in working with SQL profiler

• Experience in working with high traffic databases

• Experience in setting up and managing fail-over clusters

• Experience in database mirroring and replications

• Experience in AWS (RDS, EC2, S3, IAM etc.) 

• Experience migrating MSSQL databases to postgresql

• Experience in managing infrastructure as code, such as terraform, ansible, etc.

Experience Requirements:

Generally requires a minimum of eight (8) to fifteen (15) years of experience with the Microsoft SQL Server. Experience in working with NOSQL databases would be an advantage.

Education Requirements:

Bachelor’s Degree in Computer Science or related field required, or equivalent work experience

Master’s Degree preferred

Judgment/Reasoning Ability:  Able to identify, troubleshoot and resolve problems quickly using sound judgment, poise and diplomacy.  Ability to use judgment and reasoning skills, and determine when to escalate issues, as required, in a timely manner. 

Physical Demands (Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)   The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. 

While performing the duties of this job, the employee is required to sit, stand, walk, reach, bend and move about the facility. 

Work Environment:  The noise in the work environment is usually moderate.  Other factors are:

• Ability to travel 

• Hectic, fast-paced with multi-level distractions

• Professional, yet casual work environment

• Office environment

• Ability to work extended hours as required

#LI-JC1