Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

MSSQL Database SME

Ohio, United States (Remote)

MSSQL Database SME

1 Week ago • All levels • Administrative

About the job

Summary

This role involves directing the architecture, configuration, integration, monitoring, and development support of client database applications. Responsibilities include ensuring daily health checks, successful backups, database job execution, monitoring alert resolution, capacity planning, timely email responses, efficient ticket handling, high availability, database maintenance, technical support, consultancy on database design, disaster recovery execution, security updates, vulnerability remediation, project delivery, procedure updates, on-call support, cost optimization, and relationship building across the bank. The ideal candidate will have extensive experience with MS SQL Server database administration, Active Directory, and exposure to other database platforms. The role requires excellent knowledge of multiple database platforms, operating systems, networking, storage, and database design principles.

15 skills required for this role

Test your skills to join the top 1% applicants for this job

oracle

sql

mongodb

linux

java

confluence

ruby

bash

jira

subversion

vmware

github

teamcity

windows-server

azure

Must have:

MSSQL Database Administration
Active Directory experience
Excellent knowledge of multiple database platforms
Backup and recovery strategies
Database performance tuning
High availability and disaster recovery
Database security and auditing

Good to have:

MSSQL 2008-2019
Oracle 11g-19c
SAP Sybase ASE
MongoDB
Snowflake
SQL, T-SQL, PL-SQL
Python, Perl, Bash, PowerShell
Linux, Windows Server
Cloud computing (Azure, AWS, GCP, Oracle)

Not hearing back from companies?

Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

Project description

About the client: Our client is a UK subsidiary of a global financial house working in multiple markets and asset classes.
About the project: We're seeking for a talented and enthusiastic MS SQL Server/Oracle SME who will be responsible for, as part of a team, directing the architecture, configuration, integration, monitoring and development support of client database applications and associated resources.
The ideal candidate will have experience in MS Server database and specifics of Cloud solutions. This role will be focused on buildouts of new environments and overall heath and support of existed database systems. In this role you will also work to establishing best practices, standards in security, manage projects, actively participate in systems architecture events to create innovative solutions.

Responsibilities

OVERVIEW OF THE DEPARTMENT/SECTION:

Responsible for managing, maintaining, enhancing and strategic development of all database related technologies in EMEA as well as internationally for the Securities Business.

MAIN PURPOSE OF THE ROLE :

The Database Operations team are responsible for providing 24x7 RDBMS and NoSQL database support in EMEA and internationally for the Securities Business.

KEY RESPONSIBILITIES:

Responsible for ensuring daily health and compliance checks are performed for all Production systems.

Responsible for ensuring database systems are backed up successfully and any issues are promptly resolved

Responsible for ensuring database jobs are running successfully and any issues are promptly resolved.

Responsible for ensuring database monitoring alerts are detected promptly and satisfactorily resolved.

Responsible for ensuring sufficient capacity is available to accommodate projected BAU growth.

Responsible for ensuring all emails sent to the team distribution list are responded to in a timely manner.

Responsible for ensuring problem tickets and service requests are handled with efficiency and the customer in mind.

Responsible for ensuring database platforms are highly available, reliable, secure and performant.

Responsible for database installation, configuration, tuning, upgrades and general maintenance activities.

Responsible for providing technical support to application support and development teams.

Responsible for providing consultancy to application support and development teams on database and systems design.

Responsible for executing disaster recovery procedures when necessary.

Responsible for applying database security updates as per defined policies.

Responsible for reviewing and subsequently remediating items detected by Qualys vulnerability and compliance scans.

Responsible for ensuring that all project/investment related workloads are delivered according to plans and budget defined.

Responsible for ensuring all operational procedures are kept current and accurate.

Responsible for participating in On-Call rotation, triaging and addressing production issues as they arise.

Responsible for identifying cost saving and optimisation opportunities within MUS EMEA and the wider MUFG group.

Responsible for building strong relationships across the Bank and Securities with other Bank and Securities functions and businessareas, underpinned by trust and the core values of the bank.

Skills

Must have

SKILLS AND EXPERIENCE:

We need MSSQL Database Administration primarily

Essential:

-We are looking for a SQL Server DBA SME with Active Directory experience and some exposure to any of Sybase / Oracle / MongoDB / Snowflake.

Excellent knowledge of multiple database platforms such as MSSQL, Sybase, MySQL, PostgreSQL and MongoDB.

Excellent knowledge of configuring Linux and Windows operating systems for optimal database performance.

Excellent knowledge of networking, storage, server and virtualization layers.

Excellent knowledge of logical and physical database design.

Excellent knowledge of database installation and configuration.

Excellent knowledge of backup and recovery strategies.

Excellent knowledge of database performance and tuning.

Excellent knowledge of database migrations and upgrades.

Excellent knowledge of clustering and high-availability.

Excellent knowledge of replication and disaster recovery.

Excellent knowledge of database security and auditing.

Excellent knowledge of data security governance and regulations such as GDPR and SOX.

Nice to have

Desirable:

Good working knowledge of MSSQL 2008 / 2012 / 2014 / 2016 / 2017 / 2019 (including Always-On and Analysis Services).

Good working knowledge of Oracle 11g / 12c / 18c / 19c (including RAC, ASM, DataGuard and ODA appliances).

Good working knowledge of SAP (Sybase) ASE 12.5 / 15.7 / 16.0.

Good working knowledge of MongoDB 3.4 / 3.6 / 4.0 / 4.

Good working knowledge of Snowflake.

Good working knowledge of SQL, T-SQL and PL-SQL.

Good working knowledge of Python, Perl, Bash, PowerShell, C#, Java, Ruby.

Good working knowledge of Red Hat Enterprise Linux and Oracle Solaris.

Good working knowledge of Windows Server.

Good working knowledge of BMC Control-M.

Good working knowledge of ESX VMWare.

Good working knowledge of Nutanix HCI.

Good working knowledge of Rubrik.

Good working knowledge of EMC and HDS storage arrays.

Good working knowledge of EMC Networker, Data Domain and IBM Tivoli Storage Manager.

Good working knowledge of Bradmark, Oracle Cloud Control and Tivoil.

Good working knowledge of Active Directory, LDAP and Kerberos.

Good working knowledge of GitHub, Subversion and TeamCity.

Good working knowledge of CyberArk.

Good working knowledge of Splunk and QRadar.

Good working knowledge of Qualys.

Good working knowledge of SharePoint, JIRA and Confluence.

Good working knowledge of ServiceNow and Serena Business Manager.

Good working knowledge of cloud computing

IaaS, PaaS and SaaS offerings across Azure, AWS, GCP and Oracle.

Other

Languages

English: B2 Upper Intermediate

Seniority

Senior

View Full Job Description

About The Company

Luxoft

1245 Active Jobs

Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications.

DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.