MS SQL Senior Engineer

We are looking for a MS SQL Senior Engineer. The ideal candidate is a problem solver with proven work experience with MS SQL, well organized and team player. Our new colleague 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 monitoring, 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 English & Romanian (spoken and written)
• Russian (spoken and written) is a plus

Benefits:

• Professional training, certification and development plans on behalf of the Company;
• A young, highly experienced team with diversified IT experience and know-how across different technologies to boost your expertise and potential;
• Work-from-home and flexible schedule policy;
• Highly competitive remuneration package;
• Laptop, mobile phone and GSM package;
• Private Medical insurance package;
• Monthly and Annual team building events.