Razvan-Andrei Z.

Database Administrator

760 dollar
Freelancer
18 ans
Londres, ROYAUME-UNI

Mon expérience

Voir plus

dbAZ LtdSeptember 2018 - Présent

- Available now, SQL DBA contracts, London or remote.


Voir plus

RateSetterNovember 2017 - September 2018

- SQL DBA in a team of 4 data experts.
Highly transactional, fast evolving environment. Support for the
Ratesetter.com customer-facing website, DWH, Backoffice tools and Dev
teams, on SQL Server 2016 in Azure VM.
- Pushed for adoption of new SQL
Server 2016 SP1 features. Used Redgate tools and monitoring. - Code
review for T-SQL via Bitbucket and TFS, enforcing best practices and a
CR process, with bi-monthly releases mid-day, mid-week.- Performance
testing on major changes (sprocs, DDL), on all existing tiers:
test/QA/Prod AG replicas; built new environments where necessary. - Highlights:
Performed core platform upgrades (SQL 2014 to 2016) and updates (SP,
CU). - Major performance improvements (Autorek - reconciliation).
- Post-release index tuning on production tier.


Voir plus

SMBC Nikko Capital Markets LimitedSeptember 2017 - November 2017

- Sole DBA in  UK. AVP in Systems and Technology. BAU and projects on SQL Server, used for trading

systems and infrastructure backend.


Voir plus

Imperial College Healthcare NHS TrustAugust 2017 - September 2017

- Sole DBA for the Infrastructure
department. Managed multiple instances, dev to mission-critical
production systems, SQL 2005 - 2016.
- Configured and maintained servers,
refined regular processes, tracked issues, maintained documentation,
performed scheduled maintenance. - Monitored system health and
performance via custom-built tools for high levels of performance,
availability and security. Independently analysed, solved and corrected
issues in real time, provided problem resolution end-to-end.
- Assisted developers with complex query tuning using native monitoring. Supported dev releases.
- Supported Infrastructure's backend SQL databases and educated the team on SQL best practices.
Voir plus

eFinancialCareersAugust 2015 - April 2017

- Sole DBA in UK, focused on eFC brand, worked with DHI Group's US-based DBA team of 4. Supported SQL 2008 - 2016 on AWS and DC. Cross-trained, able to solve most MongoDB, MySQL, PostgreSQL, Oracle issues.
- BAU: production incidents SLA 4h; release/hotfix support; CR; health checks, alert investigation, storage, backups, security; performance tuning; maintenance, patches, upgrades, migrations; code review; scripting and automation of processes.
- Projects: AWS migration planning and scripts, SQL 2016 builds; BI DWH improvements, data archival and compression; backups to Amazon S3; server consolidation planning and execution, cost savings on SQL licenses and AWS instance time.
- Mentored a junior DBA and provided T-SQL support to devs and local DevOps team.
- Highlights: Added extra monitoring and alerting via custom T-SQL and Powershell scripts running as Agent jobs, pushed for adoption of tools such as Solarwinds DPA, Performance Dashboard reports, OpsManager, AppDynamics, Splunk. Tested Redgate SQL Monitor, Idera SQL Diagnostic Manager, SelectStar.io and Amazon CloudWatch. Built Always On AG on AWS EC2 and provided platform production support and improvements.
Voir plus

Hyperion Insurance GroupOctober 2014 - August 2015

- Maintained, expanded large estate of
SQL Server 2005 - 2014 on WS 2003 to 2012 R2 as sole DBA. Database
support for in-house applications and 3rd party legacy insurance
systems. Hands-on with infrastructure systems as 60/40% DBA/SysAdmin.

- Highlights: Built 3TB instance and the ETL to aggregate financial
information from 40 systems, helped develop the data dictionary and data
cleanup logic alongside the BI team. Implemented real-time
infrastructure systems health dashboard using Dundas, based on SCOM
metrics. Research and PoC for systems migration from on-premise to
Azure, fully scripted deployments with Azure Powershell.
Voir plus

InsureandGo UKMay 2014 - October 2014

- Administration and maintenance duties for SQL Server 2005 - 2008 on WS 2003 R2 environment.
- Provided database support for applications and web portals developed in-house, T-SQL performance analysis and improvements alongside the development team, SSIS/SSRS data processing, reporting and data feeds for major players in the UK travel insurance business, SSAS cubes, PCI compliance implementation.
- Highlights: Following a 2-day handover from the previous DBA, applied database changes to improve performance and delivered new data feeds in my first week, despite limited business logic knowledge.
- Documented legacy IT tools and SSRS items in preparation for SQL 2012 upgrade.
Voir plus

Computer Generated SolutionsOctober 2007 - April 2014

- Implemented the IT side of BPO projects, strong emphasis on fast delivery & HA, involved liaison with multidisciplinary teams in worldwide locations, facing customers at all levels from support to highest management.
- Work progressed on many projects at the same time, for different corporate customers, with ever-evolving requirements & tight deadlines. Calm communication, prioritization, effective delegation, time management were my essential skills for success in this fast environment.
BAU: 24/7 systems and support availability, as sole DBA. T-SQL development, database/query performance tuning.
- Data warehousing, data analysis & transformation, data feeds. Development & maintenance of SQL Server and MySQL based reporting systems for CDR, agent timesheets, CRM interactions.
- ACD planning, implementation & administration. IVR development. Data center management, implementation/testing of data recovery & disaster plans for telephony & database systems. Server and workstation configuration, new installs, deployment, troubleshooting, updates, upgrades, backups.
- ICT solutions proposals & budgeting, new technology evaluation. Acting as the interface between the company's operational team and clients'​ ICT teams. Involved in the RFQ and RFP phases for over 10 new clients in 6 years.
- Highlights: Launched 20+ new contact center projects, provided support for servers, applications, business processes, implemented reporting systems, throughout pilot and production phases. Planned & executed the migration to Microsoft Hyper-V and VMware ESXi.
- Passed 100% BCP & security compliance audits. Mentored 4 IT team juniors in support & developer roles, all currently moved to senior roles in major companies in Romania & abroad.
Voir plus

Smart Marketing ServicesJuly 2005 - October 2007

- Started as the Sysadmin/DBA. Planned, installed, configured and monitored a new MSSQL, Windows and Linux infrastructure. Implemented and monitored High Availability, backup and recovery strategies.
- Designed and implemented ETL with SSIS. Built and tuned SQL queries, stored procedures, triggers, views. Planned and implemented the data/telco infrastructure.
- Switched from an old generation Avaya to a modern Dialogic-based ACD with predictive dialing and trained all teams on the new platform in less than 2 months.
Due to fast company growth, moved into IT Manager role after 3 months. Involved in business development. - Built the fulfillment system to improve the QA process. Used data mining on 3 years of sales data, built new products and contract terms, reversed the previous 6 months downward sales trend.
- Additional role as General Manager from February 2006. Managed 150+ employees on 50+ desks over 3 shifts. Established general strategy and goals based on the latest UK mortgage market developments. Vastly improved collaboration between Leads, Quality and Sales teams.
- Reduced employee attrition and increased efficiency. Reduced costs by switching suppliers for better telco rates and by relocating to a more suitable facility.
Voir plus

Star Limo Services/MiilesJanuary 2004 - June 2005

- Responsible for hardware/software installation, config and tshoot of server and desktop systems
used to track and manage the vehicle fleet. Network and PBX administration. Website and email

servers administration.


Voir plus

United Air TempMay 2004 - March 2005

- DBA duties on MySQL, T-SQL development
on Access and SQL Server. Windows and Linux server and desktop
administration.
- Support ACD with Predictive Dialer support, campaign
design, KPI reports, DNC list implementation. - Highlights: Evaluated
telephony platforms, implemented 60 seats ACD. Improved leads data
quality via ETL scripts.
- Developed sales CRM with MySQL, PHP and Apache.
Planned and coordinated the relocation of the call center to a new
office building without service downtime.
Voir plus

CCCF SANovember 2002 - December 2003

- Provided Active Directory and desktop applications support. Responsible for hardware acquisitions
and scheduled IT maintenance for over 30 clients.
- Planned and executed data/voice structured

cabling and wi-fi, facility surveillance systems on multiple sites.


Mes compétences

Embedded and Telecom

IVR, PBX

Business Intelligence

SQL Server Reporting Services, SSRS, ETL, Data Warehouse

Languages

T-SQL, PHP, Shell Scripting, PowerShell, Bash, SQL

Others

Database Design

Technologies

CRM, AWS

Protocols

VoIP, SIP, ISDN

IT Infrastructure

Virtualization, Microsoft Azure, Unix, Active Directory, CentOS, Linux, VMware, Windows Server, Hyper-V

Databases

Microsoft SQL Server, MySQL, Oracle

Mes études et formations

- Studies, 2 years of courses focused on Economy of Commerce, Tourism and Services - „Hyperion” University from București.2005 - 2007

- Bachelor's Studies in Automatic Control and Computer Sciences - "Politehnica" University of Bucharest.1999 - 2000