Sr. Database Administrator

Job Title :   Senior SQL Database Administrator  

Location:    London (Remote in Canada)     

Reporting To : Manager - Database Administration

Position Overview:

As a part of a technical team, the Senior DBA focus more on automating workload into repeatable and consistent processes leveraging appropriate tools.  Builds should be scripted as much as possible, and these scripts are managed in a source control system. You will design, implement, administer and maintain databases including monitoring, backup and recovery procedures, performance tuning and implementing database change management.  This role requires strong familiarity with both MSSQL and MySQL database systems on Window/Linux/Unix based environments. The person promotes teamwork between Development and Operations teams. The Senior DBA ensures principals with data design, stewardship and acts as a data guardian.

Core Job Duties and Responsibilities:

• Works with Development resources in partnership to Code, test, and implement database solution according to best standard
• Coordinates physical changes to relational and non-relational databases
• Experience working with case tracking tools (i.e. JIRA)
• Designs logical and physical databases and reviews database design to understand how changes to be made would affect physical database (how data is stored in terms of physical characteristics, such as location, amount of space, and access method)
• Establishes physical database parameters, codes database objects/queries and specifies database identifiers to DBMS or guide others in coding best practices
• Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve
• Tests and corrects errors (i.e. queries, views, stored procedures/functions, triggers etc.), and refine changes to database configuration
• Interacts with developers to effectively explore, investigate and implement requirements as they apply to database technology
• Ensures that database systems are available, secure, and that production support procedures are well documented and leverages scripting and automation technologies to improve speed of delivery (i.e. GIT, Ansible)
• Other duties as required by the position

Education, Experience and Qualifications:

• A degree or diploma in Computer Science
• 7+ years’ experience in relational database technologies (i.e. MSSQL, MySQL Server, Postgres, Oracle etc.)
• Familiarity with non-relational database (i.e. Cassandra, MongoDB, Solr) will be huge plus
• Demonstrable expertise with performance tuning, replication and data warehousing
• Experience with Data modeling tools
• Experience with developing stored procedures/queries/triggers/views etc. using various SQL scripting languages
• High availability experience with MySQL replication (master-slave, master-master) and SQL Server Always On Availability Groups (AOAG)
• Expertise with Windows/Linux Operating Systems and cloud hosting providers (Azure/AWS etc.)
• Automation and configuration management tools
• Backup and recovery
• Security and Monitoring applications
• Knowledge of development process, tools and technologies

J.D. Power is a global leader in consumer insights, data, analytics, and advisory services that helps clients drive growth and profitability. The company’s industry benchmarks and reputation for independence and integrity have established it as one of the world’s most well-known and trusted brands.

Truth that Transforms: At J.D. Power, we amplify the voice of the consumer, and help brands improve the value of their products and services. Our capabilities empower everyone in the global commerce ecosystem, enabling better purchase decisions – and better business results. We understand that the customer experience is vital and that simply measuring it is not enough. Our analysts focus on driving results that improve customer loyalty and advocacy. Our success is driven by how much we help companies improve the customer experience. But data is only as powerful as the analysis and insights tied to it—and we put that power in the hands of our clients through our interactive reporting platforms. The data, analytics, insights, best practices, and action plans clients need are available whenever and wherever they need them, to help them make data-driven decisions that will improve their customer experience and drive positive financial results.

J.D. Power’s recruitment efforts are aligned with the company's commitment to provide opportunities rooted in diversity, inclusion, and equality.

Our Vision: To be the leader in providing advanced data solutions that empower industry transformation.

Our Mission: We unite industry leading data and insights with world-class technology to solve our clients’ toughest challenges.

Our Values: We are Truth Finders, Change Makers and Team Driven.

We are dedicated to leveraging comprehensive and equitable practices which contribute to the overall success of the company and its employees. We invite you to learn more about our DE&I efforts.

To all recruitment agencies: J.D. Power does not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes.

Apply now