Gabriel Stan

– MSSQL installation 2019/2022,migrate older system to newest versions,installing Always On AG,FCI Windows Cluster. Apply CU for MSSQL. – Automate with T-sql jobs and PowerShell script the backup, alerts,deadlocks. – Performance tuning with Query Store, DMV's and extended events. – Administering Reporting Services, upload new reports,control security for all systems. – MSSQl2012/2014/2016/2019/2022,SSMS,Sql Sentry DPA,dbatools. PGAdmin,MySQL workbench, Mongodb on Windows,replicaSET.MongoDB Compass, PostgresSQL,pgAdmin,pg extensions

– DBA production – Performance tuning with DMV,wait stats methods, Query Store, creating indexes, Brent Ozar stored Procedures and extended events,tuning instance and database parameters.

– Installing and configuring MSSQL instances into a cluster configuration, design HA & DR solutions between data centres using Always ON Availability Groups, mirror, log shipping and replication. – Troubleshooting, support and improve the performance of the MSSQL instances and databases, investigating and improving database and server performance using Profiler, Query Store wait stats and Extended Events methods. – Responsible for the security logins and users, and audit policies. – Migration and upgrade projects MSSQL2008R2 to MSSQ 2012/2014/2016/2019 and Azure SQL Database assessing migration plan with SQL Upgrade Advisor,SQL server Migration Assistant. With Database Migration Service to Azure SQL DB. – Installing, configuring, and administering MSSQL 2014/2016/2019 FCI and Always ON AG on Windows Server 2016 Core using configuration file/unattended installation. for critical mission applications., migrate SQL logins with PowerShell scripts. Dba tools. – Installing and configuring SQL server 2016 R Services,Reporting Services, deploy and upgrade between Report Server 2012/2016 version, security for users, investigating and improve |Report Performance with cache, indexes. – Patch OS windows, installing updates Windows servers, WSFC cluster, applying SP and CU for SQL Server – Deploying Application using Docker – Administering Oracle 12.2 database on Linux,RMAN,Tuning,patching,ASH.,AWR,OEM – Manual Backup\restore databases using T-Sql scripts, Ola Hallengren Solutions implemented.as Backup\Optimization maintenance jobs – DW projects with fact table and SSIS packages in order to load from heterogeneous data sources like Excel,csv and,SQL Server – Automate task with PowerShell scripts – Migrating MSSQL cluster versus new boxes and SAN storage,tempdb local on RAM SSD.

– Writing IQ, SOP and WI for MSSQL 2014. – Upgrade from 2000 version to 2012/2014. – Investigate the database performance and tune with Profiler,DMW's, Extended Events and Waits tats method. – Implementing routines in order automating tasks – Manage TDE databases – Involved in defining the architecture HA,BI or Azure SQL possibilities – Automate the maintenance and optimizations tasks based on Ola Hallogren scripts. – Securing MSSQL with Kerberos, encryption, auditing the logins. – Implementing mirroring and HA Always ON Availability Groups – Support Oracle 11gR2 and 12c pluggable database – RMAN backup

– Administering clusters MSSQL 2008R2, troubleshooting and solving performance issues, – Audit MSSQL-SAN performance; refresh test and dev from prod.,backup/restore „troubleshooting SQL issue. – Planned architecture and testing upgrading cluster 2008R2 to Cluster 2012 & AlwaysONAvailibility Groups as DR solution. – SharePoint databases administration, creating scripts to monitor and maintenance tasks. – Training and formation for new DBA Junior, – Health-Check with MS RAAS for cluster side. – Troubleshooting and administering and support RS and Analyses Services upgrades

– Administering MSSQL cluster, consolidation and virtualization project, and SAP and SharePoint farm implementation under MSSQL 2005/2008/2012. – Creating maintenance monitoring jobs with PowerShell, security for logins and users, solving performance issues using Profiler, traces, DMV has, extended events, wait stats or query hints. – Responsible for backup-restore policy. Creating backup jobs, alerts related to jobs. – New MSSQL 2008/R2/2012 installations, tools apply the Service Packs and patches. – Creating databases, importing databases, improving database performance with indexes and trace flags. Monitor CPU,I/O and RAM for instances and setup baseline for them. – Creating SSIS packages to import from heterogeneous sources like Fox Pro, Sybase ASA – Create database links for MSSQL, ODBC connections, linked servers to Oracle, MSSQL – Planned, Implemented, configuring and troubleshooting HA & DR site through and AlwaysONCluster and Availability Groups on Windows2012 Server. – Monitoring and obtaining reports on MSSQL instances with SCOM 2012. – Setup MSSQL Mail for sending reports and messages, implementing security audit, – Work closely with Wintel admin for AD groups and security issues. – Requested database refreshes from prod to Test & Dev. – Creating Reports with SSRS and BI stack. – Migration Oracle 9i to MSSQL 2008,Migration Access to MSSQL 2008R2 – Administration Oracle 11gR2 on Linux/Windows servers,RMAN,clone db's

– Working with test & acceptance environments for acceptance of the new servers to respect the ING standards in terms of security AD integration, monitoring and backup. – Audit performance of the MSSQL and increase performance with indexes, statistics instances and hints. – implementing best practices security ING – Installing and configuring MSSQL 2005/2008 new systems – Backup scripts for TSM backup solution – Administering Oracle 9i/10g AIX

– Working as Team Leader for the Sybase official partner in Romania.. – Leading, recruiting, training and motivating 4 people composed technical department. – Involved in administering, marketing strategy targeting the market from their IT Budget's. – Involving in pre-sales and sales operations. – Conducted POC demos. – Installing and configuring ASE 12.5, IQ and Replication Server under Windows, Linux and AIX. – Using MDA tables and sp_sysmon for monitoring, creating new indexes resulting significant performance improvements. – Creating shell scripts for dumping database and logs, rebuild indexes. – Developing mapplets with Informatica Power Centre and develop reports with BOXI – Transfer into Sybase IQ with Informatica Power Centre from MSSQL and Oracle – SAP HANA

– Remote DBA Sybase for Swiss Re based London. – Daily admin tasks for dump-load, tuning databases and servers.

– Installation, maintenance, management, planning architecture, migration/upgrade of prod and dev SQL Server 2000 / SQL Server 2005 databases(sizes up to 130Gb), MSSQL Clusters,Oracle 9i & 10g – SQL Server Monitoring – daily use of Quest Software for troubleshooting on 40 Database.

– Installation, maintenance, management, planning architecture, migration/upgrade of prod and dev SQL Server 2000 databases – Propose design and modelling for databases and tables. – SQL Server Monitoring/Alerting daily using using T-sql scripts. – T-SQL optimization, scripts, stored procedures, functions and triggers. – Project Data Warehouse, modelling a Data Warehouse,create the cubes,develop stored procedures to transfer dates from production to DW.. – Performance tuning and optimization of SQL Servers, applications, Indexes, and – T-SQL. Tools used include Performance Monitor, Profiler, Query Execution Plans, stored procedures and resulting significant performance improvements. – Working close with developers to improve the performance of new software applications – Data Migration/ETL/Data cleansing – SQL scripts and DTS packages to migrate, cleanse and transform data between DTS Packages – designing for data import and export. – Security - Set and enforced standards create users and roles etc. – Administering Windows 2000/2003 servers with AD.

– Installation, maintenance, et administration of prod and dev SQL Server 2000 / SQL Server 7 databases (sizes up to 100GB). Clusters.

– Audit MSSQL servers to improve the architecture and performance.. – Mission to replace DBA for a short period.

– Installing and adminstering.Windows NT/2000 server, installing and configuring MSSQL 6.5/7. – Implementing Backup-Restore plan with T-SQL job and Agent Jobs.. – Modelling databases,creating the databases,tables, views and indexes – Optimize the performance of the queries with DBCC,trace flags, SQL Trace/Profiler – Migrating Access database to MSSQL 2000