Position: Lead MS SQL/Oracle DBA
Company: Luxoft
Experience required: 3y
Category: Other
English level: upper
Published: 2020-12-01T00:00:00+02:00

About the project: We're seeking for a talented and enthusiastic MS SQL Server/Oracle DBA 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.
About our team: Rapidly expanding group in Kyiv developing and supporting a range of client projects.
About working environment: Our team primary location is Kiev, working remotely in client environment. Currently the team operates fully in WFH mode.
Responsibilities:
Administration, support, and maintenance multiple MS SQL databases to ensure their performance, availability, and security for the agency both on prem/Azure.
Administration ofg Oracle database and Oracle Applications R12 12.2.x.
Serving as a technical expert in the area of Oracle Applications and database administration
Building database schema, tables, procedures and users/user access levels for each segment of database and modification of existing databases and database management systems. Setting up database for appropriate data sharing and disk partitioning,
Overseeing backup, clustering, mirroring, replication and fail-over. Implementing security and encryption to the database to safeguard information against accidental or unauthorized use, modification or disclosure.
Analysis, consolidation and tuning of databases for optimal efficiency, monitor systems and platforms for availability, monitoring database jobs for timely and accurate completion, and monitoring of capacity and performance of database and jobs for effective up-time and response time to the consumers of the data.
Serving as the top-tier escalation point for technical user issues and diagnose and resolve the most advanced issues.
Working as a part of a project team to coordinate database configurations and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.
Mandatory Skills:
- Excellent knowledge of MSSQL 2008 / 2012 / 2014 / 2016 / 2017 / 2019 (including Always-On and Analysis Services).
- Excellent knowledge of Oracle 11g / 12c / 18c / 19c (including RAC, ASM, DataGuard and ODA appliances).
- Excellent knowledge of SQL, T-SQL and PL-SQL.
- 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 Skills:
- Good working knowledge of scripting languages such as Python, Perl, Bash and PowerShell.
- 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.2.
- Good working knowledge of Oracle E-Business Suite 12.2.6.
- 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.