We are looking for a Database Senior Engineer for SkyConsult ( https://www.skyconsult.com/ ).
The ideal candidate is a problem solver with work experience in enterprise or carrier infrastructure, well organized and team player. Candidate will have the opportunity to develop his/her consulting skills, business processes knowledge and technical expertise by being exposed to our client’s complex business environment (oil & gas).
Primary Responsibilities:
Skills & Experience:
Working conditions:
The ideal candidate is a problem solver with work experience in enterprise or carrier infrastructure, well organized and team player. Candidate will have the opportunity to develop his/her consulting skills, business processes knowledge and technical expertise by being exposed to our client’s complex business environment (oil & gas).
Primary Responsibilities:
- Perform support activities, verifying the integrity and availability of all database systems, reviewing system and DB logs and proactively address issues;
- Database administration including installation, configuration, security, troubleshoot/fix problems, backup/restore process, data recovery;
- Design, develop, and support SQL Server SSIS packages covering the ETL for the Data Warehouse;
- Identify and lead the setting and exercising of data management standards and procedures for effective DBMS utilization and security;
- Fulfil ad hoc query and report requests from other departments;
- Act as lead for complex problem diagnosis and resolution and perform root cause analysis for service interruption issues;
- Perform Capacity forecasting and planning;
- Handle performance tuning and troubleshoot issues;
- Design and implement backup and recovery strategy;
- Ensure that system design complies with policies, standards, and principles;
- Deliver quality project deliverables in engineering, support and/or consultation to other teams;
- Develop, display, and maintain metrics for performance or reporting purposes;
- Support incidents and perform root cause analysis for service interruption issues;
- Automate administrative tasks using scripting languages;
- Work with diverse technical and non-technical teams, including Development, QA, IT Operations, Customer Operations and Project Management teams;
- Act as a point of expertise, advise others in the team on best practice and share knowledge;
- Create and implement change requests as needed;
- Structure, draft and review technical documentation, document technical requirements and processes for technical and non-technical audiences.
Skills & Experience:
- Professional experience of supporting a variety of RDBMS products in an enterprise environment – Specifically Microsoft SQL Server;
- Experience in design and management of MS SQL database on Linux or Windows, in optimizing database performance, implementing monitori, testing backup and restore strategies;
- Knowledge of SQL and related scripting;
- Knowledge of scripting technologies such as Shell, Bash, Perl, Batch, Python is a plus;
- Knowledge of networking fundamentals (a background in network administration or engineering would be helpful);
- Excellent understanding of the Windows operating system and Microsoft Clustering;
- ETL and Data Warehouse development skills including a very good understanding and practical application of dimensional modelling represent a plus;
- MS SQL Server, Oracle, PostgreSQL certification is a plus;
- Enterprise Database monitoring experience using native tools;
- Experience with RDBMS logical and physical system design, database performance tuning, including using DMVs, indexing, query optimization, Perfmon, etc.;
- Experience of working with Database Mirroring, Log Shipping, FCI clusters, AlwaysOn, and Transactional Replication on SQL Server 2008 or later;
- Relevant experience with SSIS development is a plus;
- Good understanding of data privacy and security considerations;
- Ability to tackle with issues that involve database infrastructure, and subsequent fixes or optimizations;
- Excellent systems architect and design skills represent a plus;
- Fluent Romanian & Russian (spoken and written);
- English (spoken and written) is a plus.
Working conditions:
- Remote position;
- Shifts 7:00-19:00 / 19:00-7:00 (36 / 48 hours per week);
- Attractive salary conditions plus bonuses;
- Private medical insurance;
- Professional trainings/certifications;
- Career opportunities;
- IT Park.